Database Superhero Adventures, July 2018
Sorry readers, I was having some many adventures there was no June edition. In May, I had SQLSaturday Dallas where...
2018-07-02
62 reads
Blog Posts
Introduction to Docker and Docker Toolbox
The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding Docker and...
2018-07-02
500 reads
Mastering Index Tuning–Day 2
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-02
947 reads
Microsoft Azure – Enable Geo replication of data – Cosmos DB Part 2
In this article, we will learn how to replicate the data to any Azure region globally. Global Distribution Azure Cosmos...
2018-07-02
376 reads
Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second MVP award. This is an truly an honor and...
2018-07-02
11 reads
Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second...
2018-07-02
344 reads
New at Simple-Talk: Principles of Data Protection
My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we...
2018-07-02
362 reads
SSMS reset window layout (Day 37)
SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...
2018-07-02 (first published: 2018-06-20)
4,688 reads
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,390 reads
DevOps Debugs the Demo
I had my 24 Hours of Pass session today, Database DevOps to Ensure Compliance, and my demo broke. At least,...
2018-06-29 (first published: 2018-06-12)
2,148 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