SQL Saturday returns to the Boston area this April, with what is certain to be an exceptional speaker and session lineup. (The actual schedule will be posted soon, but in the meantime you can see the submitted sessions.) The free event ($10 if you'd like to eat lunch) will take place on Saturday, April 6. Highly recommended for anyone in the area ...

Fixes the following issues:Bug with transaction information not working for databases with ''th'' in their nameBug with very large CPU times causing an overflow exception on SQL Server 2005Excessive tempdb utilization caused by large string concatenationAdded host_process_id to additional_info collection

Contains fixes for a couple of minor bugs that existed in v11.00.

One of my first major projects at SQL Sentry was framed shortly after I joined the company: to publish an analysis of the overhead that Performance Advisor and Event Manager place on both the server(s) being monitored and on the server(s) doing the monitoring. Every vendor wants to sell you on the ''zero impact'' and ''no footprint'' lines, but we ...

Who is Active? is a comprehensive server activity stored procedure based on the SQL Server 2005 and 2008 dynamic management views (DMVs). Think of it as sp_who2 on a hefty dose of anabolic steroids. Features supported by Who is Active? include: Server activity collection, including data about currently running T-SQL, server resources ...

Who is Active? is a comprehensive server activity stored procedure based on the SQL Server 2005 and 2008 dynamic management views (DMVs). Think of it as sp_who2 on a hefty dose of anabolic steroids. Features supported by Who is Active? include:Server activity collection, including data about currently running T-SQL, server resources ...

Today I am happy to release the newest official build of my Who is Active procedure: v10.00. For those of you who haven't been following along, here are some quick facts on Who is Active:Who is Active is a DMV-based monitoring stored procedure that uses 15 different views to show a large amount of data about what's running on your serverWho is ...

I find myself categorizing a subset of SSMS features ranging from ''must have'' features to ''cringe when they are mentioned.''  I'll try to summarize the standouts for you here, then ask you these questions: Which parts of SSMS do you rely on? Which do you wish were not there at all? The ''I almost always use it to get the task done.'' ...