Tag Archives: security

A Nice Refund

This editorial was originally published on Sept 12, 2006. How’d you like to be the DBA for a system thatmistakenly gives out $318 million? It probably wasn’t the database, but more likely the code for some application that caused this … Continue reading

Posted in Editorial | Tagged , | Comments Off on A Nice Refund

SQL Authentication – Forcing Password Changes

When you create a SQL Server login (with SQL authentication), you have the option of enforcing password policies from Windows (in SQL Server 2005 and above). The recommendation is that you check all three and force strong passwords. You also … Continue reading

Posted in Blog | Tagged , , | Comments Off on SQL Authentication – Forcing Password Changes

Data Quality on the Open Web

I used to hear that one of the strengths of Linux was the thousands of volunteers that would help you get a patch or a fix in record time when you reported an issue. That worked well, but not well … Continue reading

Posted in Editorial | Tagged , | Comments Off on Data Quality on the Open Web

Map a Login – Basic Skill #3

This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server. This post is part of Skill #3 – Setup Security. I wrote about the basic security model for SQL Server, … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Map a Login – Basic Skill #3