(Marcin Policht) Throughout our series of articles dedicated to SQL Server 2005 Integration Services, we have been working mainly with packages using the Business Intelligence Development Studio interface (although more recently, we also discussed SSIS-related functionality available in SQL Server M

Microsoft SQL Server requires that the I/O subsystem used to store system and user databases fully honor Write-Ahead Logging (WAL) requirements through specific I/O principals. These requirements are necessary in order to honor the ACID properties of transactions: Atomic, Consistent, Isolated, and D

(Scott Mitchell) When displaying large amounts of data to a user, it’s important that the information be presented in digestible chunks rather than slamming it all down their throats at once. For example, searching for “Microsoft” on Google returns approximately 2,190,000,000 results, but thankfully

(Neeraj Nagpal) In the first article in the series, I explained the setup of a report that ensures that backups are happening as per the backup policy. In this article, I will explain how to monitor SQL Server errorlog, leveraging the capabilities of DTS.

(Serdar Yegulalp) Like many services, SQL Server and the SQL Server Agent can run in a variety of account contexts. By default, both SQL Server and the Agent are installed in the Local System Account context. However, Microsoft notes in one of its own discussions that the Local System Account is pro

(Alex Woodie) Microsoft’s new database, SQL Server 2005, has been on the shelves for just a couple of months, but by the end of April, the first service pack should be available. SQL Server 2005 Service Pack 1 (SP1) will add support for mirroring, a crucial ingredient in high availability environmen

(Serdar Yegulalp) When a data file is created in a SQL Server database, the file’s autogrowth factor is set by default: Files are set to grow by 10% of their size whenever they’re close to running out of free space — and they are set to grow in an unrestricted fashion. For modestly sized databases

When a Microsoft Visual Basic application opens a dynamic cursor on a GROUP BY query, you receive an error message that is similar to the following: Run-time error ‘3251’: Object or provider is not capable of performing requested operation

(John Charles) Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 20051. Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means, which can be explored for valuable information. It is about learning the characteri

(Steven S. Warren) In the age of catastrophes, which include disk failures, power failures, fires and floods, disasters can take their toll on any business and stop the flow of information. With each minute of lost data translating into unrecoverable revenues, downtime is being taken seriously.