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

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

What is spinlock ALLOC_CACHES_HASH?

By My_Sky

Hi, Queries are slow, cpu usage at 80%. ALLOC_CACHES_HASH backoffs start at same time...

BULK insert several thousand files

By MVDBA (Mike Vessey)

I have a bunch of logging data that my sysadmin has downloaded from our...

SSRS 2016 install on FCI with AAAG.

By snomadj

Appreciate advice here as I am slightly confused. I need to install SSRS 2016...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers