Tag Archives: Microsoft SQL Server

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

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

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

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

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

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

  7. Auditing with “C2 Auditing” and “Common Criteria Compliance”

    Leave a comment

    September 7, 2021 by Kenneth Fisher

    I’m going to be fairly high level on these because to be honest, if you are going to use them …
    Continue reading

  8. SQL Homework – September 2021 – How good is your recovery plan?

    Leave a comment

    September 2, 2021 by Kenneth Fisher

    Last month I had you create a security standards document. This month we are going to document our recovery plan. …
    Continue reading

  9. Error: Cannot continue the execution because the session is in the kill state.

    Leave a comment

    August 24, 2021 by Kenneth Fisher

    This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to …
    Continue reading

  10. SQL Homework – August 2021 – Security Standards

    1

    August 3, 2021 by Kenneth Fisher

    A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
    Continue reading

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

Join 3,692 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013