SQL Server 2008

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.

Rename a Database and its MDF and LDF files in SQL Server

by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Latest Articles

Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!

by Mubin M. Shaikh

Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

SQL Browser

by Alaa Ben Fatma

Explore your MMSQL server tables in a professional way

Security on the Web by Advanced Encryption Standard (AES) and Security Assertion Markup Language (SAML)

by Mahsa Hassankashi

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

Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation

by Mahsa Hassankashi

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

All Articles

top

SQL Server 2008

Simple Data Access in C#

11 Jan 2009 by 6opuc

Fast and easy to use data access class library.

C#3.0

C#2.0

.NET3.0

A LINQ Tutorial: Mapping Tables to Objects

12 Dec 2009 by 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.

A LINQ Tutorial: Adding/Updating/Deleting Data

11 Dec 2009 by 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.

A LINQ Tutorial: WPF Data Binding with LINQ to SQL

11 Dec 2009 by 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 Framework

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.

Quick Overview: Temporary Tables in SQL Server 2005

22 Sep 2009 by Abhijit Jana

Basic overview of temporary Tables in SQL Server 2005

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

2 Aug 2009 by Abhishek Sur

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

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

2 Aug 2009 by Abhishek Sur

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

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

27 Sep 2009 by acarpio1975

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

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.

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 by AhsanAhmed

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

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017 by AhsanAhmed

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

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

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

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

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 by 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 Browser

2 Nov 2019 by Alaa Ben Fatma

Explore your MMSQL server tables in a professional way

A scheduler GUI for SQL Server Agent

10 May 2012 by Alberto Venditti

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

A general-purpose service engine for unattended processing execution

23 Sep 2015 by Alberto Venditti

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

Using SQL Bulk Load to Upload Fixed Width Text Files

3 Mar 2009 by 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.

Set Based and Procedural Approaches in Examples

4 Jan 2010 by Alexandru Cibotari

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

SQL-Server-2008

SQL-Server

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

26 Jul 2009 by AlexS9999

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

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

16 Jan 2009 by Alfredo_Fernandez

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

How to change ConnectionString easily

6 Feb 2010 by Ali Marzban

Changing ConnectionString like an attribute in C#

Peer to Peer File Sharing Through WCF

10 Jan 2018 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.

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

26 Aug 2009 by Andy_L_J

Generate unique column values using UDFs and Stored Procedures

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

9 Oct 2009 by Andy_L_J

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

Report Service 2008 R2 - Delivery Extension User Control

7 Feb 2013 by 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 by AnupKumarYadav

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

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

SharePoint 2010 Logging Database

6 Apr 2010 by Ayman M. El-Hattab

Four reasons to directly query SharePoint logging database

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

13 May 2011 by Balwant.mnd

Silverlight application for scheduling a meeting

Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth

23 Oct 2013 by BharatRamV

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

Business Logic with Entity Framework

26 May 2009 by Bishoy Demian

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

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

31 Dec 2008 by BobP1339

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

Multi Language Reports in SSRS

31 Mar 2009 by BobP1339

Explains how to do multi language reports in SSRS

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

15 Jan 2009 by Brian C Hart

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

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!

Visual Representation of SQL Joins

3 Feb 2009 by C.L. Moffatt

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

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

Thinking in SQL - Generating Random Numbers

23 Jan 2014 by Christian Graus

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

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

How to Non-alphabetically Sort GridView Columns with Text Data

22 Apr 2009 by 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...

Inversion of Control with nHydrate

10 Dec 2009 by Christopher R Davis, Michael S Knight

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

nHydrate Generator Template

31 Dec 2009 by Christopher R Davis, Michael S Knight

Extend nHydrate with your own custom generator templates.

Generate Classes and CRUD Procedures

5 May 2009 by ColinBashBash

Generate classes / CRUD procedures.

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

9 May 2010 by composeme

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

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

19 Jul 2012 by CrinaT

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

SQL Server Date Format Language

