How you SHOULD perform a manual fail-over of a SQL AlwaysOn Availability Group

Since the arrival of BizTalk Server 2016, Microsoft added support for SQL AlwaysOn. It still is new to many BizTalk operators, administrators and developers. Often having been dealing with older versions of BizTalk.
Not many people have been dealing with SQL AlwaysOn already, so this post is for non-BizTalk geeks as well…

There was always the need for high available SQL environments. Companies want their data and systems running in a way that downtime can be minimized and SQL Server has a lot of solutions to that problem, one of them being SQL AlwaysOn.

When having dealt with a SQL Failover Cluster before, you might be tempted to use the Failover Cluster Manager to fail-over an availability group, however this is NOT a good choice when dealing with SQL AlwaysOn…

Continue reading

Advertisements

What you need to know about SQL identity columns

As every other developer working with Microsoft SQL Server on-premise, you probably already came in contact with SQL IDENTITY columns. They are commonly used and are pretty straightforward… or at least they seem that way.

As an architect I regularly use them in my designs, but there are a few quirks I learned along the way that some of you might not have encountered yet.

Disclaimer: I’m not a DBA nor is this article intended for DBA’s, this is mainly directed towards developers.

So, now that we got our DBA disclaimer up….. 😉
Here are some of the things you might now know yet…

Continue reading