Welcome to SQLSaturday #46 — Raleigh NC — 18 Sep

Welcome to SQLSaturday #46 — Raleigh NC — 18 Sep Chris Skorlinski Microsoft SQL Server Escalation Services If you are in the Raleigh, North Carolina area on Saturday September 18th plan on attending SQLSaturday.  This is a great opportunity to attend a 1 day conference on a wide variety SQL Server topics.   I’ll be there…

0

Example code executing TSQL for each Table in a database

Chris Skorlinski Microsoft SQL Server Escalation Services Not very fancy, but here are some examples of executing same statement for multiple tables in a database.  The first two techniques build a TSQL statement in the query output window.  You can then copy-n-paste that text into a new query and execute.  The last two examples just…

1

SQLSaturday June 5th in Pensacola Florida

If you’re in the Pensacola, FL area Saturday June 5th, check out SQLSaturday.  Its a great way to meet with other SQL Server professionals listen to some great presentations.  Some presenters are international speakers seen in SQL PASS, some are local from the Pensacola area.  Me, I’m from Microsoft SQL Escalation Services team in Charlotte,…

0

April 24th SQLSaturday Workshop in Atlanta GA on CDC and Merge Replication

April 24th SQLSaturday Workshop in Atlanta GA on CDC and Merge Replication If you’re in the Atlanta, GA area Saturday April 24th, check out SQLSaturday.  Its a great way to meet with other SQL Server professionals listen to some great presentations.  Some presenters are international speakers seen in SQL PASS, some are local from the…

0

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