SQL Server Articles

SQL Azure Performance Tuning is a much tougher task than SQL Server since SQL Azure lacks some of the basic tools available to SQL Server DBA’s

A recent blog entry I read reminded me again that I wanted to rant about an issue in SQL Server for quite some time now… SQL Server 2005 introduced the separation between user and schema. Though schemata already existed  before SQL Server 2005, they really became usable with this version, imho. At the same time  [...]

First introduced with SharePoint 2010, Resource Throttling allows the farm administrator to control the overall performance of a SharePoint farm.

Securing your ASP.NET web app from SQL Injection attacks paramount in the design of any ASP.NET app

The .NET System.IO.Compression namespace provides two general purpose compressions streams –  DeflateStream and GZipStream

To easily manage the permissions in our databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals. They are like groups in the Microsoft Windows operating system. Database-level roles are database-wide in their permissions scope. The various types of SQL Server fixed database roles are as follows: · [...]

Data Mining with Microsoft Office Excel Introduction A key issue in data mining is not only generating the results but also interpreting them. Unfortunately it is often difficult to interpret the results of data mining and many users are turning to Excel and its data mining add-in tool. Requirements You will need to have permission [...]

I once walked into a bar, and saw two construction workers pounding each other to a pulp.  The argument was over what was the better tool—a  hammer or screwdriver.  I feel a similar sensation when I see SQL developers arguing over whether to use natural or surrogate keys.    Few other arguments in database design can [...]

The IDENTITY property for a column of a numerical data type is a frequently used method to achieve system-generated “uniqueness” for each row in a table. Such a column then in turn is a quite popular choice for the PRIMARY KEY constraint. Most of the times one would choose the data type int for the [...]

When using the BETWEEN operator on multiple columns, you are likely using a 2D range query.  Such queries perform very poorly in SQL Server.   This article will tell you how you can often use additional information to rewrite such queries for much better performance.  We’ll conclude by rewriting an actual BETWEEN query in a manner [...]