Fashionably Late, but She's Here!
I'm pleased to announce the latest addition to the Kelley family, a beautiful baby girl born at 11:56 PM last...
2010-12-21
715 reads
Blog Posts
Get Prepared for the January Hiring Season
Get Prepared for the January Hiring Season
As the year winds down, in what was undoubtedly a tough economic year for...
2010-12-21
763 reads
MCM Live Blog – Week December 20
Watching videos?! Su-ure!
Time for the second week of blogging about the things that I’m doing to study for the MCM...
2010-12-21
590 reads
Pragmatic Works: The Transition
So if you know me via Twitter or my blog you
probably know that as of about a month or two...
2010-12-21
983 reads
SQL Server 2008 R2 RTM Cumulative Update 5 Released
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 5 (CU5), which is Build 1753. I count 40 separate...
2010-12-21
890 reads
SQL Server Storage Internals Part 4 - How to read a Heap page
I like to share 4 updates before moving on to this section:
1. I 've updated my profile to know more about...
2010-12-21
7,758 reads
The 9th Day of SQL: Things Aren't as Simple as They Seem
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which...
2010-12-21
707 reads
And the winners are….. (iPads for Christmas contest)
Congratulations to the following winners of our iPads for Christmas contest. It was a hard choice, but I ended up...
2010-12-20
1,301 reads
Another Lunch Story
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
585 reads
Can You Dig It? – SHOWPLAN XML Structure
She can dig it!
D Sharon PruittIn the last couple plan cache posts, I talked about a couple items that are...
2010-12-20
890 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