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

    Category: Microsoft SQL Server, Powershell, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: ,

  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

    Category: Auditing, Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Backups, Documentation, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , , , , , ,

  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

    Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication | Tags: ,

  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

    Category: Documentation, Microsoft SQL Server, Security, SQL Homework, SQLServerPedia Syndication | Tags: , , ,

  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

    Category: Microsoft SQL Server, SQLServerPedia Syndication | Tags:

  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

    Category: Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: ,

  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

    Category: Backups, Extended Events, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , , , ,

  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

    Category: Auditing, Extended Events, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

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

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013