Yesterday I was trying to remember a bug in SQL Server 2005 log shipping when using the secondary database for reporting. As most of you may know in order to use the secondary database for reporting, the database must be recovered with standby. A very long time ago when SQL Server 2005 was supported , [...]
I have been using Central Management Servers(CMS) for quite some time now and I think CMS are a essential tool for a DBA. Brent Ozar wrote a blog about CMS back in 2008, you can find his blog here. Brent mentions in that blog that one of the limitations of CMS is that it can’t [...]
Back in 2009 Jonathan Kehayias wrote an article on SQL Server Central with the title “Retrieving Deadlock Graphs with SQL Server 2008 Extended Events”. It is a very handy article, it explains how to obtain deadlock information from a SQL Server 2008 or higher version without enabling a trace flag. The only thing I was [...]
Today I read an amazing post by Kendal Van Dyke. In the post he gives great news, he introduces SQLPowerDoc. I can’t wait to give it a try. Please take the time to read Kendal’s blog post and let me know what do you think of ” SQLPowerDoc”. You can find his post on his [...]
I have been asked many times on how to find the backup file location for a specific database, to be honest I always forget the name of the table I need to join to “backupset” and end up looking for the table name on the MSDB database to find the backup file location. I think [...]
One of the things we usually forget as DBAs is that we need to check from time to time the CPU speed on our SQL Servers. In a perfect world we should not do it, but since the world is not perfect I will advice you to do so. This advice is not new, Brent [...]
One of the things that surprise me a lot is how little known are the Microsoft SQL Server Virtual Labs. Sometime ago I blogged about it, back then SQL Server 2012 was not released. If you would like to try some of the new features of SQL Server, the virtual labs are something for you. [...]
Some days ago I wrote a post where I added a query with the description on the wait types. Today I going to do the same with the latch query that Paul Randal posted is his blog “Most common latch classes and what they mean”. I slightly modified Paul’s query. adding information on the latch [...]
In 2009 I wrote about fixing problems with the performance dashboard for SQL Server 2005. The SQL Server 2005 performance dashboard is a great way to troubleshoot your SQL Servers, when SQL Server 2008 was introduced the performance dashboard didn’t word on it anymore and it was recommended to use the new activity monitor or [...]
One of the best posts you can find on internet about the “waits and queues” Troubleshooting methodology is Paul Randal’s “wait-statistics-or-please-tell-me-where-it-hurts”. I check it very often and whenever you google a waittype you are most likely to get the link to his post in the top ten. In his post Paul provides a modified version [...]
I have over 12 years experience in IT, in 2006 I started working with SQL Server. I am a Microsoft Certified IT Professional DBA in Microsoft SQL Server 2005 and in Microsoft SQL Server 2008.
My key areas of interest are SQL Server Disaster Recovery, SQL Server Internals, performance tuning & Database Architecture.