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

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...

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...

October 23, 2017

It's important to be able to analyze the deadlock graph once it's been detected. I'm going to give a brief run down on what I look at. 

The process nodes show information regarding the actual modification.  The node that is X'd out is known as the deadlock victim. This...

October 17, 2017

Deadlocks can be a serious plague to your existing systems. I am a fan of being proactive whenever  possible. So instead of waiting for complaints from users or application developers, and then having to dig through logs and extended events, we can setup some type of a...

October 9, 2017

What is it?

A trigger is almost like a command/function that executes automatically in response to another transaction that has executed. Think of it as kind of a stored procedure that executes automatically when an event occurs. 

Types:

DML Triggers - After and Instead

AF...

September 19, 2017

While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency  of powershell.  Building off of my previous posts, I'm going to provide a few powershell commands to login and create a new Azure SQL Database.

The first step allows you...

September 7, 2017

 You might be turning the gun on yourself if you ever have to implement this.

Disclaimer: I would never suggest running this in a production environment without good reason. I was asked to come up with something that will automatically kill blocked processes until the...

August 30, 2017

 We could use this sign when we have approved downtime for upgrades. 

So this isn't exactly just for SQL, this cmdlet can be used stop and start any clustered service. 

It proved especially useful for me since I am currently on a project that requires the systematic...

August 22, 2017

 Mendenhall Glacier

SQL cruise was something I've always wanted to do ever since it's inception (years ago). Of course, no company was going to send me to any conference with the word "cruise" in the title. Rather, they would send me to local training facilities that co...

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