Site Owners

Capturing the business value of Compliant Database DevOps

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

Stairway to SSAS Tabular Level 7: Time Intelligence

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 […]

2019-07-10

2,858 reads

SQL Clone for Unit Testing Databases

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

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

Blogs

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Data Visualization, Context, and Domain Expertise

By

I recently posted a graph to twitter and asked people to explain it. Let’s...

Approaches to running Databricks ETL code from Azure ADF

By

Databricks is fantastic, but there is a small issue with how people use it....

Read the latest Blogs

Forums

How to compare 2 databases to find what objects are out of sync?

By Goalie35

Last night, my company tried deploying a large update to almost all tables &...

Worker Threads Per Session

By alex.sqldba

Morning All, Is it possible to determine how many threads are spawned by a...

Is it acceptable to use the presence of a value in a NULLable column as a flag?

By edwardwill

I have a stored procedure that processes rows in a table. The stored procedure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers