(Marcin Policht) In this installment of our series covering new and improved functionality of SQL Server 2005 Beta 2, we will focus on the topic of security, which has been becoming increasingly prominent among the issues on every database and system administrator’s agenda. A new approach to softwar

(Venkat Prasad) This article discusses some programming techniques for saving XML data from Microsoft SQL Servers, Web Servers, XML Web Services, and Microsoft SQL Reporting Servers. Topics include a comparison of traditional techniques used for saving XML streams, using ASP/ASPX and COM, with newer

(Kimberly L. Tripp) Table-based partitioning features in SQL Server 2005 provide flexibility and performance to simplify the creation and maintenance of partitioned tables. Trace the progression of capabilities from logically and manually partitioning tables to the latest partitioning features, and

(William Vaughn and Peter Blackburn) This chapter details the installation and configuration of SQL Server reporting services, providing advice on testing and options for this useful function.

(Dale Elizabeth Corey) More than once, I have heard, “I never knew that feature existed in Enterprise Manager”, so I thought I would conjure up a Top Ten List for Enterprise Manager. However, I will not say that there may be other features that are not as equally important and these are not necessa

(Barrie Sosinsky) There are several steps you can take to make SQL Server databases more resistant to tampering and hacking. Some are simply part of good server management, like keeping up with SQL Server’s latest patches, while others involve active-user monitoring. The five steps below will get yo

When creating a new SQL Server Data Source Name (DSN) using the ODBC API SQLConfigDataSource function, a network library must be specified. If the network library name is in lowercase letters, the Client Configuration dialog box may show it as “Other”.

(Parthasarathy Mandayam) You already know that stored procedures offer enormous benefits over direct SELECT statements. But one of the things you tend to have to sacrifice when you replace a simple SELECT with a stored procedure is direct control over the resultset.

(Stephen J. Friedl) A customer asked that we check out his intranet site, which was used by the company’s employees and customers. This was part of a larger security review, and though we’d not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concep

(Alexei Bocharov and Jesper Lind) The two main functions of data mining are classification and prediction (or forecasting). Data mining helps you make sense of those countless gigabytes of raw data stored in databases by finding important patterns and rules present in the data or derived from it. An