Category Archives: SQL Homework
-
SQL Homework – May 2018 – Create a database
4May 2, 2018 by Kenneth Fisher
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as …
Continue reading -
SQL Homework – April 2018 – Indexes
Leave a commentApril 2, 2018 by Kenneth Fisher
This month we are going to look at a topic near and dear to both database developers and database administrators …
Continue reading -
SQL Homework – March 2018 – Recovery Objectives
Leave a commentMarch 5, 2018 by Kenneth Fisher
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
Continue reading -
SQL Homework – February 2018 – Work with security
Leave a commentFebruary 5, 2018 by Kenneth Fisher
This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
Continue reading -
SQL Homework – January 2018 – Inspect an Execution Plan
6January 3, 2018 by Kenneth Fisher
It’s a new year and yet education never ends. So this month let’s take a look at an important part …
Continue reading -
SQL Homework – December 2017 – View the log
3December 4, 2017 by Kenneth Fisher
Last homework of the year. Last month was to create a view. This month it’s time to take a look …
Continue reading -
SQL Homework Nov 2017: Create a view
3November 1, 2017 by Kenneth Fisher
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
Continue reading -
SQL Homework – October 2017 – Sample/Test Database(s)
2October 2, 2017 by Kenneth Fisher
Last month your homework was to set up your own lab. Now it’s time to put a sample database or …
Continue reading -
SQL Homework – August 2017 – Create a table
5August 2, 2017 by Kenneth Fisher
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month …
Continue reading -
SQL Homework – July 2017
11July 3, 2017 by Kenneth Fisher
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a …
Continue reading
