2001-06-14
5,656 reads
Security
2001-05-25
4,018 reads
Removing NT Administrators as Sysadmins
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,088 reads
More About the Fixed Database Roles
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,725 reads
Securing Your SQL Server
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,564 reads
Using the Public Role to Manage Permissions
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,644 reads
Rants about the sa account!
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,860 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers