Category Archives: SQL Homework
-
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
Leave a commentJanuary 5, 2021 by Kenneth Fisher
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true …
Continue reading -
SQL Homework – December 2020 – Participate in the Advent of Code.
Leave a commentDecember 3, 2020 by Kenneth Fisher
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect …
Continue reading -
SQL Homework – November 2020 – Help!
Leave a commentNovember 3, 2020 by Kenneth Fisher
If you ask any senior IT person What is the most important tool you have? there is a decent chance that …
Continue reading -
SQL Homework – September 2020 – More DML Triggers
Leave a commentSeptember 1, 2020 by Kenneth Fisher
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all …
Continue reading -
SQL Homework – August 2020 – Write a SELECT statement.
Leave a commentAugust 13, 2020 by Kenneth Fisher
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was …
Continue reading -
SQL Homework – June 2020 – DML Triggers
Leave a commentJune 4, 2020 by Kenneth Fisher
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds …
Continue reading -
SQL Homework – May 2020 – Forum Lurking.
Leave a commentMay 4, 2020 by Kenneth Fisher
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among …
Continue reading -
SQL Homework – April 2020 – Continuity planning.
3April 1, 2020 by Kenneth Fisher
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world …
Continue reading -
SQL Homework – March 2020 – Database Configurations.
Leave a commentMarch 2, 2020 by Kenneth Fisher
A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this …
Continue reading -
SQL Homework – February 2020 – Write a blog post.
1February 3, 2020 by Kenneth Fisher
Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what …
Continue reading