Regular Expressions: tagging expressions
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take...
2018-10-15
379 reads
Blog Posts
SQL Pivot and Unpivot relational operatots
In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose...
2018-10-15
265 reads
Starting SSMS with a specific connection and script file
Have you ever wanted SSMS to start and automatically and establish a connection to your DBA \ hub server and have...
2018-10-15 (first published: 2018-10-02)
7,726 reads
Last week reading (2018-10-14)
Hi guys! Not too much this week as I was very busy on #DataRelay tour across UK whole week (relation...
2018-10-14
57 reads
Installing minikube on CentOS
In this blog post, I’ll show you how to install Minikube on CentOS. Minikube is a platform you can use...
2018-10-13
3,134 reads
Installing minikube on CentOS
In this blog post, I’ll show you how to install Minikube on CentOS. Minikube is a platform you can use to test kubernetes clusters on your local machine or...
2018-10-13
19 reads
My Current Training Courses on Pluralsight!
Here’s a run down of the Linux training that I have available on Pluralsight!
Just getting started!
Understanding and Using Essential Tools...
2018-10-13
408 reads
My Current Training Courses on Pluralsight!
Here’s a run down of the Linux training that I have available on Pluralsight!
Just getting started! Understanding and Using Essential Tools for Enterprise Linux 7 – If you heard...
2018-10-13
4 reads
SQL Server on Linux – External Memory Pressure with 2019 CTP2
In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is a very long post, and it ends with me...
2018-10-13
9 reads
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager...
2018-10-12 (first published: 2018-10-01)
2,451 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