Tag Archives: SQL Homework

  1. 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

  2. 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

  3. 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

  4. SQL Homework – December 2017 – View the log

    1

    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

  5. 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

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

    1

    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

  7. 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

  8. SQL Homework – July 2017

    10

    July 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

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

Join 2,176 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013