Why CONTROL SERVER Doesn't Cut It
With the new securables since SQL Server 2005, Microsoft has advised that we start moving away from the fixed server...
2010-10-26
4,544 reads
Blog Posts
You know you want it! - SQLRally Precon Voting
For those of you who have seen our team present, we always do our best to make it really informative,...
2010-10-26
871 reads
Another Must See Session
I can’t believe I missed this one in all the posts and recommendations I’ve been making about great sessions coming...
2010-10-25
447 reads
Bloggers, Quit Worrying About Spam
I don’t comment as often as I should on blog posts. I say should because as a blogger I know...
2010-10-25
612 reads
Fundamentals of Storage Systems, Solid State Storage Basics
Solid state storage is the new kid on the block. We see new press releases every day about just how...
2010-10-25
1,437 reads
My SQLSat54 Experience
In case you hadn’t heard SQLSaturday #54 was Oct 23 in Salt Lake City. It was a dreary opening to...
2010-10-25
1,119 reads
PragmaticWorks Webinar – Policy-Based Management
This is just a quick note to remind everyone I’ll be presenting tomorrow, Tuesday October 26th 2010 for the PragmaticWorks...
2010-10-25
563 reads
Return of Index Analysis Part 5
Let’s Anaylze An Index!Alright, up to the last of the changes I’ve made to the index analysis query that I...
2010-10-25
1,538 reads
Slides & samples from my SQLdays 2010 sessions and workshop
As announced in my workshop and in my sessions at the SQLdays 2010 last week in Rosenheim/Germany,
you can download my...
2010-10-25
470 reads
SQL Rally Voting
I received word over the weekend that my precon application had made it past committee and was now subject to...
2010-10-25
610 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