Free Tools for the SQL Server DBA Part 2

Question

Free Tools for the SQL Server DBA Part 2

Viewing 15 posts - 31 through 45 (of 47 total)

You must be logged in to reply to this topic. Login to reply

ggefaell SSC Journeyman Points: 82 More actions · Answer 1

Thanks for the list 😉

I would like to add my SQL Express Profiler. SQL Profiler it's and open source application that provides similar functionality the standard Profiler does. For those that use SQL Express or Workgroup edition it's a great tool.

http://sqlprofiler.googlepages.com

Chuck Lathrope Mr or Mrs. 500 Points: 568 More actions · Answer 2

I also have a huge list of free tools. It has gone beyond just SQL tools, but very server administrator focused. http://www.sqlwebpedia.com/content/free-sql-server-tools

Chuck Lathrope

@SQLGuyChuck

JJ B SSCertifiable Points: 5130 More actions · Answer 3

JJ B

SSCertifiable

Points: 5130

August 28, 2009 at 1:45 pm

#1046392

Nice list Chuck! Thanks for sharing.

theSuda SSC Eights! Points: 887 More actions · Answer 4

This is kinda old article but still no tools you mentioned have become obsolete. I would like to mention SqlDBX personal which I think is very fast and good for quick querying.

http://www.sqldbx.com/personal_edition.htm

_____________________________________________________________

[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]

Andreas Erson SSC Journeyman Points: 96 More actions · Answer 5

Microsoft SQL Server 2008 Management Studio Express isn't pre-packaged with SP1. You either install it with the regular download or (even simplier) with the Web Platform Installer (you can also install the Express database with it). Then just use Windows Update to get the SP1.

Web Platform Installer

http://www.microsoft.com/web/downloads/platform.aspx

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 6

I have just released some tools which are either free or have free editions - there is:

SQL Everywhere - an IDE with code completion, auditing, multiple execution, lots more - free edition available

http://www.atlantis-interactive.co.uk/products/sqleverywhere/

Schema Inspector - a schema comparison and synchronisation tool - free edition available

http://www.atlantis-interactive.co.uk/products/schemainspector/

Data Space Analyser - a graphing tool to explore the space used in databases - totally free

http://www.atlantis-interactive.co.uk/products/dataspaceanalyser/

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

Steve Culshaw SSC Rookie Points: 38 More actions · Answer 7

Tried the link to SQL Safe Free Edition, but Idera have pulled it 🙁

David-Leibowitz SSChasing Mays Points: 610 More actions · Answer 8

SQLScrubs Community Edition is a free resource for management, audit and optimization of SSRS 2008. It includes a datawarehouse, SSIS log scrubbers, and a basic kit of report to get you started.

Reporting services execution log review helps you locate the slowest reports, data hogs and areas to tune.

http://scrubs.codeplex.com

SQLScrubs: SSRS Audit, Optimization & Management reports

mike.styers Mr or Mrs. 500 Points: 505 More actions · Answer 9

We have a central database that stores all data from independent companies databases. Does anyone know of a tool that compares data for two or more databases but with filtering functionality? I'd like to be able to compare the central database company A data to the database for company A, central database company B data to the database for company B, etc. The database schema's are identical.

Thanks,

M

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 10

whoops

i thought you said schema, not data!

Red gate's data compare does it quite well, and the tablediff utility is worth investigating...

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

mike.styers Mr or Mrs. 500 Points: 505 More actions · Answer 11

I looked a Red Gate but I didn't see the filtering functionality. The data in Company A is a subset of what is stored in the Central database. Looks like I would be bombarded with rows in Central but not in Company A errors. To make things more interesting, we have data that synch's everywhere like Vendors, but Invoices, Payments, Inventory are Company specific............

Thanks for the response,

M

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 12

I'll be sure to remember that as a feature when I come to write my one! 🙂

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

yonision Ten Centuries Points: 1033 More actions · Answer 13

Some more nice free SQL Server tools:

http://www.nobhillsoft.com/Freebies.aspx

SanjayAttray SSChampion Points: 13157 More actions · Answer 14

Does any one know of a tool which actually converts T-SQL procedures/Triggers/Functions to PL/SQL ?

I had got the project where they need to convert code to pl/sql format. Only code and no data migration ?

Thanks.

SQL DBA.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Nice list - thanks

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events