SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree | Journey to SQL Authority with Pinal Dave

Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any way he can list directory… Continue Reading...

Source: SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree | Journey to SQL Authority with Pinal Dave

SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience | Journey to SQL Authority with Pinal Dave

It has been my lifelong dream to be an author, and recently I have seen that goal realized three times.  One of the books I am most proud of is SQL Server Interview Questions and Answers. When I wrote SQL Server Interview Questions and Answers - I had very clear idea what my goals were… Continue Reading...

Source: SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience | Journey to SQL Authority with Pinal Dave

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore | Journey to SQL Authority with Pinal Dave

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 providing working script for user… Continue Reading...

Source: SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore | Journey to SQL Authority with Pinal Dave

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column | Journey to SQL Authority with Pinal Dave

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 question, I was asked following… Continue Reading...

Source: SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column | Journey to SQL Authority with Pinal Dave

SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users | Journey to SQL Authority with Pinal Dave

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 and asked few questions. As… Continue Reading...

Source: SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users | Journey to SQL Authority with Pinal Dave

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Journey to SQL Authority with Pinal Dave

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 database but every single time… Continue Reading...

Source: SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Journey to SQL Authority with Pinal Dave

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012 | Journey to SQL Authority with Pinal Dave

Recently I was going over few advanced options of SQL Server 2012 in database properties and I found a new option in the property screen. Properties screen of SQL Server 2008 R2 Properties screen of SQL Server 2012 I got little curious and decided to learn what does this new feature indicates. When I started… Continue Reading...

Source: SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012 | Journey to SQL Authority with Pinal Dave