Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.

Code First with SQL CE

by Damijan Vodopivec

Sample Code First project with SQL CE 4.0 database

Code Review Checklist

by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

Coding an N-Tier Application in C# Without Any Wizard: Part II

by Vimalsoft(Pty) Ltd

Coding an N-Tier application in C# without using Wizards.

Convert a Text File to a PDF File

by Florence FZ Li

This article shows how to convert a text file to PDF.

Create a Modified On Column in SQL Server

by james.wren

How to add a modified on column in SQL Server using triggers.

Creating Pocket PC Application Setup Packages Using the CAB Wizard - 2

by Girish Nurani Sankaranarayanan

An article describing the implementing of Custom actions in Pocket PC application Setup packages.

Data Driven Unit Testing for a DotNetNuke Private Assembly Module

by Bruce Chapman DNN

Using data driven unit tests with SQL Server CE for DotNetNuke private module development.

Data Synchronization in SQL Express

by Ganesan Krishnan

Data Synchronization in SQL Express

Database Deadlocks for Dummies

by Andrew J Dixon

Explaining Database deadlocking to non-technical people

DataBinding in WPF Browser Application using SQL Server Compact

by RameshSengamalai

DataBinding in WPF Browser Application using SQL Server Compact

DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV

by Pieter Van Parys

Creating profiling information in our ProxyDbxxx classes

Disaster Recovery Plan In MOSS 2007

by Tariq Younas

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

Document SQL Server 2000/2005 Database

by Nitinpatel

T-SQL script to generate the document of SQL 2000/2005 database

Easier Database Transactions - Extending the Using Statement to Perform Automatic Database Transactions

by Chad Z. Hower aka Kudzu

Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.

Easy application to detect and recognize faces with EmugCV

by Emanuel Santos

In this article i will show how to create a basic application to detect and recognize faces using EmugCV.

Easy SQL-CE Access Utility in C#

by Bart-Jan Verhoeff

Access data in any SQL server compact edition datatable using only one line of code in C#

EasySqlCe: easy access to SQL CE in C#

by Bart-Jan Verhoeff

An easy way to access your SQL compact edition database in C#

Efficient data processing with ADO in C++: Method GetRows

by Vitaly Tomilov

Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.

End-to-End Real World BlackBerry Application, Part 6

by MiamiCoder

How to create a real-world BlackBerry application.

Format Excel Sheet from DTS when Excel is Not Installed on SQL Server

by s_arun_kumar

Format Excel Sheet from DTS when Excel is not installed on SQL Server

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

Get SQL Table Information

by Md. Marufuzzaman

Get SQL Table Information

Global Variables in SQL Server

by Md. Marufuzzaman

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

HeMoSiBi™ WPF App

by DrABELL

Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)

How Do I Protect My Stored Procedure Code

by Md. Marufuzzaman

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

How Many Records Are There in your Database?

by Md. Marufuzzaman

How many records are there in your database?

How to Call SSIS Package from the Stored Procedure

by JustChiragPatel

No need to create web service for SSIS package call

How to Config Linked Servers in a Minute

by Kamran Hazari

How to create Linked servers in a minute in an easy way

How To Handle Concurrency in LINQ to SQL?

by Shivprasad koirala

How to handle concurrency in LINQ to SQL?

How to Integrate an OLE Object with SQL Server

by Md. Marufuzzaman

This article will demonstrate how we can integrate T-SQL with an external application.

How to search for related query inside the Database using ASP.NET

by Afzaal Ahmad Zeeshan

This article explains how you can use ASP.NET (C#) and search for related queries in your Database.

How To Store Any File into SQL Database

by Md. Marufuzzaman

An easy technique to store any file into SQL database

How to Validate ASP.NET and MVC Web Forms Using Business Rules Engine

by Misha1964

Learn how to validate complex web forms using business rules engine

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!

Implementing Audit Trail using Trigger

by Shivprasad koirala

Implementing Audit trail using trigger

Implementing multi-level trees in MS SQL Server

by Duong Ba Hong Minh

A good way to setup and install a multi-tree level structure by using a MS SQL Server database.

Improving the performance of queries using SQL Server: Part 2

by Pete O'Hanlon

These articles are on prioritizing and improving query performance in SQL Server.

Install and Configure SQL Server for SQLCE replication

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

Introductory Mobile Tracker Application for SmartPhones

by Santosh Ingawale

LINQ and Deploying SQL Server CE 3.5

by Matt Sollars

How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.

LINQ Challenges and SQL Server Compact Edition

by Matt Sollars

Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.

LINQ Code generator

by Sree Nivas

This generates Basic linq codes just by giving necessary inputs

LINQ FAQ: Part 3

by Shivprasad koirala

Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.

LINQ to SQL

by Le Sourcier

How to use LINQ to SQL

LinqToSQL: Query Multiple Databases in One LINQ Expression and More...

by Muigai Mwaura

Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database

Managing Blobs Using the ATL OLE DB Consumer Templates on the Pocket PC

by João Paulo Figueira

Managing large data types on SQL CE databases and the ATL OLE DB Consumer Templates.

Merge Replication between SQL 2000 or SQL 2005 using SQLCE

by ihsanps

Merge Replication using SQL 2000 or 2005 using Compact Framework

Merge Replication between SQL Server 2000 and SQL Server CE

by sebagomez

An article on how to configure a SQL Server 2000 and SQL CE on different PPC that syncronize their data with the SQL Server 2000

Minimalistic Driver-less Native MySql Client

by Ladislav Nevery

Native MySql Client not requiring any special driver or library

Mobile Birthday Reminder and Automatic SMS Sender

by Wild-Programmer

This code sends automatic SMS to birthday boys/girls :) from phone

Multiple filters on a WHERE clause

by fhunth

How to write multiple filters on a WHERE clause on a sql sentence

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

by Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

Overview of SQL Server database Triggers

by Md. Marufuzzaman

Overview of SQL Server database Triggers

Overview of SQL Server Stored Procedure

by Md. Marufuzzaman

Overview of SQL server stored procedure

Packaging and Deploying Pocket PC Applications and SQL Server CE 2.0

by JacobEgholm

This article is about making a package containing a Pocket PC application and a SQL Server CE. The package will be of type MSI. When you click it, it will first install SQL Server CE 2.0 and then it will install the Pocket PC application.

Parse DataSet via Reflection

by NeoPunk

This article shows how to bind relational data model with object design model

Passing an Array as Parameter to SQL Server Procedure

by Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

Password Safe Reader for Windows Mobile

by Svante Seleborg, Alphons van der Heijden, Dave Shaw, katakana2

A Windows Mobile C# reader for the popular Password Safe archive files.

PocketPcAgent

by Tamer Oz

PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.

Procedure to Shrink the Database Transaction Log

by Md. Marufuzzaman

This article will demonstrate the procedure to shrink the database transaction log.

RegiRide, a complete Windows Phone application

by Patrick Kalkman

A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration

Retrieving and Storing Call History

by Bryan Sachdeva

This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.

Sending complex emails in .NET 1.1

by FlorentinB

This article describes complex issues about sending emails in .NET 1.1 (such as using a SMTP server that requires authentication).

Simple bit of Transact SQL to help locate text in a database

by codelion

Simple bit of Transact SQL to help locate text in a database using cursors

Simple Data Access in C#

by 6opuc

Fast and easy to use data access class library.

Simple Data Paging

by Barend Jnr

Simple Data Paging

Simplify Database Operations with Generic Fluent NHibernate

by Kieran Maltz, Cayen Systems

This article describes database communication using a generic Fluent NHibernate implementation.

SQL Battleship 2008

by craigd

Single-player game using GEOMETRY datatype and spatial functions in SQL Server.

SQL Champ - A Quiz to Prove Your SQL Knowlege

by r.stropek

software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.

SQL Compact 3.5 Tidbits and Gotchas!

by Jammer

An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.

SQL Injection Attacks and Some Tips on How to Prevent Them

by Colin Angus Mackay

Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.

SQL Performance: Good Practices for Beginners

by Praveen Nair (NinethSense)

This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases.

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

by pinaldave

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

SQL Server – Active Directory Interaction

by ThomasMiller

Descripe the SQL Server 2000/2005 interaction with Active Directory on Windows 2000 or 2003 server

SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download

by pinaldave

I tried to accommodate all of them in the last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer to at your convenience.

SQL SERVER – Order of Columns in Update Statement Does not Matter

by pinaldave

SQL SERVER – Order of Columns in Update Statement does not matter

SQL Server CE Query Tool

by ray_mayukh

User friendly query designer and data manipulation tool for SQL Server CE

SQL Server Compact (CE) Database Maintenance Helper

by Tadeusz Kaliszewski

A small .NET class library for maintaining SQL CE database schema written in C#.

SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)

by User 992674

A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures

Sql Server In Clause With Multiple Literal Values Performance Behaviour

by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL Server to SQL Server Compact Edition Database Copy Utility

by johnnycantcode

Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases

SQL Tuning Tutorial - Understanding a Database Execution Plan (1)

by Gael Fraiteur

If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.

SQL Wizardry Part Eight - Tally Tables

by Christian Graus

A description of the best way to create tally tables, and how to use them

SQL Wizardry Part Five - when not to use DISTINCT

by Christian Graus

Just a quick explanation of why it's not always a good idea to use DISTINCT

SQL Wizardry Part Seven - PIVOT and arbitrary lists of data

by Christian Graus

Discussion on pivot and other ways to turn columns of data in to rows in SQL Server

SQL Wizardry Part Six - Windowing Functions

by Christian Graus

A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012

SQL Wizardry Part Three - Common Table Expressions (CTEs)

by Christian Graus

In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks

SSIS Basic OLEDB / ODBC destination script

by madgardener

Simple destination script to use do updates with a sub query.

Store and forward GPS data for Smart Phones

by Slava Khristich

How to deliver GPS data asynchronously to the server over the internet without queues.

Table Data Sharing Across Stored Procedures

by ManojKumar19

This tip demonstrates how table data can be shared in two stored procedures.

The LOGIC Behind Mad MAX()

by Joe Negron

The SQL MAX() function is a little tricky when trying to work with numeric data - Not quite the same in other languages.

Thinking in SQL - Generating Random Numbers

by Christian Graus

A discussion of ways to create random number sequences in SQL Server

T-SQL Coding Standard

by Casper Leon Nielsen

T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)

Uncommon Common Table Expressions (CTEs)

by Jeremy Likness

Common table expressions (CTEs) are a powerful new construct for building advanced queries.

URL Decoding in pure T-SQL

by orinoco77

How to decode a URLEncoded URL with T-SQL

Very fast test data generation using exponential INSERT

by weilidai2001

Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.

Very Lightweight Data Access Layer in C# and .NET 2.0

by Fitim Skenderi

Very Lightweight Data Access Layer in C# and .NET 2.0

Visual Representation of SQL Joins

by C.L. Moffatt

This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.

WCF by Example - Chapter I - Baseline

by Enrique Albert

First draft version of the model, repository, and services.

WCF by Example - Chapter XVI - EF 5 & SQL CE - AzureWebSites Deployment

by Enrique Albert

EF Code First implementation of generic repository and unit of work. With deployment to Azure web sites using SQL Compact.

WCF by Example - Introduction

by Enrique Albert

Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate

Web enabling data on a SQL Anywhere Server using a native web service

by mysorian

An HTML Native web Service on SQL Anywhere Database Server

Windows Forms Setup Saver

by Nick Kopp

Presents a generic method of saving and reloading the status of a Form's controls using XML.

Windows Mobile App Development Part 5: Intro to using SQL Server CE

by mstruys, dougturn

Learn to access data through DataSets and SQLCeResultSets in your Mobile apps.

Workaround: When a user clicks "Select All", the report should pass a blank value instead of parsing everything in the MultiSelect DropDown parameter

by Shobhit Dixit

If you have a long list of drop down items and you want to pass in one value, you can use this method