With a data breach at Marriot, there is a call from one person for companies to spend more on security.

Data Quality

by Additional Articles

SimpleTalk

Data Quality

Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks about data quality and where the issues tend to happen.

Get Patched If Not Supported

by Steve Jones

SQLServerCentral.com

Editorial

Many organizations that run older versions of SQL Server are not patched.

Getting Sneaky With Forced Parameterization

by Additional Articles

Brent Ozar Blog

Forced Parameterization

In which Erik works around the documented limitations with CROSS APPLY.

Trust But Verify

by Steve Jones

SQLServerCentral.com

Editorial

Malware slips into packages, and it could slip into SQL code in the future.

SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2

by Additional Articles

MSSQLTips.com

always on

In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.

Deploy the Database First

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

by Additional Articles

SimpleTalk

Power BI

SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.

Code Reviews

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.