Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Free Tools for the SQL Server DBA Part 2


Free Tools for the SQL Server DBA Part 2

Author
Message
noeld
noeld
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6852 Visits: 2048
NICE!


* Noel
nelsonj-902869
nelsonj-902869
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2748 Visits: 747
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
Jerry Hung
Jerry Hung
SSC Eights!
SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)

Group: General Forum Members
Points: 926 Visits: 1208
nelsonj (12/4/2008)
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


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
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Administrators
Points: 40849 Visits: 18861
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
My Blog: www.voiceofthedba.com
robkraft
robkraft
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.



Solomon Rutzky
Solomon Rutzky
SSC Eights!
SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)

Group: General Forum Members
Points: 904 Visits: 2946
Thanks for this list. Very handy info Smile

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/
ChiragNS
ChiragNS
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2591 Visits: 1865
thanks for the list.

"Keep Trying"
JJ B
JJ B
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 2849
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.
nariman.ghanghro
nariman.ghanghro
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
Misha_SQL
Misha_SQL
Right there with Babe
Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)

Group: General Forum Members
Points: 728 Visits: 994
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search