(Greg Hamilton) It is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a stored procedure that returned a particular “page” of d

(Adam Machanic) If you were to ask a group of database administrators which key personality trait they have that helps them do their jobs well, the most important and popular answer would be an excellent sense of organization. Great DBAs organize everything in the database — from the data itself to

This article outlines some of the key factors customers should be aware of when evaluating a third-party file caching system.

(Serdar Yegulalp) The Windows Firewall, which ships standard with Windows Server 2003 in all its incarnations, provides a basic level of protection. It’s nothing spectacular, but it’s a good first line of defense in the absence of more sophisticated products like Microsoft’s own ISA Server or a hard

Twenty-three new webcasts are scheduled for May, covering such topics as Migrating from Access to SQL Server 2005 Express, Implementing Database Mirroring in SQL Server 2005, Creating Analytical Multidimensional Expression (MDX) Queries and more.

This HP white paper describes the evolution of data warehousing systems and explains how standards-based, object-oriented programming has improved the newest generation of Business Intelligence (BI) software. The paper outlines key differences between components-based and integrated approaches to BI

When you use linked servers in Microsoft SQL Server 2000, you may receive one or more of the following error messages: Error message 1 SQL Server Assertion File : , Line = 501 Failed Assertion = ‘FALSE’ Invalid switch value

(Charles Babcock) Microsoft can check another item off its “to do” list in pursuing parity with database competitors. And administrators who manage Microsoft’s SQL Server databases may have a slightly shorter worry list when it comes to database downtime.

(Marcin Policht) In the previous installment of this series, we started exploring different ways to store SQL Server 2005 Integration Services packages. As presented, this can be accomplished by saving them as .dtsx files (either in an arbitrary local or remote location or within the designated area

Consider the following scenario. You use Microsoft SQL Server 2000 on a computer that is running one of the following operating systems: • Microsoft Windows 2000 Server Service Pack 4 (SP4) • Microsoft Windows Server 2003