Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

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 ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

UPDATE: The story that originally got my attention has been updated in all of the places I could still find it yesterday, so I’m pulling my references to the story and just focusing on the positive ...

Microsoft will end security support for SQL Server 2005 in April 2016, and higher education IT leaders must prepare to upgrade. Phil Goldstein is a former web editor of the CDW family of tech ...

July 9 marked the end of "extended support" for SQL Server 2008 and SQL Server 2008 R2, the last five-year phase of Microsoft's overall 10-year product lifecycle for these products. The two servers ...

If you are still working on SQL Server 2000 (as many of our customers are), here’s another reason to upgrade to a newer version. One area that has improved vastly is file-level security. SQL Server ...

Take advantage of the mission-critical capabilities in SQL Server 2016 for real time operational analytics, rich data visualizations and improved data security SQL Server is Microsoft’s flagship ...

I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.