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

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

“Security is the most important thing in our business,” said Gordon Mangione, vice president in charge of SQL Server. Microsoft had already started to focus more resources on SQL Server ...

The highlights of the newest version of Microsoft’s SQL Server 2016 take security and visibility upgrades of earlier versions and move toward availability, simplicity, and consistency. With only ...

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

Additionally, Microsoft will subject SQL Server 2005 to the federal government’s Common Criteria certification from the National Security Agency. Common Criteria certification carries a more ...

SQL Server has come a long way in the past 5 years, though the history seems to linger. Let's look at the recent history and see what the story is with database vulnerabilities.

Sentrigo discovered a new security hole in SQL Server, but so far Microsoft isn't paying attention. Let me show you why they should ...

Understanding Columnstore Indexes in SQL Server First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads.