My company uses replication quite extensively across SQL 2000, SQL 2005 and SQL 2008 servers. The problem with using different versions of SQL Server is that the replication options do not always behave the same way. Because of these differences we have stopped using SQL Server Management Studio and Enterprise Manager to setup replication. Also we have taken the time to look at the schema options for replication to make sure the end result is the same for all versions of SQL Server.

State Transition Constraints

by Additional Articles

SimpleTalk

theory

Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer. A commercial world is full of complex rules for sequences of procedures, of fixed or variable lifespans, Warranties, commercial offers and bids. All this requires considerable subtlety to prevent bad data getting in, and if it does, locating and fixing the problem. Joe Celko shows how useful a State transition graph can be, and how essential it can become with the time aspect added.

MERS

by Steve Jones

SQLServerCentral.com

The foreclosure issues that are occurring in the US might be due to database issues at one company. Steve Jones notes that when your database is the legal system of record, it has to be accurate.

The 2010 SQLServerCentral Opening Night Party

by Press Release

SQLServerCentral.com

PASS Summit

SQLServerCentral is hosting an opening night party at the 2010 PASS Summit. Read more about this and learn how to get a ticket.

Working with null values in SQL XML

by Richard Rozema

SQLServerCentral.com

NULL

We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?

Top 10 Mistakes When Building and Maintaining a Database

by Additional Articles

Database Journal

Administration

Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.

Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

by Wagner Crivelini

SQLServerCentral.com

Primary Key (PK)

This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.

End of October Free Training from PASS Virtual Chapters

by Aaron Nelson

SQLServerCentral.com

This wraps up the last of the free training the PASS Virtual Chapters are providing in October.

Remote Security

by Steve Jones

SQLServerCentral.com

Editorial

As more and more people look to work away from inside traditional networks, security becomes an issue. As a data professional, Steve Jones reminds you to be sure that your data is protected.

SQL Slammer

by Steve Jones

SQLServerCentral.com

Editorial

It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.

Replication Schema Option Across Different Versions of SQL Server

State Transition Constraints

MERS

The 2010 SQLServerCentral Opening Night Party

Working with null values in SQL XML

Top 10 Mistakes When Building and Maintaining a Database

Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

End of October Free Training from PASS Virtual Chapters

Remote Security

SQL Slammer

Blogs

T-SQL Tuesday #196 – Two risky career decisions I made

T-SQL Tuesday #192: What career risks have you taken?

T-SQL Tuesday #196: Taking Risks

Forums

OPENQUERY Flexibility

A Full Shutdown

Going Native with Fabric Spark Pools: The Fabric Modern Data Platform

Question of the Day

OPENQUERY Flexibility