Open Source SQL Server projects on CodePlex

I was perusing CodePlex and I noticed some new and interesting projects. This is the search that I used. Just sort by release date. There are a ton of projects but these are the ones that I found interesting.

SQL Server Cache Manager

"SQL Server Cache Manager will allow you to return information about what is stored is the SQL Server cache and how efficiently it is being used."

This is ubercool especially if you are not intimate with sys.dm_exec_query_stats. I admit that I probably will not use this much though. I already have my analysis queries written. I am used to them plus I can CROSS APPLY sys.dm_exec_query_plan to get the xml show plan.

 

Open DBDiff

"Open DBDiff is a open source database schema comparison tool for SQL Server 2005."

Nice looking tool if you don't use Data Dude. They also mention that support for MySQL and SQL2000 is coming.

 

SQLServerFineBuild

"SQLServerFineBuild provides 1-click install and best-practice configuration of SQL Server 2005."

One-click Install of SQL Server 2005

• The standard build includes Service Pack, Cumulative Update hotfix, community tools, and best-practice configuration.
• The builds can be deployed manually or by a distribution tool such as Altiris.

Highly Customizable

• Each site can edit the Configuration File to include site standards.
• Site-specific components can be included in the FineBuild process

Pre-Configured Standard Builds

• Default Server build - for multi-drive servers
• Named Instance build - adds another SQL Server instance to a server
• Workstation build - for single-drive desktop machines
• Client Tools build - just the tools, to allow remote administration of SQL Server

I am definitely going to give this one a try next time I have to do a 2005 install.

 

This are just the 3 that I thought were new and notable. Check out the full list.

email it! |   |   |   |  | 

Permalink     3 Comments  

Rate this Post: 12345
COMMENTS:

Hi Jason,

You might want to try openDBA www.opendba.info which is a complete open-source SQL Server Monitoring application.

Your feedback will be of great value.

Cheers,
Nariman

posted @ Sunday, June 22, 2008 10:12 PM by Nariman

---

Comments from the following blog entry: Interesting Finds: 2008.06.30, located at: http://weblogs.asp.net/yuanjian/archive/2008/06/29/interesting-finds-2008-06-30.aspx

posted @ Sunday, June 29, 2008 7:28 PM by gOODiDEA.NET

---

Comments from the following blog entry: Interesting Finds: 2008.06.30, located at: http://www.cnblogs.com/gOODiDEA/archive/2008/06/30/1232236.html

posted @ Sunday, June 29, 2008 7:29 PM by gOODiDEA

---

Name (required)

Email (required)

Website

Notify me of followup comments via e-mail

Simple BBCode can be used like [url=http://example.com]Example[/url] and [B]