clipped from searchsqlserver.techtarget.com
INSTALLATION AND MANAGEMENT TOOLS
Installs SQL Server -- and best-practice configurations -- with one click. Download SQL Server FineBuild.
Streamlines the process of cross-server SQL Server job management, reducing job failure rates and the amount of time spent on job management activities. Download SQL Job Manager.
SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, Linux, and Solaris. Download RazorSQL.
Ideal for large databases, simplifies partitioned table maintenance by automating management tasks. Download SQL Partition Manager.
Script file of T-SQL stored procedures that automate routine database maintenance. Download YourSQLDba.
Built-in feature in SQL Server Management Studio 2008 that helps find objects in a particular datatbase. More on Object Search.
MONITORING AND PERFORMANCE TUNING TOOLS
Set of 24 administration tools for monitoring, troubleshooting, administering, and reporting including Password Checker, Job Editor and Patch analyzer. Microsoft MVPs receive a free license. Download SQL admin toolset.
Web-based application that administers SQL Server and Desktop Engine databases over the internet. Download myLittleAdmin
Moves logins and applies permissions across all databases on the target server or single database. Download SQL Permissions.
A scheduling, alerting and response system for SQL Server jobs and other events that impact performance that allows problems to be solved as they arise. Download Event Manager.
An advanced performance dashboard that deliver Windows and SQL Server metrics in a single view along with details regarding heavy SQL blocking, deadlocks and disk bottlenecks. Download Performance Advisor.
Built-in administrative console that helps monitor speed and efficiency of databases, and collects real-time performance data from multiple databases and stores them in a central repository. More on using Performance Studio.
Component of SQL Server 2008 that collects data and provides one central point for data collection across database servers and applications. More on Data Collector.
Low-footprint technology that collects performance information, which can bedanalyzed by an easy-to-understand user interface. Free for SQL Server Express Edition. Download Performance Monitor.
Monitors performance and pulls together numerous statistics in a single screen. Functions as a secure screen saver. Download SQL Check.
Detects and diagnoses performance issues across a SQL Server environment and provides an overview of enterprise performance. Download Spotlight.
BACKUP AND RECOVERY TOOLS
Creates smaller, safer and faster backups of SQL Server databases. Download SQL Backup.
Backup and recovery software that provides integrated high performance compression technology. Download LiteSpeed.
Continuous data protection software that provides data recovery at any point in time, and allows workflow to resume without having to recover from tape. Download TimeData.
Accelerates, compresses and encrypts database backups. Download SQL safe Backup.
Based on Idera's SQL safe product, includes a high-performance backup and recovery engine, a scriptable interface and can backup and compress any size and any number of databases. Download SQL safe Freeware Edition.
Allows SQL Server backup files to be attached, queried as real databases and data to be accessed in SQL Server backup files without restoring. Download SQL virtual database.
Copies a SQL Server database from one instance to another by backing it up, copying the backup file to the destination server and restoring the database. Download SQL Server Database Copy Tool .
SECURITY TOOLS
Network-based, vulnerability assessment tool that locates, examines, reports and helps fix security holes. Download AppDetective.
Vulnerability assessment tool available for SQL Server 2000 and SQL Server 2005. Download NGSSquirrel.
Penetration testing and exploit tool. Download Metasploit.
Vulnerability assessment tool that combines vulnerability management service with an IT compliance solution. Download QualysGuard.
Manages encryption keys and certificates inside SQL Server, directly inside SQL Server Management Studio. Download SQL Encryption Assistant.
DEVELOPMENT AND BI TOOLS
Compares and synchronizes database changes quickly and simply. Download SQL Compare.
Management and development toolset designed to bridge the gap between SQL Server Management Studio and Visual Server. Download Toad.
Monitors and optimizes SQL Server Analysis Services performance, and provides insight related to memory, storage systems, aggregation usage, queries and processing. Download Performance Advisor for Analysis Services.
Built-in tool that includes all the core debugging features -- the Locals, Watch, QuickWatch and Output windows – in addition to the ability to set breakpoints to stop execution. More on working with T-SQL Debugger.
An auto-completion system supported in SQL Server Management Studio 2008 that provides easy access to language elements as you write your queries. More on IntelliSense.
Data driven, web-reporting solution for SQL Server. Download APEX SQL Report.
Add-on application that provides auto-complete functionality while typing for programs used to create SQL statements. Download SQL Prompt.
Generates code from C# or VB.NET code templates. Free for a limited time. Download ApexSQL Code.
Online tool that cleans-up SQL code, formats SQL into HTML and translates SQL code into other program languages like Java. Use Instant SQL Formatter.
Automatic web-based SQL code formatter. Access SQLinForm.
Data export and scripting utility for SQL Server. Packages and transports table data. Download SQL Scripter.
MORE RESOURCES
- More SQL Server security tool
Check out the best places to find security tips and countless security tools. - SQL injection tools
SQL injection is a security exploit in which the attacker adds SQL code to a Web form input box to gain access. These tools automate testing of SQL injection. - Top SQL Server products of 2008/2007 | 2006 |2005
SQL SERVER DATABASE TOOLS FOR:
Get Clipmarks - The easiest way to email text, images and videos you find on the web.
No comments:
Post a Comment