Home
August 21, 2008
tblMashedUp


SELECT feed FROM fGetRSS()


pBlogCategories


::fn_BlogRoll()


tblTagCloud

Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless



Open Source SQL Server projects on CodePlex

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

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  

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

Click here to post a comment
  Copyright 2006 by Statistics IO, My SQL Server Blog