Creating a Distributed AG can have some issues. This article covers the problems that we encountered.
SQL
Duplicating an AG to another environment, for migration purposes.
Overview For a future article, I require a Listener for the Availability Group (AG) that was created from this article. This post describes the simple steps required to create a Listener.
Background For some investigative work that I had to do, I required an Availability Group (AG) that I could destroy and rebuild without impacting anybody else. Hyper-V was an obvious solution and this article describes the steps required.
Background Whilst watching a Pluralsight training course by Paul Randal, on ‘Logging, Recovery and the Transaction log’, a particular snippet related to differential backups piqued my curiosity. Basically, does a differential backup only take backups of altered pages, within a database. The short answer is ‘yes’, but the detail is a little bit more interesting …
No. Well, that was easy – I should write more articles that succinctly. Although the real answer, is of course – it depends.
Background I have a series of articles lined up, which require showing details of the log file. Using fn_dblog can be a series of articles in itself, so I’m covering a few basic scenarios here first.
Using a synonym to move a table to another database, without changing any queries.
Introduction Binary Large Objects (BLOB) data can be a graphical image, a pdf document, a music file or any of a wide range of data types, which can generally be saved into a SQL Server database. As part of a series of investigations I’m currently performing within SQL Server, I have looked at how BLOB …
Introduction The Microsoft documentation tells us that the SessionId column, within ASPStateTempSessions, consists of the Session ID plus the App ID. Although accurate, the method used for this does not make it obvious.
Notes on SQL 