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

How to Restore SQL Server 2005 Suspect Database

by Suvendu Banik

How to Restore SQL Server 2005 Suspect Database

All Articles

top

SQL

Overview of SQL Server Stored Procedure

12 Apr 2012 by Md. Marufuzzaman

Overview of SQL server stored procedure

SQL

SQL2005

SQL-CE

SQL-Server

SQL2000

DBA

Dev

Recover SQL Server 2005 Database from SUSPECT Mode

14 Nov 2011 by Aruna Randeni

Recover SQL server 2005 database from SUSPECT mode

Database Export Wizard for ASP.NET and SQL Server

21 Nov 2011 by Evoluteur

A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL

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

SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search

25 Nov 2011 by pinaldave

First article on topic - SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search

MOSS 2007 Department and People Viewer Part 1/2

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

BizTalk Server 2006 / R2 Throttling Mechanisms

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

Pitfalls Encountered and their Workarounds during Development of BizTalk Projects

12 Apr 2012 by Abhijit Mahato

This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects

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.

SQL Server Interview Questions - Part 1

12 Apr 2012 by Shivprasad koirala

An article listing SQL Server Interview Questions

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

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

SQL Server Report Compress solution (Zip format)

12 Apr 2012 by prabhu.subbiah

To compress a SQL Server report which allows the user to download the report in Zip format.

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

Using config file for Custom Assembly in Reporting Services (Step by Step)

12 Apr 2012 by alifaraze

A trick to use config file for Custom assembly in reporting services

Install and Configure SQL Server for SQLCE replication

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

Project Life Cycle beyond SDLC

12 Apr 2012 by Shivprasad koirala

Project Life Cycle beyond SDLC

A Crontab Linux like Windows Service

1 May 2012 by marcominas

A Windows Service that uses interface to work like the Linux Crontab service

Database Export Wizard for ASP.NET and SQL Server

25 Nov 2011 by Evoluteur

A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL

SQL Query Optimization FAQ Part 1 (With video explanation)

12 Apr 2012 by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)

Microsoft SQL Server 2008 - Change Data Capture (CDC)

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

99.99% available ASP.NET and SQL Server SaaS Production Architecture

25 Nov 2011 by Omar Al Zabir