A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.

Using Backup Encryption with an External Certificate

by Steve Jones

SQLServerCentral

Learn how to load an external certificate into SQL Server to encrypt your backups.

Reporting Services Basics: Overview and Installation

by Additional Articles

SimpleTalk

SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.

SQL in the City Summits – UK, US & Down Under

by Press Release

Redgate

event

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today. Register now

Tracking the number of active sessions on a database using SQL Monitor

by Additional Articles

Redgate

Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior.

Can Azure Stack Reduce Software Development Costs?

by Steve Jones

SQLServerCentral

Azure Stack provides a hybrid cloud infrastructure platform. Steve wonders if this really helps reduce software development costs.

5 reasons why backup and restore doesn’t cut it in dev and test

by Additional Articles

Redgate

The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.