solving sql server problems for millions of dbas and developers since 2006

Top SQL Server Tools

SQL compliance manager

SQL diagnostic manager

SQL Server performance monitoring that makes prioritizing simple

SQL Sentry Performance Advisor

SQL Source Control

Sankar Reddy

Sankar is a Database Engineer/DBA currently working for FunMobility, a mobile media entertainment company. He has been working with SQL Server from 2003 in a variety of roles including development DBA, Database administrator, Report writer and datawarehouse developer. Currently he works with high traffic OLTP and Tera byte datawarehouse systems. Sankar spends most of his free time at MSDN social forums answering questions.

Deprecated Features

Identify Deprecated SQL Server Code with Extended Events (10/13/2009)

Indexing

SQL Server Unique Constraints for Large Text Columns (10/28/2009)

Reporting Services Monitoring

How to easily identify a scheduled SQL Server Reporting Services report (9/28/2009)

Reporting Services Parameters

Script to determine SQL Server Reporting Services parameters, path and default values (9/17/2009)

SQL Server Agent

Script to determine verbose logging options of SQL Server Jobs (4/27/2010)

System Databases

SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events (10/7/2009)

Triggers

Script to check SQL Server connection pooling (9/4/2009)

Sponsor Information

SQL Server having some performance issues? Idera SQL check. FREE SQL Server enhancement.

SQL Monitor: prioritize your SQL Server workload with easy-to-use performance monitoring

What grade do you think your SQL Servers get? Find out with Edgewood's Health Check consulting services.

The COMPLETE Performance Solution for SQL Server - SQL Sentry

Optimizing SQL Server performance can be a daunting task. Or is it?