Tag Archives: Microsoft SQL Server

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

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

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

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

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

  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. Commenting a branching IF-THEN-ELSE.

    1

    October 19, 2021 by Kenneth Fisher

    I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE …
    Continue reading

  8. Code examples : T-SQL Tuesday #143

    Leave a comment

    October 12, 2021 by Kenneth Fisher

    It’s TSQL Tuesday! John Armando McCormack (blog|twitter) is our host this month and he’d like us to share some of …
    Continue reading

  9. Dealing with foreign keys when deleting rows.

    2

    October 7, 2021 by Kenneth Fisher

    Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of …
    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,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013