Here are the main things I worked on last week (in addition to my 'normal' work for clients, which I don't detail here):
- I watched several videos from the "SQL Server tutorial for Beginners" playlist on YouTube, which is produced by kudvenkat. As you know, I am not a beginner with SQL Server. Even so, I don't have much practical experience with the LEAD(), LAG() and windowing functions. I've been working on a project where these functions are beneficial, so I am learning more about them. I found the ten or so videos that I watched up around the "Part 110" area to be well-explained.
- I am up to page 145 in my "Implementing a SQL Data Warehouse" review.
- My progress was impeded by having to catch up with the quarterly and annual bookkeeping.