Resources

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 RC0 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.