Category Archives: SQL Homework

  1. SQL Homework – October 2018 – Time for an upgrade

    Leave a comment

    October 1, 2018 by Kenneth Fisher

    When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was …
    Continue reading

  2. SQL Homework – September 2018 – Backup and Restore continued.

    Leave a comment

    September 3, 2018 by Kenneth Fisher

    In the very first SQL Homework post you were asked to take a backup. In fact it asked you to …
    Continue reading

  3. SQL Homework – August 2018 – Set up database mail

    Leave a comment

    August 1, 2018 by Kenneth Fisher

    This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail. Why database mail? …
    Continue reading

  4. SQL Homework – July 2018 – Create a SQL Agent Job

    Leave a comment

    July 2, 2018 by Kenneth Fisher

    For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used …
    Continue reading

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

  6. SQL Homework – May 2018 – Create a database

    4

    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

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

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

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

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

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

Join 2,461 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013