Replication and Linked Servers

Problem I recently hit upon an issue with trying to setup a linked server to an instance which was already a subscriber to a publication. When replication is setup, it actually creates a remote server for the subscriber. However that ‘remote server’ is not configured for data access. So if you try to use that…

2

My Favorite SQL Server Blogs

At our workshops and during other customer interactions, we are usually asked for links to good blogs and reading materials. Here is a list of my favorite SQL-related blogs, arranged in no specific order. http://blogs.msdn.com/craigfr: Craig Freedman on Query Processing (QP) http://blogs.msdn.com/sqlprogrammability: Plan cache, parameterization etc. http://blogs.msdn.com/sqlserverstorageengine: Storage Engine http://blogs.msdn.com/repltalk: Replication support team http://blogs.msdn.com/psssql: CSS…

1

Hack of the day: Shrink all log files in the instance

Before I proceed, I will add two disclaimers: This script is provided as-is for knowledge purposes. It is not a recommendation, or in any way intended for production usage. No warranty or guarantee is made about the correctness of the script. Use it at your own risk. We do not recommend using SHRINK operations on…

3

Priority boost details – and why it’s not recommended

Some times, we see customer has (accidentally or otherwise) enabled the option ‘boost priority’ for SQL Server worker threads. In general Microsoft does not recommend that you set this option. Why? First a bit of background. When we set the ‘priority boost’ option using sp_configure what is happening is that after restart the SQL engine…

10