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,076 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,717 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,548 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,603 reads
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,829 reads
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers
