By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,060 reads
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,701 reads
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,516 reads
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,398 reads
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,794 reads
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Hello experts, I got a report from an application owner of degraded performance for...
Which of these indexes is superseded by another?
See possible answers