Tip of the Day - Queries For Debugging Bi-Directional SQL Server Merge Replication
Tip of the Day - Using MERGE in SQL Server to insert, update and delete at the same time.
Tip of the Day - Move SQL Server Merge Replication Subscriber to new Server without Reconfiguring Replication
Tip of the Day - Configure SQL Server Merge Replication with Web Syncronization
Tip of the Day - How to Merge a Conflict in SQL Server 2016 Master Data Services
Change All Computed Columns to Persisted in SQL Server. http://www.mssqltips.com/sqlservertip/3338/change-all-computed-columns-to-persisted-in-sql-server/
Restore info: https://www.mssqltips.com/sqlservertip/1860/identify-when-a-sql-server-database-was-restored-the-source-and-backup-date/ select top 1 * from restorehistory where destination_database_name='xxxxxxxxx' order by restore_history_id desc
Dr. Dallas Snider MSSQLTips author and Assistant Professor in the Computer Science Department at the University of West Florida.
Persisting SQL Server Index-Usage Statistics with MERGE
Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions