July 5, 2018

Why should I use Query Store?

Query store can be used for a number of things.  For example:

  • Find out what was happening on my server last night?

  • Identify and fix queries suffering from parameter sniffing or plan regression

  • Testing (ie - when upgrading to a...

June 25, 2018

It's amazing that we never had a built in feature that logged historical record of queries. Sure we had the plan cache, but that was cleared with a service restart or reboot. How many times have you walked into an environment and they would say the server was slow yest...

November 1, 2017

Before we begin:

While the gui/wizard for setting up Availability groups is super easy, I'm going to go through utilizing T-SQL. This gives us an "Under the hood" look at the way these are setup. I will provide the full script at the end of the post.

As an FYI, I will be...

Please reload

Please reload




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
  • Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle