Earlier I wrote blog article SQL SERVER – Finding Last Backup Time for All Database. In the response of this article I have received very interesting script from SQL Server Expert Matteo as a comment in the blog. He has written script using sys.databases which provides plenty of the information…
Read MoreSQLAuthority News – SQL Server Denali CTP1 – Release Date November 9, 2010
I am very excited as I was about to witness SQL Server 2011 – Code Named “Denali” is released on November 11, 2010 at SQLPASS. I will write a detail report for the same in future. You can download CTP1 right away right now and install on your machine. The…
Read MoreSQL SERVER – Get Database Backup History for a Single Database
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 More