Advice I Like: Naps
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living I don’t like naps. In fact, I try to avoid them and keep...
2025-08-15
25 reads
The Voice of the DBA
T-SQL Tuesday #189–AI and your Career
I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly...
2025-08-13
54 reads
Using SQL Compare to Revert a Stored Procedure
Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do...
2025-08-13
133 reads
Adding a Named Default Constraint to a Table: #SQLNewBlogger
As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a...
2025-09-03 (first published: 2025-08-11)
479 reads
Just a few weeks to PASS on Tour and the Redgate Summit
It’s just a few weeks until the PASS Summit on Tour in New York City. This is the first event in the series, and I’m excited to go back...
2025-08-06
13 reads
Speaking at the PASS Data Community Summit
I’m honored to be speaking at the PASS Data Community Summit in Seattle this fall. I’ll be delivering a Professional Development session (Blogging for the Tech Professional), which might...
2025-07-22
57 reads
The PASS Summit on Tour in the Netherlands
The PASS Summit goes on tour this year, with the final date the first few days of October in the Netherlands, Utrect to be exact. This is the first...
2025-07-15
47 reads
Sample Data with GenAI in Seconds
A friend was asking for help with some data analysis. This was in PowerBI, and the source data was PII. I asked them to mask the data for me...
2025-07-14
38 reads
The PASS Summit on Tour in Dallas
The PASS Summit goes on tour this year, with a September stop in Dallas. This is the first event in the series, and I’m excited to go back to...
2025-07-09
70 reads
T-SQL Tuesday #188: Growing the Community
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
106 reads
Blogs
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers