Monthly Archives: September 2021

  1. A DBA horror story in database file extensions.

    4

    September 30, 2021 by Kenneth Fisher

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

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

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

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

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

  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

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

Join 3,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013