Adam Machanic

  • Interests: RDB theory, VLDB, query optimization

A Guide to SQL Server 2000 Transactional and Snapshot Replication

Two MVPs at one shot in this one. SQL Server MVP Hilary Cotter has written a book on replication, one of the very few there are on this topic. And it's presented as a review by MVP Adam Mechanic, a regular visitor to SQLServerCentral.com. If you're looking for replication help, check out this book.

2005-04-13

7,098 reads

Blogs

Webinar – Building a Proper SQL Server Database Security Model

By

Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...

Stellar Toolkit for MS SQL - Software Review

By

As a SQL database administrator, I am responsible for maintaining our organization's SQL Server...

Behavior of numeric data types with ”

By

As we all know, there are various numeric data types, such as TINYINT, INT,...

Read the latest Blogs

Forums

Calling a Function to Update Temp Table

By rjjh78

Hello, I have created a function that will determine the Distance between 2 sets...

Alert configuration

By ramyours2003

How to set up alerts  on long running jobs on sql server ?,  pls...

Help with procedure creation and execution

By FABISILVA

I created the procedure below, but the updates do not run, how do I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers