List of Free code SQLServer
Analysis Services Helper - SSMS Addin
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.
Analysis Services Stored Procedure Project
A set of stored procedures for Microsoft SQL Server Analysis Services.
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.
AppTrans4 for MS SQL Server 2012 Express
Business Intelligence LAB
Business Intelligence LAB is a Microsoft Business Intelligence Framework that is developped based on real life needs.
This repository hosts a set of development done upon SQL Server Business Intelligence Stack.
This covers :
- Data Access
- Sample Cube
- Sample OLAP Viewer
CEQuery is usefull for managing SQL Server CE databases. It is developed in C# and supports SQL Server CE 3.5 and 4.0.
Class Builder Wizard
Class Builder Wizard is a Microsoft Visual Studio wizard that generates data object classes and a full data layer implementation for database objects (MS SQL Server and others). It can also be used to quickly create custom classes (not necessarily based on a database object) b...
Connect to your SQL Server database easily, efficiently, writing minimal code.
Data Dictionary Creator
Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.
Data Tier Generator
Generates SQL Server scripts for stored procedures and C# classes used to access those stored procedures.
Windows application for managing SQL Server databases.
This beta version of Visual Studio extension helps people generate an entire sql server database from a dataset
DAX Editor for SQL Server
The DAX Editor for SQL Server an extension to Visual Studio 2010 that implements a language service for the DAX language. The DAX language is the expression languaged used for SQL Server Analysis Services tabular models. This extension can be used when editing DAX queries and ...
DbDiff: Database Diff and Database Scripting
Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali )
- compare database structures
- scripting without dmo or smo
- commandline scripting, commandline compare
- standalone dll-s for referencing
DBScripter - Library for scripting SQL Server database objects
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 a...
Directory service with DSML 2.0 support for MSSQL 2008+
LDS is simple DS (directory service) created on top of MSSQLServer 2008+. It uses DSML v 2.0 as communication interface.
Document MSSql Schema As XML
Extracts the schema of a Microsoft Sql Server database into XML files. There will be one XML file per table, view, procedure, etc.
ExceptionMessageBox is development of messagebox to show exception detail in your app like .NET unhandled exception dialog. More and better features and view, similar to Microsoft.ExceptionMessageBox from SQL Server, shall be added by contributors. This is developed in C# WPF.
ExpressProfiler is a simple but good enough replacement for SQL Server Profiler.
Can be used with 2005/2008/2008r2/2012/LocalDb, either express or standard
Eye on SQL - Load Test
Eye on SQL - Load Test is a tool designed for volume tests against SQL Server.
Fast Data Access Library for SQL Server
FDAL is a data access layer generator that maps your stored procedures to C# functions.
File Properties Task
Retrieves and optionally sets properties on a file in the SQL Server Integration Services Control Flow. Available properties include file existence, size, read/write locks, creation/last access/last modification date, and file attributes.
FileSystemHelper SQL Server CLR
FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.
Fotia SQLCLR Library
The Fotia SQLCLR library contains indispensable SQL Server 2008 user-defined functions and aggregates written in C#.
sport club web site based on c# and mssql
GPS Tracker for Windows Mobile
Project Description: GPS Tracker is using Windows Mobile 5.0 device (PDA) for collecting GPS data. PDA sends GPS coordinates using Web services to server and saves data to SQL Server 2005. GPS Data can be visualized as new layer on Virtual Earth. Application can be used for ex...
Internals Viewer (updated) for SQL Server 2008 R2.
Internals viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
All sorts of tasks performed by a DBA or developer can benefit greatly from knowledge of what the storage engine is doing and how it ...
Internals Viewer for SQL Server
Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
All sorts of tasks performed by a DBA or developer can benefit greatly from knowledge of what the storage engine is doing and how it works
Kona Framework - OLAP/Analysis Services for the .Net Developer
The Kona Framework is a .Net 3.5 library that was created to make it easier for the .Net developer to build applications that use SQL Server Analysis Services. It is being developed to improve upon the ADOMD Client library, adding support for Connection Pooling and adding a ...
Libro "SQL Server 2012 - Guida all'uso"
Databases and examples for my Italian book on "SQL Server 2012 - Guida all'uso"
Magelia WebStore Open-source Ecommerce software
Magelia WebStore is a customizable, multilingual and multi-currency open-source e-commerce software for the .net environment.
WebStore was developped C# and Aspx and only requires an SQL Server Express.
Managed Services Engine
This site contains code and content related to the Managed Services Engine, a solution that supports service virtualization through a meta data-driven service repository using .NET and Microsoft SQL Server.
Microsoft SQL Server Community & Samples
CodePlex is the project hosting site for Microsoft SQL Server Samples and Community Projects. Projects listed here are official Microsoft samples for SQL Server (released with Service Packs or major releases of SQL Server) and applications developed by MVPs, and the SQL Server co
Microsoft SQL Server Community Samples: Analysis Services
This project contains SQL Server Analysis Services samples contributed by Microsoft outside of the regular release cycle, MVPs, and other members of the community.
Microsoft SQL Server Community Samples: Integration Services
Samples for use with SQL Server Integration Services samples created by the Integration Services product team.
Microsoft SQL Server Product Samples: Analysis Services
This project contains Analysis Services samples released with Microsoft SQL Server product.
Microsoft SQL Server Product Samples: Data Programming
This project contains Data Programming samples released with Microsoft SQL Server product.
Microsoft SQL Server Product Samples: Integration Services
This project contains Integration Services samples released with Microsoft SQL Server product.
Microsoft SQL Server Product Samples: Service Broker
This project contains Reporting Services samples released with Microsoft SQL Server product.
MSSQL Compressed Backup
SQL Server Compressed Backup is a command line utility for backing up and restoring SQL Server 2005+ with compression(zip,bzip2,gzip,lz4) and encryption(AES).
MSSQL Deployment Tool
It is a utility based on MSSQL Server, to make deployment more easily and fully control with Version Management & Configuration & Deployment Tracking.
NQueue provides an enterprise level work scheduling and execution framework and toolset that contains no single point of failure. Using a farm of servers and a clustered SQL server backend, multiple NQueue windows services compete to evaluate configured schedules and execute work
Online Quiz using .Net 4.0 and Sql server
This is an online quiz developed using c# and .net 4.0. This is a simple application using parametrised SQL queries and web forms.
Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008.
It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.
Pauses a SQL Server Integration Services Control Flow for a specified number of milliseconds, or until a specific time of day.
Pssdiag and Sqldiag Manager
This Pssdiag/Sqldiag manager is commonly used by Microsoft CSS SQL support to troubleshoot various SQL issues particular SQL Server performance issues. It provides data collection for SQL Server 2005, 2008 and 2008 R2.
RSA ID Validation for SQL Server
Solution for validating South African identity numbers.
Provides SQL Server CLR bindings which allow identity numbers to be efficiently validated within T-SQL
RS Utility is a C# application that interacts with a SQL Server Reporting Services (SSRS) web service to manage items on a report server.
ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database. It will work against any SQL Server 2000 or 2005 database. It creates a directory tree structure with a similar hierarchy to that in Object Explorer i...
Scriptio - A SQL Server Object Scripting Utility
A utility for generating object scripts for Microsoft SQL Server. It is specifically designed to script DROPs and CREATEs in the same script.
Simples Reports is a web-based .Net query tool for querying SQL server databases.
This tool is intended for end-user with no SQL programming experience and is intended to be a drag-drop/point-click interface.
It's developed in C# utilizing .Net 4 and Visual Studio 2010.
A handy application for viewing spatial data for use with SQL Server 2008.
Its is very difficult to visualise a Spatial shape from a set of points, this application allows you to do that very easily.
This is a windows forms application that allows you to draw shapes and obt...
SQL 2005 Service Manager
Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related ...
SQL Chart Add-in for SQL Server Management Studio
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 Compact Bulk Insert Library
.NET Library for loading data fast (doing bulk inserts) into a SQL Server Compact database file. Attempts to mimic the SQLClient SqlBulkCopy API.
SQL Compact Command Line Tool
Administer SQL Compact databases directly from the command line, without having Visual Studio or SQL Server Management Studio installed. Only requires NetFx 2.0 and SQL Compact installed. Command line options similar to sqlcmd. Also runs any SQL Compact script files.
SQL Compact data and schema script utility
This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.
SQL Compact Query Analyzer
SQL Server Compact Edition Database Query Analyzer
SQL Database to Script Generator
Generate individual script for procedures, functions, triggers, views etc from SQL Server Database
SQL DB Administrator
Web based administrator for SQL Server 2005.
Sql Express automated incremental backup/restore and shipping logs
It is sometimes difficult to manage incremental backups and restore for Sql Server Express Edition 2005 as the log shipping feature is available starting from the standard edition.
This command line program, when runs via windows scheduler creates periodic full backups, trans...
SQL Fault Retry Provider
The Fault Retry sample demonstrates recommended practices for creating high availability database applications using SQL Server mirroring technology in the back end.
SQL Load Generator
SQL Load Generator is used to run multiple concurrent queries against SQL Server. The user can choose the number of concurrent queries to run, provide different queries, choose SQL or domain accounts, and provide application name settings. SLG was developed using C# 3.5.
SQL Max Memory Calculator
This CodePlex project is a simple forms application that will allow you to easily calculate the maximum SQL Server memory according to MS best practices
SQL Nexus Tool
What is SQL Nexus?
SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
SQL PraRup - Free Tool for Auto Formating/Indenting SQL Server Database Objects
Features SQL PraRup
>>Auto Formatting/Indents all objects at Once
>>Custom Stored Procedure Formatting/Indentation
>>Multiple Stored Procedure Indentation
SQL Server Blocked Process Monitor
The SQL Server Blocked Process Monitor makes monitoring, tracking and troubleshooting blocking inside SQL Server 2005 and SQL Server 2008 easy. You'll no longer have to manually enable and run a trace to capture the blocked process report. It is developed in C#.
SQL Server Compact Toolbox
SQL Server Compact Toolbox is a Visual Studio add-in and standalone app , for managing all aspects of your SQL Server Compact database files
SQL Server Compression Estimator
SQL Server Compression Estimator makes it easier for DBA's to estimate the value of compression on objects in their database. You will no longer have to manually calculate comression savings. This tool is developed in C#.
Sql Server Database Backup Utility
This application is designed to help automate the backup of Sql Server Databases to the local file system. Written in C#, the Sql Server SMO class library is leveraged to perform a full backup each time the application is run. Optionally, backups an be archived in a zip file.
SQL Server Database Copy Tool
Simple tool to copy databases from one SQL Server to another.
SQL Server Dump
SQL Server Dump (sqlserverdump) is a command line utility inspired by mysqldump. It allows to dump SQL Server databases and their content as SQL statements. It's developped in C#.
SQL Server Extended Properties Quick Editor
SQL Server quick editor for extended properties, as descriptions and more.
SQL Server Health & History (SQLH2)
This is SQLH2 project which was originally published on Microsoft.com in 2004. The code published here was slightly modified from the latest version available for download at Microsoft.com.
SQL Server Metadata Toolkit 2008
SQL Server Metadata Toolkit
MSDN's SQL 2005 tool kit updated to 2008 for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.
SQL Server S3 Backup
SQL Server command line backup tool that will perform full, differential and transaction log backups, zip them up and then upload to an Amazon S3 bucket.
SQL Server Script Kit
The objective of this project is to maintain a myriad of SQL Server scripts related to SQL Server features, sample demonstrations, inner workings and useful scripts. When analyzing the scripts I expect you to better understand how the product works and learn about the new feat...
SQL Server Spatial Tools
This project is a collection of tools for use with the spatial types that are new to SQL Server 2008. This project does not provide an end-user application, but rather a set of reusable functions which applications can make use of.
These functions may include data conversion...
SQL Server Stored Procedure best practices
This SQL Server stored procedure best practice guide contains documentations of best practices and helper tools to enhance further match with the best practices.
SQL Server To KML
SQLServerToKml is a library that can be used to create KML documents from SQL Server 2008 geography data type instances. The KML documents can be used with Google Maps or Bing Maps.
SQL Server Web Tools
SQL Server Web Tools is a Web-based Administration tool to manage SQL Server databases. With SSWT, you can administer accounts, manage databases and tables, write and run queries and Stored Procedures, and much more.
SQL Service Broker Management Studio
Service Broker is part of the SQL Server 2005 Database Engine, includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications. The current version of the management st...
SQL Sprocket is a template-based code generating tool for SQL Server 2005, 2008 R2, and 2012. Generate stored procs, objects, and TSQL code in minutes.
A very basic SQL Server tracer, like SQL Profiler, handy when SQL Profiler is not available.
SQL To ASPX Code Generator for C# or VB
Generate ASPX websites with C# or VB in minutes using a SQL Server database. Provides maximum versatility, hundreds of generation options, with minimum effort.
consolidate data from many Sql Servers databases.
It's developed in C#
SQL Server library, a collection of useful/missing features.
Interesting and useful Addins for SQL Server Management Studio 2005 and 2008.
SSMS Executor - Execute Current Statement
SQL Server Management Studio 2012 Add-in.
SSMS execute current statement base on the cursor position.
This windows application allows you to manage Microsoft Reporting Service instance. Currently supporting SQL Server 2000, 2005, 2008, 2008R2 (only Native Mode).
SSRS Subscription Manager
This utility allows you to re-execute subscriptions in Microsoft SQL Server Reporting Services
Commandline tool which u can use to deploy your reports, resources, folders and datasources to
SQL Server Reporting Services (currently only tested with SQL Server Reporting Services 2005).
StressTester is a client-server application to stress test SQL Server Analysis Services.
SyncData for SQL Server
Synchronizes the data contained in two or more database tables with the same structure, generating insert, update and delete instructions that allows that the target and source table have the same data.
Test Data Generator
This project aims at creating huge volume of test data for MSDE,SQL SERVER 2000, SQL SERVER 2005. The project currently supports the above databases and can create the specified number of rows for any table , keeping in mind the foreign key relation ship. The tool can be helpf...
This project is designed to implement the multy-functional explorer-navigator based on the tree-view which simulate the structure and main parts of the University and it's activities.
The project is based on flexible 3 tiers arhitecture.
DataBase Layer-InterObject, SQLServer
Venatek SQL Server File Archive - Watched Folder Saves Files to Database
One or more watched folders are defined. Each folder is given a category. A Windows service watches the folders. When a file is dropped into a folder, the system inserts it into a SQL Server table. Admin is done via a Windows forms app written using Developer Express controls. C#
* Ein einfacher Dienstplaner mit dem Personen und Dienste in einem Monatsplan eingeteilt werden k?nnen.
* Komplet geschrieben in C# mit Visual Studio 2010.
* Ben?tigt MSSQL Server 2005 oder h?her (Express Edition reicht).
Windows Service Monitor
Windows service monitor is a little utility represented by icon in a windows system tray. The icon has different colors based on status of monitored windows services. You can monitor start / stop any windows services e.g sqlserver. This program is simplified version of service...
Zen4Sync, Orchestration and Test Load platform for SQL Server Merge Replication
This project is all about providing a orchestration and test load platform able to validate any SQL Server Merge Replication based Architecture.