Category Archives: SQL Homework
-
SQL Homework – December 2021 – Changing collation
Leave a commentDecember 2, 2021 by Kenneth Fisher
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked …
Continue reading -
SQL Homework – November 2021 – Backup, restore, and move the system databases.
2November 2, 2021 by Kenneth Fisher
On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points …
Continue reading -
SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?
Leave a commentOctober 5, 2021 by Kenneth Fisher
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? …
Continue reading -
SQL Homework – September 2021 – How good is your recovery plan?
Leave a commentSeptember 2, 2021 by Kenneth Fisher
Last month I had you create a security standards document. This month we are going to document our recovery plan. …
Continue reading -
SQL Homework – August 2021 – Security Standards
1August 3, 2021 by Kenneth Fisher
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
Continue reading -
SQL Homework – July 2021 – Log shipping
Leave a commentJuly 1, 2021 by Kenneth Fisher
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy …
Continue reading -
SQL Homework – June 2021 – SQL Audits
Leave a commentJune 1, 2021 by Kenneth Fisher
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. …
Continue reading -
SQL Homework – May 2021 – Extended Events.
2May 4, 2021 by Kenneth Fisher
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to …
Continue reading -
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 Studies 