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

With SQL Server 2016, that is no longer a problem. Implementation Row-Level Security in SQL Server 2016 (and SQL Azure) is based on a specially crafted inline table valued function.

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

How to protect your database from SQL injection, data theft, rogue users, and well-meaning meddlers without tying your environment in knots ...

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

The company says it's tightening up security in "Yukon," the next version of its SQL Server database management software, to make it easier to plug holes--and to keep hackers out.

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

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.

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.