Click here to Skip to main content

Submit your article

SQL 2005

SQL2005

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

How to Restore SQL Server 2005 Suspect Database

by Suvendu Banik

How to Restore SQL Server 2005 Suspect Database

Import Data to SQL Server from Excel or Access using TSQL Script

by Waynes World

An article on importing data from external data sources to SQL server without using wizards

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

by Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

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

by Md. Marufuzzaman

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

All Articles

SQL 2005

Overview of SQL Server Stored Procedure

12 Apr 2012 by Md. Marufuzzaman

Overview of SQL server stored procedure

Recover SQL Server 2005 Database from SUSPECT Mode

14 Nov 2011 by Aruna Randeni

Recover SQL server 2005 database from SUSPECT mode

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

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

25 Nov 2011 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!

SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database

25 Nov 2011 by pinaldave

SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database

Developing Office SharePoint 2007 application

12 Apr 2012 by Moim Hossain

Describes how to develop custom business portal application using WSS 3.0 and Office SharePoint Server 2007

Disaster Recovery Plan In MOSS 2007

12 Apr 2012 by Tariq Younas

Article describes how to make backup and recovery plan of MOSS 2007.

Form Authentication for MOSS 2007 Site

12 Apr 2012 by NagendraGunaga

The purpose of this document is to provide the step by step information about enabling the Form Based Authentication (FBA) for MOSS 2007 site.

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

12 Apr 2012 by Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

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

12 Apr 2012 by Md. Marufuzzaman

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

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

12 Apr 2012 by Md. Marufuzzaman

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

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

12 Apr 2012 by Md. Marufuzzaman

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

Global Variables in SQL Server

12 Apr 2012 by Md. Marufuzzaman

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

Overview of SQL Server database Triggers

12 Apr 2012 by Md. Marufuzzaman

Overview of SQL Server database Triggers

How Do I Protect My Stored Procedure Code

12 Apr 2012 by 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 by Md. Marufuzzaman

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

11 Important Database designing rules which I follow

12 Apr 2012 by Shivprasad koirala

This article will discuss about 11 important database designing rules.

A Simple Use of SQL CASE Expression

12 Apr 2012 by 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.

How to Restore SQL Server 2005 Suspect Database

12 Apr 2012 by Suvendu Banik

How to Restore SQL Server 2005 Suspect Database

Import Data to SQL Server from Excel or Access using TSQL Script

12 Apr 2012 by Waynes World

An article on importing data from external data sources to SQL server without using wizards

MOSS 2007 – Enabling Forms Authentication

12 Apr 2012 by vivekthangaswamy

An article about how Forms Authentication is enabled in Microsoft Office SharePoint Server 2007

SQL Server Procedures And Functions Encryptions

25 Nov 2011 by Mohammad A Gharakhanlou

this application is answer for ;How to encrypt sql server procedures and functions at a time

SQL Query Optimization FAQ Part 1 (With video explanation)

12 Apr 2012 by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)