SQL DBA Bundle

Sept outils essentiels pour l’administration de bases de données.

Publié par Redgate Software
Distribué par ComponentSource depuis 2005

i

Redgate SQL DBA Bundle has been retired. Redgate has now stopped selling the SQL DBA Bundle.
The SQL DBA Bundle has been replaced by the SQL Toobelt (It includes SQL Backup Pro, SQL Monitor, and SQL Multi Script).
If you have a license for the SQL DBA Bundle, it will still work. SQL Backup Pro, SQL Monitor, and SQL Multi Script remain fully supported, and if you have Support & Upgrades you...

Show more

Redgate SQL DBA Bundle has been retired. Redgate has now stopped selling the SQL DBA Bundle.
The SQL DBA Bundle has been replaced by the SQL Toobelt (It includes SQL Backup Pro, SQL Monitor, and SQL Multi Script).
If you have a license for the SQL DBA Bundle, it will still work. SQL Backup Pro, SQL Monitor, and SQL Multi Script remain fully supported, and if you have Support & Upgrades you will still receive updates to them.

You can still renew your Support & Upgrades package, or contact sales@componentsource.com to request a quote for additional licenses for the bundle.

À propos de SQL DBA Bundle

Sept outils essentiels pour l’administration de bases de données.

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:

  • SQL Backup Pro - Compresses, verifies, and encrypts SQL Server backups
  • SQL Monitor - SQL Server performance monitoring and alerting
  • SQL Multi Script - Execute on multiple SQL Servers
  • SQL Compare - Compares and deploys schema changes
  • SQL Data Compare - Compares and synchronizes data
  • SQL Prompt - An add-in for SQL Server Management Studio and Visual Studio
  • SQL Doc - document your databases automatically

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.

  • Manage and schedule regular backup jobs from a central UI.
  • Use high-performance compression to create smaller, faster SQL Server backups.
  • Protect your data with up to 256-bit AES encryption.

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.

  • Monitor what's happening on your servers in real time and get alerted to problems in seconds.
  • Collect and analyze historical data to help pinpoint past performance problems.
  • Keep an eye on the top 10 most expensive queries for each database and server.
  • Create your own custom metrics to monitor the data that’s important to you and your organization. You can also download custom metrics for common use cases, written by SQL Server experts.
  • When you're ready to roll out any resulting improvements, run multiple scripts on multiple servers with just one click.

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.

  • Compare and synchronize schema and data within SSMS.
  • Generate T-SQL scripts to update one database to match the schema and the contents of another.
  • Speed up the deployment of new database schema updates.
  • Eliminate mistakes migrating database changes, or copying lookup data, from dev, to test, to production.
  • Quickly fix problems by restoring damaged or missing data to a single row.

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.

  • Compress backups by up to 95%, saving on storage space.
  • Monitor database size and be alerted to low disk space.

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.

  • Get alerts within seconds of a problem occurring on your servers, so you can respond fast.
  • Fix problems faster with embedded advice and suggestions on which steps to take next.
  • Drill down using historical data to help you identify the cause of a problem.

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.

  • Write SQL smoothly with unparalleled code-completion and customizable code snippets.
  • Make code readable and keep everyone on your team working to the same standards, with single-click, customizable code reformatting.
  • Explore your database with the ability to track down invalid objects and find unused variables and parameters.
  • Refactor your code without breaking dependencies and encapsulate code as stored procedures.

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.

  • Eliminate tedious and time-consuming manual documentation tasks
  • Satisfy audit requirements by keeping complete documentation
  • Document a database with a couple of clicks in SSMS
  • Keep teams up to date by distributing documentation

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.