Tools

SQL Server is a huge product and there are few products which I personally use to improve my productivity.

Red-Gate

Red Gate Software is a software company based in Cambridge, UK. It primarily provides tools for database developers and administrators.

SSMS Tools Pack

SSMS Tools Pack is a Microsoft SQL Server Management Studio (SSMS) add-in.

SQL Power Tools

Sql Power Tools Server Bottleneck Monitor performs agentless monitoring of wait types, wait times, disk bottlenecks, TempDb bottlenecks, SQL performance, SQL plan mining, top N SQL, performance counters, blocking, deadlocks, procedure cache, buffer cache, database space, disk drive space, SQL jobs, performance baselines, VMware and Hyper-V. With one-click graphing of SQL plans.

SQL Space Map

SQL Space Map is a tool that lets you quickly and easily view the relative size of database objects on a map, so you can compare them visually. It helps identify large objects, objects with a high index/data ratio, and tables which may be growing more quickly than expected.

Custom SSIS Tasks

Row Number Transformation by Darren Green

File Watcher Task by Darren Green

File Properties Task by toddmcdermid

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s