Cardinality: Not Just For The Birds
Watch this week’s episode on YouTube.
When building indexes for your queries, the order of your index key columns matters. SQL...
2019-01-29
1,023 reads
Blog Posts
Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,216 reads
Deploying SQL Server to Kubernetes using Helm
In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...
2019-01-29 (first published: 2019-01-16)
2,671 reads
Midlands PASS Meeting – February 5, 2019
Midlands PASS (Columbia, SC) will be hosting Shannon Lowder on February 5, 2019, from 5:30-8:00 PM. He will be speaking...
2019-01-29
147 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...
2019-01-29
5 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here....
2019-01-29
184 reads
Query tuning: The IN clause
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
2,653 reads
Research into Autism in Information Technology
Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis
My name is Sabrina Ellis, I am the Operations Director here at...
2019-01-29
35 reads
Research into Autism in Information Technology
Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis
My name is...
2019-01-29
197 reads
SSDT: Build in VSCode
Over the last couple of years I have been using VSCode more and more and Visual Studio less and less, this is great but there isn't first class support...
2019-01-29
5 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