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
Rocky Mountain Tech Trifecta 2.0 – First Thoughts
It was a good day down in downtown Denver at the Rocky Mountain Tech Trifecta 2.0. I presented a session...
2010-02-27
1,440 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,779 reads
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,114 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,772 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,400 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,944 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,467 reads
User Group Leaders: Who Are Your Members?
At the MVP Summit last week, I was talking with fellow Dallas-area tweep Sean McCown about our local SQL Server...
2010-02-26
1,643 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,576 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers