Click here to Skip to main content
984 members
SQL

SQL

Great Reads

by Md. Marufuzzaman
Overview of SQL server stored procedure
by Aruna Randeni
Recover SQL server 2005 database from SUSPECT mode
by Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
by Omar Al Zabir
Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance

Latest Articles

by marcominas
A Windows Service that uses interface to work like the Linux Crontab service
by Shivprasad koirala
Project Life Cycle beyond SDLC
by Garth Tissington
After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain
by Suvendu Banik
How to Restore SQL Server 2005 Suspect Database

All Articles

Sort by Title

SQL 

25 Nov 2011
Omar Al Zabir
Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance
1 May 2012
marcominas
A Windows Service that uses interface to work like the Linux Crontab service
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.
12 Apr 2012
Md. Marufuzzaman
This article will demonstrate how to split a string 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.
12 Apr 2012
Nilay Parikh
BizTalk Server 2006 / R2 Throttling Mechanisms, BizTalk 2006 / R2 comes with good relief in terms of performance and throttling mechanism, if you work close to administrating and performance tuning job for BizTalk environment or any messaging system then you can visualize the complexity of pick proc
25 Nov 2011
Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
21 Nov 2011
Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
25 Nov 2011
Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
12 Apr 2012
Moim Hossain
Describes how to develop custom business portal application using WSS 3.0 and Office SharePoint Server 2007
12 Apr 2012
Tariq Younas
Article describes how to make backup and recovery plan of MOSS 2007.
12 Apr 2012
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
12 Apr 2012
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
12 Apr 2012
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
12 Apr 2012
Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
12 Apr 2012
Suvendu Banik
How to Restore SQL Server 2005 Suspect Database
25 Nov 2011
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!
12 Apr 2012
Waynes World
An article on importing data from external data sources to SQL server without using wizards
12 Apr 2012
Garth Tissington
After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain
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.
25 Nov 2011
Dietmar Kurok
Showing People grouped by departments in an own style (XSLT) and without limits in count of results and paging. Only intensively using build-in Webparts.
12 Apr 2012
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
12 Apr 2012
Md. Marufuzzaman
Overview of SQL Server database Triggers
12 Apr 2012
Md. Marufuzzaman
Overview of SQL server stored procedure
12 Apr 2012
Abhijit Mahato
This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects
12 Apr 2012
Shivprasad koirala
Project Life Cycle beyond SDLC
14 Nov 2011
Aruna Randeni
Recover SQL server 2005 database from SUSPECT mode
12 Apr 2012
Shivprasad koirala
SQL Query Optimization FAQ Part 1 (With video explanation)
25 Nov 2011
pinaldave
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
25 Nov 2011
pinaldave
First article on topic - SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
12 Apr 2012
Shivprasad koirala
An article listing SQL Server Interview Questions
12 Apr 2012
prabhu.subbiah
To compress a SQL Server report which allows the user to download the report in Zip format.
12 Apr 2012
alifaraze
A trick to use config file for Custom assembly in reporting services