Click here to Skip to main content

Submit your article

SQL-Server-2008

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.

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

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

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.

WCF by Example - Chapter VII - Decoupling of WCF Services from the ViewModel

by Enrique Albert

Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.

Latest Articles

Select Statement to HTML Table

by Luca Astolfi

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

Peer to Peer File Sharing Through WCF

by Amir Jalilifard

In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.

Pay Attention to What "Script...To" Generates

by John Simmons / outlaw programmer

It doesn't always happen the way you expect.

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!

All Articles

SQL-Server-2008

Simple Data Access in C#

11 Jan 2009

6opuc

Fast and easy to use data access class library.

SQL-server-2005

SQL-server-2000

A LINQ Tutorial: Mapping Tables to Objects

12 Dec 2009

Abby Fichtner (Hacker Chick)

A beginner's LINQ tutorial that walks you through mapping your SQL Server database tables and relationships to objects, and how to retrieve that data via simple LINQ queries.

SQL-Server-2008

A LINQ Tutorial: Adding/Updating/Deleting Data

11 Dec 2009

Abby Fichtner (Hacker Chick)

A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL while keeping your class relationships (M:M, 1:M, and M:1) synchronized.

SQL-Server-2008

A LINQ Tutorial: WPF Data Binding with LINQ to SQL

11 Dec 2009

Abby Fichtner (Hacker Chick)

A tutorial and application on using WPF Data Binding with LINQ to SQL classes. This is part 3 of a three-part tutorial on using LINQ to SQL.

SQL-Server-2008

16 Aug 2012

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

Quick Overview: Temporary Tables in SQL Server 2005

22 Sep 2009

Abhijit Jana

Basic overview of temporary Tables in SQL Server 2005

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Working with CLR Objects in SQL Server 2005 or Higher: Part I

2 Aug 2009

Abhishek Sur

Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.

SQL-server-2005

Working with CLR Objects in SQL Server 2005 or Above Part 2

2 Aug 2009

Abhishek Sur

Gives an introduction of how to create SQL CLR managed objects in SQL server.

SQL-server-2005

Auto Adjusting Date Ranges on Entry of a New Range using SQL

28 Sep 2009

acarpio1975

Given date ranged data, adjust existing ranges on entry of a new ranged data.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Continuous Integration for Databases with Visual Studio

23 Nov 2010

Adam Nachman

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

SQL-server-2005

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017

AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

SQL-server-2008R2

SQL-server-2012

SQL-server-2014

SQL-Server-2016

SQL-Server-2008

FOR XML Basics (EXPLICIT Mode): 3 of 4

2 Jun 2017

AhsanAhmed

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

SQL-server-2008R2

SQL-server-2012

SQL-server-2014

SQL-Server-2016

SQL-Server-2008

Executing a Web Service in a CLR Based Table Valued Function and Representing its IEnumerable Type Output as a Table in SQL Server

16 Jun 2010

Akbar Ali Bhatti

Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.

SQL-Server-2008

SQL-server-2005

Find multiple strings in selected columns

28 Aug 2012

akhil khare

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

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Code First Approach using Entity Framework 4.1, Inversion of Control, Unity Framework, Repository & Unit of Work Pattern and MVC3 Razor View

26 Nov 2014

Akhil Mittal

My effort in this article was to put some light on building a generic multilayered architecture using Entity Framework 4.1 and MVC3 razor view engine.

SQL-Server-2008

SQL browser

6 Jul 2015

Alaa Ben Fatma

Explore your MMSQL server tables in a professional way .

A scheduler GUI for SQL Server Agent

10 May 2012

Alberto Venditti

An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs

SQL-Server-2008

A general-purpose service engine for unattended processing execution

24 Sep 2015

Alberto Venditti

Using a .NET Windows service as an engine for specialized custom plug-ins execution

SQL-server-2000

Using SQL Bulk Load to Upload Fixed Width Text Files

3 Mar 2009

Alden John Snow

This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.

SQL-server-2005

SQL-server-2000

Set Based and Procedural Approaches in Examples

4 Jan 2010

Alexandru Cibotari

Set based and procedural approaches in examples tested on SQL Server 2008

SQL-Server-2008

A uniform interface for large texts for a C# SQL client

26 Jul 2009

AlexS9999

The article provides a simple interface for handling large text in SqlClient and C# file streams.

SQL-Server-2008

SQL-server-2005

Performance Comparison - Identity() x NewId() x NewSequentialId

16 Jan 2009

Alfredo_Fernandez

Performance comparison - Identity() x NewId() x NewSequentialId.

SQL-Server-2008

SQL-server-2005

How to change ConnectionString easily

6 Feb 2010

Ali Marzban

Changing ConnectionString like an attribute in C#

SQL-server-2005

Peer to Peer File Sharing Through WCF

10 Jan 2018

Amir Jalilifard

In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.

Donate your Blood

2 May 2013

AmitGajjar

This website will help those people who actually need blood at the right time.

SQL-Server-2008

Using User Defined Functions in Table Inserts and Seeding with Stored Procedures

26 Aug 2009

Andy_L_J

Generate unique column values using UDFs and Stored Procedures

SQL-Server-2008

SQL-server-2005

Table-Value Parameters in SQL Server 2008 - VB.NET

9 Oct 2009

Andy_L_J

Using Table-Value Parameters to perform Inserts in SQL Server 2008 from VB.NET.

SQL-Server-2008

Report Service 2008 R2 - Delivery Extension User Control

7 Feb 2013

Anupama Agarwal

This article describes how to create custom delivery extension of Reporting service with User Control (.ascx) instead of server control.

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

9 Dec 2010

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

SQL And C#

15 Apr 2011

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

SharePoint 2010 Logging Database

6 Apr 2010

Ayman M. El-Hattab

Four reasons to directly query SharePoint logging database

SQL-Server-2008

SQL-server-2005

Silverlight Application with WCF Service and Child Windows as Popups - Part 1

13 May 2011

Balwant.mnd

Silverlight application for scheduling a meeting

SQL-Server-2008

Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth

23 Oct 2013

BharatRamV

Distributed transaction between MS SQL Server and MariaDB - A myth.

SQL-Server-2008

Business Logic with Entity Framework

26 May 2009

Bishoy Demian

How to use Entity framework to do some basic logic when a change happens in related Entities or Associations

SQL-server-2005

How to Use a Multi-Result Set Stored Procedure in SSIS

31 Dec 2008

BobP1339

How to use a script component as a data source for multi-result set Stored Procedures.

SQL-Server-2008

SQL-server-2005

Multi Language Reports in SSRS

31 Mar 2009

BobP1339

Explains how to do multi language reports in SSRS

SQL-Server-2008

SQL-server-2005

Walkthrough: Filtering and Updating in an N-Tier Data Application

15 Jan 2009

Brian C Hart

Builds on the Microsoft N-Tier Data Application walkthrough to add filtering and updating features.

SQL-Server-2008

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

18 Oct 2013

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

Visual Representation of SQL Joins

4 Feb 2009

C.L. Moffatt

This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.

SQL-server-2005

SQL-server-2000

SQL Wizardry Part 2 - Select, beyond the basics

12 Mar 2014

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

SQL Wizardry Part Three - Common Table Expressions (CTEs)

12 Jan 2014

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 Four - passing lists of data to SQL Server

12 Jan 2014

Christian Graus

In which we talk of ways to pass an arbitrary list of values to SQL Server

SQL-server-2005

SQL-Server-2008

SQL-server-2000

SQL Wizardry Part Five - when not to use DISTINCT

6 Jan 2014

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

SQL Wizardry Part Six - Windowing Functions

13 Jan 2014

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 Seven - PIVOT and arbitrary lists of data

16 Jan 2014

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 Eight - Tally Tables

21 Jan 2014

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

Thinking in SQL - Generating Random Numbers

23 Jan 2014

Christian Graus

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

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Thinking in SQL - Working with dates

14 Mar 2014

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

How to Non-alphabetically Sort GridView Columns with Text Data

22 Apr 2009

Christopher Geyer

Creating a sortable GridView is easy. But, what if you want to perform a nonalphabetic sort on a column that is alphabetical? Answer below...

SQL-server-2005

SQL-server-2000

Inversion of Control with nHydrate

10 Dec 2009

Christopher R Davis, Michael S Knight

Generate applications using Inversion of Control with the nHydrate code generator.

SQL-server-2005

nHydrate Generator Template

31 Dec 2009

Christopher R Davis, Michael S Knight

Extend nHydrate with your own custom generator templates.

SQL-Server-2008

SQL-server-2005

Generate Classes and CRUD Procedures

5 May 2009

ColinBashBash

Generate classes / CRUD procedures.

SQL-server-2005

SQL-server-2000

Visual Studio 2010 and Microsoft SQL 2008- Authentication System using ASP.NET (JQuery, Json and Web services)

9 May 2010

composeme

How to call server side methods or functions directly using JQuery in ASP.NET C#

SQL-Server-2008

Generate XML from SQL Server 2008 and update the database from XML

19 Jul 2012

CrinaT

How to generate XML from SQL Server 2008 DB and update DB from XML.

SQL-Server-2008

SQL Server Date Format Language

23 May 2012

Cristhian Selah

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

SQL-Server-2008

SQL-server-2005

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015

csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

SQL-Server-2008

SQL-server-2008R2

stored-procedure

Configuring SQL Server Accent-Insensitivity

21 Feb 2012

Daniel Miller

This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.

SQL-Server-2008

Getting Started With SSIS Script transforms

20 Aug 2012

Daniel_Wheeler

Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.

Thread-safety with SQL Server 2008

16 Jun 2013

Darek Danielewski

The subject of thread safety is often overlooked by even experienced developers. When designing an application or service to be utilized by multiple internal and external threads, one must account for potential issues arising from concurrent access to shared data.

SQL-Server-2008

SSRS 2012 Forms Authentication

24 Jan 2014

Darey

SQL Server Reporting services forms authentication implementation

SQL-Server-2008

Reading sql_variant in Entity Framework

8 Jan 2011

dasblinkenlight

Working around an Entity Framework exclusion of sql_variant

SQL-Server-2008

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

19 Dec 2011

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

Regular Expressions in MS SQL Server 2005/2008

11 Oct 2009

db_developer

describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration

SQL-Server-2008

SQL-server-2005

SyBASE ASE vs Microsoft SQL Server at Hierarchy Building Sample

30 Sep 2010

db_developer

This article describes how modern industrial RDBMSs solve hierarchy building task, by the way SyBASE ASE and Microsoft SQL Server SQL are compared

SQL-Server-2008

Understanding Three Layer Architecture and its Implementation in C# .NET

8 Nov 2013

Debopam Pal

What is three layer architecture and how to implement it.

An End-To-End LightSwitch HTML Example

15 Jun 2013

defwebserver

Step-by-step tutorial to create a HTML5 LightSwitch application

SQL Server Easy Column Search

11 Jan 2010

Divan van der Watt

Column search functionality that works as easy as sp_help.

SQL-Server-2008

SQL-server-2005

How SQL Server deletes records

30 Apr 2012

DLM@TD

How SQL Server deletes records

SQL-Server-2008

SQL-server-2005

FIPS Encryption Algorithms and Implementation of AES in C# and SQL Server 2008

2 Oct 2013

Dnyaneshwar Pawar

Implementation of AES in C# and SQL Server 2008.

SQL-Server-2008

CDC - Change Data Capture

13 Sep 2009

Donsw

Audit of SQL inserts, udpates, and deletes

SQL-Server-2008

Upload and Download Files with SQL Server in ASP.NET

1 Jan 2012

Dr. Song Li

This article presents an example to upload and download files with SQL Server in ASP.NET.

SQL-Server-2008

Storing Images in SQL Server using EF and ASP.NET

24 Oct 2013

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

Using LINQ to SQL in N-Tier Architectures

27 Feb 2009

emad_awad

How to use LINQ to SQL in N-Tier architectures.

SQL-server-2005

WCF by Example - Introduction

28 May 2013

Enrique Albert

Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate

WCF by Example - Chapter I - Baseline

19 Dec 2012

Enrique Albert

First draft version of the model, repository, and services.

WCF by Example - Chapter II - Repositories

5 Nov 2010

Enrique Albert

Introducing the RepositoryLocator pattern.

SQL-server-2005

WCF by Example - Chapter V - Contexts

23 Oct 2012

Enrique Albert

Global and Request context pattern for server side resources

WCF by Example - Chapter VI - WPF Client - Baseline

23 Oct 2012

Enrique Albert

Baseline WCF Client application using the MVVM pattern

WCF by Example - Chapter VII - Decoupling of WCF Services from the ViewModel

11 Oct 2011

Enrique Albert

Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.

WCF by Example - Chapter VIII - WPF Client - Relay Command

11 Oct 2011

Enrique Albert

WPF ICommand implementation based on Josh Smith's pattern.

WCF by Example - Chapter IX - WPF Client - Notify Property Change

11 Oct 2011

Enrique Albert

WPF INotifyPropertyChanged implementation.

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

14 Oct 2011

Enrique Albert

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

SQL-server-2005

WCF by Example - Chapter XI - NHibernate Implementation

14 Oct 2011

Enrique Albert

Unit of work pattern on NHibernate using repositories.

SQL-server-2005

WCF by Example - Chapter XII - WCF Implementation

18 Dec 2010

Enrique Albert

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

SQL-server-2005

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

7 Jan 2011

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 XIV - Validation & Exception Management

25 Oct 2012

Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

SQL-server-2005

Restoring SQL Server Express 2008 Database with Click Once

15 Nov 2010

Ferhat_Karatas

Restoring SQL Server Express 2008 Database with Click Once

SQL-Server-2008

entity-framework

Small Paging Control for Windows Presentation Foundation (WPF)

27 Jun 2012

freedeveloper

A small control to control paging in Windows Presentation Foundation.

SQL-server-2005

Fingerprint Reader Integration using the M2SYS SDK

10 Aug 2009

Friedrich Brunzema

An article exploring integrating a fingerprint reader into a user's application

Using Silverlight in Enterprise: RAD of User Friendly Database Access

31 Jul 2009

fulcrumweb

This article introduces FulcrumWeb RAD Framework - A Silverlight UI Engine to build user friendly database driven applications

C# and Table Value Parameters

20 Aug 2009

gaurav_verma_mca

How to send bulk data using table value parameters from C#

Transaction Management Across Application Domains

11 Oct 2009

gaurav_verma_mca

This article details out the best practices of transaction management across application domains

SQL-server-2005

Enterprise Configuration Management

23 Nov 2009

gaurav_verma_mca

Configuration of .NET applications using database

SQL-server-2005

How Do I: Use SQL File Stream

18 Nov 2010

gaurav_verma_mca

An end to end article describing how to use file stream data type in SQL Server. This article discusses both SQL Server and .NET side of things.

SQL-Server-2008

Constructing Web Interfaces on the Fly

26 Jan 2009

Gil Shabat

Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.

SQL-server-2005

SQL-server-2000

SqlTimeSpan

30 Jul 2009

Giovanni Bejarasco

Porting of System.TimeSpan as a SQL Server UDT.

SQL-Server-2008

SQL-server-2005

Inside Recursive CTEs

25 May 2010

gjvdkamp

A step by step explanation of how a recursive CTE actually works.

SQL-Server-2008

SQL-server-2005

Create INSERT batch files easily with ScriptBuilder

8 Dec 2009

Gordon Kushner

Utility program for generating SQL Server INSERT scripts

SQL-server-2005

SQL-server-2000

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

11 Oct 2011

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

SQL Server 2008 R2 Setup, Configurations & Remote Accessing using Java

3 May 2011

Green Mile

This article decribes SQL Server 2008 R2 setup, configurations & remote accessing using Java

SQL-Server-2008

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET

22 Aug 2014

Gurdeep Singh Toor

A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.

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

14 Aug 2013

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

AutoRefresh Entity Framework Data Using SQL Server Service Broker

14 Sep 2012

Harry von Borstel

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

SQL-Server-2008

SQL-server-2005

C# Project on Database for Beginners

6 Jan 2014

Hasan Habib Surzo

Class, Database Connection, Login Winform

SQL-server-2005

Optimization using SMO because of latency - SQL Server Management Object - To script table

7 Oct 2012

Hassan Boutougha

Workaround for SMO latency when scripting.

SQL-Server-2008

Market Basket Analysis in SSAS 2005+

28 Feb 2009

Igor Krupitsky

This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).

SQL-Server-2008

SQL-server-2005

Save and Retrieve PDF from SQL DB using SSRS and ASP.NET

18 Sep 2016

inishant12

Using SSRS report, generate the PDF, save it into DB and send it through mail using C#

.NET-Compiler-Platform

Use RegEx in SQL with CLR Procs

7 Aug 2017

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

Uncommon Common Table Expressions (CTEs)

25 Aug 2009

Jeremy Likness

Common table expressions (CTEs) are a powerful new construct for building advanced queries.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

White Stone Business Network: Bringing Businesses Closer to Their Customers

29 Apr 2013

JoewyCodes

White Stone Helps Businesses Give Their Customers Greater Value for their Money.

Event-Driven Architecture in the Clouds with Windows Azure

5 Feb 2010

John Mokkosian-Kane, Daniel Hsu

To demonstrate Azure and EDA, this article will show you how to build a flight delay management system for all US airports in clouds with Windows Azure.

SQL-Server-2008

Configuring IIS, ASP.NET, and SQL Server

29 Oct 2013

Juan Steyn

This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.

SQL-Server-2008

Build a Silverlight 2 Web Chat Application

12 Feb 2009

junnark

We are going to build a simple web chat application using Silverlight 2 and the technologies surrounding it like, ASP.NET 3.5, C#, WCF, and LINQ-to-SQL. We will use MS SQL Server to store user details and messages from this chat room.

SQL-server-2005

Build a Silverlight Web Chatroom with Multiple Rooms and Private Chat - Part 2

17 Mar 2009

junnark

In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.

SQL-server-2005

SQL-server-2000

How to Config Linked Servers in a Minute

29 Apr 2009

Kamran Hazari

How to create Linked servers in a minute in an easy way

SQL-server-2005

SQL-Server-2008

SQL-server-2000

SMO Tutorial 3 of n - Scripting

27 Feb 2011

Kanasz Robert

1 alternative

In this article, I will show you how to use the scripting functions of SMOs.

SQL-Server-2008

Library for scripting SQL Server database objects with examples

8 Nov 2011

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

Dynamic Cross Tabs and Pivots, A Different Approach

23 Sep 2010

Kannan K R

In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Custom Membership Providers - Task Manager

9 Apr 2011

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

SQL Server Schema Comparison Tool in Visual Studio 2010

14 Jan 2011

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

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

11 Feb 2011

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

Microsoft SQL Server 2008 - Change Data Capture (CDC)

8 Mar 2011

Keshav Singh

CDC is a new feature for logging DML changes. In this article, we will see how CDC could be put to use and how efficiently it could serve our purpose.

SQL-Server-2008

Audits on MS SQL Server 2008

8 Mar 2011

Keshav Singh

An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.

SQL-Server-2008

Policy Based Management in SQL Server 2008

