Tag Archives: security
-
UDP vs TCP
3June 7, 2017 by Kenneth Fisher
If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance …
Continue reading -
Why is a Windows authenticated login more secure than a SQL authenticated one?
8April 26, 2017 by Kenneth Fisher
I had this question come up at work the other day and while I knew it was true I wasn’t …
Continue reading -
Server level database permissions
4February 14, 2017 by Kenneth Fisher
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a …
Continue reading -
My SQL logins don’t work. Again.
Leave a commentJanuary 25, 2017 by Kenneth Fisher
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
Continue reading -
Why won’t my SQL Logins work?
10January 12, 2017 by Kenneth Fisher
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
Continue reading -
It greatly pleases me to announce, HAL0003!
25November 23, 2016 by Kenneth Fisher
I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal …
Continue reading -
Is it safe to grant Administer Bulk Operations?
4November 10, 2016 by Kenneth Fisher
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are …
Continue reading -
SA Spoof
14September 8, 2016 by Kenneth Fisher
This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are …
Continue reading
