Free Windows/SQL Perfmon Counter poster from Quest Software

Free Windows/SQL Perfmon Counter poster from Quest Software Chris Skorlinski SQL Server Escalation Services The Quest Software team did a great job building a SQL Server Perfmon Counters Poster.  This poster provides description of key Windows/SQL Perfmon counters with recommended target values. A great resource for understanding areas to focus when troubleshooting SQL performance.

0

How to Archive your SQL Errorlogs into a Table

How to Archive your SQL Errorlogs into a Table Chris Skorlinski Microsoft SQL Server Escalation Services Have you noticed your SQL Server errorlogs taking up a lot of disk space?  Ever wonder what was logged a few weeks ago, but the logs have already rolled over?  Why not create a SQL Agent job and archive…

0

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