Creating a Distributed AG can have some issues. This article covers the problems that we encountered.
Uncategorized
Overview As part of a series of development actions, we need to replace our SQL Server 2012 installations with SQL Server 2017. This is a four-node Availability Group (AG) for a system that is required 24/7 – so downtime is best avoided.
Overview When upgrading a SQL Server installation to SQL2017, SQL Server Reporting Services (SSRS) is now a stand-alone installation. This short article lists the main issues that we encountered, as best as I can recall.
So, Paul Randall is offering to mentor six people for a couple of months, in response to the feedback from the Tribal Awards last year. Now that’s a double-edged sword, isn’t it? First of all, the opportunity to seek guidance and assistance from one of the most knowledgeable people in the SQL Server community, for …
Well that was fun. Setting up the WordPress account was quite straightforward and there’s plenty of material out there about creating a basic post for it. However, I wanted to be able to include SQL code that could be copied by anybody reading the article – much friendlier than making them type it back out …
Notes on SQL 