Click here to Skip to main content

Submit your article

SQL Server 2005

SQL-Server-2005

Great Reads

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

AJAX-enabled Name Selector User Control

by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Notification of Silverlight Applications about Database State Changes

by Max Paulousky

This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.

Latest Articles

SQL - Pivot with Grand Total Column and Row

by Narapareddy Shyamprasad

SQL Dynamic Pivots

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

Use RegEx in SQL with CLR Procs

by JasonShort

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!

Code Review Checklist

by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

All Articles

SQL Server 2005

SQL - Pivot with Grand Total Column and Row

16 Aug 2018 by Narapareddy Shyamprasad

SQL Dynamic Pivots

SQL-Server-2005

Use RegEx in SQL with CLR Procs

7 Aug 2017 by JasonShort

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!

SQL-Server-2008

SQL-Server-2005

Code Review Checklist

24 Feb 2017 by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

SQL-Server-2005

SQL-server-2000

Use one SSRS Report to Find All Your Microsoft SQL Servers, Out of Date Editions, and Service Packs

3 Oct 2016 by Mark W Solomon

In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.

SQL-Server-2005

SQL-server-2000

reporting-services

SQL Server Database Development in Visual Studio

1 Sep 2016 by NaibedyaKar

SQL Server database project creation using Visual Studio 2013

SQL-Server-2005

Sql Server In Clause With Multiple Literal Values Performance Behaviour

26 Aug 2016 by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL-Server-2008

SQL-Server-2005

Automatically Create Data Access Layers and Business Layers From Microsoft Access or SQL Server Databases

27 May 2016 by icemanind

How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database

SQL-Server-2005

SQL-server-2000

How To Send Mail Using SQL Server: Part 2

27 Mar 2016 by Manish kumar choudhary

In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.

SQL-Server-2005

LayerGenMMX

2 Nov 2015 by icemanind

Easily create Business and Data Layers!

SQL-Server-2005

SQL-server-2000

Customize the built-in Outlook Select Names dialog (or any other)

14 Jan 2015 by Helmut Obertanner

In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.

SQL-Server-2005

How to Validate ASP.NET and MVC Web Forms Using Business Rules Engine

14 Jul 2014 by Misha1964

Learn how to validate complex web forms using business rules engine

SQL-Server-2005

SQL-server-2000

Thinking in SQL - Working with dates

14 Mar 2014 by Christian Graus

In this installment, I talk about working with dates and date functions in SQL Server

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

SQL Wizardry Part 2 - Select, beyond the basics

12 Mar 2014 by Christian Graus

The second in my series digs in to some of the different things you can do within a select statement.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Five steps to using a logging utility in your projects using Application Blocks

5 Mar 2014 by Shivprasad koirala

Steps to use a logging utility in your projects using Application Blocks.

SQL-Server-2005

SQL-server-2000

ASP.NET Caching Interview Questions: Part 2

4 Mar 2014 by Shivprasad koirala

ASP.NET Caching Interview Questions Part 2

SQL-Server-2005

SQL-server-2000

Northwind N-Tier Blueprint Application Using WPF/WCF/LINQ to SQL

5 Feb 2014 by The Cool Wayfarer

A blueprint application to showcase an enterprise standard architecture using the .NET 3.5 technologies like WPF, WCF, and LINQ to SQL.

SQL-Server-2005

Thinking in SQL - Generating Random Numbers

23 Jan 2014 by Christian Graus

A discussion of ways to create random number sequences in SQL Server

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

SQL Wizardry Part Eight - Tally Tables

21 Jan 2014 by Christian Graus

A description of the best way to create tally tables, and how to use them

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Learn to Write Custom MDX Query First Time

17 Jan 2014 by Mubin M. Shaikh

Learn Custom MDX Query Step by Step

SQL-Server-2008

SQL-Server-2005

SQL Wizardry Part Seven - PIVOT and arbitrary lists of data

16 Jan 2014 by Christian Graus

Discussion on pivot and other ways to turn columns of data in to rows in SQL Server

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

SQL Wizardry Part Six - Windowing Functions

13 Jan 2014 by Christian Graus

A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

SQL Wizardry Part Three - Common Table Expressions (CTEs)

12 Jan 2014 by Christian Graus

In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

SQL Wizardry Part Five - when not to use DISTINCT

6 Jan 2014 by Christian Graus

Just a quick explanation of why it's not always a good idea to use DISTINCT

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

C# Project on Database for Beginners

6 Jan 2014 by Hasan Habib Surzo

Class, Database Connection, Login Winform

SQL-Server-2005

Truncate Log File in SQL Server 2005

6 Jan 2014 by Assil

A tool that facilitates the truncation of SQL log file

SQL-Server-2005

Architecture Guide: Windows Forms, Generics, Auto-Mapper, Entity Framework, Framework Design, and many more..

12 Dec 2013 by Nirosh

Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.

SQL-Server-2005

Duplicate Rows/XML-Nodes Identification and Clean-up from Database

27 Nov 2013 by S. M. Ahasan Habib

In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.

SQL-Server-2008

SQL-Server-2005

Storing Images in SQL Server using EF and ASP.NET

23 Oct 2013 by Eduard Keilholz

A quick help for storing images in SQL Server and displaying them on a ASP.NET Website

SQL-Server-2008

SQL-Server-2005

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

18 Oct 2013 by Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!

SQL-Server-2005

SQL-server-2000

HowTo: Install the Northwind and Pubs Sample Databases

18 Oct 2013 by Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express.

SQL-Server-2005

Send Email Alert on Database Schema Change in SQL Server

4 Oct 2013 by Mubin M. Shaikh

Auto Monitoring On Schema Change within Database in SQL Server and Email Alert

SQL-Server-2005

Measurement Unit Conversion Library

2 Oct 2013 by George Ziady

This is an alternative for "Measurement Unit Conversion Library"

SQL-Server-2005

SOA Interview Questions: Part 1

19 Sep 2013 by Shivprasad koirala

Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).

SQL-Server-2005

SQL-server-2000

Create and Populate Date Dimension for Data Warehouse

4 Sep 2013 by Mubin M. Shaikh

This article shows how to create and populate date dimension for data warehouse.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Security in SQL Server 2005 as seen by a programmer

28 Aug 2013 by Software Developer's Journal

The goal of this article is to present elements of security in SQL Server such as: restrictive access to the server, blocking and safe configuration of services, and reduction of attack space for new elements. Techniques for creating and managing users and for securing data are illustrated.

SQL-Server-2005

Zip Rendering Extension for SQL Server Reporting Services 2005/2008/2012

14 Aug 2013 by Harmen Brouwer

How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.

SQL-Server-2008

SQL-Server-2005

Making OUTER and CROSS APPLY work for you

6 Aug 2013 by Michiel du Toit

Explaining and demonstrating the use of the APPLY keyword for SQL Server

SQL-Server-2008

SQL-Server-2005

19 Jun 2013 by Mayank Dubey

XQuery basics.

SQL-Server-2008

SQL-Server-2005

Continuous Database Integration

16 May 2013 by Peter Hancock

Using NAnt and CruiseControl.NET to continuously integrate database changes

SQL-Server-2005

SQL-server-2000

DBMapper - A New ORM Tool

2 May 2013 by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

SQL-Server-2005

How to execute multiple long running SQL Statements Asynchronously in small chunks

28 Mar 2013 by Khorshed Alam, Dhaka

How to execute multiple long running SQL Statement Asynchronously in smaller chunks

SQL-Server-2005

SQL-server-2000

Online Query Management Studio 1.0

22 Mar 2013 by Shubham Choudhary

OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.

SQL-Server-2005

Binary Copy files in T-SQL with helps of CLR

22 Jan 2013 by Levente Kupás

Managing SQL backups can be more simple by using this FileRelay CLR

SQL-Server-2008

SQL-Server-2005

Convert SQL Server DB to SQLite DB

13 Jan 2013 by liron.levi

A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB

SQL-Server-2005

SQL-server-2000

Coding an N-Tier Application in C# Without Any Wizard: Part II

5 Jan 2013 by Vimalsoft(Pty) Ltd

Coding an N-Tier application in C# without using Wizards.

SQL-Server-2005

SQL-server-2000

Editable GridView in ASP.NET 2.0

26 Nov 2012 by Ashrafur Rahaman

This article will give you an overview of how to use an ASP.NET GridView completely, and how to use RowEditing, RowUpdating, RowDeleting, RowCommand, RowDataBound, RowCancelingEdit, and Pagination in a DataGrid. From this article, you will have a clear view of GridView data inserting, deleting, and

SQL-Server-2005

Effective paging with List View control in ASP.NET

9 Nov 2012 by Abdul Quader Mamun

To develop scalable applications, effective paging is essential. Devoid of smart and effective paging and sorting to handle thousands of thousand data takes extra time and system resources.

SQL-Server-2005

WCF by Example - Chapter XIV - Validation & Exception Management

25 Oct 2012 by Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

SQL-Server-2005

WCF by Example - Chapter IV - Transaction Manager

24 Oct 2012 by Enrique Albert

Generic transaction and exception manager for server side services

SQL-Server-2005

WCF by Example - Chapter III - Response

