One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
2006-05-29 (first published: 2001-07-17)
33,144 reads
A new security alert affecting SQL Server was released on June 12, 2001
2001-06-14
3,605 reads
2001-06-14
5,484 reads
2001-05-25
3,799 reads
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,037 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,688 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,457 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
17,622 reads
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,773 reads
By KendraLittle
I'm not an expert on collation in SQL Server, but there are a few...
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
We will have backup server maintenance with the outage between 15mins to 1 hr....
Hey all, Regarding licensing of SQL server, we are considering the possibility of running...
I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've...
Ask SSC