This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From “Out of Space” errors to a database going suspect, this list is great quick reference for every SQL administrator. (pdf)

(Slava Oks) We have already talked about Windows AWE mechanism on 32 bit and how SQL Server utilizes it. Today I would like to go over AWE & related mechanism on 64 bit platforms.

(Phil Factor) The development foot soldiers in the IT army are required to have two arrows in their quiver: fluency with the procedural language currently in fashion and a measure of skill in database programming.

(William Pearson) A common request within the implementation of enterprise reporting systems is to endow the reports of our users with interactive features. While we have spent a great deal of time upon parameterization in general (even discussing parameterized sorting in Black Belt Components: Ad H

This article discusses why the auto create statistics option, the auto update statistics option, and the Parallelism setting are turned off in the Microsoft SQL Server 2000 or Microsoft SQL Server 2005 database instance that hosts the Microsoft BizTalk Server 2004 BizTalkMsgBoxDB database or the Mic

(Darren Green) The SQL Server 2005 product family has now been released, so with four editions available, what does this mean for SQL Server Integration Services? Starting from the bottom we have the free edition known as Express, and the entry level Workgroup edition, and neither include the full I

(Brian Walker) This tip continues the system stored procedure series with a routine to list information about selected SQL Agent jobs. (R)

Microsoft SQL Server 2000 hotfixes are created for a specific Microsoft SQL Server service pack. For example, you cannot apply a hotfix that was designed for Microsoft SQL Server 2000 Service Pack 3 (SP3) to an installation of Microsoft SQL Server 2000 Service Pack 4 (SP4) unless a special case is n

(David Watts, Michael Lawson and Yuichiro Tanimoto) The xSeries 460 is the number one x86 scalable server in the industry. The combination of the x460 and Microsoft SQL Server 2005 creates a perfect match for addressing needs for more database performance. The x460 is an effective four-way server, b

(Greg Robidoux) Large SQL Server installations bring added challenges, particularly how to back up all those databases and ensure minimal data loss in the event of a failure. Here I’ll detail some points to consider when setting up a backup plan for a large SQL Server environment. (R)