An Experiment with Deadlocks
There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...
2019-03-25
231 reads
Blog Posts
Can You Force A Parallel Plan in Query Store?
I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be...
2019-03-25
94 reads
Changing physical locations of all DBs
I got a request this week from an application engineer. The request was to move ALL physical database files from...
2019-03-25 (first published: 2012-07-02)
4,444 reads
Communication in Azure: using Data Factory to send messages to Azure Service Bus
(2019-Mar-10) A conversation between two or more people involves continuous efforts to listen and reflect on what other people have to...
2019-03-25 (first published: 2019-03-10)
11,032 reads
Installing and Configuring SQL Server on Linux
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-03-25
951 reads
Last Week Reading (2019-03-24)
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
5 reads
SQL Server Availability Group Failovers in Kubernetes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-03-25 (first published: 2019-03-11)
535 reads
SQL Source Control and Bitbucket–Getting Started
This is in response to someone asking about getting started with their database in SQL Source Control and then hosting at BitBucket. I’m going to assume people can set...
2019-03-25
424 reads
SSMS Tip #3: Easily Access/Research ALL Unicode Characters (Yes, Including Emojis ??)
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.… Continue...
2019-03-25
591 reads
Weekly reading #8
Good day! Good week! Let’s start it with some news form the Data Platform world!
SQL Internals – Physical Table Structure under...
2019-03-25
231 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers