Site Owners

SQLServerCentral.com 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

3,638 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

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)

By

Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series

By

Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

T-SQL Tuesday Retrospective #009: Beach Time

By

(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In...

Read the latest Blogs

Forums

How to find index usage by stored procedure?

By SQL Guy 1

Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...

Odd things with Report Builder (also tried VS 2019)

By kevlray

This is kinda hard to explain, maybe I can make sense of it. So...

PBM policy to check empty passwords

By Lou

Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers