Rocky Mountain Tech Trifecta – Beginning SQL Server
At the Rocky Mountain Tech Trifecta this past weekend in Denver, I presented a talk on “Beginning SQL Server”, a...
2010-02-28
1,570 reads
Blog Posts
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,484 reads
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,112 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,568 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,555 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,437 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,108 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,763 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,773 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,942 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers