(William Pearson) Within the world of OLAP, sparsity is pervasive. There are many reasons to want to display something other than an empty space in a report, where a “blank” is about as welcome, to most readers, as silence on a radio show. In an Analysis Services cube, as well as in the reportin

(Arthur Fuller) While talking to a colleague about the trouble he was having with a stored procedure, I suggested that he run the debugger in Query Analyzer. He really surprised me when he asked, “What debugger?”

(Paul Ibison) Replication over the Internet or across non-trusted domains is usually performed using a virtual private network (VPN), and consequently the configuration is much the same as that used on a LAN. This article outlines what to do if such a VPN is not available. While it’s true that i

(Merrion) This class library is a quick implementation to use custom attributes to marshal a .NET class to/from an SQL Server database table. It is fairly simple in that it assumes a one-to-one mapping between the class and the table.

As long as Web applications are used to provide access to data, SQL Injection will continue to be a threat. SQL Injection is typically used to accomplish one of four objectives: bypass authentication, glean information, inject new or alter existing data, perform a denial of service attack, or gain a

(Shawn Wildermuth) In the first part of this article, we discussed how the CLR integration works in SQL Server 2005. This included writing stored procedures, but we could not do anything interesting in those first examples because we had no access to the data inside the database. In this second a

In Microsoft SQL Server 2000 Service Pack 3 (SP3) and in earlier SQL Server 2000 service packs, a query that involves data that is the numeric data type may return incorrect results when the following conditions are true: • You compare numeric columns or numeric constants that are of different p

(Tal Kelley) Several State and Federal contracts that I have worked on in the past have wanted to keep track of all changes to a particular record, such as who modified the record, what kind of modification took place, and when the record modification occurred. I decided to solve this problem wi

(Paul Ibison) This article describes the changes to replication from the point of view of the SQL Server 2005 GUI. In case you haven’t already been checking out the new version, ‘Microsoft SQL Server Management Studio’ is the new graphical replacement for ‘Enterprise Manager’. It’s probably true

(Don Schlichting) A pivot is a data mining option typically used to transform large amounts data into a condensed list. Pivot style reports display data in a grid along a vertical and horizontal axis. Financial and managerial reports are the examples usually sited. The pivot style report pictured be