Speaking at SQLSaturday #14 in Pensacola on June 6, 2009
I'm driving over tonight to spend a long weekend in Pensacola (6-7 hour drive from Orlando) for their first SQLSaturday,...
2009-06-03
470 reads
SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,328 reads
TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,491 reads
Scripting Our Daily (Professional) Lives
I talk a lot about scripting tasks on our servers to automate our regular processes, but in this case I'm...
2009-06-03
347 reads
Seatguru - Getting a Good Seat on the Plane
Ran across this a while back and just getting to it, Seatguru is a site that lets you figure out...
2009-06-03
389 reads
I Learned a New Word
Do you know what a Geoid is?
I’ve been working my way through Beginning Spatial with SQL Server 2008, actually “through”...
2009-06-03
658 reads
Balancing Priorities
This one isn't a technical post, but it's entirely appropriate to those of us in the IT field. Today was a...
2009-06-02
775 reads
Other Desktops
The USB not in Hyper-V thing is annoying. It actually made me stop and consider my alternatives for a desktop....
2009-06-02
773 reads
Reminder - SQLSaturday #12 in Portland is June 6, 2009
Ken Starnes from the Portland group will be having their first event on June 6th. I like the way they've...
2009-06-01
299 reads
Notes on SQLSaturday #7
I flew up to Birmingham Friday for SQLSaturday #7 organized by John Baldwin from Steel City SQL and a lot...
2009-06-01
712 reads
Blogs
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...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
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