Examine the similarities and differences between Windows security and SQL Server security and you'll find that most of the concepts you already know from managing a network will map quite nicely into ...

All set up went well. When I came to test out Report Manager, I hit security issues. The first one was simple. The Developer Edition of SQL Server is not set up for Remote connections by default so I ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

Use Windows accounts or groups whenever possible. SQL Server accounts are difficult to maintain and track, and SQL Server is a frequent target of hacker attacks. Here's one final piece of advice: Set ...