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,521 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
288 reads
2018-12-24
38 reads
2018-09-21 (first published: 2016-01-04)
6,153 reads
2018-08-10 (first published: 2015-10-05)
4,752 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
This is something I touched on back in 2017 a little after the Live...
In my home lab I have an Ubuntu virtual machine that runs both SQL...
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
Comments posted to this topic are about the item Is Data the Future of...
Comments posted to this topic are about the item A Good Reason to use...
Comments posted to this topic are about the item Soft Skills: Controlling your career
Ask SSC