I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

Free SQL Server tools that might make your life a little easier

Update: New Stuff from the latest update will be in RED.

This list will grow as I find new tools. So if you know of some not on this list do post them in the comments.

 

SQL Server Management Studio Add-in's

SSMS Tools Pack - an add-in with lots of IDE options (Query Execution history, regions, debug sections, CRUD stored procedures creation, new query templates, running custom scripts from Object explorer's context menu) for SQL Server Management Studio and SQL Server Management Studio Express

Data Scripter - generates insert statements for a table

Create Database Snapshot - simple GUI for creating a database snapshot

Sort SQL Project Files - sorts SQL project files

The Black Art of Writing a SQL Server Management Studio 2005 Add-In - a how-to article and a Search DB Objects add-in with code

How to create SSMS Add-in - an article that describes how to create add-ins without any source code

 

Free SQL Server books

"Boost your DBA expertise" and "DBA Best Practices"  - two free books by RedGate

 

SQL Injection tools

Top 15 free SQL Injection Scanners - 15 free SQL injection scanners :)

Microsoft Source Code Analyzer for SQL Injection - a static code analysis tool for finding SQL Injection vulnerabilities in ASP code

UrlScan v3.0 Beta - a Microsoft security tool that restricts the types of HTTP requests that Internet Information Services (IIS) will process

HP Scrawlr - crawls a website, simultaneously analyzing the parameters of each individual web page for SQL Injection vulnerabilities

Blind Sql Injection Brute Forcer version 2 - accepts custom SQL queries as a command line parameter and it works for both integer and string based injections.

 

Administration

SQL Web Data Administrator - enables you to easily manage your SQL Server data from a web browser

SQL Server Cache Manager - allows you to return information about what is stored is the SQL Server cache and how efficiently it is being used.

SQL Internals Viewer - a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organized and stored.

Microsoft SQL Server 2000/2005 Management Pack - monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems.

Performance Analysis of Logs (PAL) Tool - tool that reads in a performance monitor counter log (any known format) and analyzes it using complex, but known thresholds (provided).

Microsoft Baseline Security Analyzer - helps small- and medium-sized businesses determine their security state in accordance with Microsoft security recommendations and offers specific remediation guidance

RML Utilities for SQL Server (x86) and (x64) - tools to help database administrators manage the performance of Microsoft SQL Server: Overview

SQLDumper.exe - comes with SQL Server. Installed at ..\Microsoft SQL Server\90\Shared\SQLDumper.exe. Generates a dump file on demand for any Microsoft Windows application.

SQL Server 2005 Partition Management - helps in data loading and extraction from partitions

SQLdiag Utility - a general purpose diagnostics collection utility that can be run as a console application or as a service (comes with SQL Server)

SQL Nexus - analyzes SQLDIAG captures

PSSDiag Utility - a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files

SQL Recon - performs active and passive scans of your network in order to identify all of the SQL Server/MSDE installations in your enterprise

SQL Server 2005 Express Profiler - a free SQL Profiler for SQL Express

Log Parser 2.2 - provides query access to log files, XML files and CSV files, the Event Log, the Registry, the file system, and Active Directory

Microsoft SQL Server Management Studio Express - apparently a lot of people don't know this exists. Stripped down version of SSMS

SQL Server 2005 System Views Map - a nice map of all the DMV's and links between them

SQL Server Web Data Administrator - admin your SQL Server over the web

SQL Server Express Utility - simple interaction with SQL Server

TableDiff.exe - utility that compares 2 tables for differences in data and schema for SQL Server 2000 and 2005

DMVStats - collects, analyzes and reports on SQL Server 2005 DMV performance data

 

Best practices, analysis, health and performance

SQL Server FineBuild - provides one-click install and best-practice configuration of SQL Server 2005.

SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act (SOX) - contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Sarbanes-Oxley compliance efforts

SQLIO GUI - user interface for SQLIO Disk Subsystem Benchmark Tool

SQLQueryStress -  automatically collects metrics to help you determine whether your queries will perform under load, and what kind of resource strain they put on your server

SQLIO Disk Subsystem Benchmark Tool - used to determine the I/O capacity of a given configuration

SQL Server 2005 Best Practices Analyzer - lets you verify the implementation of common Best Practices in SQL Server 2005

