Category: Resources – SQL Server

Where did all the disk space go?

Where did all the disk space go?

I seem to suffer from a recurring event. Disk space just disappears. We have monitoring in place which alerts once free disk space has passed a set threshold (generally 20% left). Service Tickets are raised, the issue is resolved and the ticket is closed. Recently, a Service Ticket was re-opened a week later with a…

Read More Read More

MAP Toolkit – SQL Server Inventory data for free!

MAP Toolkit – SQL Server Inventory data for free!

The Microsoft Assessment and Planning (MAP) Toolkit is provided by Microsoft as a simple way of identifying what Servers you have on your Network. This allows you to ensure that everything is licensed and paid for. So kind. MAP Toolkit also helps you to plan migrations onto Virtual Platform, helping you choose additional Microsoft product…

Read More Read More

T-SQL Tuesday #102: Giving Back

T-SQL Tuesday #102: Giving Back

T-SQL Tuesday was started some time ago by Adam Machanic whereby lots of people blog their thoughts on a common topic. Month #102 is hosted by Riley Major with the topic of “Giving Back”, Riley is encouraging people to ask themselves not what they can get, but what they can give back to the SQL…

Read More Read More

Runaway Rollbacks… or I stopped my SQL Query, so why is it still running?

Runaway Rollbacks… or I stopped my SQL Query, so why is it still running?

I received a call for help today. A Developer called to say that they had “killed a query, but it just won’t stop”. Actually, it wasn’t the Developer responsible, but his colleague, but that’s irrelevant. “can you take a look”?   As a DBA, killing a SQL Server query is generally used a last resort.…

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

SQL Server Podcasts

SQL Server Podcasts

      I’m fortunate enough to be able to run or walk some of my daily commute. This leaves me with some time to listen to Podcasts – think of them as specialist Radio Shows that you can schedule yourself. Some of them are just about SQL Server. To listen to a Podcast, you…

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

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