(Don Schlichting) SQL languages are designed so groups of records, or sets, can be manipulated easily and quickly. The speed at which groups of data can be altered, updated and deleted, demonstrates why working with sets is the preferred method. A traditional programmatic database connection, us

(Alex Glauberzon and Martin Wiseman) Think about the last time you had to update a table that contained a large number of columns. Now, imagine that the table is under construction and you’re responsible for adding or deleting columns or modifying columns’ data specifications. And, of course, this s

(Haidong Ji) In my previous articles (Using xp_cmdshell, Using WMI, Using VBScript, Automate DTS Logging, among others), I talked about various technologies you can use to automate SQL Server management. Different situations call for different techniques. Many times, you may find yourself using a co

(Stéphane Faroult) FROM what? It may seem surprising to state it so, but the FROM clause of SQL statements seems to be one of the most often misused parts of SQL queries. Misused? How is that possible? We put into the FROM clause all the tables to join together in a query, don’t we? Well, well

(Gregory A. Larsen) As a DBA, you will need to perform a number of different tasks to keep your databases and servers up and running. One of those DBA tasks you will need to perform is disk space capacity planning. You need to make sure there is enough disk space, so when one of your databases n

When you traverse a dimension through a Multidimensional Expressions (MDX), you may have to determine if you are at the top most level of the hierarchy. This article shows you four MDX expressions that allow you to find out if you are at the top most level of the hierarchy.

When you view data associated with a custom member of a parent-child dimension, the cell values may display as “#Err”. When you examine the cell properties of any of the custom members, you receive the following error message: Infinite recursion detected during execution of calculated member.

This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. We discuss the techniques available using Microsoft’s graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer

(Dale Elizabeth Corey) NGSSquirrel for SQL Server is a vulnerability assessment scanner. It allows system administrators and security professionals to quickly and easily assess SQL Servers (7 & 2000) for a variety of security vulnerabilities and deficits. The NGSSquirrel security scanner comprehensi

(Anthony Glenwright) This article will show you how to use Microsoft SQL Server’s Reporting Services Web service to install your reports and execute them from a smart client application.