W najnowszym SQL Server Magazine pojawił artykuł (autorstwa Megan Keller) opisujący zestaw, a w zasadzie “MEGA ZESTAW” aplikacji i narzędzi do SQL Servera. The Mega Guide to Free SQL Server Tools opisuje jakie to są narzędiza i zawiera linki skąd można je pobrać. Poniżej zestawienie tych narzędzi:
Administration
• Data Scripter Add-in for Management Studio
• Iometer
• Microsoft SQL Server 2005 Upgrade Advisor
• mRemote
• MSSQL Blocks
• Orphan Finder
• Partition Management
• SortSQLFilesInProject
• SQLDBSize 1.0
• SQL Management Studio Snapshot Add-In
• SQLRecon
• SQL Server 2008 Extended Events Manager
• SQL Server Automation Scripts
• SQL Server Database Copy Tool
• SQL Server Express Utility
• SQL Server Health and History Tool (SQLH2) Performance Collector
• SQL Server Health and History Tool (SQLH2) Reports
Backup and Recovery
• Idera’s SQL safe Freeware Edition
Best Practice and Compliance
• Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0
• Microsoft SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act (SOX)
• SQL Server 2005 Best Practices Analyzer
• SQL Server FineBuild
Business Intelligence
• BIDS Helper
• DTLoggedExec
• Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
• Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE)
• Reporting Services Scripter
• RSBuild
• SQL Nexus
Change Management
• SQLDBSearch 2.0
• Tarantino Database Change Management
Code Formatters
• ApexSQL Refactor
• Instant SQL Formatter
• Manoli C# Code Format—You can use this tool to format code to the HTML 4.01 specification for a website or blog (www.manoli.net/csharpformat)
• Simple-Talk Code Prettifier
• SQLinForm
Database Comparison
• CompareData
• Open DBDiff
• SQL Accord Community Edition for Microsoft SQL Server
• SQLDBDiff
• TableDiff.exe GUI
Database Security
• Devenius SQL Encryption Assistant Basic Edition
• Idera’s SQL permissions
• Lockdown.sql
• Microsoft Baseline Security Analyzer 2.1
• SQLPing 3.0
Development
• ScriptDB
• SpatialViewer
• SQL Server PowerShell Extensions (SQLPSX)
• SQL Spatial Tools
• SQLCLRProject
• SQLIO Disk Subsystem Benchmark Tool
• SQLScripter
• SSMS Tools Pack
• Stored Procedure Generator
• tsqlt
Job Management
• Idera’s SQL job manager
• JAMS Monitor
Log Management
• Log Parser 2.2
• PSSDIAG Data Collection Utility
Performance and Monitoring
• ClearTrace
• DMVStats 1.01
• Idera’s SQL check
• Internals Viewer for SQL Server
• MDX Script Performance Analyser
• Performance Analysis of Logs (PAL) Tool
• Quest Discovery Wizard for SQL Server (beta)
• RML Utilities for SQL Server (x86)
• SQLIOSim
• SQLQueryStress
• SQL Server 2005 Performance Dashboard Reports
• SQL Server Cache Manager
• SQL Server DBA Dashboard
Prevent SQL Server Injection Attacks
• bsqlbf-v2
• HP Scrawlr
• Microsoft Source Code Analyzer for SQL Injection
• URLScan
Web Administration
• SQL Server Hosting Toolkit
• SQL Server Web Tools
• SQL Web Data Administrator
###EDIT 12;28PM 070809###
Pod linkiem na stronie SQL Magazine do każdego z narzędzi jest link z którego można je pobrać. Na przykład:
Backup and Recovery
• Idera’s SQL safe Freeware Edition—This utility lets you back up and compress multiple databases of any size and offers a scriptable interface (www.idera.com/Products/Free-Tools/SQL-safe-Freeware-Edition)
0 Comments.