CodePlex Published Projects For Tag SQL Server

SSIS Restart Framework

CodePlex — Wed, 16 May 2012 08:16:15 GMT

A framework that provides restartability for SSIS 2012 projects. It is very much work in progress so at the current time, use at your own peril.

Pro-I: advanced analytics for threat detection

CodePlex — Thu, 03 May 2012 06:55:58 GMT

Pro-I is a solution created at Intel for information security threat detection. It is an end-to-end solution, currently built on the SQL Server 2008 Platform. It has multiple analytics and realtime components, plus 3-D visualization of big data for users.

Database Task Parallel Foundation - dbParallel for Oracle & SQL Server

CodePlex — Sat, 28 Apr 2012 18:30:04 GMT

The dbParallel is a Database Task Parallel Foundation that provides database developers an application level support for parallel programming. Being distinct from Oracle 11g R2's DBMS_PARALLEL_EXECUTE parallelism within a query by chunks, dbParallel works more like a .NET Task Parallel Library implemented on database side, it handles the partitioning of the asynchronous job, the scheduling of tasks, state management, and other low-level details.

Features
Following API list of current version reflects the features:

- CREATE_PJOB
Each of the above sample processing units are called a PJob. PJob represents an asynchronous operation.
- ADD_TASK
Each pJob contains one or more parallel tasks. Each task is a dynamic SQL. Call the ADD_TASK multiple times to add every parallel tasks into the pJob.
- ADD_CALLBACK_FOR_SUCCESS
This is a optional method. Since a pJob is asynchronous, the callback Task is called to execute a continuation when all the parallel Tasks successfully completed.
- ADD_CALLBACK_FOR_FAIL
This is a optional method. Similar but opposite to previous callback for success.
- START_PJOB
Starts the pJob, scheduling it for execution.
- TRY_CANCEL_PJOB
Try to cancel a scheduled pJob if it hasn't begin to execute.
- START_NEW_SINGLE_TASK
This method encapsulates a series of steps for conveniently creating and starting single task and callback task.

How It's Made
- Dtabase Side
Each pJob is added into the Scheduler, and then the State Manager controls every stage in the lifecycle of the pJob.
- Windows Service Side
At least one Pump Service must reside in Windows Services act as a dispatcher.

Service Mode

A Pump Service always starts up in Standby Mode. Multiple Standby Services can keep running for the same database, one of them will switch to Primary Mode when none Primary Service is active.

Supported Databases:
- Oracle
- SQL Server

Places

CodePlex — Sun, 22 Apr 2012 00:05:42 GMT

Places is an application that lets you add pushpins, draw trails, and mark areas on a map of the world. It is powered by the Bing Maps WPF Control, SQL Server, and the Entity Framework.

IQ.DbA

CodePlex — Wed, 11 Apr 2012 20:58:37 GMT

IQ.DbA is a light weight database management tool.
- Easily browse through your table's data, run queries.
- Compare schema / meta data.
- Compare & synchronize table data (schema must be the same).
- Create, Backup & Restore Db.
- View & kill connections.
- Added, sync indexes

Command-Line Database Builder

CodePlex — Wed, 11 Apr 2012 03:24:09 GMT

A command-line tool for interacting with a DBMS command-line interface (e.g., sqlcmd.exe) to execute a sequential list of SQL scripts against the DBMS. Tool allows for expression replacement in the SQL scripts during execution.

Northwind SSDT

CodePlex — Tue, 10 Apr 2012 20:49:15 GMT

An SSDT project for the Northwind database. This will enable you to deploy Northwind wherever you like.
Note that to allow for hosting in a SQL Azure database that is used to host objects for other applications all the Northwind objects have been moved into a schema called [Northwind]

LittleUmph

CodePlex — Wed, 28 Mar 2012 15:47:54 GMT

It's a little library to help you to alleviate some of the mundane stuff during your development. It has some nifty stuff like a neat database wrapper, conversion utilities, string functions and vast of other mini helpers to improve the efficiency and consistency of your code.

