• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

January 9, 2018

Sometimes for testing purposes (or an emergency) one might find it useful to remove query plan for a single stored procedure. This way you won't have to disrupt the entire instance (and possibly anger your fellow developers!).

I often forget that DBCC FREEPROCCACHE acce...

December 19, 2017

I know, it sounds like it could be a desert. But it's poison! 

You ever have one of those Saturday morning emergencies and come face to face with a wait type that you're completely unfamiliar with? 

I  recently got contacted that a highly transactional SQL Server was per...

December 13, 2017

It is unbelievable how common it is to walk into a new organization only to find that they have no database backups. But when having a conversation with management, they expect zero data loss.  Seems like a bit of a conundrum don't you think?

It's important to bring abo...

December 5, 2017

It's important to test your storage performance especially prior to installing or deploying a new SQL Server. 

Microsoft has provided us with a great tool called Diskspd, which was meant to replace SQLIO. Diskspd synthetically generates workloads to run against your ser...

November 21, 2017

 Happy Thanksgiving!

If you're not familiar with DBAtools.io I suggest you head over to the site and see what you're missing. The amount of cmdlets is just staggering.  These cmdlets can be used for so much more than migrations. But i'm going to share just a tiny fracti...

November 9, 2017

There are several ways to monitor your Availability Groups using native SQL tools. In this particular article I'm going to cover a few SQL Agent Alerts that I have used in the past. 

Let's first identify some of the error numbers we will be referencing.

Error 1480 - Indi...

November 7, 2017

This post is meant to be a quick primer on Table Partitioning in SQL Server. 

What is it?

Let's say you have a large table that is accepting a lot of transactions, partitioning allows you to scale this particular table out into different (physical partitions). Thus sprea...

October 27, 2017

 Build the cluster right so you don't run around frantically like this guy does for a living.

So most DBA's know that AlwaysOn Availability groups were introduced in SQL 2012.  I know it was the most exciting feature for me a few years ago and I couldn't wait to impleme...

October 25, 2017

An elegant function for a more civilized age:

Another way to detect deadlocks is to utilize the TRY CATCH block to raise errors in TSQL code. I found this to be a very elegant way of detecting deadlocks pragmatically. You can use the below code sample in a stored proced...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server.  When not working I like to lift weights, play music, and travel with my wife.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle