SQL admin toolset
Incredibly useful tools for SQL Server people
_______________________________________________________________________
SQL admin toolset -
Highlights:
Are you a DBA or developer tired of spending countless hours on routine administrative and troubleshooting tasks, like figuring out why a user can't connect, or moving databases, or producing reports for your boss to show that the backups really did run, or finding rogue SQL Servers, or checking configurations or…. yeah, we know, the list is endless.
If the answer is yes then, you need our SQL admin toolset. Packed with 24 powerful tools that will make troubleshooting, administration and reporting such a breeze you'll be wondering what to do with all the spare time you have on your hands - really! Download now and see.
|
|
| Diagnostic | |
| Backup Status | Check whether your databases are backed up |
| SQL Search | Search for text anywhere you have SQL code (stored procs, functions, triggers etc...) |
| Object Search | Find objects by name anywhere they are hiding in your SQL Servers |
| SQL Discovery | Find the SQL Servers lurking on your network |
| Password Checker | Check the strength of your SQL Server passwords |
| Connection Check | Diagnose connection problems, quickly determine why users can’t reach your SQL Servers |
| Administration | |
| Multi Query | Execute and manage queries across multiple SQL Servers |
| Database Mover | Move or copy a database and associated logins across servers or relocate data files. |
| Login Copy | Copy server logins across SQL Servers |
| User Clone | Create a new user using an existing user as a template |
| Job Mover | Move and copy between servers |
| Job Editor | View and edit jobs across multiple SQL Servers |
| Quick Reindex | Quickly review and rebuild the indexes on your SQL Servers |
| Server Configuration | Compare and edit server configuration for one or more SQL Servers |
| Database Configuration | Compare and edit database configuration for one or more databases |
| Partition Generator | View existing partition information and generate new partitions |
| Connection String Generator | Wade the multitude of options for connection strings and create your own in seconds |
| Table Pin | View and manage the pinned status of your tables (SQL Server 2000 only) |
| Analytics | |
| Inventory Reporter | Get a list of everything important about your SQL Servers, including version, hardware and more |
| Patch Analyser | Report and analyze your SQL Server version levels |
| Index Analyser | Analyse your indexes for usage patterns and sizes. Determine if you need more, less etc… |
| Space Analyser | Analyse the space usage of your SQL Server by drive or database |
| Server Statistics | View loads of statistics about your SQL Server |
| Server Ping | Keep a constant eye on the status of your SQL Servers |
| (1) plus maintenance @ 20% p/a - excludes GST | |