Visual Studio Data Generators

CodePlex — Thu, 15 Mar 2012 21:51:16 GMT

Visual Studio Data Generators is a collection of custom data generators for the Data Generation Plan feature of Visual Studio 2010 Premium and Ultimate. It generates random, valid data in several formats: URLs, emails, telephones and so on.

ASP.Net Database Client

CodePlex — Mon, 12 Mar 2012 10:24:19 GMT

Database client is a web application for SQL Server Data management.
CRUD, write and execute queries, quick search records.
Map referencing columns for easier data edit.
All you need is connection string to database and you are ready to go.

It's developet in ASP.Net

SQL Scriptz Runner

CodePlex — Mon, 05 Mar 2012 06:14:39 GMT

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

SQLCLR Cmd Exec Framework Example

CodePlex — Wed, 29 Feb 2012 23:05:38 GMT

For users of MS SQL Server, xp_cmdshell is a utility that we usually want to have disabled. However there are still cases where calling a command line is needed. This project provides an framework/example to make command line calls. It is not meant as an xp_cmdshell replacement but as a workaround.

DB Compare

CodePlex — Sat, 25 Feb 2012 08:08:54 GMT

DB Compare is a simple utility that compares the schema (Tables, Views, and Stored Procedures) of two SQL Server databases.

I do all my development on my local SQL Server instance and when I deploy new versions of web sites or web services I often wonder if the schema has changed or if I have only changed the code.

The source code consists of a Visual Studio 2010 solution that contains two projects.

DataClassBuilder.Net.Dll - This is the main code generation engine of RAD Studio Code Generation Toolkit, located at http://radstudio.codeplex.com .

In my completely biased opinion RAD Studio is the best C# code generator / data tier creator / stored procedure generator for C# and other .Net developers.

In addition to the time savings that DB Compare saves me, I built this project to demonstrate RAD Studio Code Generation Toolkit. I think more developers would use it if they knew about it and how to use it property.

Hopefully this project will become popular and also increase the popularity of RAD Studio, as there is alot of very useful code in the program.

One last thing, if you do wish to work on the code, I have another project called Regionizer, which is a Visual Studio Package that docks in the toolbar where the Solution Explorer or Properties Window is located, and will format a C# document into regions for Private Variables, Methods, Constructors, Events and Properties.

http://regionizer.codeplex.com

About DB Compare:

DB Compare is a simple tool that compares two instances of SQL Server and compares the of the tables, views and stored procedures to make sure they are up to date.

To use the tool enter (or create) a connection string for the source database and target database and a Comparison Report is generated on screen that will report if the databases are equal or if they are not equal any differences are shown.

Activities.MSSQL

CodePlex — Thu, 23 Feb 2012 11:09:16 GMT

WF4 で利用できる Microsoft SQL Server 関係のアクティビティライブラリ

Activities library for Microsoft SQL Server available in WF4

FluentData -Micro ORM with a fluent API that makes it simple to query a database

CodePlex — Mon, 13 Feb 2012 22:05:58 GMT

A simple to use Micro ORM with a great fluent API that makes it simple to select, insert, update and delete data in a database.
Supported databases: Microsoft SQL Server, MS SQL Server Compact, MS SQL Azure, Oracle and MySQL.

蒼の王座IndexView

CodePlex — Sun, 12 Feb 2012 18:53:14 GMT

蒼の王座IndexViewは、SQL Serverのインデックスの断片化率を一覧表示します。
断片化しているインデックスを選択して、再構築することができます。再構築時の進捗状況を表示することが目的のツールです。

MongoDB SQL Server Importer

CodePlex — Tue, 07 Feb 2012 16:23:35 GMT

If you want a quick (but kinda dirty) way to import your SQL Server database to MongoDB, this is your tool. This tool is for those who wants to leverage their existing database to learn MongoDB. It's developed in C#.

Songhay Data Access

CodePlex — Wed, 25 Jan 2012 23:46:16 GMT

Songhay Data Access is a set of static helper classes defining routines around System.Data.Common. Songhay Data Access has been used with SQLite, MySQL and SQL Server but this set of libraries will work with any database that has an ADO.NET providprovider written for it.

DBComparer

CodePlex — Thu, 19 Jan 2012 20:15:42 GMT

Find Differences Between two Database and Update Target Database.

DbDeploy.net 2 - Database Deploy for .net

CodePlex — Tue, 03 Jan 2012 01:48:39 GMT

DbDeploy.Net 2 is a reimagining of DbDeploy.Net, which has atrophied.

Based on DbDeploy, the popular Java version, DbDeploy.Net 2 is written using modern .net technologies and provides support for MsBuild and command line execution.

This version also supports Sql Azure as a target for building a script.

Snippets Generator for SQL Server 2012

CodePlex — Mon, 12 Dec 2011 17:39:25 GMT

This tool allows you to create T-SQL snippets for SQL Server 2012 within minutes!

You just enter some meta-information, T-SQL code, and Snippets Generator generates the snippet in the form of an XML file that can be imported in SQL Server 2012 Management Studio (SSMS).

Then, the snippet can be used when writing T-SQL scripts within SSMS.

SQL Chart Add-in for SQL Server Management Studio

CodePlex — Fri, 09 Dec 2011 10:54:46 GMT

SQL Chart renders a chart from SQL data. Simply create a query that returns data in two columns. First column for X axis and second for Y.

SQL Server Inventory, Configuration Monitoring, and Logging Infrastructure

CodePlex — Sun, 04 Dec 2011 00:05:40 GMT

This project is designed to allow inventorying and configuration management of SQL Servers in your environment. Including SQL Server configurations, databases, database configurations, database file configurations. And more.

ScriptifyDB

CodePlex — Thu, 01 Dec 2011 09:39:09 GMT

ScriptifyDB is a Windows Forms utility designed for developers and dbadmins to generate database creation scripts for a growing number of databases. It's developed in .NET 4.0.

Visual Image Processing

CodePlex — Thu, 03 Nov 2011 06:12:15 GMT

Visual Image processing for 2d or 3d real-time video or still image from camera or web cam or scanner ...

LWB-DOTNET

CodePlex — Thu, 27 Oct 2011 12:26:10 GMT

This project contains ASP.NET Ajax support for the AJAX-Lightweight Binder.

SolutionManagementKit

CodePlex — Wed, 26 Oct 2011 18:44:37 GMT

SolutionManagementKit
This product will try to combine several monitoring / support tools available right now.
the primary focus will be on (T) SQL / MDX parsing for SQL 2008 R2 SSAS 2008 R2
as well as cube maintance

Development in C# / VB .NET

Developer Team Article System Management

CodePlex — Mon, 24 Oct 2011 12:19:50 GMT

Developer Team Article System Management Makes it easier for Authors to publish their articles .
It developed in VB.NET .

TomCdc

CodePlex — Sun, 23 Oct 2011 23:15:14 GMT

TomCdc is a solution which makes tracking of sql databse changes easy. Quick and simple installation process allows to start using the solution in just a few minutes. It supports all versions of Microsoft Sql server.
You'll no longer have to write triggers manually to find out what process is changing data in a table.

SQL floating point compare function

CodePlex — Fri, 21 Oct 2011 15:24:25 GMT

Comparison of floating point values in SQL Server not always gives the expected result.

With this function, comparison is only done on the first 15 significant digits.

Since SQL Server only garantees a precision of 15 digits for float datatypes, this is expected to be secure.

Profiler Repliator by SQLDair.com for SQL Server Performance Testing

CodePlex — Sat, 15 Oct 2011 22:14:55 GMT

I've developed a small application that will help you test the performance of you SQL engine. the application simply retrieve your Queries from a Pre-set Profiler table and start replicate this in multithreading mode with you set configuration to brute the destination database and you can get out of it of simple Log with all what happened to the database, or you can start your profiler on it and do your statistics. the application is very simple you choose the queries you want to run and how many Users, the think time and new user join every what interval. you have you go test your database.
Project homepage www.sqldair.com

BugNET Issue Tracker

CodePlex — Sun, 25 Sep 2011 03:00:02 GMT

BugNET is a free, open source issue tracking and project issue management solution for the ASP.NET platform. The main goals are to keep the codebase simple, well documented, easy to deploy and scalable.

The project has a clean look to it and is under active development.

This is a mature project which has been hosted on Sourceforge.net since 2006 but has now moved across to CodePlex.

LoBDb.NET

CodePlex — Fri, 23 Sep 2011 18:22:45 GMT

LobDB.NET provides a universal database API and a .NET wrapper for creating a database that is well suited for a line-of-business application.

Sql Server Management Studio - Connection Buttons Addin

CodePlex — Sun, 28 Aug 2011 11:08:22 GMT

Connection Buttons helps developers to connect any data source from SSMS quickly.

You set an BUTTON for a CONNECTION, then you connect it with a single click.

No login Screen !!!

An Addin for Sql Server Management Studio

SQL Parallel Boost

CodePlex — Mon, 22 Aug 2011 20:23:02 GMT

Compared to the single-thread approach of SQL Server itself, SQL Parallel Boost facilitates the parallel execution of any data modification operations (UPDATE, INSERT, DELETE) - making best use of all available CPU resources.
This results in performance gains of up to factor 10 (!), which is typically useful in data warehouse and ETL environments, or situations you're facing massive data modification operations.

SQL Parallel Boost is purely based on T-SQL. The built-in dispatching function automatically splits any statement into activities, which are the executed in parallel. The currently supported splitting rules are: even, or no split if count of rows affected is below a predefined threshold.

The parallel execution can be tuned thru job related priority settings. Potential deadlocking situations are handled automatically (retry) and the execution of queued (waiting) activities can be indirectly cancelled thru optional timeout values.

SQL Server Companion WPF

CodePlex — Sun, 21 Aug 2011 23:52:27 GMT

This is a little WPF application designed to help developers script database objects easily and quickly during the early development stages.

For example, it allows you to quickly generate a script that drops and recreates all foreign keys on a db so that you can populate tables with data without getting referential integrity errors.

This application is also a sample C# WPF MVVM application for new developers to use as part of the learning process.

This project uses the Cinch v2 framework created by Sacha Barber. Thanks for a rich and easy to implement framework.

SQL Server Database Maintenance API

CodePlex — Wed, 17 Aug 2011 13:04:50 GMT

SQL Server Database Maintenance API in versions 2000, 2005, 2008 and 2008R2.

SQL Server DB & SSIS Powershell Deployment

CodePlex — Fri, 12 Aug 2011 18:14:41 GMT

A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

Eye on SQL - Load Test

CodePlex — Tue, 02 Aug 2011 11:16:50 GMT

Eye on SQL - Load Test is a tool designed for volume tests against SQL Server.

Technologies Speak Themselves

CodePlex — Tue, 12 Jul 2011 11:09:19 GMT

Technologies Speak Themselves is a DotNet Developers Content and Technical News Grabber site.

Stored Procedure Caller

CodePlex — Sun, 10 Jul 2011 12:50:40 GMT

A small C# library to assist ADO.NET developer to call SQL Server stored procedures with minimal effort.

Sql Server Column Finder

CodePlex — Wed, 06 Jul 2011 10:10:24 GMT

Have you ever been confronted with a huge existing database and you need to know about the data fields without reading documentation (if they exist!). This couple of line StoredProcedure will help you to do just that. Search for field names and find out in which table they are.

DbViewSharp

CodePlex — Fri, 01 Jul 2011 20:43:02 GMT

DbViewSharp is a Winforms program designed for developers to explore a SQL server database. It scores over SQL management studio in these four ways: 1. It's faster 2. No tree controls; 3. Searching is on partial text match; 4. Displays a row count for every table in the database.

SQLBK; una solucion para respaldos de SQL Server. (SQL Server backups)

CodePlex — Tue, 21 Jun 2011 17:12:40 GMT

SQLBk es una aplicacion basada en .NET Framework 2.0 que permite realizar respaldos 'Full' de una base de datos de SQL Server, comprimirla y opcionalmente enviarla a un servidor FTP. En la proxima actualizacion se espera agregar respaldos diferenciales, multiples bases de datos y encriptacion.

SQLBk is a VB .NET application that allows 'Full' backup of a database on SQL Server, compress and optionally sent to an FTP server. In the next update is expected to add differential backups, multiple databases and encryption.

SQL Server Replication Explorer

CodePlex — Thu, 16 Jun 2011 19:43:48 GMT

SQL Server Replication Explorer is a client tool for browsing through Microsoft SQL Server replication topology. It can also be used for troubleshooting and monitoring of the Microsoft SQL Server replication.

SQLDeploy.Net

CodePlex — Sun, 12 Jun 2011 11:15:21 GMT

SQLDeploy.Net is a utility to deploy [run] a set of SQL Scripts on SQL Server. The utility can be integrated with any deployment manager like Marimba , Hudson etc to automate database deployment.

The project is developed on .Net Framework 4.0 but it is equally backward compatible.

For a list of known issues and enhancements which are being worked upon, refer to Issue Tracker.

Analysis Services Helper - SSMS Addin

CodePlex — Tue, 24 May 2011 16:05:15 GMT

The Analysis Services Helper is an add-in for SQL Server Management Studio that helps users with repetitive tasks involved with Analysis Services such as processing and deployment. It's developed in C# .Net 2.0, and tested with SSMS 2008 R2.

BCP2SQLAzure: Free tool to import/export data between SQL Azure and SQL Server

CodePlex — Wed, 18 May 2011 16:03:31 GMT

SQL Azure BCP makes it easier for database admins and developers, to do bulk copy loads into SQL Azure. This bcp replacement allows you to define each load using an easily XML file.
It´s developed using C#.

Medical Friend ICD-10 EMR

CodePlex — Thu, 12 May 2011 04:47:22 GMT

Medical Friend is an Open Source version of an EMR/HIS system based on SQL Server 2008. This system is intended to improve Diabetic treatment.
Medical Friend intends to be a Meaningful Use certified EMR eventually with: a Medical Repository DW, Claims Processing system, CMS file loader system, and finally an ICD-10 EMR Scheduling system. This project was created by Diabetics for Diabetics.

DataScripter

CodePlex — Mon, 09 May 2011 19:00:32 GMT

Browse your data and optionally script it - the smart way.

SQL Server Backup

CodePlex — Wed, 27 Apr 2011 13:22:52 GMT

SqlAdmin Backup makes it easier to created and maintain database backups in a organisation with several installations.
The database backups are standarzied to help quick and safe administration and recovery.
This tool is developed in C# using ADO.NET with prototyping in PowerShell.

Fox Migrator

CodePlex — Tue, 19 Apr 2011 17:33:59 GMT

If you are suffering with the data extraction from old FoxPro tables Fox migrator is a solution to take foxpro tables to Oracle or Sql server databases, developed in C# using VS2010.

SQL Server Blocked Process Report Viewer

CodePlex — Mon, 18 Apr 2011 15:16:27 GMT

SQL Server's tracing tools generate blocked process reports to give more information about potential concurrency problems on a database server. But they are difficult to read. SQL Server Blocked Process Report Viewer organizes and presents this information in a useful way.

Connection String Generator

CodePlex — Tue, 12 Apr 2011 21:09:10 GMT

Project to Create a Connection String using SQL Server.
This will be enhanced to make connection string using Access, Oracel, MySQL, and DB2

Application Updater

CodePlex — Sun, 10 Apr 2011 23:38:01 GMT

Application updater allows .NET developers to include automatic update feature to their projects.
Now updates from file system or MS SQL server are supported.
It written in C# and runs under .NET Framework 2.0.

Tags: SQL server,application, updater, automatic.

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

CodePlex — Sun, 10 Apr 2011 22:32:29 GMT

SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

Script SQL Server Configuration

CodePlex — Mon, 04 Apr 2011 23:40:09 GMT

Script SQL Server configuration information in a format suitable for DR purposes or checking into a source control system.

Opus Suite

CodePlex — Mon, 04 Apr 2011 13:14:00 GMT

Owner/Occupier Property Management software for the commercial and residential rental markets using the ASP.NET MVC platform.

dotSqlCopy

CodePlex — Wed, 30 Mar 2011 22:22:58 GMT

dotSqlCopy a été créé par Davyd REY au départ pour des besoins professionnels puis personnelles.Cet outil permet déjà de réaliser le minimum requis en ce qui concerne la copie intégrale de tables de données d'une base de données SQL server vers une autre base de donnée Sql Server

SQL Azure Agent

CodePlex — Tue, 29 Mar 2011 20:32:27 GMT

Proof of concept project to show how you can achieve SQL Server Agent like functionality for Sql Azure

StringHelper SQL Server CLR

CodePlex — Thu, 24 Mar 2011 02:42:43 GMT

StringHelper SQL Server CLR provides a collection of CLR stored procedures and functions useful for manipulating and interacting with string data. Using these stored procedures and functions will allow you to bring the flexibility of .NET into the database.

SQLCLR File Functions

CodePlex — Wed, 23 Mar 2011 07:29:53 GMT

File Functions for SQL. Implemented as a SQLCLR assembly. Compatible with SQL 2008 and SQL 2008R2. May be compatible with SQL 2005, but untested.

Copy File, Delete File, Delete Files, Get File Specs, Make Directory, Move File, Save File Image, Get File Image, and more!

anito.NET - Object Relational Mapping Framework

CodePlex — Wed, 16 Mar 2011 01:45:46 GMT

Anito.net is an under development, simple, open source Object Relational Mapping framework for .Net that aims to speed up database-driven development through reusable patterns and database independent solutions. Supported database MS-SQL, MySQL, SQLite and MongoDB

SQL Script Executer

CodePlex — Fri, 11 Mar 2011 18:28:38 GMT

SQL Executer makes it easy to deploy, execute multiple scripts on SQL Server as you could do in VS 2008. In Visual Studio 2008's Database Project, one had an option to select multiple sql files and Run them on choosen DB. Visual Studio 2010, doesn't come with this functionality.

Microsoft All-In-One Video Framework

CodePlex — Sun, 20 Feb 2011 10:44:13 GMT

Learn your Technology by video.

SQL Script to Create a Website Directory

CodePlex — Fri, 18 Feb 2011 16:26:54 GMT

Here you can download sql script to create a website directory using SQL Server.

* This is only the easy directory sql script to develop your website.

Directory software may publish in future.

Marbles CMS

CodePlex — Mon, 14 Feb 2011 10:22:16 GMT

Marbles aims to be a simple Content Management Server for hosting multiple websites.

SQL Space Map

CodePlex — Sat, 05 Feb 2011 20:48:29 GMT

SQL Space Map is a tool that lets you quickly and easily view the relative size of database objects on a map, so you can compare them visually. It helps identify large objects, objects with a high index/data ratio, and tables which may be growing more quickly than expected.

NGinn.BPM

CodePlex — Tue, 01 Feb 2011 12:27:49 GMT

NGinn.BPM - a BPM / Workflow engine for Microsoft.Net

It's a lightweight workflow manager based on Petri nets and taking some ideas from BPMN. NGinn BPM helps automate business processes in large organizations, such as telecoms, by enabling to build workflows that coordinate human work and flow of data between applications. The main goals of NGInn design are elasticity, simplicity and ease of integration.

It's a permanent work in progress project with some production deployments. Developed mainly in C# and using MS SQL as a database backend.

Related projects:

nginn-messagebus - [url:http://code.google.com/p/nginn-messagebus] - publish-subscribe message bus based on SQL Server
nginn-exchange - [url:http://code.google.com/p/nginn-exchange] - MS Exchange integration framework

HelloWorld

CodePlex — Tue, 25 Jan 2011 15:39:02 GMT

As a sample center, HelloWorld sketches the skeletons of most Microsoft development techniques. Each sample is elaborately selected, composed, and documented to demonstrate one frequently-asked/tested/used scenario based on my experience as a support engineer.

DelNet

CodePlex — Mon, 24 Jan 2011 00:40:17 GMT

Tool created in C # to automate the development process.

With this tool, you do not need to spend time with the creation of classes of connection, data access layer, view or update data with Windows Forms.

Everything is here, ready.

ClomibepASP

CodePlex — Mon, 17 Jan 2011 09:26:13 GMT

PL: Zaawansowany system zarządzania treścią ClomibepASP.
EN: Advenced content managment system ClomibepASP.

NetReports

CodePlex — Thu, 13 Jan 2011 11:17:19 GMT

NetReport is a free open-source project to create either reports

Entity Visualizer

CodePlex — Sun, 26 Dec 2010 14:53:27 GMT

Entity Framework Debugger Visualizer to display SQL source code generated by Entity Framework.

Data Access Engine (DAE)

CodePlex — Fri, 17 Dec 2010 03:58:20 GMT

Data Access Engine (DAE) is an open source and free .NET component to access all popular DBMSs such as Microsoft SQL Server, MySQL, Oracle, Microsoft Access, SQLite and databases that connected by ODBC. DAE helps to connect different DBMSs at the same time.

SqlExecuter

CodePlex — Wed, 15 Dec 2010 18:30:36 GMT

Simply run sql scripts against a SQL Server database

SSIS Reporting Pack

CodePlex — Sat, 11 Dec 2010 16:34:18 GMT

A suite of SQL Server Reporting Services reports that operate over the SSIS catalog in SQL Server code-named Denali

EasyMapping

CodePlex — Sat, 11 Dec 2010 05:47:24 GMT

EasyMapping makes OR Mapping Configuration easy, writing code easy

The first version only support SQLSever
Framework version: 3.5
Language: C#

NARDAX

CodePlex — Mon, 29 Nov 2010 03:34:52 GMT

A collection of usefull API's and extensions that have been built out of necessity.

Azure Table Sync Lib

CodePlex — Mon, 22 Nov 2010 13:20:14 GMT

Developing custom sync providers for Windows Azure Table Storage to support the following sync scenarios

1. Azure Table <-> SQL Server
2. Azure Table <-> SQL CE
3. Azure Table <-> SQL Azure

SQL Monitor - managing sql server performance

CodePlex — Thu, 18 Nov 2010 20:49:01 GMT

monitor sql server processes and jobs, analyze performance, analyse system, object version control, view executing sql query, kill process / job, object explorer,

SQL Schema Sync API

CodePlex — Thu, 11 Nov 2010 09:10:50 GMT

SQL Schema Sync API offers a new approach to DB structure synchronization since this component is integrated into your program. The product is run time royalty free. Full source code is available. A library is developed for SQL Server 2008.

Database Schema Reader

CodePlex — Mon, 01 Nov 2010 09:31:03 GMT

A simple, cross-database facade over .Net 2.0 DbProviderFactories to read database metadata.

SQL Server Separation of Duties Framework

CodePlex — Sat, 30 Oct 2010 15:51:39 GMT

Implement to provide a means for the DBA to execute processes which require elevated privileges. Solution is used when organizations dictate that a DBA does not have sysadmin privileges.

SauceDB

CodePlex — Sat, 09 Oct 2010 03:25:10 GMT

Database access that just works

EdgeStatz

CodePlex — Mon, 06 Sep 2010 11:49:26 GMT

EdgeStatz is a statistics and club management software tool for sports clubs (Currently Cricket only).

This is a desktop application using .Net 3.5 SP1 as well as .Net 4.0 Report Viewer.
The application requires a Microsoft Sql Database server to operate.

Infopath XSD to SQL Server Table

CodePlex — Fri, 03 Sep 2010 23:22:16 GMT

Ixsd2db makes it easier for infopath developers to create database tables from infopath xsd file. Its developed in C#.

This tool does not support child groups at this time. But that is something we are looking to have it in future.

Really Simple Data Dictionary

CodePlex — Thu, 26 Aug 2010 14:49:31 GMT

Really Simple Data Dictionary (RSDD) is a meta data collector for SQL Server and Oracle. Developed in PowerShell, RSDD imports meta data into a central SQL Server repository from the INFORMATION_SCHEMA or equivalent supported systems views.

SQL Server History Cleanup

CodePlex — Tue, 24 Aug 2010 21:09:17 GMT

Clean up backup history, job history and maintenance plan history without using a maintenance plan.
The functionality is similar to the History Cleanup Task in a maintenance plan.

SqlResource

CodePlex — Fri, 13 Aug 2010 07:18:53 GMT

The System.Resources.SqlResource namespace provides classes and interfaces that allow developers to create, store, and manage, in SQL Server (2000-2005),
various culture-specific resources used in an web application. Support caching with auto-refresh.

Consumer Direction Module (CDM)

CodePlex — Tue, 10 Aug 2010 19:58:22 GMT

A web-based management information system designed specifically for participant-directed long-term care programs. The CDM creates system-wide efficiencies, quality, and cost savings by integrating information sharing, planning tools, and reporting in a highly configurable tool.

SQL Bandwidth Meter Log Parser

CodePlex — Mon, 09 Aug 2010 23:15:40 GMT

Parses the log files created by the Hosts Tools SQL Bandwidth Meter application

SSIS Custom Task BewiseSmartIndexManager

CodePlex — Mon, 09 Aug 2010 08:37:16 GMT

This project show an Maintenance Task which is availaible in Control Flow into SSIS Package.

sp_CascadingDataViewer

CodePlex — Mon, 02 Aug 2010 22:42:40 GMT

sp_CascadingDataViewer is a stored procedure enables the user to find all data that is dependant on a given set of rows in a given table in a given database.
It traverses the database's foreign keys to find that dependant data.
It is written in T-SQL and works on SQL Server 2008.

Mozess CMS (Pre-alpha)

CodePlex — Mon, 26 Jul 2010 02:29:53 GMT

Mozess CMS is an open source ASP.NET based web application for managing data and content within your website. Mozess is backed by .NET 2.0/3.5, C# and based on patterns from many highly used CMS suites.

Stormy - Micro ORM in C#

CodePlex — Sun, 25 Jul 2010 21:13:04 GMT

Stormy is a powerful Micro ORM (object relational mapping) for C# in 327 lines of code

Stored Procedures Generator - Rabbit.SPGen

CodePlex — Sun, 18 Jul 2010 09:50:50 GMT

Rabbit.SPGen

tChat - ASP.NET, Ajax & Web Service based Chat Room

CodePlex — Thu, 10 Jun 2010 19:24:35 GMT

Simple chat room application. Technology: ASP .NET, Ajax, Web Services and MS SQL Server Database. Uses ASP .NET authentication mechanism.

SQL Server Compact Toolbox

CodePlex — Fri, 04 Jun 2010 11:55:12 GMT

SQL Server Compact Toolbox is a Visual Studio 2010 Pro or higher add-in (for 3.5/4.0) and standalone app (for 4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to your SQL Server Compact Data Connections in VS Server Explorer.

SQL Server and SQL Azure Shard Library

CodePlex — Tue, 01 Jun 2010 03:46:54 GMT

This library provides a Shard technology that allows you to spread the load of database queries over multiple databases easily (SQL Server and SQL Azure). Uses the Task Parallel Library (TPL) and caching for high performance.