SQL Server Blocked Process Monitor
Jonathan provides a tool via codeplex to track and capture the details of blocked processes, saving us the hassle of manually creating traces ... Source : Jonathan Kehayias - codeplex.com
Data type conversion
A timely reminder from Tibor to watch out for implicit data type conversion ... Source : Tibor Karaszi - SQLBlog.com
Common SQL Server Security Issues and Solutions
In this article, Paul tackles a number of important security issues from physical and network security through to SQL Injection, auditing and service accounts ... Source : Paul Randal - Technet Magazine
What the?
What looks odd here? select * from person where 'thomas' in (Firstname,LastName,LEFT(emailaddress,7)) ... Source : Denis Gobo - SQLBlog.com
Partition switching gotchas
Important things to consider when switching-out partitions in SQL Server 2005 / 2008 ... Source : Microsoft SQL ISV Program Management Team - Blog Post
Index Defrag script
Aaron provides some personal tweaks to Michelle Ufford's Index Defrag script ... Source : Aaron Bertrand - SQLBlog.com
Limiting connections to a specific application
Aaron lets us in on a little known SQL Server feature; the ability to restrict connections to a particular application ... Source : Aaron Bertrand - SQLBlog.com
Troubleshooting Performance Problems in SQL Server 2008
From the whitepaper summary "This paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as SQL Server Profiler, Performance Monitor, dynamic management views, and SQL Server Extended Events (Extended Events) and the data collector" ... Source : SQLCat.com - Whitepaper
Locked pages in memory
Sankar provides a quick and painless way to determine if a SQL Server instance is using Locked Pages in Memory ... Source : Sankar Reddy - SQLServerPedia.com
T-SQL debugger for SQL Server 2008
The first of Bill's three part series on using the T-SQL debugger in SQL Server 2008 ... Source : Bill Ramos - MSDN.com - Blog Post
Recursive Queries
Linchi answers one of life's great questions; How do recursive queries actually work? ... Source : Linchi Shea - SQLBlog.com
Standardized SQL Server 2008 Audit
Lara provides several scripts to help get us started on creating standardized SQL Server audits ... Source : Lara Rubbelke - SQLBlog.com
Roadmap of SQL Server Certifications
Pinal Dave provides us with a link to his SQL Server certification roadmap pdf ... Source : Pinal Dave - SQLServerPedia.com
Memory deep dive
The first of Ulrich's 9 part series on memory. Whilst not written for a SQL Server audience, it's a great read nonetheless. Lots to be learned here ... Source : Ulrich Drepper - LWN.net
Controlling Lock Granularity
In this post, Kalen talks about the new options in SQL Server 2008 for controlling lock granularity ... Source : Kalen Delaney - SQLBlog.com
Using @@ROWCOUNT in Triggers
Steve warns us of the dangers of using @@ROWCOUNT in Triggers ... Source : Steve Kass - SQLBlog.com