Tag Archives: security
-
What permissions do temp stored procedures use?
1June 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.
Leave a commentMay 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 -
Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?
1May 8, 2019 by Kenneth Fisher
If you have to deal with linked servers then you probably have or will run into the following error: Login …
Continue reading -
db_owner in msdb == sysadmin
1May 6, 2019 by Kenneth Fisher
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner …
Continue reading -
How do I let someone execute a SQL Agent job they don’t own?
2April 15, 2019 by Kenneth Fisher
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
Continue reading -
Can SQL Ids be used on an instance with Windows Authentication only?
2April 11, 2019 by Kenneth Fisher
tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
Continue reading -
Mixed feelings over the new truncation error
2March 20, 2019 by Kenneth Fisher
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. …
Continue reading -
Using the Microsoft Authenticator app to log into Azure
Leave a commentFebruary 25, 2019 by Kenneth Fisher
So I was trying to work on a blog post about the new truncation error this morning and realized I …
Continue reading
