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
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)
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
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
The next version of SQLServerCentral will go love on Saturday, March 30, 2019
2019-03-29
285 reads
2018-12-24
38 reads
2018-09-21 (first published: 2016-01-04)
6,141 reads
2018-08-10 (first published: 2015-10-05)
4,739 reads
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
A look at the positive and negative aspects of IoT in this infographic.
2017-02-01
231 reads
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
By Steve Jones
At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure...
My last two blogs were on understanding columnstore and creating columnstore indexes. In this...
Comments posted to this topic are about the item The AI Manager
Hello all, We have a SQL Server 2012 Enterprise SP1 running our ERP system. ...
Hello experts, I have a colleague who's trying to connect to one of our...
Ask SSC