Category Archives: SQL Homework
-
SQL Homework – December 2019 – The default trace and the system health session.
Leave a commentDecember 2, 2019 by Kenneth Fisher
I know this is the holiday season for many of us (which ones depend on your religion and nationality of …
Continue reading -
SQL Homework – November 2019 – SSMS built in reports
1November 4, 2019 by Kenneth Fisher
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but …
Continue reading -
SQL Homework – October 2019 – Code review (self and peer)
Leave a commentOctober 2, 2019 by Kenneth Fisher
Every database person I’ve ever met writes at least some code at some point in their career. That code might …
Continue reading -
SQL Homework – September 2019 – Getting the data in
Leave a commentSeptember 2, 2019 by Kenneth Fisher
Everything else aside two of the most important tasks of a database are to get data in, and get data …
Continue reading -
SQL Homework – August 2019 – Getting the data out
Leave a commentAugust 5, 2019 by Kenneth Fisher
Everything else aside two of the most important tasks of a database are to get data in, and get data …
Continue reading -
SQL Homework – July 2019 – Table Size
Leave a commentJuly 1, 2019 by Kenneth Fisher
In general this homework series is meant to give you ideas of things to play with that most if not …
Continue reading -
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