A Day in the Life (3/?) - September 13, 2018
This is my third installment in a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the day, filling...
2018-09-24
9 reads
Blog Posts
Accidentally deleted an Azure SQL DB?
Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest...
2018-09-24
268 reads
Azure Cognitive Services – Search APIs
Throughout this week’s Azure Every Day blog posts, I’ll focus on different APIs available with Azure Cognitive Services. With Azure...
2018-09-24
274 reads
Escaping strings
No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom.
Not...
2018-09-24
889 reads
Extended Events and Stored Procedure Parameter Values
One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently...
2018-09-24
502 reads
More PowerShell for fun (and profit) – filter files by date
PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in...
2018-09-24
737 reads
My upcoming Speaking Schedule
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-24
225 reads
Prefixated
Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...
2018-09-24
260 reads
Them Con+cat+enatin’ Blues
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...
2018-09-24 (first published: 2018-09-13)
3,202 reads
Using Table Valued Parameters with sp_executesql
Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to...
2018-09-24 (first published: 2018-09-13)
3,877 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