Visual Studio Utility to Compare 2 SQL Server Databases

Visual Studio Utility to Compare 2 SQL Server Databases Chris SkorlinskiMicrosoft 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 for the data changes but doesn’t help with schema changes.  For schema differences you can use Database Compare tool available…

0

How to run “sp_change_users_login” for all users in a database

How to run “sp_change_users_login” for all users in a database Chris SkorlinskiMicrosoft 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 commands in order to resynchronize database users with SQL logins.  We then ran these sp_change_users_login commands to automatically…

0

Be sure to check out your local SQLSaturday conferences

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 almost 250 people attended from 4 different states.  It was…

0

Microsoft SQL Server Replication Web Sites you may want to visit

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 top sites.  Hope you find nugget of…

0

Slides from SQL Saturday #33 "Troubleshooting Transactional Replication"

Slides from SQL Saturday #33 Replication Talk “Troubleshooting Transactional Replication” Chris SkorlinskiMicrosoft SQL Server Escalation Services Here are the slides I used for my SQL Server Replication presentation “Troubleshooting Transactional Replication” during SQLSaturday #33 in Charlotte, NC.  Keep an eye our for the nearest SQL Saturday and plan to attend.  These mini-SQL PASS conferences provide great local…

0

Slides from SQL Saturday #33 "Comparison of Replication Technologies"

Slides from SQL Saturday #33 Replication Talks “Comparison of Replication Technologies” Chris SkorlinskiMicrosoft SQL Server Escalation Services Here are the slides I used for my SQL Server Replication presentation “Comparison of Replication Technologies” during SQLSaturday #33 in Charlotte, NC.  Keep an eye our for the nearest SQL Saturday and plan to attend.  These mini-SQL PASS conferences provide…

0