You could use dbatools.io (already mentioned) to move logins, linked servers, jobs etc ahead of time.  We did this a couple of years ago when switching between data centers.  We...

Hi,

Thanks for the response, but I don't understand?  I'm aware that the backups are encrypted - We migrated the certificates to the new instance before we could restore our databases.

The...

We're doing the same holidays as last year.  Maybe boring to some, but we love it.

We headed down to Devon, South West England for the May school half...

Nice, we don't use Azure, but backups are tested regularly for creating internal data sets as well as scheduled tests from tape.

As well as verifying the backups can...

I always used to store them on USB, then Google Drive.  However, I have since created a private github repository for all my scripts.  This way, they are accessible whether...

Nice post. My only grumble would he the reference of 300s as a threshold for the PLE counter. It's a really old piece of information which may not be relevant.

Assume...

No, I've never been asked to design an ER diagram during an interview.  Like you, questions on designs, normalisation etc.

The most interesting test was to write a Sudoku...

Two weeks in sunny Florida. It will be our 3rd trip in a row. Maybe a bit boring for some, but our 5 year old loves it. So do his...

Valid point!

I think NoSQL has it's uses. The trend I've experienced is poor database and/or query design in relational databases can lead some developers to believing that the relational database...

Could be numerous things. A baseline springs to mind as a comparison, but that's a little late now.

Have you traced the start up to see what it is actually...

I'm yet to read the article in full, but in principal, the concept is great. All too often, people ignore a baseline and then wonder what is the "norm"...

Great post, Steve. Given my current situation, it was a compelling read.

I've only ever used this once. We had a client who wanted to move from our hosted platform to their own infrastructure. Rather than wait on courier to...

Sounds like some nasty little application creating all of those databases. Weird, as you say!

One comment would be the use of sp_msforeachdb. Personally, I'm not a fan because...