Comparing Plans via Query Store

Posted on May 4, 2017 by blobeater

A small but nice little feature I have been using recently can be found within Query Store.

I Escaped from a SQL Server Service Pack Nightmare

Posted on April 24, 2017 by blobeater

I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if not you might want to reconsider. Initially I wasn’t going to capture the screen shots during this recovery because my focus was to fix the issue but I thought I would just in case others experience the same thing.

I wanted to move from SQL Server 2014 SP1 to SP2, as you can see I had a clear issue.

Continue reading →

Getting intimate with Brent Ozar (The First Responder Kit)

Posted on April 12, 2017 by blobeater

Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL Server databases and it is a battle just to keep the lights on. If this sounds like you then you need all the help you can get. You can find this help from https://www.BrentOzar.com/first-aid/ where Brent, his team and community members (found here https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/graphs/contributors) have developed something known as the First Responder Kit and let me tell you, it will make your life “easier”. (In the long term)

Continue reading →