Sankar Reddy, SQL Server Developer/DBA

In SQL Server 2008, some features are deprecated and we have many ways of identifying the deprecated features. In this tip (Identify Deprecated SQL Server Code with Extended Events), I wrote for MSSQLTips we will go over using . . . → Read More: Using Extended Events to find out the Deprecated features in SQL Server 2008

In SQL Server, unique constraints have a limitation of 900 bytes and this can be a limitation in some instances. In this tip (SQL Server Unique Constraints for Large Text Columns) I wrote for MSSQLTips, I explain some options that are available in SQL Server 2005/2008. Among the options, HASHBYTES seems to be the clear winner. . . . → Read More: Using SQL Server HASHBYTES for enforcing Unique constraints

SQL Server tempdb is a shared resource for every instance and can be a serious bottleneck. In previous versions identifying the bottlenecks per database was NOT that easy. In this tip (SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events) I wrote for MSSQLTips, I showed how we can use Extended events to track the . . . → Read More: Identifying SQL Server tempdb bottlenecks using Extended Events

This is a valuable information to know for every DBA and I just posted a tip on MSSQLTips.com. Check out the tip at Script to check if connections to SQL Server are using connection pooling.

This post is inspired by James Rowland Jones’s post How To Tell: If connections to SQL Server are pooled (or not) few . . . → Read More: Are your applications connecting to SQL Server using connection pool?

I happen to work with a lot of reports, actually hundreds of reports and it really helps to know the parameters of the reports, the default values of those reports, formulae for these default values and if there are any hidden parameters. This information can be found by looking at the Properties | Parameters section on . . . → Read More: How to identify all the parameters of a Reporting Services report?

If you are working with Reporting Services then you might have noticed the pain of re-sending a subscription report. It’s a very tedious process and wrote a small neat script to make this process easy. This tip is posted on MSSQLTIPS and you can find it here (How to easily identify a scheduled Reporting Services report). . . . → Read More: Need to re-send a Reporting Services subscription?