Stairway Series

Stairway to SSAS Tabular

Stairway to SSAS Tabular Level 7: Time Intelligence

  • Stairway Step

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,693 reads

The Basics - Level 1 of the Stairway to Query Store

  • Stairway Step

Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]

5 (3)

2019-05-13

3,195 reads

Blogs

How a new custom PowerPoint template is helping us to be more effective presenters

By

DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for...

New Event Calendar

By

Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...

Databricks Delta Lake

By

Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...

Read the latest Blogs

Forums

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

Finding out mismatch between time lines.

By koti.raavi

CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE...

development of encrypted password field

By snomadj

I want to be able to: encrypt a password column display characters x &...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers