The Wickedness of the mass 'REPLACE()'
I have been admonished in the past for the use of this code which makes as many
substitutions as you like...
2009-01-23
1,158 reads
The Story of Pumpkin Man
Another story from a previous job. I joined the company in August, in October they started prepping for Halloween - it...
2009-01-22
943 reads
What Do You Want Auditors to Know About Auditing SQL Server?
Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...
2009-01-22
1,102 reads
Read-Only Access to SQL Server Jobs
This question comes up a lot: how do I give read-only access to job status to a group of people?...
2009-01-22
4,064 reads
Influence
I saw Paul Kenny of Ocean Learningspeak about sales least year at the Business of Software Conference. I thought he...
2009-01-22
904 reads
Notes from the January 2009 oPASS Meeting
We had our first oPASS meeting of the year last week with about 18 attending. Jonathan Kehayias was our featured...
2009-01-21
685 reads
Play the T-SQL Alphabet Game
I recently had the opportunity to play the T-SQL Alphabet Game, which was introduced to me by SQL Server MVP,...
2009-01-21
1,254 reads
Mastering SQL Server Profiler E-Book Available for Free
After a lot of delays, my book on how to use SQL Server Profiler has been published by Simple-Talk Publishing,...
2009-01-21
4,398 reads
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
686 reads
Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've...
2009-01-20
1,137 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