All Articles - SQL Authority with Pinal Dave

SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT

December 21, 2011

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Yesterday I posted A Quick Trick about SQL Server 2012 CONCAT function and the very first comment in few minutes of Vinod Kumar. He suggested that this function should be also used with the PRINT statement as well. While I was having conversation with him – Jacob Sebastian sent me message…

SQL SERVER – A Quick Trick about SQL Server CONCAT function

December 20, 2011

Pinal Dave

SQL Video

SQL Function, SQL Scripts, SQL Server, SQLAuthority Book Review

Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you.

SQLAuthority News – Introduction to expressor Connectivity to Salesforce – expressor Data Integration Applications

December 19, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

This month, expressor software is releasing the newest version of their data integration product – expressor 3.5. This release includes three significant enhancements to this powerful and adaptable product: an extensibility framework, integration with Melissa Data’s data quality tools, and operators to read from and write to Salesforce.com databases. As…

SQL SERVER – AdventureWorks for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0

December 18, 2011

Pinal Dave

SQL

SQL Documentation, SQL Download, SQL Sample Database

Microsoft has just released AdventureWorks database for SQL Server 2012 RC0. I am very happy that now I will be able to play with this new sample database and base my various demo script around the same. Here is the link to download AdventureWorks 2012 RC0 database.

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

December 17, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages, SQL Server Management Studio

I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘D:\Backup\SQLAuthority.bak’. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level…

SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files

December 16, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

Recently I was exploring SQL Server Audit and found something very interesting. I found two enhancements in the SQL Server 2008 Create Audit Screen. SQL Server 2012 Create Audit Screen SQL Server 2008 Create Audit Screen On Audit Log Failure Options You can see that in SQL Server 2012 they…

SQLAuthority News – Online Session Practical Tricks and Tips to Speed up Database Queries Today

December 15, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

I am presenting on performance tuning topic again today at Virtual Tech Days. This time I am going to talk about lots of practical tips and will focus on what we can do immediately right after the session is over. During the session I have two things for you to…

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book

December 14, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

I was recently reading excellent Just Learned Tip regarding 3 part naming Cannot be used when dropping Views,Functions or Procedures. This is quite a well known tip however, every developer and DBA learns at sometime in their career with ‘hm…’ moment. To illustrate this further here is a simple case…

SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

December 13, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of Tips and Tricks. For me, this is a very interesting subject. I perfectly enjoy a discussion when it is about performance tuning. I commonly get follow-up questions regarding this subject, but most of them do not give…

SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011

December 12, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Performance tuning has been my favorite subject and any time when I have to present on this subject, this itself gives me tremendous pleasure as well. I am always excited to present something new on this topic. Virtual Tech Days is just here around the corner and I am going…