SQL Server Database Compliance

SQL Server Database Compliance News

May 18, 2017 18 May'17
Azure Cosmos multimodel database delivers features familiar and new

There are bits of DocumentDB at the foundation of Microsoft's Azure Cosmos DB, a multimodel database that supports multiple modes of data processing.
October 21, 2015 21 Oct'15
The Azure SQL Data Warehouse gains an auditing feature

Microsoft announced that it had enabled an auditing feature for the Azure SQL Data Warehouse. The new feature has many benefits, but storing audit logs won't be free.

Bring yourself up to speed with our introductory content

How much do you really know about SQL Server 2016 licensing?

Should you use Server + CAL licensing for SQL Server 2016 or does Per Core licensing offer more bang for your buck? Read our primer and take this quiz to see if you'd choose right. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading
HIPAA compliance and SQL Server: Tricks and tools of the trade

Find out which tools help attain HIPAA compliance. Lena Weiner profiles HIPAA pro Brandon Leach, who explains the steps needed to secure SQL Server. Continue Reading

Learn to apply best practices and optimize your operations.

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators. Continue Reading
SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask. Continue Reading
What the Microsoft GDPR compliance toolkit offers for SQL Server

The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database software to adhere to the EU's new data rules. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Eight ways that SQL Server developers hurt performance

Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong. Continue Reading
Speed up execution times in Microsoft SQL Azure

Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure. Continue Reading
Sarbanes-Oxley compliance checklist: IT security and SQL audits

If your SQL Server environment is not yet expected to meet Sarbanes-Oxley (SOX) Act compliance standards, it soon will be. In this tip, SQL Server expert Michelle Gutzait presents security practices, procedures and documentation that prepare you for... Continue Reading