(Arthur Fuller) While eating dinner recently with Dejan Sunderic (author of SQL Server 2000 Stored Procedure & XML Programming), he made me rethink some of my long-held biases about data singularity. His well-made points spurred me to write this article.

(Mike Gunderloy) You’ve certainly heard the news by now: Microsoft is on the verge of releasing a new version of their flagship enterprise-ready database, SQL Server. In fact, they announced at this year’s Tech Ed that SQL Server 2005 (formerly code-named “Yukon”) would be released to manufacturing

(William Pearson) In this article, we will examine the design and creation, within Analysis services, of relative time periods, a popular feature that can be generated automatically or manually for reporting in the Cognos PowerPlay application, within its cube design component, Cognos PowerPlay Tran

(Allan Mitchell) In this article we are going to take you through the ExecuteSQL task in SQL Server Integration Services for SQL Server 2005. We will be covering all the essentials that you will need to know to effectively use this task and make it as flexible as possible.

In Microsoft SQL Server 2000, when you run a query that generates many floating point exception errors, you may experience slow performance and query timeouts when you run other queries. This problem typically occurs when more than 1,000 floating point exceptions are generated.

Getting started with SQL Server 2005 Reporting Services or the new report controls in Visual Studio 2005? Brian Welcker demonstrates some tips and tricks that you can use to add interactive features to your own reports.

(Malik Asif Joyia) I am working on a project that is a Web-based application that uses the render and RenderStream methods of SQL Server reporting services. When you use the Render() method of SQL Server reporting service, it returns to you the stream of the report. If you have images in your rep

(Harry Parkinson) Monitor the free disk space on your SQL Server and send an alert via email or net send if the available space on any of the drives SQL Server resides on is lower than the specified limit. The script could also be scheduled as a job to provide 24/7 monitoring. Supports SQL Server 7

(John Godel) You can create queries to retrieve information from your database by using the SQL Query Tool in the Enterprise Manager, ISQL/w, ISQL, MSQuery, other tools, and third-party utilities. In this section, you will look at using the SELECT statement to retrieve rows and columns from tables i

(Brian A. Randell) Microsoft Office Excel makes it easy to work with rectangular data, such as data from an external database. In this walkthrough, you’ll load data from Microsoft SQL Server into an ADO.NET dataset. You’ll then use the Excel object model to support synchronizing changes made to the