24 Oct 2012 by Enrique Albert

WCF service response message patterns

SQL-Server-2005

ADO.NET Data Access Component for SQL Server in C# and VB.NET

28 Sep 2012 by AdamNThompson

A data access component for SQL Server in VB.NET.

SQL-Server-2005

AutoRefresh Entity Framework Data Using SQL Server Service Broker

14 Sep 2012 by Harry von Borstel

How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes

SQL-Server-2008

SQL-Server-2005

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

Find multiple strings (delimenated by space) in all selected columns.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

16 Aug 2012 by Abdul Quader Mamun

Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.

SQL-Server-2005

SQL-server-2000

Implementing multi-level trees in MS SQL Server

14 Aug 2012 by Duong Ba Hong Minh

A good way to setup and install a multi-tree level structure by using a MS SQL Server database.

SQL-Server-2005

SQL-server-2000

Table Data Sharing Across Stored Procedures

7 Aug 2012 by ManojKumar19

This tip demonstrates how table data can be shared in two stored procedures.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Cancellable SQL Server Query

23 Jul 2012 by Scott G Blood

A Cancellable threaded query for SQL Server using .net 3.5

SQL-Server-2008

SQL-Server-2005

Small Paging Control for Windows Presentation Foundation (WPF)

27 Jun 2012 by freedeveloper

A small control to control paging in Windows Presentation Foundation.

SQL-Server-2005

Building an N-Tier Application in VB.NET, in 8 Steps

24 May 2012 by Vimalsoft(Pty) Ltd

This article will show you how to build an N-Tier application in VB.NET.

SQL-Server-2005

SQL-server-2000

SQL Server Date Format Language

23 May 2012 by Cristhian Selah

Perform a conversion in a select, view, and Stored Procedure.

SQL-Server-2008

SQL-Server-2005

Cache IQueryable for Better LINQ-to-SQL Performance

21 May 2012 by Zimin Max Yang

An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.

SQL-Server-2005

Simple & Advanced Pivots with C# and ASP.NET

1 May 2012 by Jean-Francois Lanouette

This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"

SQL-Server-2005

SQL-server-2000

How SQL Server deletes records

30 Apr 2012 by DLM@TD

How SQL Server deletes records

SQL-Server-2008

SQL-Server-2005

RESTful WCF / EF POCO / Unit of Work / Repository / MEF: 1 of 2

19 Apr 2012 by Sacha Barber

A look at designing a service layer using good practices, and the MSFT technology stack.

SQL-Server-2005

web_development

Visual Application Launcher

23 Jan 2012 by Dylan Morley

A WinForms UI using WCF services, Entity Framework, repository data access, repository caching, Unit of Work, Dependency Injection, and every other buzz work you can think of!

entity-framework

SQL-Server-2005

Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005

15 Jan 2012 by Venkat Chaitanya Kanumukula

Export SQL Server Tables to Excel Files Dynamically

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Exporting Stored Procedure Results into Tables Dynamically with T-SQL

11 Jan 2012 by Venkat Chaitanya Kanumukula

T-SQL Code for Converting Stored Procedure results to Tables Dynamically

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Dynamically Generating Html/Excel/Word Document Files with SQL Server data using SSIS 2005

11 Jan 2012 by Venkat Chaitanya Kanumukula

Export SQL Server tables to HTML/Excel/Word Document files dynamically.

SQL-Server-2005

SQL-server-2000

21 Dec 2011 by Uwe Keim

An application that helps you in starting tasks at predefined times and with various dependencies.

SQL-Server-2005

Detailed SQL Server data audit through a .NET (CLR) trigger

19 Dec 2011 by David Catriel

Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.

SQL-Server-2005

Efficient Paging with Repeater and SQL Server 2005 / 2008

16 Dec 2011 by perels

An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.

SQL-Server-2008

SQL-Server-2005

Controlling IP traffic from Internet to DMZ or Intranet

5 Dec 2011 by snp157

Controlling IP traffic from Internet to DMZ or Intranet

SQL-Server-2005

Library for scripting SQL Server database objects with examples

8 Nov 2011 by Kanasz Robert

This article is about library for scripting SQL Server database objects and examples representing how this library can be used.

SQL-Server-2008

SQL-Server-2005

WCF by Example - Chapter XI - NHibernate Implementation

14 Oct 2011 by Enrique Albert

Unit of work pattern on NHibernate using repositories.

SQL-Server-2005

WCF by Example - Chapter X - Dependency Injection with Spring.Net

14 Oct 2011 by Enrique Albert

How to use Spring.Net DI reducing coupling and enhancing automated testing.

SQL-Server-2005