13 May 2011

Keshav Singh

SQL Server 2008 provides a very efficient SQL policy administrator which constantly monitors the server and reports errors appropriately. Administrators can define policies and ensure that they are being adhered to by evaluating the policies.

SQL-Server-2008

Log Shipping MS SQL Server 2008 - Part I

26 May 2011

Keshav Singh

Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the first part.

SQL-Server-2008

Log Shipping MS SQL Server 2008 - Part II

26 May 2011

Keshav Singh

Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the second part.

SQL-Server-2008

Generic grid search and data paging

25 Jan 2010

KevGUID

Generic grid search and data paging explained.

Graphical Representation of Data in ASP.NET Web Page

24 Jun 2015

Khaled Abdelhamid

Drawing on a web page on the fly using GDI+ and Flood-Fill Technique

SQL-Server-2008

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

28 Mar 2013

Khorshed Alam, Dhaka

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

SQL-server-2005

SQL-server-2000

Keep everyone away from breaking your database object naming convention with SQL Server Policy Based Management.

19 Feb 2013

Khorshed Alam, Dhaka

Standardization database object name with SQL Server Policy Based Management.

SQL-Server-2008

Simplify Database Operations with Generic Fluent NHibernate

30 May 2012

Kieran Maltz, Cayen Systems

This article describes database communication using a generic Fluent NHibernate implementation.

Direct access to C++ native code from C++/CLI MSSQL Stored Procedure

19 Sep 2014

Konstantin Tchoumak

Reading hardware information in Stored Procedure

DBMapper - A new ORM tool

2 May 2013

Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

SQL-server-2005

SQL Server Performance Impacted by New Features

11 Oct 2011

KP Lee

Specific example for improving some SQL performance problems

SQL-Server-2008

SQL-server-2005

Dynamic Excel file loading with SSIS

23 Apr 2012

Kuthuparakkal

SSIS and Excel Automation

SQL-Server-2008

Minimalistic Driver-less Native MySql Client

11 May 2009

Ladislav Nevery

Native MySql Client not requiring any special driver or library

SQL-server-2005

SQL-server-2000

Generating Class Representations Of SQL Tables

24 Dec 2009

lampiclobe

Automatically parses SQL tables into C# classes with functions like insert, select, etc.

SQL-Server-2008

Binary Copy files in T-SQL with helps of CLR

22 Jan 2013

Levente Kupás

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

SQL-Server-2008

SQL-server-2005

T-SQL reporting engine

20 Jun 2013

Levente Kupás

If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.

SQL-Server-2008

Automatic Table Generation in any database by NHibernate ORM and CodeDom for code generation

27 Mar 2015

Mahsa Hassankashi

This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase and etc just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.

SQL-Server-2008

Security On The Web By Advanced Encryption Standard (AES) and Security Assertion Markup Language (SAML)

30 Aug 2015

Mahsa Hassankashi

Best approach for have more secure channel to transfer user information throughout the web

Table Data Sharing Across Stored Procedures

8 Aug 2012

ManojKumar19

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

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Generic Database Access

10 Jun 2013

Mario Stopfer

Generic database access model which generalizes the interactions with any particular database system.

SQL-Server-2008

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

3 Oct 2016

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

How to export data from database tables to an XML file using SSIS

18 Aug 2013

Maxim Rudoi

A simple way to create an XML file from SQL Server tables using SSIS

SQL-Server-2008

19 Jun 2013

Mayank Dubey

XQuery basics.

SQL-Server-2008

SQL-server-2005

How To Store Any File into SQL Database

22 May 2009

Md. Marufuzzaman

An easy technique to store any file into SQL database

SQL-server-2005

SQL-Server-2008

SQL-server-2000

How to Integrate an OLE Object with SQL Server

15 Jun 2009

Md. Marufuzzaman

This article will demonstrate how we can integrate T-SQL with an external application.

SQL-server-2005

SQL-server-2000

Get SQL Table Information

19 Jul 2009

Md. Marufuzzaman

Get SQL Table Information

SQL-Server-2008

SQL-server-2005

How Many Records Are There in your Database?

20 Jul 2009

Md. Marufuzzaman

How many records are there in your database?

SQL-Server-2008

SQL-server-2005

Procedure to Shrink the Database Transaction Log

25 Jul 2009

Md. Marufuzzaman

This article will demonstrate the procedure to shrink the database transaction log.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Get List of Extended storedProcedures that are Allowed to you for Common Use

26 Jul 2009

Md. Marufuzzaman

An easy way to get a list of extended storedProcedure allowed to you for common use

SQL-Server-2008

SQL-server-2005

How Do I Protect My Stored Procedure Code

29 Jul 2009

Md. Marufuzzaman

This article will demonstrate the best practice to protect SQL server code object.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Overview of SQL Server Stored Procedure

13 Jul 2010

Md. Marufuzzaman

Overview of SQL server stored procedure

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Overview of SQL Server database Triggers

7 Aug 2009

Md. Marufuzzaman

Overview of SQL Server database Triggers

SQL-server-2005

SQL-Server-2008

SQL-server-2000

An Easy But Effective Way to Split a String using Transact-SQL

9 Aug 2009

Md. Marufuzzaman

This article will demonstrate how to split a string using Transact-SQL.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL

9 Aug 2009

Md. Marufuzzaman

This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Overview of SQL Server 2005/2008 Table Indexing (Part-1)

25 Aug 2009

Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

SQL-Server-2008

SQL-server-2005

A Simple Use of SQL CASE Expression

19 Aug 2009

Md. Marufuzzaman

This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Global Variables in SQL Server

19 Aug 2009

Md. Marufuzzaman

A list of Global variables in SQL Server and their uses in Transact-SQL

SQL-server-2005

SQL-server-2000

Generate SQL Script Programmatically

8 Sep 2009

Md. Marufuzzaman

How to generate SQL object script using C#.NET

SQL-server-2005

A simple example of SQL server admin tools.

13 Sep 2009

Md. Marufuzzaman

A simple example of SQL server admin tools.

SQL-server-2005

SQL-server-2000

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

24 Oct 2009

Md. Marufuzzaman

Cannot alter Microsoft SQL Server 2008 Table Object in design mode

SQL-Server-2008

Few Step(s) to Remove SQL Server Database User(s)

21 Mar 2010

Md. Marufuzzaman

Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.

SQL-Server-2008

SQL-server-2005

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

10 Jun 2011

Md. Marufuzzaman

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

SQL-server-2005

Stored Procedure for Single & List Object in ASP.NET MVC with angularJS

9 Oct 2016

Md._Mehedi_Hasan

CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.

jQuery Mobile AutoComplete in ASP.NET with SQL Server Database Connection

12 Dec 2013

Mehmet Murat TANDOĞAN

How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.

Microsoft Visual Studio LightSwitch Business Application Development

28 Nov 2011

Member 7656529

A review of the book Microsoft Visual Studio LightSwitch Business Application Development.

Making OUTER and CROSS APPLY work for you

6 Aug 2013

Michiel du Toit

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

SQL-Server-2008

SQL-server-2005

Calculating Tree Cost in Microsoft SQL Server

2 Jan 2014

mihirj

This article explains database schema design for storing tree structure and an algorithm to compute its cost.

SQL-Server-2008

VS2010 1-Click Publishing

6 Nov 2009

mohamad halabi

Shows the new 1-Click deployment feature of VS2010.

SQL-Server-2008

Passing an Array as Parameter to SQL Server Procedure

13 May 2009

Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

SQL-server-2005

SQL-server-2000

Persian Diary in WPF

6 Jan 2010

Mohammad Dayyan

With Persian Diary, you can navigate in Persian Calendar and store your memorandums

Jotdown

3 May 2013

Mohan Mallampalli

A HTML5 note taking app capable of capturing Video notes.

