by XTIVIA | Aug 22, 2019 | Blog, SQL Server
There may be a situation when you need to move one of your servers that is part of an Availability Group to a different data center and the IP address for that server will change. In this example, we will be moving a DR node from one data center to another and change...
by XTIVIA | May 23, 2019 | Blog, SQL Server
When you create a new Availability Group there are a couple of administrative tasks that should be completed before creating your Availability Group within SQL Server. This will elevate any domain permission issues when you are trying to create your Availability Group...
by Tony Salerno | May 20, 2019 | Blog, Database
Showcasing popular databases in the Database 101 series was meant to provide an introduction to database information and also XTIVIA’s exceptional database services. With the introductions out of the way, we’d like to share a little bit about our company...
by XTIVIA | Oct 9, 2018 | Blog, SQL Server
Replication is a great way to copy tables/data from one server to another so you can do reporting on the second server. Within replication tables, stored procedure, functions, views, and indexed views are called articles but in this blog tables and articles mean the...
by XTIVIA | Sep 27, 2018 | Blog, SQL Server
AlwaysOn Availability Group (AG) is one of my favorite features in SQL Server and is worth considering when using SQL server 2012 or greater. One of the nicest features in AlwaysOn AG is that in a single subnet environment it can be totally transparent to your...
