Tag Archives: Microsoft SQL Server

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

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

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

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

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

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

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

    3

    September 28, 2021 by Kenneth Fisher

    One of the easiest ways to collect information about table activity is to add a series of audit columns to …
    Continue reading

  9. #PowershellBasics: Bulk insert.

    Leave a comment

    September 21, 2021 by Kenneth Fisher

    In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql …
    Continue reading

  10. Database Sizes

    7

    September 14, 2021 by Kenneth Fisher

    Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure …
    Continue reading

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

Join 3,616 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013