Tag Archives: security
-
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 -
Introducing sp_AzSQLDBPermissions (Beta)
9June 27, 2019 by Kenneth Fisher
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough …
Continue reading -
What does the User Mapping tab of Login Properties really tell us.
4June 24, 2019 by Kenneth Fisher
In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, …
Continue reading -
What permissions do temp stored procedures use?
4June 19, 2019 by Kenneth Fisher
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting …
Continue reading -
How do I force a SQL Login to change it’s password on next login
2June 5, 2019 by Kenneth Fisher
Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten …
Continue reading -
I’m moving my permissions scripts to GitHub
2May 30, 2019 by Kenneth Fisher
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are …
Continue reading -
Security Learning Pathway at PASS Summit.
1May 17, 2019 by Kenneth Fisher
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway …
Continue reading
