Category: Experiences

Options for deleting large amounts of data

Options for deleting large amounts of data

Recently, I had a situation where a lot of data needed to be deleted. This was caused by a Monitoring system which was incorrectly configured. When Monitoring, you should Monitor just the information that you need, but no more. In this case, far too much information was being monitored and recorded, causing the Database that…

Read More Read More

Availability Groups – Making SQL Agent Jobs only run on Primary Replica

Availability Groups – Making SQL Agent Jobs only run on Primary Replica

I recently encountered some strange behaviour with SQLAgent Jobs in an Always On Availability Group. There’s a major difference between SQL Server Failover Cluster Instances (FCI) and SQL Server Availability Groups that makes it a little bit more complicated with SQLAgent Jobs. Put simply, with a Failover Cluster, there is only one “SQL Server” involved.…

Read More Read More

Using SQL Server Data Compression

Using SQL Server Data Compression

Over time, things come along that you think “that would have been so useful” in the past. Data Compression is one of those features within SQL Server.   Data Compression has been around for a few years. It was introduced in SQL Server 2008. I remember a conversation with Tony Rogerson (UK SQL Server User…

Read More Read More

Out of control Database Log Files

Out of control Database Log Files

I have previously spoken about the issues caused by Shrinking Data Files in SQL Server, but also some genuine reasons why you might need to do this, and how. Shrinking Log files is a different matter. Log files can grow enormously for a few reasons, quite often by accident. A common pattern occurs when someone…

Read More Read More

Checking Databases after Backup / Restore

Checking Databases after Backup / Restore

When Moving a Database between Servers – e.g. migrating to a new Production Server, how can you be absolutely sure that the Backup that you restored is the correct one? The nature of the DBA role dictates a certain amount of OCD. Most people work in a methodical manner – using a specific Folder for…

Read More Read More

Breaking into SQL Server

Breaking into SQL Server

I recently had a situation where I needed to access a SQL Server that I didn’t have permissions to. This was a bit inconvenient and always in such a situation, the SQL Server was experiencing difficulties that needed a quick resolution. An Application had been installed by someone with Domain Administrator privileges. The Application Installed…

Read More Read More

Shrinking Database Files

Shrinking Database Files

There are times when you need to do things that you’re told not to do. Scan the Internet, and you’ll find a lot of advice on Shrinking Database files. Generally, it’s “Don’t”. Paul Randal – “Don’t do it”, Pinal Dave – “Shrinking Database is bad”, Brent Ozar – “Don’t touch that dial”. In many cases,…

Read More Read More

Follow on Feedly

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close