Thoughts on Correlating data when troubleshooting

Let’s face it; troubleshooting can be quite painful, and if you find yourself troubleshooting a production issue, chances are it’s impacting normal business operations. There are no recipes for troubleshooting, and one person’s approach is usually quite different from another. And even if a problem reoccurs, the first troubleshooting technique may be quite different from subsequent …

Have Replication Latency? Say Hello to NitroAccelerator

Let’s get to the facts. SQL Server transactional replication is am impressive technology for synchronizing data between two databases: the publisher and the subscriber. Data can be relatively up-to-date between the two databases and in some cases near real-time performance can be achieved with high network speed resulting in low latency. Its wizard-based setup is easy …

AWS SQL Server Backup/Retention Policy

One of the primary responsibilities of a database administrator is to architect an effective and cost-saving backup and retention policy to manage database backups throughout its lifecycle. In AWS, this could save the company a chunk of change each month. And hear me out when I say, regardless of the savings, any amount is better than …

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 …