Volunteering for PASS
I said I was going to do it last year, and I followed through. After submitting an application to volunteer,...
2010-03-15
744 reads
Blog Posts
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-14
1,705 reads
Setting Up a Server Side Trace
Recently I wrote a short post on the default trace in SQL Server. You can read that here. In this...
2010-03-14
14,834 reads
Twas the Night Before the MCM ...
T'was the Night Before the MCM ...
SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The...
2010-03-14
972 reads
Document, Document, Document
A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation....
2010-03-13
1,205 reads
Another Presentation Down
This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV). I...
2010-03-12
627 reads
Business needs vs dirty reads
I have worked in many industries, but most of my time has been in the publishing industry. For those not...
2010-03-12
294 reads
Don’t Be a Shock Jock
One of the dangers of being an “Internet Journalist” or even just a blogger, is that you might compromise who...
2010-03-12
1,013 reads
Great Turnout for The Montreal XV's First Practice - Rugby XV de Montréal Première pratique
The Montreal XV Rugby Club (rejuvinating the Rugby Football Club name from the 1920s) first practice was the other night at Collège Marie...
2010-03-12
802 reads
My Experience with a Virtual Assistant using TimeSvr
Predicting the future with bold certainty is not for the faint of heart. It’s a hard job. A few get...
2010-03-12
969 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries