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,553 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

SQL Prompt and SSMS 18.5

By

I downloaded SSMS 18.5, as there were a lot of fixes in here and...

Jupyter Book Challenges in ADS

By

I was excited to try the Jupyter Book feature in the March Azure Data...

Join me (virtually) in Adelaide!

By

I will be presenting a session to the Adelaide SQL Server User Group on...

Read the latest Blogs

Forums

DB mail issue

By ramyours2003

We received error when testing the DBmail The mail could not be sent to...

Issue with case statement

By mcfarlandparkway

i have a table A where the data looks like ID        Name      Phone            CODE...

Implementing Reporting Application Enhancements with No Downtime

By Imran Quadri Syed

Comments posted to this topic are about the item Implementing Reporting Application Enhancements with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

ADF Triggers

See possible answers