The Vacation Crash
The family returned back from the UK last night, after traveling for something like 14 hours, plus an early morning...
2010-03-31
1,548 reads
Blog Posts
Auditing Report Executions with Free Source Code
Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? ...
2010-03-30
1,719 reads
Building a Wiki
I’ve long admired the value that I get from Wikipedia and like the concept of crowd sourcing knowledge, just never...
2010-03-30
1,649 reads
Didn't I Just Post about Slipstream making Installs Easier?
So the other day I posted, Slipstream - Makes installs simple, and this afternoon I needed to do a SQL Server...
2010-03-30
1,401 reads
FizzBuzz Revisited
I had bigger plans for this series than what has transpired. I think that is a testament as to how...
2010-03-30
1,950 reads
2010-03-30
1,463 reads
Instructables Contest: Paracord
Instructables has a Paracord contest going that requires some portion of a project include paracord (often referred to as 550...
2010-03-30
1,856 reads
SP_change_users_login and SQL Server 2008 onwards
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to...
2010-03-30
5,804 reads
SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!
With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases...
2010-03-30
6,187 reads
Stepping Stone Cert
A few of us have been deliberating and discussing the need for a bridge certification between the MCITP and MCM...
2010-03-30
1,549 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