Checking Trace Flags with dbachecks, online docs and PSPowerHour
It’s been a few weeks since i have blogged as I have been busy with a lot of other things....
2018-10-10 (first published: 2018-09-29)
1,956 reads
Blog Posts
Inspector V1.2 now available
It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...
2018-10-10
371 reads
Inspector V1.2 revised installation guide
Pre-requisites:
SQL 2012 or higher
SQL Server Agent
A database to store the the data collected by the agent jobs (this can be...
2018-10-10
296 reads
T-SQL Tuesday #107 - Death March
This month’s T-SQL Tuesday is hosted by Jeff Mlakar and he asks us to write about a project that went horribly wrong. My story isn’t really worthy of the...
2018-10-10
10 reads
Veterans At PASS Summit ’18
Hello all!
This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service...
2018-10-10
191 reads
Letting the business bully you: T-SQL Tuesday #107
Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in...
2018-10-09
225 reads
minikibe on windows, getting stuck on networking issues like cant connect messages?
Reading Time 1 Minute
I have been getting kubernetes setup on my laptop via minikube and I followed all the examples to the T, especially the part about creating a...
2018-10-09
14 reads
minikibe on windows, getting stuck on networking issues like cant connect messages?
Reading Time 1 Minute
I have been getting kubernetes setup on my laptop via minikube and I followed all the examples...
2018-10-09
208 reads
No More Mysterious Truncation
If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions...
2018-10-09 (first published: 2018-09-26)
3,371 reads
Power BI Custom Visuals Class (Module 118 – Stacked Bar Chart by Akvelon)
In this module you will learn how to use the Stacked Bar Chart by Akvelon. This version of the Stacked...
2018-10-09 (first published: 2018-10-03)
2,166 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