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

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

14 Jul 2020 by Mubin M. Shaikh

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

T-SQL

SQL

SQL-Server-2008

Azure

SQL Browser

2 Nov 2019 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)

3 Apr 2019 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

3 Apr 2019 by Mahsa Hassankashi

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.

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!

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

Improve Productivity by Redesigning DataBase Schema

9 Dec 2016 by Riccardo Cervelli

Redraw database structure to improve productivity

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

9 Oct 2016 by Md._Mehedi_Hasan

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

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.

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

18 Sep 2016 by inishant12

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

.NET-Compiler-Platform

SQL Server Database Development in Visual Studio

1 Sep 2016 by NaibedyaKar

SQL Server database project creation using Visual Studio 2013

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

SMO Tutorial 3 of n - Scripting

24 Jan 2016 by RickZeeland

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

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015 by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

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

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

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.

Calculating simple running totals in SQL Server

12 Dec 2014 by Wendelius

Some simple scenarios to calculate running totals in SQL Server.

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.

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

19 Sep 2014 by Konstantin Tchoumak

Reading hardware information in Stored Procedure

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.

Storing and Retrieving Images from SQL Server Using Strored Procedures and C#

12 Aug 2014 by Thilina Chandima

An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.

Load More Records in ASP.NET Gridview on Button Click from SQL Server Table

1 Jun 2014 by Webcodeexpert.com

In this article, I am going to demonstrate how to get more data on demand i.e. On every click of button fetch more records from SQL Server database table and load in GridView with wait/progress/loading image as shown in image in ASP.NET using both C# and VB languages.

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

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

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

SSRS 2012 Forms Authentication

24 Jan 2014 by Darey

SQL Server Reporting services forms authentication implementation

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

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

Learn to Write Custom MDX Query First Time

17 Jan 2014 by Mubin M. Shaikh

Learn Custom MDX Query Step by Step

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

C# Project on Database for Beginners

6 Jan 2014 by Hasan Habib Surzo

Class, Database Connection, Login Winform

Calculating Tree Cost in Microsoft SQL Server

2 Jan 2014 by mihirj

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

Windows

SQL-Server-2008

SQL-Server

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.

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

12 Dec 2013 by Mehmet Murat TANDOĞAN

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

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.

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.

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.

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

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.

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!

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

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.

Layered Application Design Pattern

25 Sep 2013 by Rajan Patekar

N-tier architecture of Project

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.

Handling SOAP Exceptions in WCF Based Applications

4 Sep 2013 by Nandha V

Using a custom exception handler component

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

18 Aug 2013 by Maxim Rudoi

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

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.

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

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)

SSIS: By coding

14 Jul 2013 by ThatsAlok

Step by Step creation of SSIS package using C#

SSIS: By coding Part 2

26 Jun 2013 by ThatsAlok

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

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.

XQuery basics

19 Jun 2013 by Mayank Dubey

XQuery basics.

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

An End-To-End LightSwitch HTML Example

15 Jun 2013 by defwebserver

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

Using WCF REST HTTP to call Stored Procedures on SQL Server

11 Jun 2013 by Tom Glick Philadelphia, US

Using WCF REST Service to call Stored Procedures and run queries on SQL Server.

Generic Database Access

10 Jun 2013 by Mario Stopfer

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

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

Jotdown

3 May 2013 by Mohan Mallampalli

A HTML5 note taking app capable of capturing Video notes.

DBMapper - A New ORM Tool

2 May 2013 by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

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

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.

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.

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

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.

WCF by Example - Chapter I - Baseline

19 Dec 2012 by Enrique Albert

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

N - tier project with WCF OData service, Entity Framework, MVC3.0, Ninject DI, jSOn.net and Automapper

10 Dec 2012 by Vijay Tanwar

N-Tier application with WCF Odata service and Entity Framework.

WCF by Example - Chapter XIV - Validation & Exception Management

25 Oct 2012 by Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

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

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

7 Oct 2012 by Hassan Boutougha

Workaround for SMO latency when scripting.

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

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

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

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.

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.

An Alternative to Sync Data from SQL Server to MySQL

16 Aug 2012 by scott_liu