With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.

Your Data After Life

by Steve Jones

SQLServerCentral

Uncategorized

Today Steve thinks about what to do when planning for your digital assets after you pass.

6 New Courses Published on the Redgate University

by Additional Articles

Redgate

learning

Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now!

Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines

by Additional Articles

SimpleTalk

Database Development

In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to get even better performance.

Carefully Giving Normal Users Security Permissions

by Steve Jones

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

When we need to delegate work to less privileged users, Steve has an idea.

Unable to connect SSIS remotely

by iLearnSQL

SQLServerCentral

A strange error with SSIS is solved with a networking change.

Automate Responses to Bad Deployments with SQL Monitor

by Additional Articles

Redgate

SQL Monitor

Jamie Wallis explains how SQL Monitor can both reveal quickly who ran a deployment, and when, and automate the incident-response workflow to ensure it's dealt with swiftly. By extending such workflows to development and test servers, as well as production, the feedback cycle starts earlier, and you can stop problems from ever reaching the users.