Notes on SQL

Random articles from a puzzled DBA

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 …

Continue reading

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 …

Continue reading

Introduction In a previous article article, I wrote about how to find out where the SQL Server error log is located. That particular article was in case your server instance did not start and you needed more information. If your SQL Server instance is working, there is another way to find the location of the …

Continue reading