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

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.

.NET

.NET3.5

SQL-Server

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.

Dynamic Excel file loading with SSIS

23 Apr 2012 by Kuthuparakkal

SSIS and Excel Automation

Small Paging Control for Windows Presentation Foundation (WPF)

27 Jun 2012 by freedeveloper

A small control to control paging in Windows Presentation Foundation.

WCF by Example - Chapter XIV - Validation & Exception Management

25 Oct 2012 by Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

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.

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

27 Apr 2011 by Niladri_Biswas

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

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.

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

T-SQL reporting engine

20 Jun 2013 by Levente Kupás

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

SqlTimeSpan

30 Jul 2009 by Giovanni Bejarasco

Porting of System.TimeSpan as a SQL Server UDT.

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

19 Feb 2013 by Khorshed Alam, Dhaka

Standardization database object name with SQL Server Policy Based Management.

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

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

Graphical Representation of Data in ASP.NET Web Page

24 Jun 2015 by Khaled Abdelhamid

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

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

Table Data Sharing Across Stored Procedures

7 Aug 2012 by ManojKumar19

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

Refering dlls in SSIS Script Task

10 Apr 2015 by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

Microsoft Visual Studio LightSwitch Business Application Development

28 Nov 2011 by Member 7656529

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

Data Transformation from Rows to Columns Using Dynamic SQL

2 Jan 2013 by Tomz_KV

A custom solution to transform data from rows to columns using dynamic SQL.

Dynamically Create ASP Form from SQL Stored Procedure

17 Jul 2013 by Tom Glick Philadelphia, US

Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)

Multi Language Reports in SSRS

31 Mar 2009 by BobP1339

Explains how to do multi language reports in SSRS

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.

Dynamics AX Data Maintenance & Migration Tips

29 Jun 2012 by Venkat Chaitanya Kanumukula

Maintenance of Definition's in multiple Dynamics AX Environments

SSIS: By coding Part 2

26 Jun 2013 by ThatsAlok

Step by Step creation of SSIS package using C# with Conditional Split

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

SMO Tutorial 3 of n - Scripting

24 Jan 2016 by RickZeeland

This is an alternative for "SMO Tutorial 3 of n - Scripting"

Connectivity to SQL Azure in Microsoft SQL Server 2008 R2 November CTP

17 Nov 2009 by Ramy Mahrous

Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1

SQL Server Easy Column Search

11 Jan 2010 by Divan van der Watt

Column search functionality that works as easy as sp_help.

Log Shipping MS SQL Server 2008 - Part II

26 May 2011 by 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.

Mimicking null-safe equal to operator in SQL Server

20 Sep 2011 by Wendelius

This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.

STSADM Backup Error: The backup is from a different version of SharePoint

20 Sep 2011 by Soptik Dutta

Explains an alternative way of stsadm restoration of a Site Collection.

SQL Server Performance Impacted by New Features

11 Oct 2011 by KP Lee

Specific example for improving some SQL performance problems

Jotdown

3 May 2013 by Mohan Mallampalli

A HTML5 note taking app capable of capturing Video notes.

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

3 Apr 2019 by Mahsa Hassankashi

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

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

Custom Rule Engine in WPF - MVVM

11 Sep 2010 by Renil Joy, Bangalore

Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.

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

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

3 Apr 2019 by Mahsa Hassankashi

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.

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

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

11 Oct 2011 by Enrique Albert

WPF ICommand implementation based on Josh Smith's pattern.

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.

Procedure to Shrink the Database Transaction Log

25 Jul 2009 by Md. Marufuzzaman

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

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.

WCF by Example - Chapter V - Contexts

23 Oct 2012 by Enrique Albert

Global and Request context pattern for server side resources

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.

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

Event-Driven Architecture in the Clouds with Windows Azure

5 Feb 2010 by 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.

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!

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

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.

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.

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.

Global Variables in SQL Server

19 Aug 2009 by Md. Marufuzzaman

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

Restoring SQL Server Express 2008 Database with Click Once

15 Nov 2010 by Ferhat_Karatas

Restoring SQL Server Express 2008 Database with Click Once

An End-To-End LightSwitch HTML Example

15 Jun 2013 by defwebserver

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

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.

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.

Fast declarative typesafety with DynamicMethods for SQL

16 Oct 2013 by tcassisi

Generating typed field accessors and applying them to object mapping and SQL Stored Procedures

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

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

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

SQL-Server-2008

SQL-Server-2005

WCF by Example - Chapter VI - WPF Client - Baseline

23 Oct 2012 by Enrique Albert

Baseline WCF Client application using the MVVM pattern

Generic Database Access

10 Jun 2013 by Mario Stopfer

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

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.

Overview of SQL Server Stored Procedure

13 Jul 2010 by Md. Marufuzzaman

Overview of SQL server stored procedure

Configuring IIS, ASP.NET, and SQL Server

29 Oct 2013 by Juan Davel

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

SMO Tutorial 3 of n - Scripting

27 Feb 2011 by Kanasz Robert

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

How to Integrate an OLE Object with SQL Server

15 Jun 2009 by Md. Marufuzzaman

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

Backup SQL Server with Relative File Path and Progress

11 Jun 2010 by theit8514

This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.

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.

Weekly Thai Recipe! for Windows Phone

6 Jul 2012 by Patrick Kalkman

A complete WP7 application with a central management website (ASP.NET MVC4) for recipe management and push notifications

WCF by Example - Chapter XI - NHibernate Implementation

14 Oct 2011 by Enrique Albert

Unit of work pattern on NHibernate using repositories.

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)

How to pass multiple records to a Stored Procedure

2 Dec 2008 by Wendelius

How to pass multiple records to a Stored Procedure in a single roundtrip.

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

SQL Query Optimization FAQ Part 1 (With video explanation)

7 Jun 2011 by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)

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

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.

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

25 Aug 2009 by Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

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

20 Mar 2010 by 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.

HierarchyID Data Type in SQL Server 2008

10 Jun 2009 by Robin_Roy

MS SQL Server 2008 new feature, the HierarchyID data type.

SSIS: By coding

14 Jul 2013 by ThatsAlok

Step by Step creation of SSIS package using C#

VS 2010 Deployment (Package, One click deploy and Web.config transformation)

23 Aug 2010 by Shivprasad koirala

VS 2010 Deployment (Package, One click deploy and Web.config transformation)

Optimized Paging and Sorting using Object Data Source

7 Sep 2009 by Muhammad Akhtar Shiekh

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

Calculating simple running totals in SQL Server

12 Dec 2014 by Wendelius

Some simple scenarios to calculate running totals in SQL Server.

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.

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.

A simple example of SQL server admin tools.

13 Sep 2009 by Md. Marufuzzaman

A simple example of SQL server admin tools.

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

9 Aug 2009 by Md. Marufuzzaman

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

How to Config Linked Servers in a Minute

29 Apr 2009 by Kamran Hazari

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

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

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

Entity Framework Performance

12 Mar 2012 by Not Active

A comparison of performance between ADO.NET and Entity Framework.

Reading sql_variant in Entity Framework

8 Jan 2011 by dasblinkenlight

Working around an Entity Framework exclusion of sql_variant

Using LINQ to SQL in N-Tier Architectures

27 Feb 2009 by emad_awad

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

SQL Alpha Numeric Sort Using CLR Integration

13 Apr 2009 by shteff

How to do a sort on alphanumeric strings in SQL Server.

SQL Server Database Development in Visual Studio

1 Sep 2016 by NaibedyaKar

SQL Server database project creation using Visual Studio 2013

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.