Resources

UTN Mobile Mall (ES)
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)
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
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
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
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
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
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
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
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
Remote execution of SSIS packages.

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

Coder
建设中。。。

Mapping Inheritance trees using Entity Framework
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
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
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
Samples for SQL Server Compact Edition 3.5

SQL Server Metadata Toolkit
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
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
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
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
Source Code of Castle Windsor Database Version. Documentation can be found at: http://www.ifinancialsystems.com/default.aspx

Employee Info Starter Kit
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
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
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
SQL Server Learning Materials and Tutorials

SQL Server Integration Services
Support for SQL Server Integration Services MSDN Forums

SQL Server Analysis Services
Support for SQL Server Analysis Services MSDN Forums

SQL Server Reporting Services
Support for SQL Server Reporting Services

Common Solutions for T-SQL Problems
Common Data Problems and Solutions Suggested by MSDN Forum Moderators and Answerers

VS2008 - Simplified Chinese Academia Samples [LunarCalendar/UserValidation/HRD]
由南开大学软件学院使用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
Introducing the Microsoft Sync Framework – a comprehensive synchronization platform enabling collaboration and offline for applications, services and devices with support for any data type, any data store, any transfer protocol, and network topology.

SQL Server CLR SharePoint Interface
 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)
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
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
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
An IDataReader implementation that reads a collecion of entities to enable using SqlbulkCopy with LINQ.

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

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

Linq to SQL Join Example
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
Samples and unsupported tools for the ADO.NET Entity Framework(including LINQ to Entities) and LINQ to SQL.

Entity SQL
Entity SQL tools and samples. eSqlBlast home.

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