hi,

Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.

I've got a table field with datatype varchar(10). If a value greater...

Better yet, click on the following MS Documentation about alerts and teach yourself something new.  It'll look better on your resume, as well.

https://learn.microsoft.com/en-us/sql/ssms/agent/alerts

It's not like the VLF count will go down auto-magically and so your morning report should do just fine in reporting databases that have a high VLF count.  If the...

Yes.  Ola Hallengren's backup  solution.  It's good and it's free.  I'm going to recommend that you do what a lot of people seem to not do... STUDY HIS DOCUMENTATION BEFORE...

I thought I had. Well,...

You haven't mentioned as to whether or not the redesigns are somehow better when all is said and done.

Personally, I'd just ask the boss.

Jeff, I've taken your suggestion. I didn't migrate one of our databases to Azure. Instead, I created an Azure SQL database using one of the AdventureWorks databases. It's small,...

It sounds to me like someone may have tried to move the database files and failed to do it correctly.  The MDF file may still exist someone on one of...

For the first statement, you don't actually know if that's...

Ooooo maaannnn... you hit a real "hot spot" there for me.

One of my favorite examples is...

I seriously agree about the ISO thing.  It's a real shame that MS hasn't made a few more built in functions around ISO Week and Year.

I advise caution when using...

Steve didn't write it.  His name shows up here because he's the person that...

Two way street here, Sam.  You've not answered my question above.  Why is someone trying to Truncate a table while others are trying to SELECT...

BLOCKSIZE makes a big difference when backing up...

How many backup files are you creating with these...