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.
Lets 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
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
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.
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.
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
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.
a 2 week free trial of SQL Professional Toolbelt form Red Gates web site and
see their tools first hand.
See All Articles by Columnist Steven S. Warren