You kick off a few maintenance tasks on your SQL Server instance, or they they were scheduled to start via a job which may be slowing your server down. For example a full backup, or a DBCC CHECKDB, or maybe even shrinking a file. You might be getting a touch nervous of the potential impact… Continue reading How to Find Out the Progress of Maintenance Tasks
Default Directories
You decide to create a new database, or restore one for that matter, and you find that it creates or restores the database to a file location you didn't expect. Why did the data file end up on the C: drive? Why did the transaction log file end up in the same location as the… Continue reading Default Directories
Introduction
Hi! I’m Chad. I love data, travelling and anything to do with sport. I decided it's about time I started blogging some of the interesting things I come up against and figure out, so to help other people out there who may by chance be reading this blog. I originally hail from Auckland, New Zealand,… Continue reading Introduction