December 4, 2008 at 8:57 pm
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.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
December 4, 2008 at 11:51 pm
thanks for the list.
"Keep Trying"
December 11, 2008 at 10:07 am
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.
December 17, 2008 at 2:21 am
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.
December 26, 2008 at 4:16 pm
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.
December 29, 2008 at 10:30 am
Microsoft SQLIO Disk Subsystem Benchmark Tool
has been very useful in comparing different disk IO systems. I've seen values between 600 on my desktop PC and 8000 on a SAN, and SQL Server seems to perform in proportion to these benchmarks.
Alan
January 13, 2009 at 7:38 am
Great compilation of free tools.
Thank you.
January 30, 2009 at 9:18 am
Does anyone know of a SQL 2000 compatible tool that will show the cost of queries ?? I'd like to know which queries run during the day are taking up the most resources and/or time.
February 5, 2009 at 11:23 pm
hello sir ,
i hava a problen in sql2000.
we have around 200 databases .now, i want to create a store procedure that will execute any store procedure on all 200 database's one by one .
so that i can save my valuable time .
plz help
thanks
February 6, 2009 at 9:03 am
Update to an earlier query: We were looking for an inexpensive tool to handle reallocating disk space on a 64-bit SQL 2005 server with two Raid-1 assemblies. My server mfg. techs pointed me towards a tool titled "GPartEd" (Global Partition Editor?) and while the tech advised they do not sanction such activities, they have used this product "hundreds" of times to handle just the problem I was having.
After bringing the server hardware up to snuff with recent driver and firmware upgrades and taking a system and ASR backup, I used the GPartEd software to free up space on one RAID-1 drive and reallocate that space on the mirrored drive of that same RAID-1...no problems. The task was tedious as the software performs at least two different "layers" of tasks in freeing up the space, re-positioning the space, then finally resizing the C: drive to accept the freed up space. I had not realized how much time was involved, so this task ended up taking two weekends, about 5 hours each weekend. Part of that time was in applying and resolving issues with driver and firmware updates. Also, it is recommended that drives be defragged and/or chkdisk run against them. If you don't do this and GPartEd finds a bad disk sector it will fail. Allow plenty of time for defrags, chk disk, backups, etc besides several hours for the GPartEd software. My drives are 36 GB and the GPartEd section took approx. 2 hours to free up the space and position the space and another 1 hour of time to run the process to resize the C: drive to accept the free space.
GPartEd worked as needed for this task. The website has good documentation:
http://gparted.sourceforge.net/ and I will be using it on all of my servers. JTNelson 😎
February 17, 2009 at 11:58 pm
Good collection thank you for the all information
Tharindu Dhaneenja.
MCTS,MCITP(SQL Server),OCA(Oracle)
http://www.databaseusergroup.com
March 25, 2009 at 11:28 am
April 1, 2009 at 9:17 am
Great list, this i wrote for administering sql report server 2000/2005/2008: http://rssexplorer.codeplex.com/
April 19, 2009 at 6:10 pm
SQL Encryption Assistant is a free SSMS addin to manage SQL security objects (certificates, symmetric keys, asymmetric keys, etc.)
Check it out...http://www.devenius.com/SEABasic.aspx
Tim
April 25, 2009 at 5:46 am
2 more free tools for the list from Nob Hill :
Profiler
Actively queries data at a given interval and lets you know of data changes that occur over time. Interactive reports, email notifications, generates scripts to mimick operations that happen on the data across any given timespan. Free for one year
Diana Lite
.... This one searches entities on a single SQL Server, MySQL server, or a Randolphe database (any number of databases). When you want to quickly find some database entity, script it, view the data in it, search for data or a substring across all entities in one or more databases… this is the tool for you. Free for one year
--------
SQL Data compare , Synchronize data from diffrent surces, and many other SQL tools[/url].
Viewing 15 posts - 16 through 30 (of 47 total)
You must be logged in to reply to this topic. Login to reply