Browse the archive
Question We have a 3TB OLTP database running Siemens Opcenter MES software at one of our manufacturing plants in China. This is setup in an Always-On Availability group with one secondary node. As this is a manufacturing plant, we are only provided 11 1/2 …
Continue readingQuestion We have a few Basic Availability groups in production and I've been reading about the limitations of them. I'm concerned about the following limitations: No backups on secondary replica. No integrity checks on secondary replicas. Suppose that we …
Continue readingReplace sp_hexadecimal and sp_help_revlogin with a more maintainable way to script SQL Server logins.
Continue readingQuestion For SQL Server Enterprise's Always On availability groups in Synchronous Commit mode, is there some amount of latency that can't be exceeded? For example, can it work between very distant data centers, such as between the US and Europe?
Continue readingIn yesterday’s post, I showed how to configure an availability group (AG) to use the RegisterAllProvidersIP=0 when you can’t get clients to connect using the MultiSubnetFailover=true connection string attribute. I mentioned that you have to make some …
Continue readingAs a DBA, we have the opportunity & responsibility to build highly available database platforms for use by applications & users. Even if you are a DBA at a small company supporting databases for only internal applications, we are usually still responsible for …
Continue readingAssume you have configured a transactional replication publisher, which is part of an availability group (AG). Now, you have an asynchronous secondary AG (or mirroring) replica that is offline. Perhaps this is a DR node, and you are doing patching or other …
Continue readingTest SQL Server permissions as another user without knowing or resetting that person’s password.
Continue readingUserSteve is upgrading to a new server and needs to move all his server settings to the new instance. I introduce him to DBA Tools as a quick way to copy configurations and other stuff to the new instance.
Continue readingStarting with SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3, you can now configure your distribution database as part of an Availability Group (AG). I found one spot where a minor change made a few of my scripts blow up.
Continue reading
