Category Archives: Security
-
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 -
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
2May 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?
12April 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 -
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 -
Why do I (they) own that database?
2February 20, 2019 by Kenneth Fisher
Ever looked at the list of databases and wonder why you own one of them? Or why some other user …
Continue reading -
Controlling the firewall for an Azure SQL DB via T-SQL
2January 16, 2019 by Kenneth Fisher
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I …
Continue reading -
How do I grant permissions to view users and their permissions?
1September 17, 2018 by Kenneth Fisher
tl;dr; VIEW DEFINITION Every now and again you’ll have a user that needs to be able to see what permissions …
Continue reading -
Balancing Security Concerns.
2July 12, 2018 by Kenneth Fisher
I have a presentation I do every now again on security basics that I’m actually quite proud of. One of …
Continue reading
SQL Studies 