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 If you're looking for replication help, check out this book.


7,098 reads


Webinar – Building a Proper SQL Server Database Security Model


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

Stellar Toolkit for MS SQL - Software Review


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

Behavior of numeric data types with ”


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

Read the latest Blogs


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


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

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers