You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.

Put Your Data in a Box

by Steve Jones

SQLServerCentral

A new rugged data box from Microsoft interests Steve.

Moving beyond principal components analysis

by Nick Burns

SQLServerCentral.com

R Language

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.

The Work of the Ancients

by Steve Jones

SQLServerCentral.com

Editorial

We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.

Find SQL Server Installation Date for all Instances with PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

Foreign Keys and Multi-Table Inserts in Oracle

by Additional Articles

Database Journal

Oracle

Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

by Additional Articles

Redgate

SQL Provision

Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed.

Feedback and Change

by Steve Jones

SQLServerCentral

pass

Today Steve asks you to be a part of the change you'd like to see in our professional organization.

The Basics of INCLUDE

by Steve Jones

SQLServerCentral

Learn how the INCLUDE phrase of an index can change the performance of a query.

Handling Tricky Data Migrations during State-based Database Deployments

by Additional Articles

Redgate

SQL Change Automation

This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst preserving existing data.

Capturing the business value of Compliant Database DevOps

Put Your Data in a Box

Moving beyond principal components analysis

The Work of the Ancients

Find SQL Server Installation Date for all Instances with PowerShell

Foreign Keys and Multi-Table Inserts in Oracle

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

Feedback and Change

The Basics of INCLUDE

Handling Tricky Data Migrations during State-based Database Deployments

Blogs

Using CAT for Testing of Data Agents

Are you getting value from your reporting?

The Book of Redgate: SQL Server Central

Forums

Foreach Loop still executes after process and delete all the folders

Which 'Where' statement conditional upon a variable

Backup to Immutable Storage

Question of the Day

Backup to Immutable Storage