SQL and friends
I woke up at 6am after a restful 8 hours of sleep. Read for a bit, installed SQL Express on my laptop, ate a bowl of Raisin Bran, met up with a friend for coffee, called another friend, then came home to start the exercises in my Exam Reference book. The first exercise went well - it only used tempdb. The second exercise used a database called WideWorldImporters. I assumed it was a sample database that one can download through some Microsoft site. Found it! https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 Yep. Downloaded WideWorldImporters-Full.bak and set to work restoring the backup to my machine. I'd done that at work plenty of times. Heck, I can just use the GUI if I'm feeling lazy. GUI it is!!! The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'CreateDirectoryW' on '\?\D:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\WideWorldImporters_2