I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice.
Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses. This can be very dangerous because an exclusive lock on a table or partition could cause significant performance concerns.
If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice.
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification to your columns. Today we’ll discuss what happens behind the scene and how to look at the classifications later.
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of you know I’ve been working on a UWP app to help query tuning in SQL Server and showed quite a few people an alpha of the tool at PASS Summit. My plans were to have the tool completed and published to the Windows Store by Christmas.
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that you’re going to want your hands on immediately and the conference is happening right now and goes until Friday.
You can watch and learn all about the exciting new things at this link:
Hope you enjoy and find some time to check out some of the broadcasting.
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you there.
If you haven’t registered yet, no problem. The details are here:
There’s a ton of great speakers and you don’t want to miss this one.
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.