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)
423 reads
Confessions of a Microsoft Addict
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
72 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,526 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
208 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
140 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
261 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
213 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,870 reads
I’m speaking at SQL Saturday 749 : Baton Rouge
Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many...
2018-07-27
496 reads
SQL Saturday Houston is this weekend
I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the...
2018-06-19
305 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
ASCII value of certain column is null
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Ask SSC