Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

December 26, 2011

Last day I had excellent fun asking puzzle on SQL Server Login SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users. One of the user sent me email asking urgent question about how to resolve following error. Reader was trying to remove the login from…

SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users

December 25, 2011

Pinal Dave

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

First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season. In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image…

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column

December 24, 2011

Pinal Dave

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

SQL Scripts

Christmas is just near and happy holidays to all of you. Today is Christmas eve and I decided to share something very simple but interesting with you. Recently some one reading my SQL Server Interview Questions and Answers book asked me following question. “Pinal, Instead of puzzle, or difficult interview…

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore

December 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Blogging is like writing a big novel in parts. It has its own mood and it has its own colors. Someday I feel like writing philosophy and some day I like writing theory and some day just a script. Today is one of the day when I just feel like…

SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience

December 22, 2011

Pinal Dave

SQL Interview Questions and Answers

Best Practices, SQL Server, SQLAuthority Book Review

I had very clear idea what my goals were in the book. I believed in unique learning experience. Let us talk about it in today’s blog.

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

December 21, 2011

Pinal Dave

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

SQL Function, SQLAuthority Book Review

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.