SQL DBA Bundle
Sieben wichtige Werkzeuge für die Datenbankadministration.
Veröffentlicht von Redgate Software
Wird von ComponentSource seit 2005 vertrieben
Sieben wichtige Werkzeuge für die Datenbankadministration.
SQL DBA Bundle is a suite of SQL Server database tools including, SQL Backup Pro, SQL Monitor (formerly SQL Response), SQL Multi Script, SQL Compare, SQL Data Compare, SQL Prompt and SQL Doc. With SQL DBA Bundle you can compress, backup, restore, monitor, diagnose and execute multiple scripts on multiple SQL Servers.
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.