All Articles - SQL Authority with Pinal Dave

MySQL – Introduction to User Defined Variables

May 31, 2014

MySQL supports user defined variables to have some data that can be used later part of your query. You can save a value to a variable using a SELECT statement and later you can access its value. Unlike other RDBMSs, you do not need to declare the data type for…

SQL SERVER – Merge Two Columns into a Single Column

May 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is a question which I have received from user yesterday. Hi Pinal, I want to build queries in SQL server that merge two columns of the table If I have two columns like, Column1 | Column2 1 5 2 6 3 7 4 8 I want to output like, Column1…

SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030

May 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SQL Scripts, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. The tool may also be used…

SQL SERVER – Take the Quiz for a chance to win a Quadcopter Drone – Brain Teasers

May 28, 2014

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

It has been a long time since we ran quiz. So let us get ready for a quiz. The quiz has two parts. You have to get both the parts correct to win Quadcopter with Camera (we will call it drone). We will be giving away a total of 2…

SQL SERVER – Copy Database – SQL in Sixty Seconds #067

May 28, 2014

Pinal Dave

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

Joes 2 Pros, SQLAuthority Book Review

There are multiple reasons why a user may want to make a copy of the database. Sometimes a user wants to copy the database to the same server and sometime wants to copy the database on a different server. The important point is that DBA and Developer may want copies…

SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server

May 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Agent

SQL Server Agent fails to start because of the error 15281 is a very common error. When you start to restart SQL Agent sometimes it will give following error. SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the…

SQL SERVER – Poll – What would you love to see in SQL in Sixty Seconds?

May 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL in Sixty Seconds

Last week, I had my very first SQL in Sixty Seconds Video of this year. Lots of people send me email asking for me to continue this series as it was extremely fun at times to watch the video. I am going to start the series again in the month…

SQLAuthority News – Download Whitepaper – A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1

May 25, 2014

Pinal Dave

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

SQL White Papers

In this new world of social media, apps and mobile devices, we are all now getting impatient. Automatic updates have spoiled few of our habits. When a new feature is released everybody wants to immediately adopt the feature and start using it. Though this is true in the world of…

SQLAuthority News – Presented Soft Skill Session on Presentation Skills at SQL Bangalore on May 3, 2014

May 24, 2014

Pinal Dave

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

SQLAuthority Author Visit

I have presented on various database technologies for almost 10 years now. SQL, Database and NoSQL have been part of my life. Earlier this month, I had the opportunity to present on the topic Performing an Effective Presentation. I must say it was blast to prepare as well as present…

SQL SERVER – Fix: Error: Compatibility Level Drop Down is Empty

May 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server

I currently have SQL Server 2012 and SQL Server 2014 both installed on the same machine. My job requires me to travel a lot and I like to travel light. Hence, I have only one computer with all the software installed on it. I can install Virtual Machines but as I was able to install SQL Server 2012 and SQL Server 2014 side by side, I just went ahead with that option. Now one day when I opened up my SQL Server 2014 and went to the properties of my database, I realized that the dropdown box for Compatibility level is empty.

Now one day when I opened up my SQL Server 2014 and went to the properties of the my database, I realized that the dropdown box for Compatibility level is empty.