Site Owners

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

1,249 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

Simple Talk is hiring a full-time editor

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: )

4,722 reads

Blogs

Investigating Azure Databricks

By

At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure...

Understanding Columnstore Indexes in SQL Server Part 3

By

My last two blogs were on understanding columnstore and creating columnstore indexes. In this...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

TempDB filling up

By Dan.Humphries

Hello all, We have a SQL Server 2012 Enterprise SP1 running our ERP system.  ...

SSMS connection attempt results in "Errors in the metadata manager. ..."

By webrunner

Hello experts, I have a colleague who's trying to connect to one of our...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers