Went to Iceland earlier in the year, to see the Northern Lights and it was spectacular. However, you may well spend a lot of time just standing outside and waiting...

I would suspend data movements to the databases that are part of the AG group, before applying any updates. We did this when applying a service pack to all servers...

Nice article but testing of this function is a must. When looking into these commands a few months ago, although the general trend was a reduction in data length I...

My youngest son gained a degree in Civil Engineering a few years ago and while I can't imagine it helped him too much with the following three years he worked...

Nope, you can have all of your partitions in the same filegroup - An example here.

A 'sand pit' system, where it doesn't matter what kind of mess you make is a first recommendation. It can be either on your machine or another server (VMs are...

I always thought that it should be configurable with that software.
At my previous job I documented every column, table, stored proc, parameter and so on, using SQL Doc and...

I've been giving this question some thought for a few days and I think the best day I had was the day that I realised that, in actual fact, I'm...

Yes, SQL Prompt. I've used it in every company I've worked for as a DBA - even if I'd had to persuade them to buy it.
Currently trying to get...

How many rows and what table size are we talking about here?
I have a table with 2.4 billion rows and although it isn't my favourite table, I don't feel...