February, 2009

Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity

| |

|

Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity

VSTS Web Test Step-by-Step Primer: 7-Minute Video by Microsoft A.C.E. Performance Engineer Chris Lundquist (with Copious Notes and Screen Shots from Your Humble Correspondent)

Posted over 4 years ago

by Murat
- 1 Comments
My decision to focus on the SQL Server vertical has paid off for me—metaphorically & literally. Now it's time to spread my wings a bit & learn about Visual Studio Team System (VSTS) web testing. Spread Your Wings! http://www.youtube.com...
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity

SSMS Query Results: “Include column headers when copying or saving the results"

Posted over 4 years ago

by Jimmy May
- 7 Comments
In my work with external customers, I collaborate with some excellent DBAs & Architects. But I've noticed many of them are not aware that you can capture column headers from query results to grid in SSMS. When a very bright engineer I work with...
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity

sp_reset_connection Does NOT Reset TRANSACTION ISOLATION LEVEL: Unexpected Behavior By Design

Posted over 4 years ago

by Jimmy May
- 6 Comments
I've long been an advocate of the best practice of explicitly setting the transaction isolation level in my scripts. At my old day job as an enterprise architect I mandated that along with SET NOCOUNT ON , the preamble for all SProcs explicitly must...