You are hereSQL Server 2005 DBA / Free SQL Server Tools

Free SQL Server Tools


By sqlguychuck - Posted on 02 December 2007

Your rating: None Average: 5 (6 votes)

I sometimes come across great free tools from companies or individuals and I just wanted to share them in one convenient location.

Last updated 1/10/2010 - Chuck Lathrope


Management Studio Alternatives and Add-ons

Performance Monitoring

  • Idera SQLCheck - http://www.idera.com/freetools
  • SQL SPY by Hybridx provides 75 features for SQL Server 2000 and 2005 instances.
  • Performance Dashboards - SQL Server 2005 SP2 Performance dashboards
  • SQL Server 2005 Performance Collector Tool - Works with Health and History Tool.
  • SQL Server 2005 Health and History Tool
  • DMVStats - collects, analyzes and reports on SQL Server 2005 DMV performance data
  • PSSDiag - SQL 7/2000 diagnostic tool from PSS.
  • SQL Heartbeat - Monitors servers waits, IO, Cache Hits, active processes, locks and deadlocks.
  • Server Performance Advisor - Microsoft Windows 2003 tool for actively troubleshooting IIS, AD, DNS, TS, SQL, and others.
  • LogParser - Analyze those text based log files with this tool to query text files like a database.
  • Performance Monitor Wizard - Make your Perf Monitor setup easier with this tool.
  • ClearTrace - SQL MVP created a profiler aggregation tool to roll up all the common queries to see overall usage.
  • TraceAnalyzer - Similar to ClearTrace, but more simplistic.
  • LogMan – Win2k Resource Kit - windows command line tool you can create a perfmon collection definition and push it out to all your servers, perfmon command line scripting.
  • ReLog – Win2k Resource Kit - windows command line tool to extract and manipulate perfmon data from saved log files. You can resample the log files and store them in a database via a ODBC DSN name. You can also combine log files and extract data from them specifying the time period too. You can relog to csv file also.
  • Typeperf - Win2k Resource Kit - Write perfmon information to command window or a log file. Or just see what counters are available on remote computer.
  • Performance Analysis of Logs (PAL) - Analyzes log files for best practice issues and lets you know in stoplight color coding; values for exchange, sql, iis, etc. Runas radio show from organize of the tool: http://www.runasradio.com
  • Windows Performance Analysis Toolkit - Now visible in Windows 2008 xperf is command line tool that is monitoring at a lower level than perfmon.
  • SQL Server 2005 Express Profiler - a free SQL Profiler for SQL Express

Performance Benchmarking

Security

Code Formatting

Backup

Visualize your DB

Data Modeling

Database Server Administration Tools

SQL Comparison and Script Export

  • Bypsoft's DBTYP.NET - compares SQL Server, MySQL and Oracle databases. Cross database comparison of schemas and data.
  • SQL DB Tools - SqlDbDiff, SqlDbSearch and SqlDbSize utility
  • TableDiff.exe - utility that compares 2 tables for differences in data and schema for SQL Server 2000 and 2005
  • CompareData - Table comparison using ODBC drivers.
  • SQL Scripter - data export and scripting utility for Microsoft SQL Server
  • ScriptDb - data export and scripting utility for Microsoft SQL Server
  • Script SQL DDL - A tool which scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, "Data Dude"].
  • SQLDBSearch - Find objects with a gui tool.
  • SQLBulkCopy - Full source code for using .net's bulk copy class, multiple threads per partioned file makes copies go super fast.
  • Winmerge - Compares any text files (2 at a time, but can do entire directory).
  • RegEx Builder - Simple GUI app to verify your regex works.

SSIS Specific

  • SSIS Community Tasks and Components List - A maintained motherload list of SSIS addons, free and not free.
  • BIDS Helper - A Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio (BIDS). With many Analysis Services helpers.
  • SQLIS Checksum Transform - A very quick and automated method to check for changes between two datarows or data columns.
  • Pragmaticworks.com - SSIS tools.

Windows Server Tools

  • Royal TS - RDP Session manager in one interface ver 1.5.1 is free.
  • mRemote - RDP, VNC, HTTP, ICS, SSH, Telnet, Rlogin, RAW session manager.
  • SYSInternals - All windows server admins should use their tools. ShellRunAs for Windows 2008!
  • RichCopy - An internal MS tool that is finally available to outside world. It can copy files with multiple threads, simple UI, lots of Robocopy like options. MS developer's blog. Performance testing link.
  • - Tool to help consolidate many shares into one location.

  • ClearTrace - utility to easier read your saved trace files
  • SMS Trace - Installing just the Common Tools, you can use this tool to monitor log files in real time as they change. Has nice search highlighting feature also.
  • Filezilla - FTP opensource project.
  • TCP Port Query tools - Article I wrote up on PortQryUI and PortReporter.
  • Quest Software - Lots of Systems administration tools for free.
  • Regexdesigner - GUI interface for Regex expressions.
  • Microsoft Network Monitor 3.3 - Latest version of Microsoft Network Monitor Tool (packet capture).
  • Wireshark - Next iteration of Etheral, a great network packet capture tool.
  • JKDefrag - I haven't used it yet, but looks promising.
  • WinAudit from Parmavex. It creates a lengthy report detailing software, licenses, security, hardware, network settings, etc...
  • CPU-Z by Franck Delattre from CPUID. Provides very detail information on the CPU, motherboard, and memory.
  • GPartEd - Disk partition change tool.

PowerShell and WMI

Text Editors

  • PSPad - Has ftp component, external tool linkage including compilers. HTML smart.
  • NotePad++ - Like textpad, but free.
  • XML Notepad 2007 - Great tool instead of IE for viewing and editing xml files.
  • WinMerge - Not an editor, but text file comparison tool.

File Search

Video

  • UStream - Stream your webcast video live with Twitter tweets or live chat.
  • CamStudio - Video Screen Recording Software - super cheap, but not free.
  • SharedView - Microsoft Live Meeting based application to share upto 15 people.
  • Teamviewer - Share your screen with others, like SharedView.
  • Jing - From TechSmith, creates visuals like screen shots, screen capture videos, for you to share with others.

Desktop

  • GreenShot - easy to use screen snapshot. The tool has an editor that allows you to add comments, shapes, arrows, etc...
  • Cropper - Screen capture app that works on all Windows flavors.
  • PicPick - provides more features than GreenShot and some differences in the objects you can add to an image. Some of its extra features include color picker, pixel ruler, protractor, crossbar, and whiteboard.
  • InputDirector - Control multiple computers from one computer.
  • SyncToy - Good desktop tool to sync files on just about everything. Requires MS Sync framework. Live Mesh Beta is latest iteration and much greater flexibility.
  • BullZip - PDF Printer

Microsoft Office

Disk Recovery

  • Recuva - Restore deleted files and emails from all hardware mediums.
  • PhotoRec - Photo recovery on removable media.
  • TestDisk - Recover lost partitions, recover boot sectors, deleted files from FAT, NTFS, and EXT2

Other good lists:

Scott Hanselman's Ultimate Developer and Power Users Tool List for Windows.
DougSTE Useful tools and add-ons for IIS troubleshooting and IIS7

Rate This

Your rating: None Average: 5 (6 votes)