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
Alamat Kantor Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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