2019-04-04
661 reads
Editorial
I'm In Charge of Books Online
Today Steve has an announcement about his role in moving Books Online forward.
2019-04-01
549 reads
Containers Are The Present, Not the Future
Last week was the MVP Summit. This year included a bunch of very technical discussions about some of the future of the Microsoft Data Platform (a big thank you goes to Slava Oks, Bob Ward, and all the team for a great job). I can’t share much since it was all under NDA. All I […]
2019-03-30
508 reads
Trunk Based Database Development
Trunk based development is what many of us do with shared database servers.
2019-03-29
712 reads
Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
258 reads
No More SQL Server Installs
Today, Steve wonders when we'll stop installing SQL Server on a host machine.
2019-03-26
1,276 reads
What's Worse than Announcing a Data Breach?
Steve has a few thoughts on what is worse than telling your boss about a data breach.
2019-03-25
151 reads
Query Tuning Assistant: A Tool for Upgrades
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
2019-03-25
1,247 reads
2019-03-22
126 reads
The V1 Team’s Doomed Redesign
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
106 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