With regard to the recovery  model, I'd forgotten about Bulk-Logged.  It's definitely something to consider.  Another part of the standardisation is to review the backup policies and procedures...

I somehow managed to miss having more than one schedule for a job.  All the research I did was about varying the schedule rather than having more than one.  The...

p.s.  And stop using REORGANIZE for your index maintenance.  It doesn't work the way most people think (actually sets up indexes for perpetual fragmentation) and it's not the tame little...

• This reply was modified 6 years ago by Neil Burton.
• This reply was modified 6 years ago by Neil Burton.
• This reply was modified 6 years ago by Neil Burton.

I have my production databases set to be "exposed" to the possibility of a transaction log backup every 15 minutes, but it's stupid to do an actual T-Log backup...

I like the idea of it picking up automatically, I must say.

It's an out-of-the-box method too and I think the higher-ups will like that.  It might be time for a...

• This reply was modified 6 years ago by Neil Burton.

You could also configure a SQL Server Agent Alert to run a transaction log backup job when more than a specified percentage of the log is used.   I...

I went to see ROS with my brother-in-law and nephew between Christmas and New Year and I thought it was pretty good.  There were plot holes you could drive a...

• This reply was modified 6 years ago by Neil Burton.

What do you mean, Neil? The question states the data is encrypted in 2016, moved to 2017. There's no "up to date" here. The algorithm changes. You can't xfer...

Thanks Grant.  The next day or so is going to be spent testing things.  I want to make sure I'm not planning something completely stupid before I spend any more...

I have to say I think this is a bit naughty.  The usual assumption is that all servers involved in a question are up to date. In this case though,...

Thanks Neil,

I assumed this level of disdain, to those less experienced, had disappeared twenty years ago from technical forums - apparently not.

I will not be asking too many questions...

• This reply was modified 6 years ago by Neil Burton.

Absolutely not.  Mr Celko, while undeniably hugely knowledgeable, seems to...

As in most development the code should speak for it self, and you should use:

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

• Source control...

If you're worried about Alexa listening to everything, I can say that it (she?) doesn't listen when I ask to switch the bloody cellar lights on so I'd be surprised...

OK, we're getting somewhere now.

The big question is how to you unambiguously tie folder to folder2.  I can see what you want to do but there's no way to guarantee...