Rocky Mountain Tech Trifecta Impressions
I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack...
2010-02-28
1,491 reads
Blog Posts
SQL Agent – Giving non-SA users permissions on jobs
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more...
2010-02-28
15,119 reads
Weekly Electrical Usage from Google PowerMeter
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,572 reads
Batch Starting SQL Server Services
Many times when going from demo to development to client demo, we are always starting and stopping our SQL Server...
2010-02-27
1,557 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,438 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,110 reads
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,570 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers