(Clint Boulton) Little by little, Microsoft is peeling away the layers of SQL Server 2005, the company’s forthcoming database server software. The Redmond, Wash., software giant unveiled new native security encryption and decryption support as well as government security certification.

(Jean-Luc David) Web developers must constantly cope with the pitfalls of integrating multiple platforms and technologies to produce seamless software solutions. PHP is an easy-to-learn and powerful open source scripting language. Microsoft SQL Server is a robust database product which can handle te

(graz) One of the things that has always bugged me about DTS is how difficult it was to transfer the DTS packages from SQL Server to structured storage (aka a file on the disk). In Yukon, DTS packages are always stored as files but in SQL Server 2000 they are stored in SQL Server by default. It’s po

(William Pearson) In this article and others subsequent to it, we will focus on time considerations in our MDX queries, and how we can successfully report change over time, as well as to accumulate those changes to present the precise snapshots, trends and other time-based metrics so dearly apprecia

(Rahul Sharma) For those implementing production servers using SQL, purchasing either the standard or the enterprise edition of SQL Server makes the most logical choice. The personal edition of SQL is for PCs and small workgroups, and the developer edition cannot be deployed since it is not meant fo

(Andrew Novick) Reading and writing to the disk is the heart of what any database management system does, SQL Server included. Input/Output (I/O) performance can make or break an application. This article discusses the diagnostic tools that can be used to examine SQL Server’s I/O statistics so t

(Peter Kelly) Too often, an organization’s valuable data sits locked away, inaccessible to the people who could transform it into intelligence, insight, and, ultimately, competitive advantage. With the Microsoft Office System, you can use the data that resides in Microsoft SQL Server 2000 in ways th

(Vinod Kumar) This is an interesting requirement I’ve been seeing at the public newsgroups. Most of the database designers do keep this in mind. But there this has become a common question that I thought I write some of the techniques I can think of.

(Susan Sales Harkins and Mike Gunderloy) Welcome to the final installment of our series on SQL Server security. So far, we’ve explained how to set up your SQL Server, how to manage users and groups, how to manage objects and permissions, and how to set up application roles. Today we’re going t

(Steve Jones) often see questions and posts about how you get started with SQL Server 2000. Mostly from people whose job is something else, but got stuck with the task of administering or working with SQL Server 2000. This article is geared more towards network type administrators, but developers m