External Article

Replication Schema Option Across Different Versions of SQL Server

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.

External Article

State Transition Constraints

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.

SQLServerCentral Article

MERS

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.

Blogs

Project Management – Part 1

By

The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...

Install SQL Server 2025 Container on macOS Using OrbStack

By

My old Dell XPS that I used for personal stuff started to degrade; well,...

Flyway Tips: Immediate Code Review for Developers

By

At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...

Read the latest Blogs

Forums

Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019

By abdalah.mehdoini

We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...

Forward Deployed Engineers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Forward Deployed Engineers

TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage

By john.martin

Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...

Visit the forum

Question of the Day

DBCC CHECKDB Limits II

I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?

See possible answers