Undercover Catalogue 0.1 Released
Easily Keep Track of All Your SQL Servers
We know what it’s like when you’ve got 101 SQL Servers to manage,...
2018-08-28
283 reads
Blog Posts
Upcoming Performance Tuning Webcast
On September 13, 2018, at 3 PM Eastern (USA), I’ll be giving a webcast for MSSQLTips.com on finding and correcting...
2018-08-28
215 reads
What is Automatic Tuning in Azure SQL Database
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
517 reads
Advantages of Azure Resource Manager (ARM) Deployment Model
Are you just starting out with Azure and wonder: What is Azure Resource Manager (ARM) Deployment Model? Or what’s the...
2018-08-27
267 reads
Copying formatted text out of a grid column.
I was reading a post today by Bert Wagner (b/t).
Displaying Long Variable Values in SQL Server
By the way, if...
2018-08-27
907 reads
SQL Server Encryption, What’s The Key Hierarchy All About?
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...
2018-08-27 (first published: 2018-08-09)
1,847 reads
SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?
(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...
2018-08-27 (first published: 2018-08-09)
4,068 reads
Two Posts About PASS
I’m a little late getting to this, but I think both of these are worth reading:
https://www.linkedin.com/pulse/open-letter-pass-group-leaders-sql-saturday-steve-rezhener-mba/https://medium.com/@SteffLocke/sqlsaturdays-shouldnt-give-up-pass-money-a478a97ee0c7Suggest you post any thoughts...
2018-08-27
275 reads
Why I Love Extended Events, Reason 394: Customize Live Data
There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that...
2018-08-27
359 reads
Azure Every Day, Azure Data Week, and More Azure
As you likely know, I am a Principal Consultant at Pragmatic Works. This year we have been doing some great...
2018-08-25
387 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