This article describes how to rotate a SQL Server table. Suppose you have a table that is named QTRSALES. The table has the columns YEAR, QUARTER, and AMOUNT with the data in the following format (note that there is no row for the fourth quarter of 1996):

by Scott Bekker – In response to the publication of the SQL Slammer source code in a major industry magazine, Microsoft officials are warning users to make sure they’ve taken advantage of the rash of SQL Slammer defenses on the Microsoft Web site.

By Jeremy Kadlec – This article will begin to detail the technical components faced by DBAs and developers during the upgrade process. The technical components detail critical upgrade decisions related to ANSI NULLS, quoted identifiers and other items. In addition, a valuable redundant upgrade archi

by Dan Clark – A well-designed application that uses a relational database management system in the backend should make extensive use of stored procedures. A stored procedure is a named collection of SQL statements that you store in a database. A stored procedure is similar to a function. You call t

By Michael Otey – You might not need the new functionality a service pack provides, but prompt installation of service packs could be the very thing that beats virus writers to the punch.

by Larry Ashworth – Many otherwise outstanding applications fail miserably due to database performance issues. Caching is a commonly used method of accelerating applications, but cache aging, data integrity, and multi user issues make caches difficult to implement at the application level. As a serv

By Alexander Chigrik – In this article, I want to tell you about SQL Server constraints: what a constraint is, when it is used and for which purposes. You can find in this article some examples of constraint creation and SQL Server 2000 constraints enhancements.

By George V. Hulme – Some security experts are criticizing the decision by Wired magazine to publish the complete source code to the SQL Slammer worm in its July issue, which hits newsstands Tuesday, saying it amounts to an algorithm on how to wreak havoc on IT systems worldwide.

Book Description – XML is one of a family of web standards for data description, validation, manipulation, and interchange. It enables the construction of application-specific data languages, which can be handled by generic tools. Its other main benefits are its platform independence, self-describin

Some problems aren’t just practical; they’re also fun. SQL Server Magazine’s Itzik Ben-Gan shows you how to implement the Game of Life in T-SQL code.