Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL

July 5, 2013

Recently one of my friends sent me a SQL script to debug and I noticed that above all of his scripts he was executed following query. SET CONCAT_NULL_YIELDS_NULL OFF; This made me curious and I asked him reason why is he executes above script. He answered that when his application…

SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

July 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Have you ever faced situation where you have just created or modified object but SSMS still shows the error. I quite often face this situation where I come across situation where my SSMS Intellisense Cache is not refreshed or updated. This is indeed very frustrating when you are presenting something…

Developer Training Courses – Online Courses to Learn SQL Server, MySQL and Technology

July 3, 2013

Pinal Dave

SQLAuthority News

MySQL, SQL Server, SQL Training

Developer Training Courses are the next big thing and I am so happy that I have so far authored 6 different video courses with Pluralsight. Here is the list of the courses. I have listed all of my video courses over here.

Personal Technology – Excel Tip: Comparing Excel Files

July 2, 2013

Pinal Dave

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

Excel, Personal Technology

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versionsfrom SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect. Let us read…

SQL SERVER – Check If Column Exists in SQL Server Table

July 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

A very frequent task among SQL developers is to check if any specific column exists in the database table or not. Based on the output developers perform various tasks. Here are couple of simple tricks which you can use to check if column exists in your database table or not.…

SQL SERVER – 2014 CTP1 Available for Download – SQL SERVER 2014 Community Technology Preview 1

June 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTP, SQL Service Pack

Microsoft announced that SQL Server 2014 CTP 1 available to download at TechEd Europe. You can download SQL Server 2014 CTP1 from here. Additionally, there is in depth documentation of the product in the Product Guide over here. In this blog post I have in depth discussed what are the salient features…

SQL SERVER – Weekly Series – Memory Lane – #035

June 29, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…