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)
431 reads
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)
431 reads
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
67 reads
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
2,476 reads
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
80 reads
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,528 reads
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
209 reads
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...
2019-02-13
140 reads
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
262 reads
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,897 reads
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you...
2018-09-11
213 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers