SQLSaturday #49 – Orlando: Event Recap
SQLSaturday #49 – Orlando was this past weekend (October 16th, 2010). As one of the event organizers the entire week was...
2010-10-21
571 reads
Blog Posts
SQLSaturday #49 Orlando – Recap
This past weekend I had the pleasure of presenting at another great SQLSaturday event, number 49 actually and the 3rd...
2010-10-21
1,173 reads
SQLSaturday #59 – Speaker Interview Series #8 with Aaron King.
SQLSaturday #59 – Speaker Interview Series #8 – with Aaron King.
We interrupt this blog post to bring you the latest SQLSaturday#59 News...
2010-10-21
1,112 reads
SSC Editorial – Cheap Fun
I wrote Cheap Fun after buying a really cheap – $1 – wood airplane kit at the store for the kids. Amazing...
2010-10-21
739 reads
The best things in life are free
Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product. Plan explorer is a...
2010-10-21
2,940 reads
Boulder SQL Server User’s Group - Common SQL Server Mistakes
The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...
2010-10-20
988 reads
Common SQL Server – Not Indexing FKs
This series looks at Common SQL Server mistakes that I see many people making in SQL Server.
Foreign Keys
It’s way too...
2010-10-20
1,313 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
747 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,436 reads
Minutes of the September 2010 PASS Board Meeting Posted
Please take a few minutes to review the September 2010 minutes (login required). We just had our October meeting on...
2010-10-20
663 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