Category Archives: Security
-
Restrict the usage of a SQL Server Authenticated Application Id
1December 6, 2017 by Kenneth Fisher
SQL Server login ids may not be the most secure thing in the world but they are likely to be …
Continue reading -
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?
12April 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?
11January 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!
27November 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
SQL Studies 