Category Archives: SQLServerPedia Syndication

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

  2. Database Sizes

    6

    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

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

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

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

  6. Rule 1: Be kind, be polite.

    2

    August 31, 2021 by Kenneth Fisher

    In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding …
    Continue reading

  7. The sysname datatype defaults to not NULL.

    3

    August 26, 2021 by Kenneth Fisher

    The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
    Continue reading

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

  9. A new presentation on Auditing your databases

    Leave a comment

    August 19, 2021 by Kenneth Fisher

    I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be …
    Continue reading

  10. Work requests: It’s broke. Fix it.

    3

    August 12, 2021 by Kenneth Fisher

    Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you …
    Continue reading

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

Join 3,570 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013