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

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