Pop quiz: You manage a production database and you need a copy of your backups to restore them on a development environment for application testing or performance tuning. You need to do this on a regular basis. Do you Take a backup of the database and restore it on your development environment? Configure replication between your […]
Have you ever wondered why your SQL Server database takes a long time to restore? How about why a failover of your Availability Groups, Failover Clustered Instances or even database mirroring configuration is taking a long time? I know I have. I’ve gone from querying the sys.dm_exec_requests DMV to check for the status and percentage of […]
If you’re a database administrator (DBA) reading this blog post, you might be thinking, “why would I find my replacement?” Instead of asking that question, why not, “how can I find an excellent assistant so I can finally take that long awaited vacation?” If you’re a manager or in a leadership position, you can refer to these […]
Have you been made aware of an item in your household that seem so common and familiar but that could have an impact in your safety? Like that little remote you tuck in the sun visor of your car to open your garage. In case you are not aware, someone might be able to hack open your […]
This is a very common question that gets asked on the technical forums, newsgroups, social media, etc. when it comes to synchronous SQL Server Always On Availability Groups (AG): “Why did my AG not automatically failover?” Notice that I mentioned SYNCHRONOUS and not asynchronous. Only when Always On Availability Group replica databases are configured for synchronous commit […]