The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
757 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
10,025 reads
HP Netbook 1030NR Setup
Unpacking the netbook was pretty simple. Open it, grab the large one page poster, and then the netbook. There were...
2009-07-01
705 reads
How to Become an Exceptional DBA, 2nd Edition, Now Available Free
About a year ago, the first edition of my book, How to Become an Exceptional DBA, was published. It was...
2009-07-01
1,817 reads
HP Netbook Mini 1030NR
It was not what I expected. When I was leaving for a run this morning, I decided to apply an...
2009-07-01
1,328 reads
Powershell SQL Server Backup/Restore
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,150 reads
Connector Editorial for July 1, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-30
1,517 reads
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,444 reads
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-06-30
42,035 reads
Unwired for Days
Today is the first day that I've really had any significant time on the computer over vacation. That probably sounds...
2009-06-30
1,380 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