Here is a list of vendor tools that might be useful for the every day database administrator and/or developer. The companies are listed in alphabetical order and I am not promoting them in any way.
Change data capture, replication, connectivity adapters, and federated databases are some of the products this company offers.
Ignite 8 – identifies, analyzes and resolves SQL Server database performance problems affecting your applications and users
Qure – A radical new way to approach database tuning. Instead of query by query, it does work load tuning.
DB Power Studio – is an intuitive, highly-visual toolset that complements SSMS with critical capabilities such as database change management and SQL optimization and tuning.
Expressor Studio – is an easy-to-use, modern, metadata-driven ETL tool that offers a simplified approach to data integration; ranging from small ad-hoc ETL tasks to complex data integration projects.
SQL diagnostic manager – Identify and resolve SQL Server problems before they happen; Monitor and manage SQL Servers enterprise-wide; Find and fix performance bottlenecks; Analyze performance over time; Diagnose and resolve issues from the desktop or mobile device; No agents or database objects required on monitored servers
SQL toolbox includes must-have tools for DBAs and Developers like:
- SQL doctor for performance tuning
- SQL admin toolset for daily administration tasks
- SQL comparison toolset for data and schema compare
- SQL safe lite for fast, compressed backups
- SQL virtual database for instant data recovery
Toad – is a well know tool for managing databases regardless of their type.
Spotlight – Operational Monitoring, Diagnostics, Administration and Automated Tuning.
Lightspeed – Reduce Database Backup Size &Time; Cut Recovery Time and Storage Costs.
Red Gate Software
SQL Toolbelt – 14 essential tools for SQL Server developers and DBAs
SQL Monitor – SQL Server performance monitoring and alerting
SQL DBA Bundle – High-performance SQL Server database administration tools
Performance Advisor – provides unparalleled insight, awareness and control over the true source of SQL Server performance issues, all designed with the singular goal of simplifying the process of performance tuning and optimization.
Event Manager – is the ultimate scheduling, alerting and response system for optimizing schedule performance of database servers across your enterprise.
Cloud TagsAFTER ALTER TABLE ALTER TRIGGER CPAN perl modules CREATE DATABASE create function create procedure CREATE TABLE create trigger create view database administrator database developer DATA TYPES DDL DECLARE DELETE DROP DATABASE DROP TRIGGER DROP VIEW execute EXISTS FORMAT free code INSERT ISNULL John F. Miner III PASS perl script REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.databases sys.objects sys.schemas TRIGGERS TRUNCATE TABLE TSQL UPDATE USER DEFINED VIEW vb script