THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
IT Horror Stories
SQL Server 2008 R2
Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)
The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t ...
April 9, 2014
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