In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.

A Large GDPR Victim

by Steve Jones

SQLServerCentral.com

Editorial

The GDPR is affecting one of the tech giants, who received a large fine.

SSRS Scale Out with Standard Edition Containers and Instances

by Paul Stanton

SQLServerCentral.com

Reporting Services (SSRS)

Learn how to use database cloning to scale out your reporting services workload.

Overview of Azure SQL Database Performance Monitoring

by Additional Articles

Database Journal

Azure SQL database

Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.

Doing the Right Thing

by Kathi Kellenberger

SQLServerCentral.com

Editorial

From the time you rise in the morning until you close your eyes at night, your day is filled with thousands of small decisions, many that you don’t even think about. For each decision that you make, there is a probably a good choice and a poor choice available. Most of the time, the good […]

The Devil is in the Monitoring Details

by Steve Jones

SQLServerCentral.com

Editorial

Monitoring is both simple and hard.

Introduction to SQL Server Security — Part 1

by Additional Articles

SimpleTalk

SQL Server security

Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security and protecting data, but planning and effort are required to properly implement them. In this article, the first of a series, Robert Sheldon reviews the many components available to secure and protect SQL Server databases.