Tag Archives: Microsoft SQL Server

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

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

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

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

  7. Server vs Instance. A rant.

    2

    July 29, 2021 by Kenneth Fisher

    It’s a SQL Server Instance not a SQL Server. The product is SQL Server. The installed copy is an Instance. …
    Continue reading

  8. How do I unlock a SQL Server Login using T-SQL (without changing the password)?

    1

    July 22, 2021 by Kenneth Fisher

    We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a …
    Continue reading

  9. SQL Homework – July 2021 – Log shipping

    Leave a comment

    July 1, 2021 by Kenneth Fisher

    Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy …
    Continue reading

  10. SQL Homework – June 2021 – SQL Audits

    Leave a comment

    June 1, 2021 by Kenneth Fisher

    Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. …
    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