SQL2008

Great Reads

Overview of SQL Server Stored Procedure

by Md. Marufuzzaman

Overview of SQL server stored procedure

Recover SQL Server 2005 Database from SUSPECT Mode

by Aruna Randeni

Recover SQL server 2005 database from SUSPECT mode

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

by Omar Al Zabir

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

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

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!

Latest Articles

Steps to install Microsoft SQL Server 2008 Express Edition (Standard or with Advanced Services)

by Jesus Carroll

This brief article show how to install quickly Microsoft SQL Server 2008 Express Edition Standard or with Advanced Services

SQL Query Optimization FAQ Part 1 (With video explanation)

by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)

Overview of SQL Server Stored Procedure

by Md. Marufuzzaman

Overview of SQL server stored procedure

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

by Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

All Articles

top

SQL2008

11 Important Database designing rules which I follow

12 Apr 2012

Shivprasad koirala

This article will discuss about 11 important database designing rules.

SQL2005

SQL-CE

SQL-Server

A Simple Use of SQL CASE Expression

12 Apr 2012

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.

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

12 Apr 2012

Md. Marufuzzaman

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

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

12 Apr 2012

Md. Marufuzzaman

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

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

25 Nov 2011

Omar Al Zabir

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

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

12 Apr 2012

Md. Marufuzzaman

Cannot alter Microsoft SQL Server 2008 Table Object in design mode

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

12 Apr 2012

Md. Marufuzzaman

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

Global Variables in SQL Server

12 Apr 2012

Md. Marufuzzaman

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

How Do I Protect My Stored Procedure Code

12 Apr 2012

Md. Marufuzzaman

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

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

12 Apr 2012

Md. Marufuzzaman

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

How to Install and Configure SharePoint Server 2010 RTM

25 Nov 2011

Syed Adnan Ahmed

This article describes step by step details of how to install and configure SharePoint Server 2010 RTM

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

25 Nov 2011

Brian C Hart

Microsoft SQL Server 2008 - Change Data Capture (CDC)

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