SQL DBA Bundle(英語版)
データベース管理の必須ツール7品を揃えたスイート
Redgate Software 社の製品
2005 年より日本国内にてComponentSourceで販売中。
データベース管理の必須ツール7品を揃えたスイート
SQL DBA Bundle はSQL Server database tools including, SQL Backup Pro, SQL Monitor (formerly SQL Response), SQL Multi Script, SQL Compare, SQL Data Compare, SQL Prompt とSQL Docのスイート製品です。 SQL DBA Bundleにより、圧縮、バックアップ、リストア、関し、多数の SQL サーバーの上に多数のスクリプトを診断して、そして実行できます。
SQL DBA Bundle includes the following products:
The SQL DBA Bundle supports your core SQL Server database administration tasks:
Backup and recovery
Keeping the data safe is the most important part of any DBA's job. SQL Backup Pro will help you create smaller, more secure, fully verified backups.
You can also easily schedule regular restores and include an optional DBCC CHECKDB to fully verify your backups’ integrity.
Performance monitoring & tuning
Proactively monitoring your servers with SQL Monitor ensures they're performing optimally and helps you spot potential problems or bottlenecks before your users do.
Once you've got a great understanding of your server’s current performance, you can make better informed decisions on how to improve it further.
After SQL Monitor has shown you where you could make performance improvements, SQL Multi Script makes it easier and faster to deploy those changes, letting you run multiple scripts against multiple SQL Servers in just one click.
Change management
SQL Compare and SQL Data Compare help you compare and deploy database changes quickly, simply, and with zero errors.
SQL Data Compare also lets you copy lookup data from development databases to staging or production, and damaged or missing data can be restored to a single row, without the need for full database recovery.
Storage and capacity planning
The tools in the SQL DBA Bundle help you forecast, plan ahead, and make the most of your existing storage.
SQL Monitor tracks database size and growth so you can proactively manage your space requirements. Monitor patterns of growth and set up alerts to let you know when your remaining disk space is low.
SQL Backup Pro helps you make the most of the space you already have, by compressing backup sizes by up to 95%.
Troubleshooting
In a troubleshooting situation, every second counts. SQL Monitor quickly alerts you to problems, offers insight into what went wrong, and provides you with suggestions on what to do next.
Historical data lets you compare patterns and makes it easy to see when a deviation from normal behavior occurs, so you can pinpoint when the problem arose and understand what could have triggered it.
Productivity
Save time and tedium when you’re writing SQL with SQL Prompt Pro.
SQL Prompt Pro is an add-in for SQL Server Management Studio and Visual Studio, which completes queries for you as you type. It also takes care of formatting, object renaming, checking for column dependencies, and other distractions, so you’re free to concentrate on how the code actually works.
Documentation
Documenting your databases is necessary, but isn’t much fun. SQL Doc generates full database documentation automatically, so you don't have to do it by hand.
SQL Doc is ideal for database professionals who need to quickly produce high quality database documentation. It integrates with SSMS, so you can document a database by right-clicking in the Object Explorer. You can create documentation in HTML, Microsoft Word, or Compiled HTML Help files.