Instant File initialization now works against the log file – with caveats.
SQL
Creating a Distributed AG can have some issues. This article covers the problems that we encountered.
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 …
Notes on SQL 