OK, so, importing from Excel and creating a database are two very different operations. Let's focus first on the create database question. In SSMS, either, right click on databases, select...

All great stuff. I could do with reducing TV time as well. Let me get this book rewrite finished because that's taking up my will power at the moment. I...

I feel ya! First thing I learned in PostgreSQL was backup and restore. It's just where my brain goes.

Why not make @Period an actual date and then use date math on the value there? Seems like it'd be easier.

Strong recommendation. Read through the Azure documentation on backups, restores, and retention. Partial recovery is likely to be a challenge (it's a challenge on a local machine). You're going to...

See, this is why I always (usually LoL) skim the directions for something before getting started!

It's amazing, though, how enough "little frustrations" can quickly add up to becoming a...

BTW, finished the awning yesterday, a week later.

And it was horrible. I mean, it looks great, works and all. The process of mounting it was horrible.

Damn those mynocks.

Rod, thanks for sharing that one. Great insight.

Chris. BWA-HA-HA. Sorry, probably shouldn't laugh.

Nice one Aaron. I've seen people try to make line count a measure. I told 'em straight up, I can make the line count go really, really high if necessary.

HA!...

Maybe I'm being pedantic, but I've never heard of a primary key index. As far as I know, you can make a table with a primary key that is...

I've seen all sorts of different setups. To my mind, there's not a single correct approach. It's down to understanding the architecture and where your bottlenecks are. Especially with a...

I know you fixed this already. Well done. However, figured I'd post this in case you, or anyone else, needs to hear it.

Databases are code.

They are. Yes, yes, the data...

Grant, I totally agree.  It has served me well in my career to always own up to mistakes.  Another developer I worked with always said it happens that sometimes...

Thanks for all the feedback everyone. For some reason it didn't show up in my email as per usual (I probably broke something).