Recently I ran into an unexpected problem where I tried to install multiple instances of SQL Server Reporting Services (SSRS) on one server. After installing the first SSRS instance successfully, I attempted to install the second instance. Only, I couldn't see where or how to install the second instance. It turns out, since SSRS 2017,… Continue reading Installing Multiple SSRS Instances on a Server is a Thing of the Past
Renaming and disabling the sa login
In theory, nobody should be using the sa login for anything. In reality however, I've seen many applications and processes configured to use it. Trying to change the way these applications and processes are setup, or convince people to change them, is a challenge to say the least... a challenge which I wont try to… Continue reading Renaming and disabling the sa login
Login Default Languages and the Effects of Getting it Wrong
There have been countless times where I've seen dates in SQL Server being interpreted differently to what people have expected. Sometimes the date is interpreted in the format dd-mm-yyyy whereas other times the date format is interpreted in the mm-dd-yyyy format. This can greatly change the results of queries or change the date that was… Continue reading Login Default Languages and the Effects of Getting it Wrong
How to Find Out the Progress of Maintenance Tasks
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
