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

2,864 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,415 reads

Stairway to SSAS Tabular

Stairway to SSAS Tabular

  • Stairway

SSAS (SQL Server Analysis Services) is available in two modes, tabular and multidimensional. The new tabular model is easier for those companies who are not already invested in the traditional, multidimensional model. In this stairway, Thomas LeBlanc will teach you how to create tabular models used for reports and dashboards.

5 (2)

2018-06-13

6,125 reads

Stairway to Exploring Database Metadata

Stairway to Exploring Database Metadata

  • Stairway

In addition to the data that our clients and customers store in a database, there is a tremendous amount of meta data, 'data about data', that describes how the database is set up, configured, and what the properties are for the various objects. This stairway aims to demystify and explain how you can query and use this meta data to more effectively manage your SQL Server Databases.

5 (3)

2016-07-15

2,251 reads

Stairway to U-SQL

  • Stairway

As Microsoft continues to expand the Azure platform, they have enhanced its ability in ways that are quite different from what we've come to expect from SQL Server. Learn about the new language from Microsoft, U-SQL, designed to work with Data Lakes and Big Data in Azure.

2016-06-07

3,835 reads

Stairway to SQL Server Extended Events

Stairway to SQL Server Extended Events

  • Stairway

Erin Stellato, a Principal Consultant with SQLskills.com, explores the use of Extended Events as a diagnostic data collection tool or SQL Server. She describes how to define efficient low-overhead event sessions that exploit fully the vast number of events, as well as the powerful filtering and data collection options, offered by this new event collection infrastructure. She also demonstrates simple techniques to analyze event data and identify and troubleshoot the causes of poor SQL Server performance, such as long-running queries that consume vast amounts of CPU and I/O resources. It is time to embrace Extended Events and understand all that it has to offer, and Erin's stairway is the perfect place to start.

2015-12-01

2,204 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

  • Stairway Step

A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.

2018-03-21 (first published: )

1,165 reads

Blogs

Daily Coping 5 June 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

SQL Server Authentication

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

Attunity Oracle Connector Not Showing Up in SSIS Toolbox

By brad.mccollum

I've just about exhausted every effort I can research and absolutely cannot get the...

Covert a string to simple sql datetime format

By Jeff Sims-413169

Can anyone help me out here.  I need to convert strings in a file...

Creating a DB

By Nusc

Hi there, when creating a DB with Auto close= False Auto shrink= True Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers