Tag Archives: security
-
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 -
Be our guest, be our guest, put our database to the test.
3June 25, 2018 by Kenneth Fisher
When I think of the public role I often think of the guest database principal (user) at the same time. …
Continue reading -
Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101
1April 10, 2018 by Kenneth Fisher
Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
Continue reading -
Double hop error when using SQLCMD
2February 26, 2018 by Kenneth Fisher
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos. One of the problems with linked servers (no rude noises …
Continue reading -
SQL Homework – February 2018 – Work with security
Leave a commentFebruary 5, 2018 by Kenneth Fisher
This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
Continue reading -
What’s dbo?
3January 22, 2018 by Kenneth Fisher
Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
Continue reading -
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
Leave a commentJanuary 9, 2018 by Kenneth Fisher
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
Continue reading -
What is impersonation for?
3December 27, 2017 by Kenneth Fisher
I was doing some research on impersonation the other day, and among other things, I ran across a forum question …
Continue reading
