Why is the XLOCK table hint broken?
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...
2020-02-20 (first published: 2020-02-12)
371 reads
Daniel Janik
Azure Data Studio extension – help wanted
I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice. Right now the extension is using regex, which isn’t the best for parsing...
2020-02-13
23 reads
Quick tip: Quickly bulk edit lines in SSMS
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? In SQL Server Management...
2020-02-12
22 reads
Taking a gamble on Azure Data Studio Notebooks
If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice. I would think that the majority of SQL Server professionals...
2019-05-30
36 reads
I’ve added data classifications. Now what?
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,501 reads
Free SQL tuning tool: How’s My Database?
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
196 reads
Where have I been?
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...
2019-02-13
139 reads
Where to watch Ignite
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
260 reads
Are scalar functions really a bad thing?
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
3,729 reads
Hello Denver! I’m speaking this weekend
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you...
2018-09-11
211 reads
Blogs
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a...
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having...
Renewed as a Friend of Red Gate
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
Forums
Table self-join for derived columns
Hi, I have a requirement to derive additional columns and populate the values by...
REPLICATION, Dropping Subscription Taking A Long Time
USE Published_DB; EXEC sp_dropsubscription @publication = N'Published_DB_Publication', @subscriber = N'all', @destination_db = N'Published_DB', @article...
How to use next record's date as End date of current record?
I have a select statement which its result is something like this: I would...
Ask SSC