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 Server

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

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!

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.

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

How to Install and Configure SharePoint Server 2010 RTM

25 Nov 2011 by Syed Adnan Ahmed

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

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

STSADM Backup Error: The backup is from a different version of SharePoint

12 Apr 2012 by Soptik Dutta

Explains an alternative way of stsadm restoration of a Site Collection.

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.

SQL Query Optimization FAQ Part 1 (With video explanation)

12 Apr 2012 by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)

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

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.

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

12 Apr 2012 by Md. Marufuzzaman

Cannot alter Microsoft SQL Server 2008 Table Object in design mode

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

PHP + Microsoft Overview

12 Apr 2012 by dougturn

An overview of the Microsoft interoperability story for Open Source community and PHP Developers.

A Crontab Linux like Windows Service

1 May 2012 by marcominas

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

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

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

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

MOSS 2007 – Enabling Forms Authentication

12 Apr 2012 by vivekthangaswamy

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

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