I recently wrote article SQL SERVER – Finding Last Backup Time for All Database and requested blog readers to respond with their own script which they use it Database Backup. Here is the script suggested by SQL Expert aasim abdullah, who has written excellent script which goes back and retrieves…
Read MoreSQLAuthority News – Why I am Going to Attend PASS Summit Unite 2010 – Seattle
I am once again attending SQLPASS this year.When I told this to my friend that I am going to SQL PASS again, he has the same question, which quite often many people ask. WHY? I had earlier wrote article on this subject. I am writing it again the same. The…
Read MoreSQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore
Every SharePoint site runs on SQL Server and most of the SharePoint sites face issues with performance due to suboptimal configuration of underlying SQL Server. Recently, I presented a session on SharePoint and SQL Server Performance at Singapore on Oct 26-27, 2010. It was South East Asia SharePoint Conference, and…
Read MoreSQLAuthority News – Last Day to Participate in my Questions at SQL Quiz
My very good friend, Jacob Sebastian, is running a month-long SQL Quiz Series where the best-of-the-best experts from around the globe would be the quiz masters. They will ask one question every day, and users are expected to answer them correctly. The winning prizes include cool gadgets like iPAD, Kindle…
Read MoreSQLAuthority News – Happy Deepavali and Happy News Year
Diwali (also spelled Divali in other countries) or Deepavali is popularly known as the festival of lights. It literally means “array of light”. Diwali is the most important festival of the year and is celebrated with families performing traditional activities together in their homes. Deepavali is an official holiday in…
Read MoreSQL SERVER – Finding Last Backup Time for All Database
Here is the quick script I use find last backup time for all the database in my server instance.
SQL SERVER – Are you a Database Administrator or a Database Developer?
This blog post is written in response to T-SQL Tuesday hosted by Paul Randal. I think following questions has been always very interesting question for everybody who is working with SQL Server. Are you a Database Administrator or Database Developer? The answer of this question varies from organizations to organizations…
Read MoreSQLAuthority News – 4th Birthday of Blog – 20 Million Views – Blog Anniversary – A Milestone
Today is Nov 1, 2010. Four years ago, on the same day of the year 2006, I wrote my first blog without thinking or even understanding where this blog was going to. The reason I started blogging was very simple- I just wanted to keep a note of what I…
Read More



