Replication READPAST error in SQL Server 2012

I have a client that is using transactional replication to offload resource intensive processing from production to a standalone reporting server. Everything works flawlessly until one day during a routine application upgrade SQL Server throws the following error: Msg 650, Level 16, State 1, Procedure sp_MSfixup_base_columns, Line 40 You can only specify the READPAST lock in …

ALTER DATABASE REMOVE AUTOSHRINK PERMANENTLY

When a database gets created, restored, or attached to SQL Server, this T-SQL command should execute by default. Seriously, if this command exists, that’s probably how most database administrators will find it applicable. The side effects of auto-shrink outweigh any potential benefits. Below are some of the disadvantages of auto-shrink. It will lead to indexes becoming …

Principle of Least Privilege and SysAdmin

I am often fascinated or should I say disgruntled by the lack of emphasis on the principle of least privilege (POLP). Don’t get me wrong, who wouldn’t want to be a SYSADMIN? Ask me that question, and I’ll be startled immediately. The answer will always be, YES! And that’s a “YES” with a smile. Let’s be …