SQL Server Performance Impacted by New Features

11 Oct 2011 by KP Lee

Specific example for improving some SQL performance problems

SQL-Server-2008

SQL-Server-2005

Using Integrated Windows Authentication (IWA) in a Distributed Application Architecture

11 Oct 2011 by GraemeKMiller

This article explains how you can use IWA to improve your Users' experience and it also explains how it benefits your IT support team.

SQL-Server-2005

SQL-server-2000

DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV

20 Sep 2011 by Pieter Van Parys

Creating profiling information in our ProxyDbxxx classes

SQL-Server-2005

ASP.NET Custom Control + Crystal Report Dynamic Text Format

28 Jul 2011 by Sachin Somanath Mumbare

Custom control for display client formatted text in Crystal report

SQL-Server-2005

Building High Performance Queue in Database for storing Orders, Notifications, Tasks

11 Jun 2011 by Omar Al Zabir

Building High Performance Queue in Database for storing Orders, Notifications, Tasks

SQL-Server-2008

SQL-Server-2005

How to Create your First SQL Server Integration Services (SSIS) Package - Part 1

9 Jun 2011 by Md. Marufuzzaman

How to create your first SQL Server Integration Services (SSIS) package - part 1

SQL-Server-2005

Consuming a Web Service created through Sql Server HTTP Endpoints via Web Service task in SSIS

19 May 2011 by Niladri_Biswas

In this article we will see how we can consume a web service expose through HTTP Endpoint via Web Service Task of SSIS

SQL-Server-2008

SQL-Server-2005

SSRS Series Part II: Working with Subreports, DrillDown Reports, Expressions and Custom codes, Databars, Indicators, Custom Sorting and Paging and many more

12 May 2011 by Niladri_Biswas

In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples

SQL-Server-2008

SQL-Server-2005

SSRS Series Part I: Various ways of Report creation, deployment and invocation

11 May 2011 by Niladri_Biswas

This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications

SQL-Server-2008

SQL-Server-2005

LINQ Demo with ASP.NET Web Application

29 Apr 2011 by anrorathod

A sample application for beginner users who want to start the Linq implementation in ASP.NET

SQL-Server-2005

SQL And C#

15 Apr 2011 by Ayaz Awan

Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server

SQL-Server-2005

SQL-server-2000

Custom Membership Providers - Task Manager

9 Apr 2011 by Karthik. A

This article extends what was built in the previous article. This is a task manager application that uses the custom provider designed in the last part.

SQL-Server-2005

A method to migrate and automate exisitng DSTX SSIS package from SQL server 2005 to 2008 R2

9 Mar 2011 by santosh poojari

This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis

SQL-Server-2005

SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages

10 Feb 2011 by KarthikAnbarasan

Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages

SQL-Server-2008

SQL-Server-2005

SQL Server Schema Comparison Tool in Visual Studio 2010

14 Jan 2011 by KarthikAnbarasan

This article explains the new tool in Visual Studio 2010 which most of the users use to see the comparison report of the 2 different database schemas.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Create md5 Hash-code using Assemblies in SQL Server 2005

7 Jan 2011 by Denis Strukachev

Create md5 hash-code using assemblies in SQL Server 2005

SQL-Server-2005

WCF by Example - Chapter XIII - Business Domain - Parent and Child Relationships

7 Jan 2011 by Enrique Albert

Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.

SQL-Server-2005

WCF by Example - Chapter XII - WCF Implementation

18 Dec 2010 by Enrique Albert

In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.

SQL-Server-2005

Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion

9 Dec 2010 by AnupKumarYadav

Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Continuous Integration for Databases with Visual Studio

23 Nov 2010 by Adam Nachman

Provides a framework for predictably compiling, extracting, and deploying a database project.

SQL-Server-2005

Enterprise Application Architecture: Designing Applications and Services in .NET - Part II

15 Nov 2010 by venugopalm

Database and Library Design for Customer Order Management System

SQL-Server-2005

WCF by Example - Chapter II - Repositories

5 Nov 2010 by Enrique Albert

Introducing the RepositoryLocator pattern.

SQL-Server-2005

Exception Handling in 3-Tier Architecture

15 Oct 2010 by Sohail Maroof, Farrukh Hashmi

Exception handling in 3-Tier Architecture using Enterprise Library

SQL-Server-2005

Data Synchronization in SQL Express

14 Oct 2010 by Ganesan Krishnan

Data Synchronization in SQL Express

SQL-Server-2005

SQL-server-2000

Integrating Database Development in Visual Studio

27 Sep 2010 by venugopalm

Integrating database development into Visual Studio to collaborate application development team and the database designers

SQL-Server-2005