SQL Server Articles


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

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.

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 […]

WebMatrix Tutorial – Getting Started

xx

Working with IIS using PowerShell

xx

Know your Data with Data Profiling

Introduction According to the “Data Quality and the Bottom Line: Achieving Business Success through a Commitment to High Quality Data.” The Data Warehousing Institute. Report Series 2002, data quality problems cost U.S. businesses more than $600 billion per year. Why such a cost? If your data is not up to quality, your KPIs and data […]

Optimizing Performance of SQL Server Reports

 There is not much the report writer can do to speed things up, compared to the DBAs and the people buying the hardware.  Nevertheless, I wanted to share some ideas that may or may not work in your situation. Use indexes in your database When writing stored procedures, I prefer to keep my query as […]

Overview of SQL Server 2008 R2 Express Edition

Microsoft released the final version of SQL Server 2008 R2 Express Edition on April 21, 2010. SQL Server 2008 R2 Express Edition continues to ship in 4 different packages. One can download Microsoft SQL Server 2008 R2 Express Edition from the following link. In this article we will take a look at SQL Server 2008 […]
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 |