THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 2008 R2
New White Paper: SQL Server Extended Events and Notifications
SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look? As ...
April 25, 2012
Everybody Needs a Test Harness
When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
October 31, 2011
Brought to you by