Tag Archives: SQL Homework

  1. SQL Homework – September 2022 – Query window challenge

    Leave a comment

    September 1, 2022 by Kenneth Fisher

    I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will …
    Continue reading

  2. SQL Homework – August 2022 – Replication part 1

    Leave a comment

    August 2, 2022 by Kenneth Fisher

    You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really …
    Continue reading

  3. SQL Homework – July 2022 – Update your resume.

    Leave a comment

    July 5, 2022 by Kenneth Fisher

    Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to …
    Continue reading

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

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

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

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

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

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

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

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

Join 3,709 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013