Category Archives: SQL Homework

  1. SQL Homework – June 2018 – Alter a database

    Leave a comment

    June 4, 2018 by Kenneth Fisher

    Here we are again. The beginning of another month. At the beginning of each month I put out a SQL …
    Continue reading

  2. SQL Homework – May 2018 – Create a database

    2

    May 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

  3. SQL Homework – April 2018 – Indexes

    Leave a comment

    April 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

  4. SQL Homework – March 2018 – Recovery Objectives

    Leave a comment

    March 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

  5. SQL Homework – February 2018 – Work with security

    Leave a comment

    February 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

  6. SQL Homework – January 2018 – Inspect an Execution Plan

    6

    January 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

  7. SQL Homework – December 2017 – View the log

    2

    December 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

  8. SQL Homework Nov 2017: Create a view

    3

    November 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

  9. SQL Homework – October 2017 – Sample/Test Database(s)

    2

    October 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

  10. SQL Homework – August 2017 – Create a table

    4

    August 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,423 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013