Skip to content

dba2.o

Get data fast!

  • Contact
  • About
  • Training
  • PBI (Demo)

Tag: Availability Group

SQL Server Read-Only Routing

03/25/201903/25/2019 Hiram3 Comments

Not too long ago, I had a conversation with a friend about how SQL Server Always On Availability Groups and how they could be configured for Read-Only routing. This is a typical scenario when folks want to leverage their secondary replicas (nodes) for read-only workloads. This allows you to build an active-active cluster where one… Continue reading SQL Server Read-Only Routing →

25.873613 -80.270950

SQL Server 2017 – Deferred Name Resolution Bug.

05/17/201805/17/2018 HiramLeave a comment

This issue came up recently while in the midst of an upgrade to SQL Server 2017, but it's actually not related to the upgrade and has been around all along on previous versions. So I took a moment to write this, cause a friend told me it would make a nice blog post. Mad credit… Continue reading SQL Server 2017 – Deferred Name Resolution Bug. →

Recent Comments

  • Azure Synapse Analytics Shared Security – Curated SQL on 🔐Security in a shared workspace
  • Getting Started with Sparks in Azure Synapse Analytics – Curated SQL on 🗺️Guide: Synapse Spark ✨ – Getting Started
  • Speeding Up Azure Data Factory Pipelines – Curated SQL on My pipeline is slow, what do I do?
Website Built with WordPress.com.
  • Follow Following
    • dba2.o
    • Join 33 other followers
    • Already have a WordPress.com account? Log in now.
    • dba2.o
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

You must be logged in to post a comment.