SQL Server 2000 Best Practices Analyzer - lets you verify the implementation of common Best Practices in SQL Server 2000

SQL Server Health and History Tool (SQLH2) - collects information from instances of SQL Server to determine how SQL Server is being used

SQL Server Health and History Tool (SQLH2) Performance Collector - optional tool to collect performance counters that are consumed by the SQLH2

SQL Server Health and History Tool (SQLH2) Reports - reports needed to view the data collected by the SQLH2

SQL Server 2005 Performance Dashboard Reports - performance reports that integrate into SQL Server Management Studio

Microsoft SQL Server 2000/2005 Management Pack - monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems

 

Database Publishing to hosted servers

Microsoft SQL Server Database Publishing Wizard - provides a way to publish databases to T-SQL scripts or directly to supporting hosting service providers

Microsoft SQL Server Database Publishing Services - deployed by shared hosting providers to enable publishing of SQL Server databases over the Internet

 

Upgrade and Migration

Microsoft SQL Server 2005 Upgrade Advisor - used when upgrading from lower SQL Server version to SQL Server 2005

SQL Server Migration Assistant for Access

SQL Server Migration Assistant for Oracle

SQL Server Migration Assistant for Sybase ASE

 

SQL Server Analysis Services

MDX Script Performance Analyser - allows the user to identify how much each calculated member, named set and scoped assignment in an Analysis Services cube's MDX script contributes to the overall performance of a given MDX query.

Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 - SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007

 

SQL Server Integration Services

DTLoggedExec  - allows you to run a Sql Server Integration Services (SSIS) Package producing a full and detailed logging information of execution status and package runtime data.

 

SQL Server 2005 BI Development Studio (BIDS)

BIDS Helper - Add-in for Visual Studio Business Intelligence Development Studio

 

Samples

SQL Server Analysis Services Product Samples

SQL Server 2005 Samples and Sample Databases

 

Non MS stuff

SQL CLR Project - a tool that allows you to deploy .NET assemblies to SQL Server. Pretty COOL if you work with SQL CLR a lot

SQL Designer - online SQL Database designer. Contains Importing and Exporting scripts to and from different formats

DbDiff and DbScripting - Compare SQL Server database structures and generate scripts

SQL Accord Community Edition - compares database schema

Quest software's Comparison Suite for SQL Server - tried it... pretty slick

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

ClearTrace - utility to easier read your saved trace files

SQL Sripter - data export and scripting utility for Microsoft SQL Server

ScriptDb - data export and scripting utility for Microsoft SQL Server

Idera's Free Tools - SQL Server backup and recovery tool, performance dashboard and logons and permissions transfer tool

 

SQL and other code Formatting

Jean-Claude Manoli's code formater - online formatting. I use this for my blog's code formatting. Has source code download and formats C#, VB, HTML/XML/ASPX  , T-SQL and MSH

SQLinForm - online and desktop versions

Simple Talk's Prettifier - online format tool for T-SQL, C# and VB.

Wangz's Instant SQL Formatter- formats SQL for pretty much all know databases, they also have an add-in for SSMS and QA but it's not fully free so no link :)

 

 

Even if none of this stuff helps you at the moment it's good to know they exist.

Because DBA-ing is like a box of chocolates, you never know what you're going to get :)

 

kick it on DotNetKicks.com
 

Print | posted on Tuesday, November 20, 2007 6:31 PM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: Free SQL Server tools that might make your life a little easier

I think you should also Microsoft SQL Server Management Studio Express put up there. I'm still surprised to find devs that don't know it even exists.
11/20/2007 8:53 PM | David
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Beautiful list! I love it, I was diggin for hours yesterday attempting to create a list just like this.

I only got but so far (http://adronbhall.com/blogs/technology__software_development/archive/2007/11/19/5943.aspx)

I guess you could say I got slightly distracted also. :(
11/20/2007 8:58 PM | Adron
Gravatar

# re: Free SQL Server tools that might make your life a little easier

www.sqldbtools.com
11/20/2007 9:59 PM | John S.
Gravatar

# re: Free SQL Server tools that might make your life a little easier

The Web Data Administrator is now an open source (well, Microsoft Permissive License) project at: http://www.codeplex.com/SqlWebAdmin, which has a newer version than the link you've posted above.
11/21/2007 5:25 PM | Ryan Davis
Gravatar

# re: Free SQL Server tools that might make your life a little easier

thanx ryan! fixed.
11/21/2007 5:28 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Free online sql formatter:
http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm
11/22/2007 2:23 AM | James
Gravatar

# re: Free SQL Server tools that might make your life a little easier

What about Scriptio?
11/22/2007 4:07 PM | AndrewSeven
Gravatar

# re: Free SQL Server tools that might make your life a little easier

http://www.sqlinform.com
Free online and desktop SQL Formatter for SQL Server and others (yes, there are other DBs beside SQL Server)
11/22/2007 8:41 PM | GuidoMarcel
Gravatar

# re: Free SQL Server tools that might make your life a little easier

thanx :)
11/22/2007 8:43 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Log Parser 2.2
http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx
11/23/2007 3:38 AM | Kris Brixon
Gravatar

# re: Free SQL Server tools that might make your life a little easier

DBTYP.NET - Free comparison of SQL Server, MySQL and Oracle databases. Cross database comparison of schemas and data.
http://www.bypsoft.com
11/23/2007 7:17 AM | Chris
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Code generation for Sql Server 2000.
11/23/2007 9:59 AM | Anthony Healey
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I love this free database comparison tool from Quest. It works perfectly, I use it every week!
http://www.quest.com/Comparison-Suite-for-SQL-Server/
11/23/2007 5:20 PM | Glynne Smith
Gravatar

# re: Free SQL Server tools that might make your life a little easier

One have must use this site...............
11/24/2007 8:45 AM | Niteen Lahane
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I want a free hosting server where i can host my sql server database absolutely free,can you give me name of hosting site or company where i can host my database freely .

thanks
shailehs thpaa
11/24/2007 9:19 AM | shailesh thapa
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I would like member in this profile.and i will get new every thing at all.
11/25/2007 3:29 AM | theany
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I want to join this profile and get every new thing
11/26/2007 11:36 AM | Murtuza
Gravatar

# re: Free SQL Server tools that might make your life a little easier

@ theany & Murtuza
what profile are you talking about??

@shailesh thapa
no idea on that
11/26/2007 11:38 AM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Have put together freeware Windows GUI and command-line versions of an SQL formatting/indenting utility.

http://www.curiousdevelopments.net/opensource/SQLNeatener.zip

It is ambitious in its formatting, trying to do much more than match the starts and ends of blocks but doesn't always get it right.

It does not yet have the source code included, just the binaries (and is written in Delphi). Planning to port it to c# and release the code as open-source next year.


11/27/2007 10:08 AM | Pat Connors
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Hey Mladen -- what a great post this has become! That's the most "Kicks" I've ever seen!

Anyway, I just noticed this:

http://sqlprofiler.googlepages.com/

I have not tried it yet, but it is free and looks like it may be handy if you have only SQL Express.
11/29/2007 3:19 PM | Jeff Smith
Gravatar

# re: Free SQL Server tools that might make your life a little easier

sweet! it'll definitly go into the next update.
11/29/2007 3:21 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

You may also be interested in SSIS dedicated tools. Here's mine:
http://www.codeplex.com/DTLoggedExec
12/3/2007 1:00 PM | Davide Mauri
Gravatar

# re: Free SQL Server tools that might make your life a little easier

of course i am. keep 'em coming!! :)
12/3/2007 5:29 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

First of all, great post, I am trying out a few new tools I haven't even heard of


SQL Internals Viewer
SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
http://www.sqlinternalsviewer.com/

SQL Accord CE Edition
robust (and free) comparison functionality for Microsoft SQL Server
http://www.sqleffects.com/

SQL Recon
SQLRecon performs both active and passive scans of your network in order to identify all of the SQL Server/MSDE installations in your enterprise.
http://www.specialopssecurity.com/labs/sqlrecon/
12/11/2007 3:08 PM | Jerry Hung
Gravatar

# re: Free SQL Server tools that might make your life a little easier

sweet jerry, sweet!! thanx!
12/11/2007 3:10 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Nice list! Many thanks! Another new tool that I've found just several days ago is a new edition of scriptlogic's security explorer. This new version 6.6 supports managing sql server permissions. Take a look here: http://www.scriptlogic.com/products/security-explorer/sql-server Permissions searching and some other useful features sounds promising! As I understood it's not free but I suppose the price is reasonable.
12/21/2007 2:44 PM | Clark
Gravatar

# re: Free SQL Server tools that might make your life a little easier

good list, but why didn't sqlspec make the cut?

:)
12/22/2007 8:10 AM | Jesse
Gravatar

# re: Free SQL Server tools that might make your life a little easier

it didn't? i'll add it to the list. thanx!!!
12/22/2007 3:48 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Free Database compare/ scripter with source code:

www.codeplex.com/dbdiff
1/3/2008 11:18 AM | safi
Gravatar

# re: Free SQL Server tools that might make your life a little easier


A visual query builder comes with free Oracle db Apex
1/16/2008 7:52 PM | OracleTube.com
Gravatar

# re: Free SQL Server tools that might make your life a little easier

How about those:

xSQL Object (http://www.xsqlsoftware.com/Product/Sql_Schema_Compare.aspx) for comparing and synchronizing SQL Server database schemas - it is free for SQL Server Express with no restrictions and also free for other editions of SQL Server (in those other editions it restricts the number of objects). It also includes scripting functionality completely free no restrictions for any SQL Server editions.

xSQL Data Compare (http://www.xsqlsoftware.com/Product/Sql_Data_Compare.aspx) for comparing and synchronizing data (same licensing scheme as the xSQL Object above)

xSQL Script Executor (http://www.xsqlsoftware.com/Product/Sql_Server_Script_Executor.aspx) a free tool for executing multiple scripts against a database

xSQL Object Search (http://www.xsqlsoftware.com/Product/Sql_Database_Object_Search.aspx) - a free tool for searching for objects in SQL Server 2005

RSS Reporter for SQL Server (http://www.xsqlsoftware.com/Product/Sql_Server_Rss_Reporter.aspx) - free for one SQL Server instance - automatically generate aggregate RSS Feeds with job status information from multiple servers; turn the results of a T-SQL query into an RSS feed and more.
1/17/2008 6:43 PM | JC
Gravatar

# re: Free SQL Server tools that might make your life a little easier

How to know the parsers?
like
sp_xml_preparedocument and soon
2/8/2008 10:18 AM | Rakesh
Gravatar

# re: Free SQL Server tools that might make your life a little easier

@rakesh:
what do you mean?
2/8/2008 2:47 PM | Mladen
Gravatar

# oyun

good list
2/25/2008 8:44 PM | oyun
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Thank you!
2/28/2008 2:35 PM | Jeff M
Gravatar

# re: Free SQL Server tools that might make your life a little easier

GOOD
3/5/2008 10:03 AM | ytku
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Hi,

I have requirement to convert TSQL stored procedure to .NET CLR Stored procedure. Anyone knows any conversion tool, which can read existing TSQL SP and give me .NET code for the same.

Thanks,
Hitesh
3/26/2008 5:55 PM | Hitesh
Gravatar

# re: Free SQL Server tools that might make your life a little easier

SqlServerFineBuild helps give a one-click install and configuration of SQL Server 2005. As well as slipstreaming SP2 and CUs, it optionally installs many of the tools listed on this page. www.codeplex.com/SQLServerFineBuild
4/10/2008 2:55 PM | EdVassie
Gravatar

# re: Free SQL Server tools that might make your life a little easier

sweet! thanx Ed
4/10/2008 10:10 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

This is a free SQL Development tools for SQL Server.
4/22/2008 6:21 AM | Eric M
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Sorry, I should have also put the url in the comment section
http://www.dborchestra.com/cesspr.php
4/22/2008 6:25 AM | Eric M
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I'm trying to figure out if there is a program that takes in a sql statement and schema and return the resulting schema
5/23/2008 8:32 PM | Robert
Gravatar

# re: Free SQL Server tools that might make your life a little easier

i'm not quite sure what you mean by that Robert.
if you already have a schema why would you need to get it?
5/23/2008 8:34 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I'm looking for a program to run an sql statement using only the schema without connecting to a database
5/28/2008 3:34 PM | Robert
Gravatar

# re: Free SQL Server tools that might make your life a little easier

aahhh... i don't know of such a tool. if you do find it please let me know.
5/28/2008 5:53 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

ok thanks
5/28/2008 6:32 PM | Robert
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Hi mister,

any Free SQL Server tools list for SQL SERVER 2000 ??

Thanks in advance
6/12/2008 9:59 AM | alhambra eidos
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I have compiled a list of tools for Microsoft SQL Server Analysis Services:

http://www.ssas-info.com/analysis-services-tools

Many of these tools are free, but some of them have comercial licences.
6/20/2008 5:26 PM | Vidas Matelis
Gravatar

# re: Free SQL Server tools that might make your life a little easier

This website has a free SQL Server DBA Dashboard tool. This has a number of different reports that allow you to look at what is going on in your SQL Server 2005 machine.
6/24/2008 4:23 PM | SQL Server Examples
Gravatar

# re: Free SQL Server tools that might make your life a little easier

@Keelio Software:
yeah i should but since they're not free i won't. :)
6/29/2008 11:43 PM | Mladen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Zidsoft CompareData is free for comparing table/view data. It is fast so you can also use it for replication verification for example, or for comparing data of development/production databases to ensure that data is migrated correctly as production database is updated with development builds.
7/24/2008 7:48 PM | Farid
Gravatar

# re: Free SQL Server tools that might make your life a little easier

You may also want to check out tSQLt for T-SQL unit testing: http://www.sourceforge.net/projects/tsqlt
8/22/2008 3:14 AM | Dennis
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I can also suggest the inclusion of Greg Larsen's Server DBA Dashboard tool over at http://www.sqlserverexamples.com/v2/
8/24/2008 1:53 PM | Mitch Wheat
Gravatar

# re: Free SQL Server tools that might make your life a little easier

COOL COOL COOL Thannk you!!!! a million. Hope you have the best success
11/15/2008 9:50 PM | JG
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Discovery Wizard for SQL Server from Quest Software is a freeware tool for scanning your network to identify SQL Server instances: http://www.quest.com/landing/?ID=1305
11/21/2008 2:47 PM | Alex Petrovsky
Gravatar

# re: Free SQL Server tools that might make your life a little easier

SQLcheck is a free SQL Server performance dashboard from Idera. It runs as a screensaver and gives real-time performance stats for any SQL Server
11/26/2008 5:55 PM | Janette Gawlikowski
Gravatar

# re: Free SQL Server tools that might make your life a little easier

ESF Database Convert, a tool transfer data between SQL Server and others various database&file format. Supports: SQL Server, Microsoft Access, Excel, Foxpro, Oracle, MySQL, PostgreSQL, SQLite, Firebird/Interbase in one product!

http://www.easyfrom.net/download/
12/3/2008 4:51 AM | Martin
Gravatar

# re: Free SQL Server tools that might make your life a little easier

There are also open-source tools like Nautilus (http://sourceforge.net/projects/nautilus/):

* Find records and related records
* Generate scripts (create table, update, insert into..., delete,.....)
* Build dynamic diagrams
* "Join to" wizard that lets you build a complex "select from...inner join....inner join" query just following
a wizard that guides you.
* Debug: take a snapshot of the databases, execute a program or script and then find the differences.

I hope you'd like it. Marcos.
12/3/2008 1:02 PM | Marcos
Gravatar

# re: Free SQL Server tools that might make your life a little easier

CA Database Command Center –A no-charge license multi-vendor database administration product. You can register, download and use the CA Database Command Center in your business to see firsthand how CA database management technology helps you unify and simplify database management of SQL Server, Oracle, and DB2 for Linux, UNIX and Windows databases (LUW).
12/4/2008 3:33 PM | Steve
Gravatar

# re: Free SQL Server tools that might make your life a little easier

SQL# (SQLsharp) is a CLR-based suite of over 120 Stored Procedures, User-Defined Functions, User-Defined Types, and User-Defined Aggregates. The vast majority of the functionality is free. The Paid-For (Full) version includes File System and Internet related functions. The suite works in SQL Server 2005 and SQL Server 2008. The goal of this project is to enable the SQL developer to have a more powerful language than regular T-SQL provides. Enjoy.

http://www.SQLsharp.com/

12/5/2008 4:52 AM | Solomon
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Add http://www.SQLDocumentor.com which will generate free meta-data documentation for SQL server
12/31/2008 2:57 AM | SQL Documentor
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Great list ! Here is another one to look at - SQL Excel (http://www.sqlexcel.net) Its a forms frontend that runs within microsoft excel. Its a freeware utility. Thanks for setting this list up.
J
1/15/2009 2:35 AM | John
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Excellent list! I didn't see RSScripter on there -- might want to include that. Will reverse engineer all your RDL files and plop them into a heirarchical folder structure in a location of your choice. Will transfer them between SSRS servers as well.
1/16/2009 6:18 PM | Sonya
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I recommend LZO instead of 7zip for archiving large backups

LZO - is just gzip on steroids. Simply the fastest archiver.
2/2/2009 5:52 PM | Alexander Yuryshev
Gravatar

# re: Free SQL Server tools that might make your life a little easier

You can find more free SQL tools at our site : the Data Profiler and Diana Lite, check our freebies :
http://www.nobhillsoft.com/Freebies.aspx
2/20/2009 8:01 PM | Itamar
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Spatial Viewer - useful for drawing shapes and translating them into geometry data:

http://www.codeplex.com/SpatialViewer
4/10/2009 9:19 AM | brejk
Gravatar

# re: Free SQL Server tools that might make your life a little easier

SQL Server Database Copy Tool - Simple tool to copy databases from one SQL Server to another.

http://dbcopytool.codeplex.com
4/14/2009 12:46 AM | jetro
Gravatar

# re: Free SQL Server tools that might make your life a little easier

SQL Encryption Assistant - SSMS addin to create SQL security objects and encrypt data.

http://www.devenius.com/SEABasic.aspx
4/19/2009 6:10 PM | Tim
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Here's a pseudo-code demonstration of what Squealer does when you create a file named AddEmployee.sqlr that contains:

insert Employees (Id, Name) values (1, 'Bob')
<security><user>john</user><user>mary</user></security>



It takes that code and turns it into something like this:

if procedure AddEmployee exists
drop procedure AddEmployee
go

create procedure AddEmployee
begin transaction
begin try
insert Employees (Id, Name) values (1, 'Bob')
end try
begin catch
-- automatic error handling, error logging, and deadlock trapping performed
end catch
-- plus a whole lot more
go
grant execute on AddEmployee to john
grant execute on AddEmployee to mary


Full product description:
This tool takes your minimal stored procedure code and expands it with automatic TRY..CATCH error trapping, error logging, transaction processing, and auto-retry deadlock handling on aborted batches. Error and deadlock handling works with nested procedure calls. You write code roots in standardized XML blocks. This tool expands the roots into full SQL script including all necessary DROP, CREATE, and GRANT EXECUTE statements. Alternatively, you can expand your root files into test scripts having your parameters formatted as DECLARE @var statements. Save your favorite test scenarios by filling in the 'TestValue' attributes of the parameters. This tool will also expand code roots for scalar and table-valued functions, giving you the same benefit of automatic test script generation and minimal coding. Thanks to the Axialis Team for the excellent icons used throughout the interface, Carter Medlin for his invaluable feedback and coding help, and Kim Berry for his excellent technical suggestions.
5/7/2009 7:51 AM | Squealer, FREEWARE
Gravatar

# re: Free SQL Server tools that might make your life a little easier

This is great list!! thanks :)
6/2/2009 8:16 AM | Vipul Limbachiya
Gravatar

# re: Free SQL Server tools that might make your life a little easier

A few more free spatial tools:

The SQL Server Spatial Tools project on CodePlex: a bunch of free spatial methods with code.
http://www.codeplex.com/sqlspatialtools

Morten's Shape2SQL tool: a free ESRI shapefile loader.
http://www.sharpgis.net/page/Shape2SQL.aspx

Cheers,
-Isaac
6/6/2009 6:42 PM | Isaac Kunen
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I would also add some tools for SQL Server Reporting Services, such as the RS Scripter:
http://sqldbatips.com/showarticle.asp?ID=62

There are other tools/utilities on that site as well (http://sqldbatips.com).

HTH
--
Thiago
6/8/2009 5:38 PM | Thiago Silva
Gravatar

# thanks

thanks for the info. is a great job.
6/19/2009 3:49 PM | Abel Chiola
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I've written a free SQL formatter. There is also a web service so you can include the functionality into your own applications/web site.

http://www.tsqltidy.com/
6/25/2009 9:27 AM | Mark PM
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Keep up the great work mate !!!!!
6/29/2009 10:05 AM | Nripin
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Maybe you could add SQL digger to the list.

http://sqldigger.bdsweb.be/

You can search you code.

And thanks for this great list of usefull tools !

D.
7/21/2009 9:06 PM | Danny Lauwers
Gravatar

# re: Free SQL Server tools that might make your life a little easier

The link to HP Scrawlr is not working.

Thank you for compiling the list. Good job.
8/11/2009 5:21 PM | Jeffrey
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Some SQL server conversion tools are listed at http://dbconvert.com
9/9/2009 12:28 PM | Jean
Gravatar

# re: Free SQL Server tools that might make your life a little easier

I've put together an open-source tool called DBSourceTools with similar features to Visual Studio For Database Professionals, as well as Management Studio.
The premise of the project is to help developers get their SQL databases scripted, and under source control.
It has a number of features:
- Script all database objects to disk.
- Script data to disk.
- Conditionally select database objects to script (ie. include config data but not log data).
- Publish from a Source Database to a Target Database.
- Schema comparison between databases ( thanks to dbDiff engine ).
- Search database objects.
- Enhanced SQL script editor with collapsible sections, parentheses highlighting, etc.
- Compress a database deployment to ZIP file for easy portability.
- New Query templates.
- Basic intellisense.
http://dbsourcetools.codeplex.com/
- Nathan.
9/21/2009 7:18 AM | Nathan
Gravatar

# New tools with free editions

We've just released some tools for SQL Server with free community editions. There is an IDE with full intellisense, code layout, auditing, multiple execution etc, there is a schema comparison / sync tool and a space analysis tool.

They can be found at http://www.atlantis-interactive.co.uk
1/20/2010 4:36 PM | Matt Whitfield
Gravatar

# re: Free SQL Server tools that might make your life a little easier

MSSQL SERVER AUTO RUN
2/5/2010 7:34 PM | mani R
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Hiya, I've been browsing a bit and found this great tool called SQL Search that can be downloaded free of charge from RedGate...

Some basic facts about this tool:
- Find fragments of SQL text within stored procedures, functions, views and more
- Quickly navigate to objects wherever they happen to be on your servers
- Find all references to an object
- Integrates with SSMS

http://www.red-gate.com/products/SQL_Search/index.htm
3/4/2010 2:46 PM | anton s
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Hi Everybody,

ISpySQL.com provides totally free SQL Server tools since 1999. No shareware or trials. If anyone has any questions please drop me an email. SQL SPY, SQL Query Bridge, and TSQL Script Explorer are a few of the more popular applications.

Rob Vallee
6/14/2010 2:06 PM | Rob Vallee
Gravatar

# re: Free SQL Server tools that might make your life a little easier

DBSave is a .Net Framework based solution to backup and restore MS SQL Server in running mode.


MS SQL Server backups with one click or via MS Windows based Schedule jobs.
DBSave is very easy to set up.
Backups Local, to Network or via FTP.
Remote Backup via VDI.
Supports up to 4 SQL servers instances on different servers.
Compression of the backups regardless of the SQL Server version.
Encryption of the backups via AES regardless of the SQL Server version.

http://www.sql-server-backup.de/en/
6/21/2010 10:30 PM | M. Pietsch
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Thanx a lot for the list...
7/29/2010 10:52 AM | sql recovery
Gravatar

# re: Free SQL Server tools that might make your life a little easier

Try Universal SQL Editor.. it increases your productivity when it comes in creating queries.
8/12/2010 7:03 AM | Vincent
Gravatar

# re: Free SQL Server tools that might make your life a little easier

good list - already helped me get an angle on one issue...
to compliment SQL express:
http://sqlbackupandftp.com/
free for a couple of databases - doees what it says on the tin.
9/17/2010 5:04 PM | Ian
Gravatar

# re: Free SQL Server tools that might make your life a little easier

very beautiful list......thanx a lot for sharing this.
9/27/2010 1:08 PM | MDF Database Repair
Gravatar

# aSQLDB: Makes Attach, detach and Shrink SQL Database very easy

I have created a SQL Utility tool that makes attaching, detaching and shrinking SQL databases very easy.

Features of aSQLDB:

* Attach, Detach and Shrink SQL Database File (.mdf).
* Creates DataSource Name (DSN) for the database.
* Detach Multiple databases at a time.
* Shrink multiple database at a time.
* Opens the folder physical file of the SQL Database attached.
* Search for mdf files in a folder and checks the status (attached or detached) and can attache multiple databases.
10/22/2010 12:26 PM | Ankit Gupta
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET