Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?
SQL Server Wait Types Library – UPGRADED!
Reply
Tag Archives: SQL server
Extended Events – I am dangerous (sometimes)
I did a dangerous thing, and I want to make sure that YOU DO NOT do the same.
I was creating a couple of extended events sessions and was playing around with some actions. I ended up with the following code where I was after a guy called Shane:
SQL Server Recovering Data via a Hex Editor
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised within a page) with no backups handy only an old image of the data files. The challenge being salvage data without attaching the data files.
Comparing Plans via Query Store
A small but nice little feature I have been using recently can be found within Query Store.
Getting intimate with Brent Ozar (The First Responder Kit)
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)
All About Tech 