MSDN Code Gallery Published Resources For Tag SQL Server

All-In-One Code Framework (A Sample Code Project)

MSDN Code Gallery — Tue, 05 Jan 2010 06:18:22 GMT

Microsoft All-In-One Code Framework delineates the framework and skeleton of Microsoft development techniques through typical sample codes in three popular programming languages (Visual C#, VB.NET, Visual C++). Each sample is elaborately selected, composed, and documented to demonstrate one frequently-asked, tested or used coding scenario based on our support experience in MSDN newsgroups and forums. If you are a software developer, you can fill the skeleton with blood, muscle and soul. If you are a software tester or a support engineer like us, you may extend the sample codes a little to fit your specific test scenario or refer your customer to this project if the customer's question coincides with what we collected.

sp_ExecuteSql parser

MSDN Code Gallery — Wed, 02 Dec 2009 10:15:02 GMT

A console application that converts a SQL request from a call to sp_executeSql to the unparametrised SQL, which can be used with the Database Tuning Advisor, or to show the Estimated Executation Plan

Windows Management Instrumentation (WMI) Models

MSDN Code Gallery — Tue, 17 Nov 2009 17:28:21 GMT

Windows Management Instrumentation (WMI), as described in the WMI documentation on MSDN (http://msdn.microsoft.com/en-us/library/aa394582(VS.85).aspx), is the infrastructure for management data and operations on Windows-based operating systems. It is the Microsoft implementation of Web-based Enterprise Management (WBEM), an industry initiative to develop a standard technology for accessing management information in an enterprise environment. WMI uses the Common Information Model (CIM) industry standard to represent systems, applications, networks, devices, and other managed components. CIM is developed and maintained by the Distributed Management Task Force (DMTF--see http://go.microsoft.com/fwlink/?LinkId=67786).

This sample demonstrates the expression of WMI through models written in the Microsoft code name "M" modeling language. WMI was chosen for this collection of sample models (which includes types and extents) because it contains a rich hierarchy of relationships, rooted in the CIM_PhysicalElement and Win32_PhysicalMemoryLocation models

SQL Server Modeling CTP Samples

MSDN Code Gallery — Tue, 17 Nov 2009 17:28:21 GMT

These are samples that have been produced for the SQL Server Modeling CTP (formerly code name "Oslo") as well as its individuals technologies (the code name "M" modeling language, the code name "Quadrant" tool, and SQL Server Modeling Services).

Sample Model Data for Microsoft code name "Quadrant"

MSDN Code Gallery — Tue, 17 Nov 2009 17:28:17 GMT

This resource contains sample model schemas, instance data and configurations for use with Microsoft code name "Quadrant".

The schema and instance data are supplied in a Microsoft code name "M" project (Microsoft.Quadrant.Samples.Data.csproj) and contains the following:

a. Microsoft.Samples.Organization: a sample domain that models an organization with People, Tasks & Requirements, and Events. Once the samples are installed, this domain is found under Database > Microsoft.Samples.Organization in the "Repository" Explorer.

b. Microsoft.Samples.Process: a sample domain that models processes for an organization. Once the samples are installed, this domain is found under "Database" in the “Repository” Explorer.

c. Microsoft.Samples.Infrastructure: a sample domain that models data centers, server clusters, and computers. Once the samples are installed, this domain is also found under "Database" in the “Quadrant” Repository.

The configuration for this data is supplied in a Microsoft code name "M" project (Microsoft.Quadrant.Samples.Views.csproj).

Sample Grammar: Wix

MSDN Code Gallery — Tue, 17 Nov 2009 17:28:14 GMT

In this sample, the file wix.mg contains the grammar for the Windows Installer XML language, known as Wix ("wicks"). Wix itself is a free software toolset from Microsoft that builds Windows Installer (MSI) packages from an XML document. Wix was the first software released by Microsoft under an its Common Public License. For details on Wix, see http://sourceforge.net/projects/wix/.

The grammar file in this sample is primarily provided to demonstrate how to express a complex language like Wix in "M". A more complete sample that uses this grammar to create MSI packages without writing XML will be released in the future.

Sample Grammar: Song

MSDN Code Gallery — Tue, 17 Nov 2009 17:28:11 GMT

In this sample, the file Song.mg contains the grammar for a language called "Song", a simple means of describing basic musical notation.

Once compiled, it can be used to process an input text file written in the "Song" language using the mgx.exe command-line utility. For details, see Using "M" Tools for Creating Languages in the MSDN Library at http://msdnstage.redmond.corp.microsoft.com/en-us/library/dd857692(VS.85).aspx.

This sample also includes a small C# console application that demonstrates dynamic parsing and execution of "Song" language code using Console.Beep.

Sample Grammar: "A"

MSDN Code Gallery — Tue, 17 Nov 2009 17:28:06 GMT

In this sample, the file a.mg contains the grammar for "A", a simple Visual Basic-like language for composing model-view-controller applications from existing models and controllers.

Once compiled, it can be used to process an input text file written in the "A" language using the mgx.exe command-line utility. For details, see Using "M" Tools for Creating Languages in the MSDN Library at http://msdnstage.redmond.corp.microsoft.com/en-us/library/dd857692(VS.85).aspx.

Sample Assemblies and XMI files for "DinnerNow"

MSDN Code Gallery — Tue, 17 Nov 2009 17:27:59 GMT

These files provide sample data for the following MSDN Library topics:

Walkthrough: Using the System_Runtime Domain (http://msdn.microsoft.com/en-us/library/ee713228(VS.85).aspx)

Walkthrough: Using the Microsoft.Uml2 Domain (http://msdn.microsoft.com/en-us/library/ee730897(VS.85).aspx)

Sample "M" Models: Enumerations, Queries, and Relationships

MSDN Code Gallery — Tue, 17 Nov 2009 17:27:58 GMT

The three sets of sample models available here each demonstrate how to express certain concepts in the code name "M" modeling language:

1. Enumerations: demonstrates how to express open and closed enumerations.

2. Queries: demonstrates many different queries; the sample contains 100 individual files, each containing a specific query.

3. Relationships: demonstrates how to express the four types of relationships: one-to-one, one-to-many, many-to-one, and many-to-many.

RouterManager for WCF in .NET 4 using SQL Server Modeling CTP

MSDN Code Gallery — Tue, 17 Nov 2009 17:27:57 GMT

RouterManager is a domain-specific language and runtime that allows you to program the rules for the .NET 4 WCF content-based routing service using an easy to understand language. The routing rules (Filters) are stored in a database (such as the SQL Server Modeling Services repository) which is used by the RouterManager runtime to load the most recent routing rules.

The application uses the toolchain for the code name "M" modeling language to make use of a custom textual domain-specific language (DSL) for router rules and to load the rules into a database. The ADO.NET Entity Framework is used by the RouterManager runtime to access the RouterModel instance data which contains the routing rules. A Windows Communication Foundation (WCF) Controller interface is also included in the RouterManager to configure new rule sets and signal the RouterManager to re-load the rules.

PhotoStore Application

MSDN Code Gallery — Tue, 17 Nov 2009 17:27:51 GMT

PhotoStore is an application that allows you to store information about your digital photographs in a database (such as the SQL Server Modeling Services repository) and to make this information selectively available to others.

The scenario is a photographer wants to keep information about his digital artwork in a database so he or she can sell the photos to his customers. The customers don't want to buy a cat in a bag, so they request a preview of his work -- in the form of photo metadata. After they pay, all information, including the pictures, can be made available to them.

For a graphical presentation of the scenario, see PhotoStore.pptx. The application uses the toolchain for the code name "M" modeling language to make use of a custom textual domain-specific language (DSL) for photo metadata and to load the metadata into a database. It also uses built-in repository security to show public and private information about photos to selected users.

Petshop Database in "M" and Custom Command for "Quadrant"

MSDN Code Gallery — Tue, 17 Nov 2009 17:27:50 GMT

This sample includes Petshop.m, an "M" file that contains all the schema and instance data for the Petshop database. This is used by the "Quadrant" Petshop Tutorial in the MSDN Library. Also included is a custom command for "Quadrant called ViewProducstSample. This sample accompanies "How To: Create and Install a Custom Command" in the MSDN Library.

Pattern Application for SQL Server Modeling Services

MSDN Code Gallery — Tue, 17 Nov 2009 17:26:04 GMT

This sample consists of the PatternApplication model which is designed to use for applying the SQL Server Modeling Services repository’s standard patterns to a set of models (instead of applying patterns to each model separately). The model is attached with the post SQL script which creates a generic stored procedure that automatically apply the patterns that is defined in the form of EntityPatternApplication or ModulePatternApplication instances to the corresponding models.

Northwind Database with Instance Data written in "M"

MSDN Code Gallery — Tue, 17 Nov 2009 17:26:03 GMT

This sample includes schema models and data for Microsoft's ubiquitous Northwind sample database in the Microsoft code name "M" modeling language.

Model-Driven Windows Installer XML Language (Wix)

MSDN Code Gallery — Tue, 17 Nov 2009 17:25:59 GMT

This sample demonstrates using a domain-specific language (DSL) written in the code name "M" language to simplify the process of creating Windows Installer (MSI) packages using the Windows Installer XML Language, known as Wix ("wicks"). Wix itself is a free software toolset from Microsoft that builds MSIs from an XML document. For details on Wix, see http://sourceforge.net/projects/wix/.

One of the difficulties in working with Wix is authoring the necessary XML. This sample simplifies the process by defining a DSL from which the XML can be generated. This sample includes an "M" language for that DSL as well as a compiler that will generate the XML.

MGrammarXAML - Person Sample

MSDN Code Gallery — Tue, 17 Nov 2009 17:25:56 GMT

The Person sample demonstrates using a dynamically-parsed grammar to instantiate CLR objects using a simple domain-specific language (DSL). The grammar is written using the Microsoft code name "M" modeling language and is dynamically parsed using associated "M" tools. The output of the sample is only a few lines in a console window; it's main purpose is to demonstrate the dynamic parsing.

The console output, though simple, is actually generated as XAML through a library called MGraphXamlReader. This library creates various extensions to the standard "M" language dynamic parsing facilities. Note that in this sample, the MGraphXamlReader library is built as a separate assembly.

Media Library/Player for code name "Quadrant"

MSDN Code Gallery — Tue, 17 Nov 2009 17:25:52 GMT

Media Library is a set of models, configurations, and add-ins for code name “Quadrant” that allow you to extract metadata from your audio or video files into a database (such as the SQL Server Modeling Services repository), and from there to visualize and edit it with “Quadrant”. It also includes the capability of playing the media files.

Hiring System C# Source Sample

MSDN Code Gallery — Tue, 17 Nov 2009 17:25:48 GMT

This sample creates a .NET Framework class library that can be used as an input for Common Language Runtime (CLR) and Unified Modeling Language (UML) domains of SQL Server Modeling Services. Such a class library could serve as basis for a simple hiring system simulation, which would allow for the hiring of full-time, part-time, and temporary employees. Each kind of employee has specific features that set them apart from the other kinds. For example, only full-time employees get annual leave, and only temporary employees have an expected termination date when they are hired. Part-time employees are required to work at least 20 hours per week. However, all employees have many things in common: they all get hired, all have salaries, each has a name, etc.

The class library contains a base class called Employee from which the classes FullTimeEmployee, PartTimeEmployee, and TempEmployee are derived. There is also a Friend class called EmployeeDataManager which simulates reading and writing employee data to and from a database.

Event Pattern Mesh

MSDN Code Gallery — Tue, 17 Nov 2009 17:25:42 GMT

Event Pattern Mesh is a sample of an end-to-end application that has been designed for detecting event patterns from real-time data feeds. The application makes use of a number of technologies within the Microsoft SQL Server Modeling CTP, including the code name "M" modeling language, "M" grammars, and the SQL Server Modeling Services repository.

Calculator Library C# Code Sample

MSDN Code Gallery — Tue, 17 Nov 2009 17:25:32 GMT

This sample creates two simple CLR assemblies that are intended to demonstrate the features of the System_Runtime model, part of the CLR domain in SQL Server Modeling Services. For more information, see System_Runtime in the MSDN Library at http://msdn.microsoft.com/en-us/library/dd857487(VS.85).aspx.

"M" and "M" Languages Grammars

MSDN Code Gallery — Tue, 17 Nov 2009 17:24:33 GMT

In this sample, the file m.mg contains the full expression of the Microsoft code name "M" modeling language's grammar, essentially offering a distilled version of the "M" modeling language specification. Once compiled, it can be used to process an input text file written in "M" using the mgx.exe command-line utility. For details, see Using "M" Tools for Creating Languages in the MSDN Library (http://msdn.microsoft.com/en-us/library/dd857692(VS.85).aspx).

The file mg.mg contains the full expression of the "M languages portion of the "M" modeling language, essentially offering a distilled version of that part of the language specification. Once compiled, it can be used to process other grammars (.mg files) using the mgx.exe command-line utility. For general details on this process, also see the previous link.

The files Language.Base.mg and Language.Grammar.mg are also included in this sample. These are built directly into the "M" compiler and which define the basic tokens and rules for the "M" language. As such, these grammars are inherently included in all compilations of "M" code and all other processing of input text against custom grammars. They are provided here for reference purposes and need not be built or deployed independently, nor do they need to be referenced directly in other projects.

For complete details on all aspects of the "M" modeling language, refer to The "M" Modeling Language Specification at http://msdn.microsoft.com/en-us/library/dd285282.aspx.

All-In-One Code Framework (AIO)

MSDN Code Gallery — Mon, 12 Oct 2009 14:37:06 GMT

All-In-One Code Framework code-name CodeFx delineates the framework and skeleton of most Microsoft development techniques (e.g. COM, Data Access, IPC) using typical sample codes in different programming languages (e.g. Visual C#, VB.NET, Visual C++). For instance, the code example ATLDllCOMServer shows the skeleton of an ATL ActiveX DLL as its name implies. Each example is elaborately selected, composed, and documented to demonstrate one frequently-asked, tested or used scenario based on our experience as support engineers. If you are a software developer, you can fill the skeleton with blood, muscle and soul. If you are a software tester or a support engineer like us, you may extend the sample codes a little to fit your specific test scenario or refer your customer to this project if the customer's question coincides with what we collected.

Cinque&Cinque Restaurant Management System

MSDN Code Gallery — Wed, 19 Aug 2009 19:44:11 GMT

Cinque&Cinque is restaurant management software shipped as a sample kit for .NET developers using Microsoft Visual Studio 2008.

The purpose of Cinque&Cinque is to showcase the use of the new technologies introduced in .NET Framework 3.0 (e.g., Windows Communication Foundation, Windows Workflow Foundation and Windows Presentation Foundation) and in .NET Framework 3.5 (e.g., LINQ and the various other C# 3.0 features). Cinque&Cinque also makes use of other Microsoft technologies, such as Windows Mobile/.NET Compact Framework, ASP.NET and SQL server.

UTN Mobile Mall (ES)

MSDN Code Gallery — Fri, 22 May 2009 21:36:18 GMT

The Spanish-language page for UTN's Mobile E-mall Sample. UTN Mobile Mall es una plataforma de servicios construida usando la infraestructura para desktop y móviles de Microsoft .NET Framework y Microsoft SQL Server. El ejemplo muestra la generación dinámica de servicios web WCF y aplicaciones .NET Compact Framework usando diseñadores gráficos de alto nivel. UTN Mobile Mall posibilita a usuarios no-técnicos diseñar e implementar web services y aplicaciones móviles usando simples diseñadores implementados usando WPF y Silverlight.

Programming Microsoft Synchronization Services for ADO.NET (Devices)

MSDN Code Gallery — Fri, 15 May 2009 18:15:46 GMT

These are the code samples to accompany the whitepaper "Programming Microsoft Synchronization Services for ADO.NET (Devices)" published on MSDN.
These were developed by Appa Mundi Ltd. You may use them and modify them as you wish.

Code Sample : Gather information from SharePoint to a database for reporting

MSDN Code Gallery — Mon, 11 May 2009 09:54:12 GMT

This is a sample of C# code to get some metrics from SharePoint and save them in a database using LINQ. You can find the database schema and a console app that creates a snapshot.

UTN Mobile Mall

MSDN Code Gallery — Thu, 07 May 2009 02:25:32 GMT

UTN Mobile Mall is a services platform built on top of .NET framework desktop and mobile infrastructure. This sample shows dynamic generation of WCF web services and .NET compact framework applications by using high level graphical designers. UTN Mobile Mall enables non-technical users to design and implement web services and mobile applications using simple designers implemented on WPF and Silverlight.

Email Reporter: VSTS 2008 Load Test Plug-in

MSDN Code Gallery — Mon, 09 Mar 2009 11:43:42 GMT

Microsoft’s Visual Studio Team System Test Edition provides a powerful platform to perform high volume load testing. It also provides high end flexibilities to write and utilize external plug-in for extended functionalities.

"Email Reporter: VSTS 2008 Load Test Plug-in" enables users to send the load test reports to one or more pre-configured email addresses automatically, once a VSTS Load Test is completed. This open-source load test plug-in also provides supports for customization by which you can customize the reported performance data.

SQL Server Code Samples

MSDN Code Gallery — Thu, 12 Feb 2009 07:51:35 GMT

Welcome to my Code Gallery for sample code for SQL Server. Here you will find various types of samples, which has one thing in common - they all has something to do with SQL Server.

SANMan: SAN Automation for Xiotech SANs

MSDN Code Gallery — Tue, 16 Dec 2008 01:09:44 GMT

SANMan is a service that helps automate the use of Xiotech Storage Area Networks (SANs). Xiotech is an industry leader and offers direct access to their SANs through Web Services. SANMan leverages these web services to automate the ability to Create, Delete and Move VDisks. This includes mounting; partition and volume management and drive formating on the server.

SANMan also can be used to montiror the health of the SANs. Keeping a watch over Power Supplies, Temperature Sensor, Bay/Controller/Driver health and more.

SANMan is built using Microsoft Visual Studio 2008. Written in C# using .NET Remoting and SQL Server as a data store. Microsoft Web Services 2.0 is used to communicate with the Xiotech Web Services.

[SQLServer] - Insert de Select

MSDN Code Gallery — Mon, 15 Dec 2008 01:10:09 GMT

Esse Código irá demonstrar como transportar as informações entre tabelas, como tambem pode ser usado para popular uma tabela de forma mais produtiva. Essa Tecnica pode ser utilizada em varios tipos de Databases.

Bruno Andrade Code Gallery

MSDN Code Gallery — Sun, 14 Dec 2008 23:45:24 GMT

Este projeto consiste em difundir conceitos e tecnicas com as ferramentas Microsoft para desenvolvimento de aplicações Web e Desktop. As tecnologias abordadas serão:

Microsoft .Net
Sql Server
AspNet MVC
Visual Studio 2008
Microsoft Analysis Services

dtexecRemote

MSDN Code Gallery — Thu, 04 Dec 2008 17:51:15 GMT

Remote execution of SSIS packages.

Ward Pond's TechEd Developers 2008 Resource Page

MSDN Code Gallery — Sat, 22 Nov 2008 06:06:35 GMT

Presentations and samples from Ward Pond's presentations at TechEd EMEA Developers 2008. Includes PowerPoint decks, T-SQL scripts, and sample databases.

Coder

MSDN Code Gallery — Sat, 27 Sep 2008 09:18:02 GMT

建设中。。。

Mapping Inheritance trees using Entity Framework

MSDN Code Gallery — Mon, 15 Sep 2008 09:32:57 GMT

Microsoft's Entity Data Model allows us to define an application-oriented view of our data consistent with how we reason about that data. For object oriented modeling, the ability to quickly map inheritance hierarchies to RDBMS is the most important benefit of using Entity Framework, with its visual designer.
We will have working examples of TPT (Table per type), and TPH (Table per hierarchy) implemented in Visual Studio 2008 SP1.

.NET Application Modeling Language (nAML) Specification and Tools

MSDN Code Gallery — Thu, 11 Sep 2008 17:03:41 GMT

nAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide range of specific details. It contains extremely powerful visual notations and semantics to illustrate complex application components, processes and operations easily.

The primary objectives of nAML can be considered as follows:

• Provides a single space to visually describe one or more application systems with structural and behavioral components.
• Provides a single space to visually describe one or more application systems with logical and physical components.
• Provides a single space to visually describe one or more application systems from top to low level.
• Provides a single space to visually describe a part or whole of one or more application systems.
• Extremely simple and easy understand and learn from readers and designers perspective.
• Concentrates on .NET applications, with its related logical and physical entities (user interface, application logic, business logic, database etc).

SQL Server 2000 Sample Databases

MSDN Code Gallery — Wed, 13 Aug 2008 00:23:16 GMT

The old sample databases which were published for SQL Server 2000 (Shiloh). These databases are only tested to work with SQL Server 2000.

SQL Server Compact Edition 3.5

MSDN Code Gallery — Tue, 12 Aug 2008 23:02:46 GMT

Samples for SQL Server Compact Edition 3.5

SQL Server Metadata Toolkit

MSDN Code Gallery — Wed, 18 Jun 2008 02:26:03 GMT

A white paper that covers methods 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.

A sample application:
Microsoft SQL Server 2005 Business Intelligence
Metadata Dependency Viewer and Analyzer Sample

SQL Server Full Text Searching

MSDN Code Gallery — Sat, 07 Jun 2008 05:54:04 GMT

On June 7th, 2008 I am presenting "Getting Started with SQL Server 2005/2008" at the [url:InBetween|http://www.devfish.net/articles/inbetween/] [url:SQL Saturday|http://www.sqlsaturday.com/eventhome.aspx?eventid=5] conference that is taking place between the two weeks of Microsoft TechEd. This post will have all the links relavent to my talk.

Detailed descriptive material can be found on my blog, [url:ArcaneCode.com|http://arcanecode.com], with links to specific posts below.

First off, the slides and sample code can be located at the Code Gallery site I setup specifically for Full Text Searching with SQL Server:

[url:http://code.msdn.microsoft.com/SqlServerFTS|http://code.msdn.microsoft.com/SqlServerFTS]
Look on the downloads page to see various projects around SQL Server Full Text Searching. I've created one "release" for each of the projects around FTS. Be sure to look on the right side at the various releases in order to see the various projects.
Next, you can get started with the basics by reading these entries on my blog:

[url:Lesson 0 - Getting the Bits to do Full Text Searching in SQL Server 2005|http://arcanecode.wordpress.com/2007/10/04/sql-server-2005-full-text-searching-getting-your-bits/]
[url:Lesson 1 - The Catalog|http://arcanecode.wordpress.com/2007/06/26/getting-started-with-sql-server-2005-full-text-searching-part-1-%e2%80%93-the-catalog/]
[url:Lesson 2 - The Indexes|http://arcanecode.wordpress.com/2007/06/27/getting-started-with-sql-server-2005-full-text-searching-part-2-%e2%80%93-the-indexes/]
[url:Lesson 3 - Using SQL|http://arcanecode.wordpress.com/2007/06/28/getting-started-with-sql-server-2005-full-text-searching-part-3-%e2%80%93-using-sql/]
[url:Lesson 4 - Valid Data Types|http://arcanecode.wordpress.com/2007/07/02/getting-started-with-sql-server-2005-full-text-searching-part-4-valid-data-types/]
[url:Lesson 5 - Advanced Searching|http://arcanecode.wordpress.com/2007/07/03/getting-started-with-sql-server-2005-full-text-searching-part-4-

The SQL Server Merge Style

MSDN Code Gallery — Tue, 03 Jun 2008 17:17:09 GMT

Cette démonstration expose la plupart des fonctionnalités disponibles dans la réplication de type fusion (Merge) au sein de SQL Server 2005 et SQL Server 2008. Le code source a été entièrement développé en C# sous Visual Studio 2008. Una base de données de type SQL Server Compact Edition 3.5 est utilisée côté client pour le stockage offline. Le générateur de code OlyMars (http://www.olymars.net) a également été utilisé.

Visual Studio Team System - Database Edition msdb Sample Database Projects

MSDN Code Gallery — Tue, 29 Apr 2008 20:12:39 GMT

msdb database project samples for Visual Studio Team System - Database Edition

You can create or import database objects that refer to objects in other databases(or with MSDB database projects). These cross-database references require that you define a corresponding reference in the properties of your database project. If you refer to objects in other databases but you do not define the corresponding references in your project, warnings will appear. For each database that you reference, you can define SETVAR variables that correspond to the server and database that you want to reference. When you modify an object definition to include the reference, you can define it by using these variables instead of the explicit names of the server and the database. When you build the database project, the variables are replaced by the values that you specified.

To make cross-database references specific to a particular build configuration, you must define the SETVAR variables for those references in terms of MSBuild variables. For example, you can use one set of MSBuild variables when you build and deploy a database project to a staging server and another set when you build and deploy the same project to a production server. If you define the SETVAR variables for a cross-database reference in terms of server and database names, the reference will function the same way, regardless of which build configuration you specify.

D-Binsor

MSDN Code Gallery — Mon, 14 Apr 2008 02:42:07 GMT

Source Code of Castle Windsor Database Version.
Documentation can be found at: http://www.ifinancialsystems.com/default.aspx

Employee Info Starter Kit

MSDN Code Gallery — Wed, 09 Apr 2008 08:52:50 GMT

This is a starter kit, which includes very simple user requirements, where we can create, read, update and delete (crud) the employee info of a company.

The primary purpose of this starter kit is, to provide a solid guideline with respect to building enterprise level projects, by utilizing new asp.net 2.0 and sql server 2005 features, as well as latest best coding practices.

The starter kit includes several cases where we can perform multi-table joining and/or write operations. Combining high performance and security features this starter kit shows how we can solve in real world problems and challenges, from a wide range of view point.

Asp.Net Code Jet

MSDN Code Gallery — Wed, 09 Apr 2008 07:56:27 GMT

This is a resource home where software architect Mohammad Ashraful Alam provided few of his coding samples demonstrating best practices and solutions with regarding real world problems while developing web applications. All of the coding samples provided here are considering asp.net and sql server technology.

SQL Pad

MSDN Code Gallery — Sat, 05 Apr 2008 11:40:56 GMT

A simple pad just like WFPad, but with rich SQL Server supportability, i.e. it comes with more SQL Server activity e.g. Connect2Server, ExecuteSQL, ViewResult, AccessEndPoint, ExtractSchema, ... etc. And the amazing thing is that you can jsut drag and drop to form a workflow to operate your database or manipulate the data visually .. convenient and beautiful

SQL Server Learning Materials and Tutorials

MSDN Code Gallery — Thu, 13 Mar 2008 21:59:08 GMT

SQL Server Learning Materials and Tutorials

SQL Server Integration Services

MSDN Code Gallery — Thu, 13 Mar 2008 11:31:47 GMT

Support for SQL Server Integration Services MSDN Forums

SQL Server Analysis Services

MSDN Code Gallery — Thu, 13 Mar 2008 11:29:17 GMT

Support for SQL Server Analysis Services MSDN Forums

SQL Server Reporting Services

MSDN Code Gallery — Thu, 13 Mar 2008 11:25:54 GMT

Support for SQL Server Reporting Services

Common Solutions for T-SQL Problems

MSDN Code Gallery — Wed, 12 Mar 2008 23:47:37 GMT

Common Data Problems and Solutions Suggested by MSDN Forum Moderators and Answerers

VS2008 - Simplified Chinese Academia Samples [LunarCalendar/UserValidation/HRD]

MSDN Code Gallery — Fri, 07 Mar 2008 06:52:10 GMT

由南开大学软件学院使用Visual Studio 2008开发的示例程序。这些示例程序演示了如何使用VS2008提供的诸如WPF和Globalization的先进特性。欢迎试用！
本示例包含三个程序-用户验证，农历日历和华容道。

The following samples developed with Visual Studio 2008 by NanKai University in China. These samples show some advanced features of VS2008 like WPF and Globalization. Enjoy!
This sample contains three projects - a User Validation sample, a Chinese Lunar Calendar and a game Hua-Rong-Dao.

Microsoft Sync Framework

MSDN Code Gallery — Thu, 06 Mar 2008 03:16:45 GMT

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services, and devices with support for any data type, any data store, any transfer protocol, and any network topology.

SQL Server CLR SharePoint Interface

MSDN Code Gallery — Fri, 29 Feb 2008 01:00:56 GMT

This sample code demonstrates how to query a Microsoft Office SharePoint Server
2007 or Windows SharePoint Services list from inside SQL Server 2005 or later.

With the growing popularity of SharePoint solutions, SharePoint lists are becoming
an important source of enterprise data. There is no OleDb provider for SharePoint,
so integrating SharePoint data with data in SQL Server can be a challenge.

This CLR User Defined Function shows how you can use the SQL Server's Common
Language Runtime integration to access SharePoint list data through the SharePoint
web services.

Simple SQL Server Database Schema Printer (ASP.NET)

MSDN Code Gallery — Wed, 27 Feb 2008 18:23:09 GMT

A simple ASP.NET page that gets all the tables, their column names, column data types and other information from an SQL Server database and shows them in a web page. You can then print this off, annotate it and it use it as a reference.

I use it when I start on a new project that has an existing database that I need to completely understand.

Microsoft SQL Server Community & Samples

MSDN Code Gallery — Mon, 18 Feb 2008 21:32:21 GMT

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 community at large: http://www.codeplex.com/SqlServerSamples

To obtain the SQL Server 2008 software, please sign up (for free!) with Microsoft Connect for the SQL Server SQL Server 2008 CTP Program: https://connect.microsoft.com/SQLServer/

Flat File Data Reader

MSDN Code Gallery — Mon, 18 Feb 2008 18:40:05 GMT

An abstract IDataReader implementation that reads flat files. Enables bulk loading of SQL Server using SqlBulkCopy from flat files with strange formats.

For ordinary delimited or fixed-width files, SSIS is a better tool, but when your file format doesn't work well with these tools or you need a pure .NET solution, consider using this FlatFileDataReader. Includes the option to skip over lines in the file for multi-format files.

Good scenarios are loading from clients (without SSIS), and loading files with multiple record layouts, heders and footers, etc.

Package includes a sample solution.

LINQ Entity Data Reader

MSDN Code Gallery — Mon, 18 Feb 2008 06:18:31 GMT

An IDataReader implementation that reads a collecion of entities to enable using SqlbulkCopy with LINQ.

SQL Sequence Generator

MSDN Code Gallery — Mon, 18 Feb 2008 06:18:19 GMT

This TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc.

IT Mastering

MSDN Code Gallery — Sun, 17 Feb 2008 14:53:04 GMT

A Place where you will find a lot of resources about programming languages and some Microsoft servers

Linq to SQL Join Example

MSDN Code Gallery — Thu, 31 Jan 2008 22:29:13 GMT

A example of creating a dynamic join of client data with a T-SQL statement.

The power of Contains and T-SQL IN

ADO.NET Entity Framework & LINQ to Relational Data

MSDN Code Gallery — Fri, 25 Jan 2008 06:03:19 GMT

Samples and unsupported tools for the ADO.NET Entity Framework(including LINQ to Entities) and LINQ to SQL.

Entity SQL

MSDN Code Gallery — Thu, 24 Jan 2008 08:51:42 GMT

Entity SQL tools and samples. eSqlBlast home.

CodeAuthor C# Code Generator

MSDN Code Gallery — Tue, 27 Mar 2007 14:46:05 GMT

Generates easy to use, high performance C# DAL and SQL Stored Procedures from a SQL Server DB.