All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage

July 16, 2012

Before continuing this blog post I would like to bring your attention to two of my earlier blog post where I have written in depth about FORMAT and CONCAT function. String Function – FORMAT() – A Quick Introduction String Function – CONCAT() – A Quick Introduction Read the above two blog posts…

SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name

July 15, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Place: Any Developer Shop Scenario: A developer wants to drop a column from a table Time: Any Day – usually right before developer wants to go home The developer rushes to the manager and following conversation begins: Developer: I want to drop a column from one of the tables. Manager:…

SQL SERVER – Example of Width Sensitive and Width Insensitive Collation

July 14, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I had a great time writing blog post SQL SERVER – Effect of Case Sensitive Collation on Resultset. It was interesting to see lots of questions related to collation based on this blog post. However, one of the question, I find very interesting and though to share today here. Question: What is…

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]

July 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Shortcut

Earlier this week I wrote a blog post about SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis, I received quite a lot of positive feedback from readers. If you are a regular reader of the blog post, you must be aware that I appreciate the learning shared by…

SQL SERVER – Effect of Case Sensitive Collation on Resultset

July 12, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Collation is a very interesting concept but I quite often see it is heavily neglected. I have seen developer and DBA looking for a workaround to fix collation error rather than understanding if the side effect of the workaround. Collation is a very deep subject. Earlier I wrote an article…

SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video

July 11, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

SQL in Sixty Seconds is indeed tremendous fun to do. Every week, we try to come up with some new learning which we can share in Sixty Seconds. In this busy world, we all have sixty seconds to learn something new – no matter how much busy we are. In…

SQLAuthority News – Lessons from Life and Work by Srini Chandra (Author of 3 Lives, In search of Bliss)

July 10, 2012

Pinal Dave

Personal

SQLAuthority Book Review

I requested Srini Chandra (renowned author of Amazon Best Seller 3 Lives, in search of bliss to write a guest post on this subject which developer can read and appreciate.

SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always

July 9, 2012

Pinal Dave

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

The amount of email I receive sometime it is impossible for me to answer every email. Nonetheless I try to answer pretty much every email I receive. However, quite often I receive such questions in email that I have no answer to them because either emails are not complete or they…

SQLAuthority News – 2 Whitepapers Announced – AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution

July 8, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

AlwaysOn, SQL Documentation, SQL Download, SQL White Papers

Understanding AlwaysOn Architecture is extremely important when building a solution with failover clusters and availability groups. Microsoft has just released two very important white papers related to this subject. Both the white papers are written by top experts in industry and have been reviewed by excellent panel of experts. Every…

SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

July 7, 2012

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Shortcut

Every weekend brings creative ideas and accidents brings best unknown secrets in front of us. Just a day while working with complex SQL Server code in SSMS I came across very interesting shortcut which I have never used before and instantly fell in love with it. It is totally possible that you are familiar with this but for me it was the first time and I was surprised that I did know know this short cut so far.