I had amazing fun time earlier last week when I was interviewed by prominent podcaster Dave Rael. He is amazing interviewer and knows how to get secret information from the people. He had asked me indeed very, very difficult question in the podcast. I consider myself as a good speaker, but there were many moments when I fumbled to answer the questions immediately. I think the reason for the same is simple – the interviewer Dave was too good.
“I want to change fill factor to another value – how do I do that?” The other day I received this question in via Facebook. Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the…Read More
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…Read More
It has been quite a long time since I posted SQL in Sixty Seconds Video. Here we are back with the new video. One of the most popular question, I often receive is very similar to following: “How do I reset the password for SA username?” “I have forgotten the…Read More
It has been almost 2 years since we had a poll on this blog so here a poll which ask you three simple questions. Trust me these questions, I have carefully picked after doing a beta testing on a small group of people. It was very intriguing to see that…Read More
Yesterday I wrote about my SQLPASS 2013, Charlotte Memories Friends. This is second and last part of the same series. As you know I have so far written 10 different books on SQL Server and I am very much proud of that fact. Every time at SQLPASS, our books are…Read More