SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Visual Studio LightSwitch Tutorial

Detailed walkthrough on creating a simple application using Visual Studio LightSwitch.

Manage Database Projects With Visual Studio 2010

This article demonstrates how to manage database projects with Visual Studio 2010.

IIS Application Pools for ASP.NET Apps

This article demonstrates how to manage and optimize IIS pools for running ASP.NET apps.

WCF Tutorial

Prior to .Net 3.0 it was not an easy matter to select a particular technology for communicating between systems due to the number of technologies available from  Microsoft. For example, users could have used Web Service to communicate between a Java based application and a .Net application; WSE users  could have take advantage of some […]

Unicode Compression in SQL Server 2008 R2

 Introduction Data Compression was first introduced in SQL Server 2005 with Service Pack 2 when Microsoft introduced a new storage format called VARDECIMAL to store decimal and numeric data types as variable length columns. In SQL Server 2008, Microsoft enhanced Data Compression feature to compress fixed length data types such as INTEGER, CHAR and FLOAT. […]

ASP.NET Hosting Guide

Detailed guide to shared, VPS and dedicated hosting.

Exchange Server Performance – Optimizing Database Availability Groups (DAG)

Under a DAG configuration,  mailbox data is replicated across several hosts.  The result of this is that in Exchange Server 2010 it is now less important to build in system level redundancy. If a DAG node fails, as opposed to  rebuilding it, we can simply build a node, add it as a replica, the data will replicate to it.

Using DML Triggers to Capture Multiple Events

AS DBAs we often need to develop DML triggers to capture multiple entries which are either INSERTED, UPDATED or DELETED from a table. A few months back, I came across a situation where the Application Development Team asked me to write a logic  to notify the DBA  if any records were either INSERTED,UPDATED or DELETED […]

Reporting Services 2008 R2: Geospatial Visualization – Part II

This is the continuation of my previous article: Reporting Services 2008 R2: Geospatial Visualization – Part I. Part I discussed the  main characteristics related to the Map Report Item, Data sources for spatial data, how to create a map report using shapefiles, and finally add analytical data to it.  Our goal in the part is […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |