In this tip we look at a SQL Server function that generates a report of all users and their assigned database roles.

Changing Context and Data Reuse

by Steve Jones

SQLServerCentral

We don't have strong data consent rules in the US, but Steve thinks we should.

Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS

by Eduardo Pivaral

SQLServerCentral.com

Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages

Compressed Microsoft SQL Server Backups by Default

by Additional Articles

Database Journal

Learn how to create default database compression for your SQL Server databases.

Its time to accelerate the State of DevOps

by Additional Articles

Redgate

Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we're excited to see what the research uncovers.
This year, the survey's focus areas include deployment toolchains, cloud, disaster recovery, the technical environment, how we work, and more. Take the survey to help us understand how to make the (software) world better.

Protecting Data Between Services

by Steve Jones

SQLServerCentral

data

Microsoft is shutting down HealthVault, which means that customers need to manage their records. That's a challenge for many people.

Service Broker Part 2: Why Service Broker

by Klaus Aschenbrenner

SQLServerCentral

Service Broker (SSSB)

The second part of this series focuses on the advantages of Service Broker over other messaged-based technologies to introduce asynchronous message processing into your database applications.

Easing the transition from shared to dedicated database development

by Additional Articles

Redgate

Working in a dedicated database model is the ideal. So, what does it take to move from shared development to a dedicated model? Infrastructure costs, merging multiple changes and maintaining an increased estate might be on your list of things to consider before committing to the switch. In this article we show how Redgate tools can ease the transition and new working approach.