How Do I Secure My Data?

  • Josef Finsel


Maybe you won’t have security problems on that scale, but security is an issue that everyone needs to deal with in today’s interconnected world. Security in SQL Server has never been a glamorous subject. In fact, before SQL Server 2000, it was a running joke at demonstrations that logging into SQL Server as sa (System Administrator) with no password was Microsoft’s “standard” security model. The sad truth of the matter is, however, that many SQL Server sites run with no password on the sa account and allow all data access through the sa account. This practice of not placing a password on the sa account was caused by a combination of developers not understanding how the security model worked and the fact that SQL Server installed with a default of no password on the sa account. It’s also because too many books, articles, and documentation use this “security” strategy—or lack thereof.


Security Model Enterprise Manager Execution Plan Individual Column Server Role 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Josef Finsel 2001

Authors and Affiliations

  • Josef Finsel

There are no affiliations available

Personalised recommendations