Data Management

What is in your toolbelt?

As a DBA, you probably have several tools to help you in a bad spot. Have you heard of SQL Professional Toolbelt? It can be a handy addition to keep your SQL Server humming.

Are you a SQL Server DBA that wants to streamline work? Or maybe you are a Network Engineer that just inherited SQL Server tasks to do your job. If you are new or a seasoned veteran, there are specific tools available to help you with your day-to-day SQL Server tasks. RED Gate Software recently released a new service called SQL Professional Toolbelt, a compilation of all of their tools for an annual subscription. You can compare it to a Microsoft MSDN or Technet subscription where all the software is free to you for one year. As a SQL Professional Toolbelt subscriber, you have access to all of their current and new tools for one price. The annual subscription which includes 12 months of support and upgrades, is $1,995 and renewals are $995.

"SQL Professional Toolbelt is like tapping into the entire contents of our developer's brains as they turn out the tools you need to get the job done," says Simon Galbraith, joint CEO of Red Gate. "There are three major benefits to this subscription. First, it's astonishingly good value. Second, the one-off annual payment greatly simplifies purchasing. Third, it gives SQL DBAs and developers access to the preferred tools they need right now – not in a month's time after the purchase order has been approved. It's in the nature of the DBA role that you have to deal with live issues quickly and get it right the first time. SQL Professional Toolbelt gives flexibility, speed and confidence."

With this annual subscription, the following products are available to you: SQL Compare, SQL Data Compare, SQL Packager, SQL Backup, SQL Doc, SQL Toolkit, SQL Dependency, SQL Log Rescue, SQL Refactor, SQL Prompt, and 12 months support for their products which includes upgrades.

Let’s provide you with a brief overview of these products.

SQL Compare allows you to compare and synchronized the structure of your SQL Server databases (database schemas). With this product, you choose the databases that need to be compared and then review the differences. Once that is complete, you can create a script to “synch” the databases together. You can even choose the direction in which you want the data synchronized. A close relative of SQL Compare is SQL Data Compare. This tool allows you to keep your data in production, development, and disaster recovery databases in “synch.”

Do you have a need to deploy databases on a regular basis? If so, SQL Packager allows you to deploy databases by themselves or as a part of any .Net applications that you use. One of my favorite tools is SQL Backup. Simply stated, it allows you to encrypt and compress your database backups.

With SQL Doc you can connect to a database(s) and output documentation in an HTML format. It enables you to quickly access an overview of your database, including schema and dependencies. SQL Doc Pro comes with a command-line interface. Any DBA that needs to produce documentation quickly can benefit from this tool.

The SQL Toolkit compares and synchronizes databases' schema and data. By giving you access to the APIs and command-line utilities you can automate your SQL comparison and synchronization tasks.

SQL Dependency Tracker allows you to dynamically explore all your database object dependencies, using a range of graphical layouts. You can analyze very large Microsoft SQL 2000 and SQL 2005 databases and produce diagrams for all of your database changes.

SQL Log Rescue is a safety net for SQL Server databases. It is used for identifying transactions that have damaged a database, recovering a damaged database without any downtime or data loss, understanding demands on a database in terms of numbers of transactions, rate of data change, volume of users etc, protecting your data in the event of mistakes or accidents and so on.

SQL Refactor allows you to automatically format your SQL code and database objects in the style of your choice. SQL Refactor improves the quality of your code, making it easier to read, understand and share amongst a team.

SQL Prompt provides IntelliSense-style auto-completion for Microsoft SQL Server editors. It will tell you the exact formatting you should use for your SQL commands, while you are writing them, and will therefore help you write fast, perfectly formatted SQL statements. SQL Prompt improves the productivity of all SQL script creation.

About Red Gate Software

“Since 1999, Red Gate Software has been developing ingeniously simple tools that simplify the business of working with SQL Server and .NET. Our tools, which include SQL Compare, SQL Backup and ANTS Profiler, have become industry standards for developers and DBAs worldwide.” Red Gate is a Microsoft Gold Visual Studio .NET launch partner and a VSIP partner.

Download a 2 week free trial of SQL Professional Toolbelt form Red Gate’s web site and see their tools first hand.

2 comments
asentell
asentell

We purchased SQL Toolbelt a few months back, and I have found it very useful. Specifically SQL Multi Script, SQL Compare, and SQL Data Compare. We have yet to implement SQL Backup, but that will be coming very soon. We were very impressed with its performance and the price as compared with Quest LiteSpeed. SQL Dependency Tracker has been somewhat useful, and SQL Prompt and SQL Refactor are nice programs as well although SQL Prompt can get a little annoying at times and is slow on large SQL scripts and across VPN. Another collection of DBA tools I recently purchased is the Idera SQL admin toolset. I got it for the promotional price of $195 which is a great value. It's back to the regular price of $495 now, but you still might think it's worth it. Aaron

fuller.artful
fuller.artful

Get on SQL Backup asap. It is an amazing tool. It performs a backup three times as quickly as the standard MS tool, and the resulting file is three times as small. Admittedly, I had some trouble making it work on our cluster, and had to ask our network guy for assistance, but I printed out the docs for him and he got it installed and running in an hour or so. (It helps when you know what you're doing. I'm new to clusters.) Arthur

Editor's Picks