Tag Archives: security
-
HAL0004 – I don’t feel well Dave
Leave a commentJune 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 -
I created a table and SQL created a schema and a user.
Leave a commentJune 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 -
Could not obtain information about Windows NT group/user
Leave a commentMay 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 -
Call to action: What do you own?
2April 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 -
Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.
4April 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 -
Has this login been used recently?
3April 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 -
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
Leave a commentJanuary 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 -
Pass Summit 2019 Keynote Day 2
3November 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 -
My fantasy SQL feature(s)? T-SQL Tuesday #118
3September 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 -
Is it just me or does msdb feel a lot like a user database?
Leave a commentJuly 17, 2019 by Kenneth Fisher
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to …
Continue reading