23 May 2012 by Cristhian Selah

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

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015 by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

Configuring SQL Server Accent-Insensitivity

21 Feb 2012 by 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.

Getting Started With SSIS Script transforms

20 Aug 2012 by 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 by 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

SQL-Server

threads

SSRS 2012 Forms Authentication

24 Jan 2014 by Darey

SQL Server Reporting services forms authentication implementation

Reading sql_variant in Entity Framework

8 Jan 2011 by dasblinkenlight

Working around an Entity Framework exclusion of sql_variant

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.

Regular Expressions in MS SQL Server 2005/2008

11 Oct 2009 by db_developer

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

SyBASE ASE vs Microsoft SQL Server at Hierarchy Building Sample

30 Sep 2010 by 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

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

8 Nov 2013 by Debopam Pal

What is three layer architecture and how to implement it.

An End-To-End LightSwitch HTML Example

15 Jun 2013 by defwebserver

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

SQL Server Easy Column Search

11 Jan 2010 by Divan van der Watt

Column search functionality that works as easy as sp_help.

How SQL Server deletes records

30 Apr 2012 by DLM@TD

How SQL Server deletes records

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

2 Oct 2013 by Dnyaneshwar Pawar

Implementation of AES in C# and SQL Server 2008.

CDC - Change Data Capture

13 Sep 2009 by Donsw

Audit of SQL inserts, udpates, and deletes

Upload and Download Files with SQL Server in ASP.NET

1 Jan 2012 by Dr. Song Li

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

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

Using LINQ to SQL in N-Tier Architectures

27 Feb 2009 by emad_awad

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

WCF by Example - Introduction

28 May 2013 by 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 by Enrique Albert

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

WCF by Example - Chapter II - Repositories

5 Nov 2010 by Enrique Albert

Introducing the RepositoryLocator pattern.

WCF by Example - Chapter V - Contexts

23 Oct 2012 by Enrique Albert

Global and Request context pattern for server side resources

WCF by Example - Chapter VI - WPF Client - Baseline

23 Oct 2012 by 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 by Enrique Albert

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

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

11 Oct 2011 by Enrique Albert

WPF ICommand implementation based on Josh Smith's pattern.

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

11 Oct 2011 by Enrique Albert

WPF INotifyPropertyChanged implementation.

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.

WCF by Example - Chapter XI - NHibernate Implementation

14 Oct 2011 by Enrique Albert

Unit of work pattern on NHibernate using repositories.

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.

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.

WCF by Example - Chapter XIV - Validation & Exception Management

25 Oct 2012 by Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

Restoring SQL Server Express 2008 Database with Click Once

15 Nov 2010 by Ferhat_Karatas

Restoring SQL Server Express 2008 Database with Click Once

Small Paging Control for Windows Presentation Foundation (WPF)

27 Jun 2012 by freedeveloper

A small control to control paging in Windows Presentation Foundation.

Fingerprint Reader Integration using the M2SYS SDK

10 Aug 2009 by 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 by 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 by gaurav_verma_mca

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

Transaction Management Across Application Domains

11 Oct 2009 by gaurav_verma_mca

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

Enterprise Configuration Management

23 Nov 2009 by gaurav_verma_mca

Configuration of .NET applications using database

How Do I: Use SQL File Stream

18 Nov 2010 by 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.

Constructing Web Interfaces on the Fly

26 Jan 2009 by Gil Shabat

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

SqlTimeSpan

30 Jul 2009 by Giovanni Bejarasco

Porting of System.TimeSpan as a SQL Server UDT.

Inside Recursive CTEs

25 May 2010 by gjvdkamp

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

Create INSERT batch files easily with ScriptBuilder

8 Dec 2009 by Gordon Kushner

Utility program for generating SQL Server INSERT scripts

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 2008 R2 Setup, Configurations & Remote Accessing using Java

3 May 2011 by Green Mile

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

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

22 Aug 2014 by 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 by Harmen Brouwer