Extended Events and Performance Tuning Knowledge
I’m working on updating my book, Query Performance Tuning Distilled, so that it reflects the new things available in SQL...
2011-10-05
1,821 reads
The Scary DBA
Networking
No, I’m not talking about hubs and switches. I’m talking about people. Networking is a major component of an event...
2011-10-03
1,150 reads
SQL In The City: LA
Just a reminder that there are a few seats left for SQL In The City: LA on the 29th of...
2011-09-30
1,522 reads
Book Review: Smarter, Faster, Cheaper
In my continuing quest to not get personal visits from Buck Woody (blog|twitter) I’m making sure that I make good...
2011-09-26
1,481 reads
SQL Server Execution Plans
I writequitefrequently about SQL ServerExecution Plans. I started in that area just because that’s how you figure out what a...
2011-09-22
833 reads
MicroTraining: Performance Tuning Checklist
I’ve been playing a lot with Google+ and the Hangouts there. I love them. I think they’re opening up a...
2011-09-21
1,014 reads
Statistics in Execution Plans
I was presenting on execution plans when another question came up that I didn’t know the answer to immediately. Yes,...
2011-09-20
1,355 reads
St. Louis SQL Server Users Group Feedback
You know I share what feedback I get from conferences. I don’t usually get feedback from users groups (well, I...
2011-09-16
864 reads
Probe Residual on Hash Match
I have to say, I only recently noticed this on a tool tip:
and this in the property sheet:
The bad news...
2011-09-15
1,692 reads
Meme Monday: Favorite PASS Memory
Have to complete my assignment from the Rockstar this month since I’ve missed the last several (he gets all weepy,...
2011-09-06
602 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