Spring Cleaning
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
531 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds...
2009-06-23
3,055 reads
What Would You Like to See in a Book on Database Maintenance?
I am working on the outline of a new book I am writing, tentatively called Mastering SQL Server Database Maintenance....
2009-06-23
684 reads
Clear Ceases Operations
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
630 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I...
2009-06-23
2,022 reads
Tips on Getting Hired – Part 5
I think the hardest part about the job search is interviewing and not being selected. You keep saying “why” with...
2009-06-22
616 reads
Emergency Procedures
In a followup to Aaron Bertrand's recent blog post on Disaster Recovery, I'd like to mention something I always mention...
2009-06-22
370 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install.
One of the things I always says is...
2009-06-22
3,380 reads
When the next object-persistence boat comes in.
I was reading a MCP training manual for SQL Server the other day. It was good. The whole of TSQL...
2009-06-22
1,746 reads
Big Thinker
My friend Robert Cain was kind enough to include me on his list of big thinkers along with my business...
2009-06-22
808 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
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...
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