SQL-Server-2008

Kerosene Dynamic Data Services

11 Mar 2014

Moises Barba

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

Create and Populate Date Dimension for Data Warehouse

4 Sep 2013

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

Learn to Write Custom MDX Query First Time

17 Jan 2014

Mubin M. Shaikh

Learn Custom MDX Query Step by Step

SQL-Server-2008

SQL-server-2005

Optimized Paging and Sorting using Object Data Source

8 Sep 2009

Muhammad Akhtar Shiekh

An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.

SQL-server-2005

SQL-server-2000

Date and Time as Separated Types

25 May 2010

Muhammad alaa

use date and time as separated components in SQL Server 2000 and above

SQL-server-2005

SQL-Server-2008

SQL-server-2000

Change Data Capture (SQL Server 2008)

11 Aug 2008

Muhammad Shujaat Siddiqi

Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)

SQL-Server-2008

Connection Pooling in ASP.NET

6 Dec 2009

Muhusin Khan

Effective perfomance for database application uses database

SQL-server-2005

Loading a TreeView using HierarchyID

5 Jun 2009

Mycroft Holmes

Using SQL Server 2008 Hierarchy ID data type to populate a TreeView

SQL Server Database Development in Visual Studio

1 Sep 2016

NaibedyaKar

SQL Server database project creation using Visual Studio 2013

SQL-server-2005

Handling SOAP Exceptions in WCF Based Applications

4 Sep 2013

Nandha V

Using a custom exception handler component

SQL-Server-2008

Sql Server In Clause With Multiple Literal Values Performance Behaviour

26 Aug 2016

Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL-Server-2008

SQL-server-2005

Step by Step Introduction to Microsoft SQL AZURE

19 Feb 2010

Niladri_Biswas

Step by step introduction to Microsoft SQL AZURE

SQL-Server-2008

SQL-server-2005

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

28 Apr 2011

Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

SQL-Server-2008

Copy Files from One Location to Another and Rename Them after Putting Time Stamp

28 Apr 2011

Niladri_Biswas

A program to demonstrate the copy files from one location to another and rename them after putting time stamp by using Sequence Container, Foreach Loop Container, File System Task and Script task

SQL-Server-2008

Working with Pivot and UnPivot Transformation

10 May 2011

Niladri_Biswas

This article will describe in simple ways as how to work with Pivot and Unpivot transformation component

SQL-Server-2008

An indespensible SSIS transformation component - Script Component

10 May 2011

Niladri_Biswas

This article will demonstrate as how to work with SSIS Script component with two live example

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part III (SSIS Features in CTP 1)

10 May 2011

Niladri_Biswas

In this article we will explore on the new features that Denali has offer us from SSIS perspective

SQL-Server-2008

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

12 May 2011

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

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

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

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

19 May 2011

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

An Introduction to Sql 11 (Code Name Denali) -Part IV (Contained Database in CTP 1)

19 May 2011

Niladri_Biswas

In this article we will look into the basics of Contained Database that has been shipped with Sql 11 (Code Name: Denali) CTP 1

SQL-Server-2008

Create custom transformation component(Email Validator) in SSIS- Step by step

3 Aug 2011

Niladri_Biswas

In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part VI (T-Sql Features in CTP 3)

2 Sep 2011

Niladri_Biswas

In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective

SQL-Server-2008

An Introduction to SSIS Balanced Data Distributor Transformation Component

31 Aug 2011

Niladri_Biswas

In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part VII (Column Store Index in CTP 3)

2 Sep 2011

Niladri_Biswas

In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part VIII (Data Quality Services(DQS) in CTP 3)

3 Sep 2011

Niladri_Biswas

In this article we will explore the Data Quality Services(DQS)- A new feature in SSIS Denali CTP3

SQL-Server-2008

Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190306.1 | Last Updated 24 Mar 2019

Copyright © CodeProject, 1999-2019
All Rights Reserved.

Layout: fixed | fluid