Tag Archives: security

  1. As a DBA, am I a gatekeeper?

    6

    August 27, 2020 by Kenneth Fisher

    TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
    Continue reading

  2. HAL0004 – I don’t feel well Dave

    Leave a comment

    June 29, 2020 by Kenneth Fisher

    It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for …
    Continue reading

  3. I created a table and SQL created a schema and a user.

    Leave a comment

    June 22, 2020 by Kenneth Fisher

    Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick …
    Continue reading

  4. Could not obtain information about Windows NT group/user

    Leave a comment

    May 6, 2020 by Kenneth Fisher

    This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, …
    Continue reading

  5. Call to action: What do you own?

    2

    April 29, 2020 by Kenneth Fisher

    You restored that database, did you remember to change the owner or is it still you? How about that job …
    Continue reading

  6. Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.

    4

    April 20, 2020 by Kenneth Fisher

    You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it …
    Continue reading

  7. Has this login been used recently?

    3

    April 8, 2020 by Kenneth Fisher

    I get asked this every now and again, along with the companion When was the last time this login was …
    Continue reading

  8. Changing the owner of a schema removes all direct permissions of objects owned by the schema.

    Leave a comment

    January 22, 2020 by Kenneth Fisher

    This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow …
    Continue reading

  9. Pass Summit 2019 Keynote Day 2

    3

    November 7, 2019 by Kenneth Fisher

    I’m blogging the Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit …
    Continue reading

  10. My fantasy SQL feature(s)? T-SQL Tuesday #118

    3

    September 10, 2019 by Kenneth Fisher

    It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? …
    Continue reading

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

Join 3,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013