Revisiting The West Wing
Sometimes spending some time with your spouse watching TV is right up there with comfort food, the challenge is often...
2010-09-30
1,430 reads
Blog Posts
SQL Saturday 52 Recap
I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver. This was the...
2010-09-30
2,939 reads
SQL Server 2008 Service Pack 2 Released
Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack...
2010-09-30
1,693 reads
Stupid Tech Support Tales
One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log:
"9/22/2010...
2010-09-30
1,493 reads
When the Bloc Québécois is a Nuisance for Quebeckers’ Interests: The Top 20 Countdown
The below is a republished version that has been released officially on the Canadian Federal Liberal Party's web site. Finally...
2010-09-30
8,722 reads
A Small Selection of SQL Azure System Queries
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...
2010-09-29
1,606 reads
Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,790 reads
Don’t Take me (too) Literally
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,534 reads
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,821 reads
How to Prove a Fact (Again)
Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about...
2010-09-29
1,476 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