CodePlex Information and Discussion

CodePlex.zip (88,6 MB)
This area is used for providing information and discussions about the CodePlex website.

DatingGame

DatingGame.zip (12,7 MB)
Course to teach high-school aged girls basic T-SQL using a fun scenario - querying to find the hottest boys! Used at Microsoft DigiGirlz and TKP events. Included DDL script, CSV for bcp with data, PPTX, T-SQL Cheat Sheet and teaching tips. Enjoy!

DBScripter - Library for scripting SQL Server database objects

DBScripter.zip (29,0 MB)
This project is library that allows users to script SQL Server database objects. Library uses dynamic management views for extracting data about databases objects. This library could be used in various situations. The most interesting areas are comparing database objects and generation database documentation. For both cases examples have been prepared.

EVPO Members

This is a web based contact / membership database. Good simple interface with look-ups, search , export to Excel and security features. ASP.NET & Microsoft SQL

LINQ Expression Builder

A SQL to LINQ translator that will help the development community to adopt the new expression language using a user friendly integrated tool for Visual Studio 2008.

jSQL - SQL like querying of JavaScript arrays

jSQL.zip (66 kB)
jSQL facilitates the query, update and delete of items, in an array of plain objects, using JavaScript and SQL like syntax.

Microsoft SQL Server Product Samples: Database

This project contains Database samples released with Microsoft SQL Server product.

O Library

olibrary.zip (44 kB)
O Library is a SQL 2008/2012 Framework that enables developer to add a .Net feeling to their T-SQL code and aims to bring a bit of fun into T-SQL development.

QueryToGrid Module for DotNetNuke®

This is a module that allows you to execute and display the results of T-SQL queries in DotNetNuke using your choice of AJAX grids.

SQL Scriptz Runner

Features are : Drag And Drop script files Run a directory of script files Sql Script out put messages during execution Script passed or failed that are colored green and red (yellow for running) Stop on error option Open script on error option Run report with time taken for each

SQL Server 2-D Matrix Builder

This project is all about bringing a *2-D matrix builder* to Microsoft SQL Server 2005 (or later). Why do we need this? If you need to build a query where the returned resultset colums are not actual tables columns but instead some tables records content, you will need the "*SQL Server 2-D Matrix Builder*".

SqlMeth

sqlmeth.zip (25 kB)
SqlMeth is a command line tool to speed up development time by turning database diagrams into models with control columns, views and stored procedures.

Some Important System Scripts

this is a set of system related scripts which provide some uses for out regular works, these system related scripts are mostly used in common Scenario

SQScriptRunner

Simple Quick Script Runner allows an administrator to run T-SQL Scripts against one or more servers with common characteristics. For example, an maintenance script might be targeted at a list of mirrored servers, or a list of computers running SQL Express.

SQL Spatial Tile Render Engine

sstre.zip (39 kB)
CLR CSharp application to render a set of GIS spatial images directly from SQL Server as rowset data using standard T-SQL language extended for simplicity . C# 3.5 32 or 64 bit extension for SQL server 2008

SYS2 DMVs

sys2dmvs.zip (34 kB)
A collection of scripts that simplify the usage of SQL Server 2005 and over DMVs, avoiding the user to have to write queries with tons of joins and allowing him to have directly the results he needs.

T-Sql Code Documentor

Document T-SQL Code and Extract Comments for all objects in a database.

T-SQL Split Field by Delimiter

T-SQL hasn't split function to split a text by delimiter, this function return a string which can be used in select statement to split a varchar column by a delimiter to multiple columns. This function should be used with Dynamic T-SQL.

T-SQL Toolbox

T-SQL Toolbox is a MS SQL Server database with a set of handy utilities for T-SQL database developers, e. g. it adds full timezone support using native T-SQL.

T.S.T. the T-SQL Test Tool

TST.zip (15,6 MB)
TST simplifies the task of writing and running test automation for T-SQL code. Written in T-SQL it provides an API similar to those provided by other Unit Testing frameworks. Can produce test reports in XML format. It provides automatic rollback, dataset comparison support, etc.