Should DBAs be Paid Overtime?
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
2010-02-27
3,110 reads
Blog Posts
Starting a SQL Server Blog
This is day one of my SQL Server blog so I’m not looking to write anything deep or insightful or...
2010-02-27
1,764 reads
Tally Table - Delimited list to Table
Dealing with delimited lists (Usually separated by a comma) in SQL is a problem easily handled by a simple function...
2010-02-27
3,776 reads
Article in SQL Server Magazine on SQL IO Stastics.......
Article on I/O tips appearing on SQLMag.com
If you've followed my blog, you know I've written on various topics, including I/O...
2010-02-26
1,943 reads
Book Review: Orbit by John J. Nance
Just finished re-reading Orbit ($15 or less at Amazon) after picking it up for a $1 at Books a Million...
2010-02-26
1,572 reads
Dr. DMV Script for Rocky Mountain Tech Trifecta
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,769 reads
Driving Issues with software
This is an interesting piece, talking about some of the software issues with Toyota and how that might come to...
2010-02-26
1,466 reads
Help with Learning Powershell
If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly...
2010-02-26
1,398 reads
More Snapshot Backups
I got some more feedback from my Connect item on allowing snapshot backups. They took notice, but I heard the...
2010-02-26
1,558 reads
Suncoast Technology Forum Tech Fest Event 2010
I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will...
2010-02-26
1,756 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