As a SQL Server DBA you are responsible for the integrity of your databases. On December 2012 I published a … Continue reading Are you sure the data on your database is not corrupt?
The last time I publish on my blog was 6 years ago. During the time I was absent this blog … Continue reading Back after 6 long years!
As we know, Microsoft SQL Server is a relational database management system. The SQL database is most commonly used by … Continue reading Most Common Causes of SQL Database Corruption – Know How to Fix It
Back in 2009 Jonathan Kehayias wrote an article on SQL Server Central with the title “Retrieving Deadlock Graphs with SQL … Continue reading How to view a deadlock graph using the information from the default SQL Server 2008 system_health session?
I have been asked many times on how to find the backup file location for a specific database, to be … Continue reading How to find the backup file location?
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 600 people reached the … Continue reading 2012 in review
On the 26th of July Microsoft released SQL Server 2008 R2 Service Pack 2(SP2). You can find a post on … Continue reading SQL Server 2008 R2 Service Pack 2 Download
I wrote my last post just before going to London where I attended the “Immersion Event on Performance Tuning”. I … Continue reading How to troubleshoot a SQL Server with performance issues
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: A New York City … Continue reading 2011 in review
Finally Microsoft released the long waited new CTP of SQL Server Denali. To download it, click on this link. Enjoy! Continue reading Microsoft SQL Server Denali CTP3 Download