SQL admin toolset SQL Backup Status SQL Search SQL Object Search SQL Discovery SQL Password Checker SQL Connection Check SQL Multi Query SQL Database Mover SQL Login Copy SQL User Clone SQL Job Mover SQL Job Editor SQL Quick Reindex SQL Server Configuration SQL Database Configuration SQL Partition Generator SQL Connection String Generator SQL Table Pin SQL Linked Server Copy SQL Index Analyzer SQL Inventory Reporter SQL Server Statistics SQL Space Analyzer SQL Patch Analyzer SQL Server Ping

Diagnostic

SQL Backup Status: Check whether your databases are backed up

---

SQL Search: Search for text anywhere you have SQL code (stored procs, functions, triggers etc..)

---

SQL Object Search: Find objects by name anywhere they are hiding in your SQL Servers

---

SQL Discovery: Find the SQL Servers lurking on your network

---

SQL Password Checker: Check the strength of your SQL Server passwords

---

SQL Connection Check: Diagnose connection problems, quickly determine why users can’t reach your SQL Servers

Administration

SQL Multi Query: Execute and manage queries across multiple SQL Servers

---

SQL Database Mover: Move or copy a database and associated logins across servers or relocate data files

---

SQL Login Copy: Copy server logins across SQL Servers

---

SQL User Clone: Create a new user using an existing user as a template

---

SQL Job Mover: Move and copy between servers

---

SQL Job Editor: View and edit jobs across multiple SQL Servers

---

SQL Quick Reindex: Quickly review and rebuild the indexes on your SQL Servers

---

SQL Server Configuration: Compare and edit server configuration for one or more SQL Servers

---

SQL Database Configuration: Compare and edit database configuration for one or more databases

---

SQL Partition Generator: View existing partition information and generate new partitions

---

SQL Connection String Generator: Wade the multitude of options for connection strings and create your own in seconds

---

SQL Table Pin : View and manage the pinned status of your tables (SQL Server 2000 and earlier only)

---

SQL Server Linked Copy Tool : Quickly and easily copies linked servers from one server to another

Analytics

SQL Inventory Reporter: Get a list of everything important about your SQL Servers, including version, hardware and more

---

SQL Patch Analyzer: Report and analyze your SQL Server version levels

---

SQL Index Analyzer: Analyze your indexes for usage patterns and sizes. Determine if you need more, less etc…

---

SQL Space Analyzer: Analyze the space usage of your SQL Server by drive or database

---

SQL Server Statistics: View loads of statistics about your SQL Server

---

SQL Server Ping: Keep a constant eye on the status of your SQL Servers

Collateral SQL admin toolset datasheet Migrating SQL Server Logins South Wales Police Department Improves SQL Server Management with Idera

Videos Demo: SQL admin toolset Webcast: Introduction to SQL Azure Webcast: Easily Manage your SQL Servers with CMS and PBM More SQL Server webcasts

“This is awesome! I've been a SQL Server DBA for over 10 years and it has taken me this long to build my arsenal of scripts to do the things that are all rolled into one app, SQL admin toolset. Thank you Idera for producing a tool that I can use every day!”
--SQL admin toolset User

“Great set of general purpose tools that every DBA can use that highlight regular activities that every DBA does or is going to do. I really like Server Configuration, Database Configuration, Inventory Reporter and Patch Analyzer. It is great to see side by side comparisons of all our SQL Server installations. Patch Analyzer is not only a great tool for a DBA but also for the sys admin/network admins to stay on top of OS patches. Can't wait to see the rest of the tools!”
-- SQL admin toolset User

See all quotes