SQL Server Articles
Available memory is usually the most common source for performance issues on a Windows Server installation. Fortunately, however, it is an easy metric to measure since there are several counters in the memory object which can help troubleshoot memory issues.
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
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 […]
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 […]
Applications typically make connections to the SQL Server databases in large numbers but what if those connections are not successfully closed? How you can monitor them? This short article describes the methods we can use to monitor unclosed connections. Sample Application Let us start with a simple C# WinForms application which has the following UI. […]
Almost from birth, database developers are taught that their databases must be normalized. In many shops, failing to fully normalize can result in anything from public ridicule to exile to the company’s Siberian office. Rarely discussed are the significant benefits that can accrue from intentionally denormalizing portions of a database schema. Myths about denormalization abound, […]