Free Tools for the SQL Server DBA Part 2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » Free Tools for the SQL Server DBA Part 2

48 posts, Page 2 of 5

««1 2 3 4 5 »»»

Free Tools for the SQL Server DBA Part 2

Rate Topic

Display Mode

Topic Options

Author

Message

noeld

Posted Thursday, December 04, 2008 11:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260, Visits: 1,977

NICE!

* Noel

Post #613957

nelsonj-902869

Posted Thursday, December 04, 2008 1:17 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, March 29, 2013 7:52 AM
Points: 1,483, Visits: 619

Two great articles with handy tools. I happen to be looking for a disk partitioning tool (cheap but not Partition Magic since I can't find a "server" version) that will work with RAID hd configurations on a 64-bit engineered SQL 2005 running Windows Server 2003 R2 64bit. I have C: drive and D: drive in a RAID 1 set up and am out of space on C: but with bunches of space on the D: drive (using 73GIG drives.) Has anyone found an inexpensive tool to work with 'server' environments, especially 64-bit ones? Thanks. JT Nelson

Post #614046

Jerry Hung

Posted Thursday, December 04, 2008 1:44 PM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:02 PM
Points: 768, Visits: 1,159

nelsonj (12/4/2008)

I agree, Partition Manager server version seemed to stop at 4.0? and Windows 2000

Acronis Disk Director ($499 for server, not cheap. $50 for Home)
http://www.acronis.com/enterprise/products/diskdirector/
http://www.acronis.com/enterprise/products/diskdirector/comparison.html

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005

Post #614074

Steve Jones - SSC Editor

Posted Thursday, December 04, 2008 4:32 PM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

Links in the article have been corrected.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #614189

robkraft

Posted Thursday, December 04, 2008 7:53 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 6:11 AM
Points: 1, Visits: 6

Simple SQL Backup (www.simplesql.net) is a great way for backing up and restoring simple databases. It also has a nice MOVE button to move a database. Best for SQL Express or for users that are not SQL Admins.

Post #614229

Solomon Rutzky

Posted Thursday, December 04, 2008 8:57 PM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:12 AM
Points: 285, Visits: 1,377

Thanks for this list. Very handy info :)

Another free tool is SQL# (SQLsharp). SQL# 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/

SQL# - http://www.SQLsharp.com/

Post #614240

ChiragNS

Posted Thursday, December 04, 2008 11:51 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

thanks for the list.

"Keep Trying"

Post #614282

JJ B

Posted Thursday, December 11, 2008 10:07 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:03 PM
Points: 255, Visits: 2,405

Great article. More than deciding what to put in the list itself, I appreciated that you gave enough of a description of each product that I could tell you had actually looked at it. And I could use the description to decide if the product was worth investigating further or not.

Jerry: I too miss Speed Ferret a great deal! I only used it for MS Access, but it no longer works correctly on the version of MS Access that I use. I'd love to know of a replacement. I found something at one point, but it was not as full-featured and felt, I don't know the term, but "likely to not do it's job correctly" is the gist of my concern. If I'm going to do a search and replace on an important application, I want to know it is a reliable, stable product that has all the features I need. Thanks for your post. Glad to know I'm not the only one missing it, even if for different reasons.

Post #618070

nariman.ghanghro

Posted Wednesday, December 17, 2008 2:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, April 19, 2009 6:13 PM
Points: 1, Visits: 16

openDBA http://www.opendba.info is an open source web based DBA Tool for SQL Server. Works with 2000 and 2005 versions.

The basic idea is to provide a dashboard style interface to the DBA for monitoring of common things such as Server Disk Space, Database Sizes, SQL Agent Jobs, and the description of Tables, Stored Procedures and so on.

The good thing is that openDBA provides real-time information specially the critical events such as over use of CPU or Memory and the failure of SQL Agent Jobs.

Graphical Bar Chart for Disk Space is a wonderful tool for a Bird-eye View to monitor Disk Space on Server.

The web based application is ASP based and the instructions for setup can be found in Setup.htm in the root folder.

Post #621017

mishaluba

Posted Friday, December 26, 2008 4:16 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

We have used MS log parser in a production environment for processing weblogs for a fairly prominent website (around 30-40GB worth of logs daily) and it worked great (for the most part). Thank you for the comprehensive list of valuable tools.

Post #626055

« Prev Topic | Next Topic »

48 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions