Category Archives: SQL Homework
-
SQL Homework – June 2019 – Property functions
Leave a commentJune 3, 2019 by Kenneth Fisher
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This …
Continue reading -
SQL Homework – May 2019 – SQLCMD and the DAC
5May 1, 2019 by Kenneth Fisher
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC …
Continue reading -
SQL Homework – April 2019 – Practice dealing with corruption
Leave a commentApril 3, 2019 by Kenneth Fisher
Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of …
Continue reading -
SQL Homework – March 2019 – Reconfigure tempdb
Leave a commentMarch 4, 2019 by Kenneth Fisher
You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor …
Continue reading -
SQL Homework – February 2019 – Instance configurations
4February 4, 2019 by Kenneth Fisher
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not …
Continue reading -
SQL Homework – January 2019 – Baselines
Leave a commentJanuary 2, 2019 by Kenneth Fisher
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
Continue reading -
SQL Homework – December 2018 – Configure SSMS
Leave a commentDecember 3, 2018 by Kenneth Fisher
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
Continue reading -
SQL Homework – November 2018 – Constraints
2November 5, 2018 by Kenneth Fisher
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
Continue reading -
SQL Homework – October 2018 – Time for an upgrade
1October 1, 2018 by Kenneth Fisher
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was …
Continue reading -
SQL Homework – September 2018 – Backup and Restore continued.
Leave a commentSeptember 3, 2018 by Kenneth Fisher
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to …
Continue reading
