Posts in Database Architecture

Availability Group Endpoint URL Firewall Gotcha

A few days ago I was working on changing the Endpoint URL and Port for a 2016 SQL Server Availability Group to use a private network interface. We wanted this so we could have the Synchronizing (or Mirroring) traffic have its own dedicated network, which would keep it away from the network traffic of client connections to the database server. This would help increase the throughput of data to and from the databases in the Availability Databases list.

Our setup is a straight forward Windows Cluster with two Nodes. We have two stand alone SQL Server Instances running on these Nodes. Each Instance has an Availability Group defined with one Node the Primary Replica and the other Node the Secondary Replica. We run the Replicas in Synchronous Commit Availability Mode with Automatic Failover. All connections are allowed to the Primary Role and the Readable Secondary is set to no.

Read More

AWS really does make the Pain of Purchasing Servers go away

I have thought a lot about how I used to provision traditional IT resources, and how differently I would provision Amazon Web Services resources in the cloud today. Maybe you can benefit from my perspective, based on experience, that keeps it plain and simple.

In the past, I had to think about how much hardware and software I could buy with a given budget. I would over-engineer the architecture, since I would have to live with it for several years. It was better to be safe with more than I could use, than be sorry trying to explain why the money already spent wasn’t enough. Building a whole test system up front to prove it would work would also increase costs, Read More

Pay the Piper – Software Licensing and Audits

Once upon a Wikipedia safari, I found myself sucked into the article on the Pied Piper of Hamelin. I read that contrary to popular belief, the expression “pay the piper” actually comes not from the Pied Piper, but from the phrase “He who pays the piper calls the tune.” You learn something new every day, I thought to myself. You see, over the years, I have advised employers, clients, and contemporaries that when it comes to software licensing, it is best to “pay the piper.” It was an expression I learned as a kid in the Boston area. Keep reading…

We're Here To Help.

Database problem? Tell us a little bit about it.

Name*

Email*

Subject

Message*

captcha

* Required