In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.

Using BACKUP and RESTORE in SQL Server

by Additional Articles

SQLTeam.com

Administration

This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.

Using Plan Guides in SQL Server 2005

by Additional Articles

SQL Server Performance

Performance Tuning

In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed.

Retrieving Data as XML from SQL Server

by Additional Articles

Other

Basics

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.

Some Usages for XML

by Yousef Ekhtiari

SQLServerCentral.com

Basics

While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable
with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.

Turn XML into relational data with OPENXML

by Additional Articles

Builder.com

OpenXML

XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.

SQL Server 2005 Service Pack 2 is Out

by Steve Jones

SQLServerCentral.com

Administration

Microsoft has finally release service pack 2 for SQL Server 2005. Read a short commentary and get the links to download it now.

SQL Server XML Performance Tips

by Additional Articles

SQL Server Performance

Performance Tuning

A series of tips on optimizing XML in your SQL Server databases.

The 2007 PASS Summit Is Coming to Denver

by Press Release

SQLServerCentral.com

Shred XML data with XQuery in SQL Server 2005

by Additional Articles

Builder.com

OpenXML

Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.

Database Design: A Point in Time Architecture

Using BACKUP and RESTORE in SQL Server

Using Plan Guides in SQL Server 2005

Retrieving Data as XML from SQL Server

Some Usages for XML

Turn XML into relational data with OPENXML

SQL Server 2005 Service Pack 2 is Out

SQL Server XML Performance Tips

The 2007 PASS Summit Is Coming to Denver

Shred XML data with XQuery in SQL Server 2005

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Creating a Simple and Flexible Random Password Generator in SQL Server

SQL Art, Part 3: Happy Easter Fun in SSMS

Question of the Day

Identities and Sequences IV