Category Archives: Microsoft SQL Server

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

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

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

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

  5. A DBA horror story in database file extensions.

    4

    September 30, 2021 by Kenneth Fisher

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

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

  8. #PowershellBasics: Running a .sql script file.

    5

    September 16, 2021 by Kenneth Fisher

    As with all programming tasks there are a number of ways to do something, this is just one that I …
    Continue reading

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

  10. Remote Desktop: Force the resolution to match the screen size.

    1

    September 9, 2021 by Kenneth Fisher

    One of the things I hate most about using remote desktop is when the resolution for the remote server is …
    Continue reading

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

Join 3,581 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013