Visual Studio Utility to Compare 2 SQL Server Databases Chris Skorlinski Microsoft SQL Server Escalation Services During performance troubleshooting we often need to look at difference between two different databases. We’ve used SQL Server Tablediff Utility...

How to run “sp_change_users_login” for all users in a database Chris Skorlinski Microsoft SQL Server Escalation Services Following a user database restore the database had orphaned users. We used TSQL commands below to build a list of sp_change_users_login...

If you’re in the US, check out SQLSaturday conference in your local city. These are a great way to keep up on latest SQL topics from both local and national speakers without going to SQL PASS. I recently presented at the Charlotte, NC SQLSaturday where...

Microsoft SQL Server Replication Web Sites you may want to visit Below are a few links from my IE Favorites I thought I would share. My desk is full sticky notes with various odd-n-end SQL topics. Most of the time I’ll just BING a topic and browse through...

Slides from SQL Saturday #33 Replication Talk "Troubleshooting Transactional Replication" Chris Skorlinski Microsoft SQL Server Escalation Services Here are the slides I used for my SQL Server Replication presentation "Troubleshooting Transactional...

Slides from SQL Saturday #33 Replication Talks "Comparison of Replication Technologies" Chris Skorlinski Microsoft SQL Server Escalation Services Here are the slides I used for my SQL Server Replication presentation "Comparison of Replication Technologies...