Spring Still Not Really Hitting Montreal Yet, thus More Time to Hunt Down Useless Indexes
Hopefully, by the time we have our annual family vacation in May, the Cherry Blossoms will be out – until then...
2009-04-23
750 reads
Simple Maintenance Tasks for Non-Production Databases
Log File Sizes:
It's not unusual to see cases where database backups are taken from production and restored to a development or QA environment....
2009-04-23
1,345 reads
Want a SQLSaturday Polo or Tshirt?
I've had a few requests for these, so I'll take orders through May 8, 2009. The polo is a very...
2009-04-23
831 reads
The Twitter Ripples
I saw this post on The Business of Software Blog about a use of Twitter to spread the word for...
2009-04-23
646 reads
The Google Containers
After my editorial on portable data centers, I had a number of people knock down the idea, saying it doesn’t...
2009-04-23
816 reads
Internal Outsourcing
We'll all heard about or lived with outsourcing, and hopefully we know it's good and bad. Outsourcing the janitorial services...
2009-04-22
978 reads
Day of DotNutNuke in Tampa on June 13, 2009
My friend Will Strohl is managing the Day of DNN on June 13, 2009 at the Microsoft office in Tampa....
2009-04-22
708 reads
Behind Every Great Restore is a Great Backup
Behind Every Great Restore is a Great Backup
I showed you how to do a database backup with powershell a few...
2009-04-22
2,515 reads
Thoughts on SSC Blog Site Improvement
I have been reading blogs from various sources, such as blogs on SSC, and on sqlblog.com etc. However on all...
2009-04-22
754 reads
Human Data Quality
Disclaimer: I read and speak one language, having failed pretty well at learning Latin, Spanish, and then Japanese in my...
2009-04-22
1,050 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