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.
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.
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.
Introduction Continuing my series of XML articles I’m going to move from XML RAW to XML AUTO with a handful of examples that share features between the two.
Introduction Most systems that I have worked with make use of the XML data type. I don’t find it to be the most intuitive data type to work with but most aspects of it can be built upon from a few basic examples. This will be part of a developing series that will cover XML …
Having attempted to start an old test instance from SQL Server Configuration Manager, I received the wonderful error “The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details” More helpful than some message you can get – at least it tells …
Introduction As part of my research into the various methods of protecting sensitive data, I’ve taken a look at dynamic data masking. A short demonstration and some observations are in the following article.
Notes on SQL 