InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 15:11:50 GMT20http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxHello, just wanted to add one more tool to the belt (besides, it was notably absent):[url=http://www.atlantis-interactive.co.uk/products/sqleverywhere/featureshowcase.aspx]SQL Everywhere[/url] - a free SQL Server IDE (Integrated Development Environment) which supports all versions of Microsoft SQL Server from 2000 to 2008 and comes with the most fully-featured and accurate SQL Intellisense® engine available – use it to turbocharge your productivity!Sun, 14 Nov 2010 18:33:58 GMTarthurzhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspx[quote][b]mike.styers (1/22/2010)[/b][hr]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[/quote]Hi Mike,SQL Data Compare can filter rows from the source and/or target using the "Where Clause" feature in the Tables and Views tab (project options). Is this what you're looking for? Please email support if you need assistance!David (Red Gate)Mon, 25 Jan 2010 17:11:31 GMTDavid Atkinsonhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxHere are some free toolshttp://www.sqldbtools.com/Tools.aspxFri, 22 Jan 2010 12:53:07 GMTbouarroudj Mohamedhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxNice list - thanksFri, 22 Jan 2010 07:53:24 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxDoes 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.Fri, 22 Jan 2010 07:46:00 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxSome more nice free SQL Server tools:[url=http://www.nobhillsoft.com/Freebies.aspx]http://www.nobhillsoft.com/Freebies.aspx[/url]Fri, 22 Jan 2010 07:01:20 GMTyonisionhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxI'll be sure to remember that as a feature when I come to write my one! :-)Fri, 22 Jan 2010 06:21:33 GMTMatt Whitfieldhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxI 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,MFri, 22 Jan 2010 06:16:24 GMTmike.styershttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxwhoopsi thought you said schema, not data!Red gate's data compare does it quite well, and the tablediff utility is worth investigating...Fri, 22 Jan 2010 06:03:25 GMTMatt Whitfieldhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxWe 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,MFri, 22 Jan 2010 05:59:47 GMTmike.styershttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxSQLScrubs 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.comFri, 22 Jan 2010 05:29:04 GMTDavid-Leibowitzhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxTried the link to SQL Safe Free Edition, but Idera have pulled it :(Fri, 22 Jan 2010 02:11:03 GMTSteve Culshawhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxI 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[url]http://www.atlantis-interactive.co.uk/products/sqleverywhere/[/url]Schema Inspector - a schema comparison and synchronisation tool - free edition available[url]http://www.atlantis-interactive.co.uk/products/schemainspector/[/url]Data Space Analyser - a graphing tool to explore the space used in databases - totally free[url]http://www.atlantis-interactive.co.uk/products/dataspaceanalyser/[/url]Fri, 22 Jan 2010 01:49:43 GMTMatt Whitfieldhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxMicrosoft 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[url=http://www.microsoft.com/web/downloads/platform.aspx]http://www.microsoft.com/web/downloads/platform.aspx[/url]Fri, 22 Jan 2010 01:39:59 GMTAndreas Ersonhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxThis 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.htmSat, 07 Nov 2009 08:37:00 GMTtheSudahttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxNice list Chuck! Thanks for sharing.Fri, 28 Aug 2009 13:45:16 GMTJJ Bhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxI also have a huge list of free tools. It has gone beyond just SQL tools, but very server administrator focused. [url=http://www.sqlwebpedia.com/content/free-sql-server-tools]http://www.sqlwebpedia.com/content/free-sql-server-tools[/url]Chuck Lathrope@SQLGuyChuckThu, 27 Aug 2009 23:40:45 GMTChuck Lathropehttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxThanks 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.comThu, 23 Jul 2009 05:13:00 GMTggefaellhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspx2 more [url=http://nobhillsoft.com/Freebies.aspx]free tools for the list from Nob Hill[/url] : [quote] [u]Profiler[/u]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[/quote][quote]Diana Lite.... This one searches entities on a single SQL Server, MySQL server, or a [url=http://nobhillsoft.com/Randolph.aspx]Randolphe[/url] 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[/quote]Sat, 25 Apr 2009 05:46:56 GMTitamar-863608http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspx[b]SQL Encryption Assistant[/b] is a free SSMS addin to manage SQL security objects (certificates, symmetric keys, asymmetric keys, etc.)Check it out...http://www.devenius.com/SEABasic.aspxTimSun, 19 Apr 2009 18:10:39 GMTtim-1071227http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxGreat list, this i wrote for administering sql report server 2000/2005/2008: [url]http://rssexplorer.codeplex.com/[/url]Wed, 01 Apr 2009 09:17:03 GMTpeter-880034http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxGreat list, thks.I would like to add to Editors:Notepad2 http://www.flos-freeware.ch/Emito.Wed, 25 Mar 2009 11:28:15 GMTEmitohttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxGood collection thank you for the all informationTue, 17 Feb 2009 23:58:30 GMTdhaneenja-755935http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxUpdate 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 :cool:Fri, 06 Feb 2009 09:03:33 GMTnelsonj-902869http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxhello 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 helpthanksThu, 05 Feb 2009 23:23:35 GMTmrpramodkumarsharmahttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxDoes 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.Fri, 30 Jan 2009 09:18:15 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxGreat compilation of free tools. Thank you.Tue, 13 Jan 2009 07:38:25 GMTOCTomhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxMicrosoft SQLIO Disk Subsystem Benchmark Tool http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=9A8B005B-84E4-4F24-8D65-CB53442D9E19&displaylang=enhas 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.AlanMon, 29 Dec 2008 10:30:34 GMTAlan Spillerthttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxWe 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.Fri, 26 Dec 2008 16:16:46 GMTmishalubahttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxopenDBA 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.Wed, 17 Dec 2008 02:21:17 GMTnariman.ghanghrohttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxGreat 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.Thu, 11 Dec 2008 10:07:13 GMTJJ Bhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxthanks for the list.Thu, 04 Dec 2008 23:51:40 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxThanks 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.[url]http://www.SQLsharp.com/[/url]Thu, 04 Dec 2008 20:57:13 GMTSolomon Rutzkyhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxSimple SQL Backup ([url=http://www.simplesql.net]www.simplesql.net[/url]) 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.Thu, 04 Dec 2008 19:53:09 GMTrobkrafthttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxLinks in the article have been corrected.Thu, 04 Dec 2008 16:32:41 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspx[quote][b]nelsonj (12/4/2008)[/b][hr]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[/quote]I agree, Partition Manager server version seemed to stop at 4.0? and Windows 2000Acronis Disk Director ($499 for server, not cheap. $50 for Home)[url]http://www.acronis.com/enterprise/products/diskdirector/[/url][url]http://www.acronis.com/enterprise/products/diskdirector/comparison.html[/url]Thu, 04 Dec 2008 13:44:22 GMTJerry Hunghttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxTwo 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 NelsonThu, 04 Dec 2008 13:17:17 GMTnelsonj-902869http://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxNICE!Thu, 04 Dec 2008 11:30:35 GMTnoeldhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspxGood list. Thanks you all for providing a great list. :)Thu, 04 Dec 2008 09:29:05 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic613458-283-1.aspx[quote][b]betsy.mendenhall (12/4/2008)[/b][hr]SQLServerPedia.com is also a fgood go-to source for free information and advice from MVPs.[/quote]I met their editor, Brent, at PASS last month. Nice guy. Best thing about him: he runs a laptop like I do; a MacBook Pro running Windows/SQL Server through a VM. Only I'm running Parallels, he's running VMWare. (which apparently lets you take server images from your corporate network and move them over to your Mac....)SQLServerPedia looks like it's going to be an excellent resource. SQLServerCentral will always be my #1 go to place, but I have a feeling that the 'Pedia will be #2.Thu, 04 Dec 2008 09:14:07 GMTWayne West