Capturing the business value of Compliant Database DevOps

• by Site Owners

• Redgate

• DevOps and Continuous Delivery (CI/CD)

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.

2019-10-14

Stairway to SSAS Tabular Level 7: Time Intelligence

• by Site Owners

• SQLServerCentral

• Analysis Services (SSAS)
• Stairway Series

Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2019-07-10

2,154 reads

• Discuss

How to provision realistic and compliant data to dev – free whitepaper

• by Site Owners

• Redgate

• provisioning

Compare common approaches to provisioning test data to database development teams, and assess how they stack up in terms of delivering realistic test data, managing bottlenecks, and meeting data privacy regulations.

2019-07-04 (first published: 2019-06-20)

SQL Clone for Unit Testing Databases

• by Site Owners

• Redgate

• SQL Clone

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.

2019-06-04

Safely Deleting Clones and Images during Database Development and Testing

• by Site Owners

• Redgate

Whenever you’re ready to refresh a test cell with the latest database version, you need a safe way to drop the current set of clones, and the parent image, without losing any unsaved work. Phil Factor provides a PowerShell script that automates this process so it runs in the time it takes to grab a coffee, after which can quickly deploy the new clones.

2019-04-19

SQLServerCentral v3 coming tomorrow

• by Site Owners

• SQLServerCentral.com

• SQLServerCentral

The next version of SQLServerCentral will go love on Saturday, March 30, 2019

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

2019-03-29

289 reads

• Discuss

Christmas DevOps

• by Site Owners

• SQLServerCentral.com

• Editorial

A short take on the Night Before Christmas.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

2018-12-24

39 reads

• Discuss

Learning R in SQL Server

• by Site Owners

• SQLServerCentral.com

Learn about the new R Services in SQL Server 2016

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

2018-09-21 (first published: 2016-01-04)

6,202 reads

• Discuss

Learning about FOR JSON

• by Site Owners

• SQLServerCentral.com

• FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.67 (3)

Log in or register to rate

2018-08-10 (first published: 2015-10-05)

4,763 reads

• Discuss

Simple Talk is hiring a full-time editor

• by Site Owners

• Redgate

• Hiring

Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply!

2017-08-01 (first published: 2017-07-28)

4,722 reads