Being that today is my birthday I thought I would share a nice gift to everyone who follows my blog. Below is a free link to a recorded video of one of my latest presentations that goes over multiple SQL Server developer anti-patterns I see repeated over and over again in the field. Most of these are patterns that any IT professionals can identify and fix just by identifying the pattern and changing the pattern to another one shown in the video that is optimizer friendly. I promise no brain surgery is required
Make Your SQL Server Queries Go Faster
I hope you enjoy the hour long video on making your SQL Server queries go faster!
If you want to play along feel free to download the sample scripts. If you want to learn more about being a proactive performance tuner check out my root cause performance analysis blog series which includes my What Is Running Script, Disk Latency, Wait Stats monitor processes and more..
Recently, I gave my first presentation of the year at Austin .NET User Group on Writing Faster Queries and I got a great question about Extended Events. The question was, “What security permissions are required for creating and modifying Extended Event Sessions?” I thought it would make a great blog post as I am sure others might be wondering the same thing.
In SQL Server 2008 to create an Extended Event Session you are going to need CONTROL SERVER and ALTER ANY EVENT SESSION permission on the instance that you need Extended Events created on. With SQL Server 2012 and 2014 If you want to create and modify Extended Events you are only going to need ALTER ANY EVENT SESSION.
If you like this post check out these other related blog posts:
If your in Texas and interested in learning some tips to help you do SQL Server Performance Tuning with free tools then I highly suggest that you attend one of these presentations coming to a city near you!
If you cannot make it out no worries, you can catch a recorded version of my presentation.