Tag Archives: SQL Homework

  1. SQL Homework – June 2022 – SQL Agent Jobs continued.

    2

    June 2, 2022 by Kenneth Fisher

    A few years ago I gave you homework to create a SQL Agent Job and play with it a little …
    Continue reading

  2. SQL Homework – May 2022 – Books on Line

    Leave a comment

    May 5, 2022 by Kenneth Fisher

    No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of …
    Continue reading

  3. SQL Homework – March 2022 – Formatting

    Leave a comment

    March 1, 2022 by Kenneth Fisher

    Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries …
    Continue reading

  4. SQL Homework – February 2022 – “Soft” skills.

    Leave a comment

    February 1, 2022 by Kenneth Fisher

    Well, it’s a new year and a new start, even if I am a bit behind the start of the …
    Continue reading

  5. SQL Homework – December 2021 – Changing collation

    Leave a comment

    December 2, 2021 by Kenneth Fisher

    I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked …
    Continue reading

  6. SQL Homework – November 2021 – Backup, restore, and move the system databases.

    2

    November 2, 2021 by Kenneth Fisher

    On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points …
    Continue reading

  7. SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?

    Leave a comment

    October 5, 2021 by Kenneth Fisher

    Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? …
    Continue reading

  8. SQL Homework – September 2021 – How good is your recovery plan?

    Leave a comment

    September 2, 2021 by Kenneth Fisher

    Last month I had you create a security standards document. This month we are going to document our recovery plan. …
    Continue reading

  9. SQL Homework – August 2021 – Security Standards

    1

    August 3, 2021 by Kenneth Fisher

    A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
    Continue reading

  10. SQL Homework – July 2021 – Log shipping

    Leave a comment

    July 1, 2021 by Kenneth Fisher

    Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy …
    Continue reading

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

Join 3,692 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013