Tag Archives: Microsoft SQL Server

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

  2. Creating a Database Audit Specification can create new users & schemas in the background

    1

    June 28, 2022 by Kenneth Fisher

    I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on …
    Continue reading

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

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

  5. TSQL Tuesday #150 Invite – Your first technical job

    45

    May 3, 2022 by Kenneth Fisher

    This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start …
    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. Quiz & answers for my “Auditing your data and data access” session.

    1

    November 16, 2021 by Kenneth Fisher

    I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one …
    Continue reading

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

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

Join 3,696 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013