BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Saturday, July 04, 2009
MyStreamMinimize
Print  

Open Source SQL Server projects on CodePlex

Posted by Jason on Sunday, June 22, 2008 to SQL Server 2005
1821 Views | 3 Comments | Article Rating

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."

sqlServerCacheManager

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."

Open

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
FineBuild delivers 4 standards 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:
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


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


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


Name (required)

Email (required)

Website


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

Copyright 2006 by Statistics IO, My SQL Server Blog