Tag Archives: security
-
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 -
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 -
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 -
Dealing with multiple AD accounts
8November 19, 2018 by Kenneth Fisher
To help promote the seperation of duties one of the things my company has done is to divide our permissions …
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
SQL Studies 