LEFT(), or Left Out?
So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language. Like the...
2010-01-13
667 reads
Blog Posts
New Article on Clustering Myths in the PASS SQL Server Standard
The PASS SQL Server Standard has published a new article called “Busting 6 SQL Server Failover Clustering Myths”, by Kathi...
2010-01-13
380 reads
PASS 2009 Evaluation Results
The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server...
2010-01-13
413 reads
PASS DBA Virtual Chapter Presentation
I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of...
2010-01-13
927 reads
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
649 reads
SQL Pass session evaluations
I finally got the last of my PASS Summit session evals and so, like someotherpeople, I thought I’d make them...
2010-01-13
574 reads
SQL Server Standard Volume 7 Issue 1
Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more...
2010-01-13
840 reads
Tally Table - String Cleaning
Overview
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a...
2010-01-13
4,202 reads
The Advantage of GUIDs
I never liked GUIDs, not really using them in most of my development until I had a conversation many years...
2010-01-13
688 reads
Why not play my cards?
Still no work on my laptop. It’s been over 24 hours since I left a message for the customer escalation...
2010-01-13
722 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