Monthly Archives: June 2021

  1. Another reason I prefer side-by-side SQL Server instance upgrades.

    1

    June 29, 2021 by Kenneth Fisher

    This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of …
    Continue reading

  2. DDL Trigger to log database level security commands.

    4

    June 24, 2021 by Kenneth Fisher

    In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
    Continue reading

  3. Why are my permissions missing?

    Leave a comment

    June 22, 2021 by Kenneth Fisher

    You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz …
    Continue reading

  4. #PowershellBasics: Finding a common AD group for a set of users.

    3

    June 17, 2021 by Kenneth Fisher

    A while back (almost 7 years 😲) I wrote a post on finding the common AD groups of a set …
    Continue reading

  5. Long names vs short names (or aliases)

    8

    June 15, 2021 by Kenneth Fisher

    I remember when I was first learning to code there was always the argument of how long a name should …
    Continue reading

  6. CROSS vs OUTER APPLY

    2

    June 10, 2021 by Kenneth Fisher

    I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
    Continue reading

  7. My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139

    Leave a comment

    June 8, 2021 by Kenneth Fisher

    One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about …
    Continue reading

  8. Use BCP to create a CSV (comma delimited) file from a table.

    1

    June 3, 2021 by Kenneth Fisher

    This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one …
    Continue reading

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