Category Archives: SQL Homework

  1. SQL Homework – July 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

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

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

  4. SQL Homework – May 2018 – Create a database


    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

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

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

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

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


    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

  9. SQL Homework – December 2017 – View the log


    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

  10. SQL Homework Nov 2017: Create a view


    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

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

Join 2,442 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013