LiveWriter 2011
I recently upgraded to LiveWriter 2011 while upgrading to the final version of LiveMesh. After the upgrade I noted the...
2010-12-01
340 reads
Blog Posts
No More Drive Extender - Windows Home Server
I guess I might need to go back to RAID. From the Windows Team Blog, there is a decision to...
2010-12-01
442 reads
Passing SSRS T-SQL Values to SSRS MDX Parameters
At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source....
2010-12-01
2,374 reads
Real World SQL Azure
Worthy of an editorial, but this is a pretty good use-case for why SQL Azure might make sense. This is...
2010-12-01
402 reads
RTFM365
Physicians have primum non nocere – a Latin phrase that means “First, do no harm”. (Thank you, WikiPedia.) I think for...
2010-12-01
594 reads
Semi-Crippled
When it rains it pours.
Last week my Nano died. It won’t hold a charge, or at least it won’t...
2010-12-01
447 reads
The Development DBA Role
The Development DBA role, though not as common as the more prominent DBA and Database Developer roles in the database...
2010-12-01
4,500 reads
When Were The Statistics In SQL Server Last Updated?
When SQL Server receives a new query, the Query Optimizer undertakes the task of identifying a good plan to resolve the...
2010-12-01
678 reads
2010 PASS Summit Slide Decks and Scripts
How time flies - it really has been almost 2 1\2 weeks since the 2010 PASS Summit came to a close!...
2010-11-30
1,502 reads
Book Review: Chasing Daylight
I read Chasing Daylight by Eugene O’Kelly after a reference to it in an audio book. It’s the story of...
2010-11-30
1,508 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