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 …

Passing the AWS Certified Solutions Architect Exam

Even without in-depth knowledge of the material, some people are good at taking a test. I am not one of those individuals. I tend to lean on my thorough understanding of the information and my ability to explain it if needed. That way, I am assured that I will pass the exam and my knowledge will …

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 …

See you in the Cloud!

I remember the good old days when provisioning a new server for production was a big deal. All sorts of teams were involved in the purchasing process, and by the time a purchase order was approved, all participants celebrated their birthday twice. The server was usually scaled up, with the center of interest being the CPU …

AWSome Day Ft. Lauderdale 2018 is almost here

AWSome day Fort Lauderdale is only one day away. If you are not familiar with AWSome day, it is a one-day training event hosted by Amazon that focuses on services for compute, storage, database, and networking. The Boward County Convention Center located at 1950 Eisenhower Blvd, Fort Lauderdale, FL 33316 will host the event on April …

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 …