Articles

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.

2010-10-27

2,218 reads

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.

2010-10-27

1,942 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2010-10-26

152 reads

Technical Article

Introducing ADO.NET Entity Framework

The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.

2010-10-25

3,289 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCU MANGGA DUA RAYA,Telpon/Wa 0821-8200-239

By alivenje

Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec. Pademangan, Jkt...

BCA KCP Kramat Jaya,Telpon/Wa 0821-8200-239

By alivenje

Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah...

BCA KCP Yos Sudarso,Telpon/Wa 0821-8200-239

By alivenje

Jl. Kebon Bawang VII No.40 2, RT.2/RW.6, Kb. Bawang, Kec. Tj. Priok, Jkt Utara,...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers