Stairway Series

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 (3)

2018-06-13

7,788 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,610 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

4,244 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,523 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.

2015-03-18

1,338 reads

Blogs

Why I am running for the PASS Board in 2020

By

This blog post lists the reasons why I felt the need to run for...

Blog Refresh – Growing Readers

By

Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...

Daily Coping 27 Oct 2020

By

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

Read the latest Blogs

Forums

Help Writing a Udf that get Number of "Years in a row"

By Pucko

Hello. I have a table (say orderlines) with orderrows,    There is a column...

SSIS 2017 stopped running, not status is Pending Execution

By ConnieD

We have 3 sql agent jobs that are running SSIS packages.  Until this past...

cannot find MSOLEDBSQL driver for SSIS 2019 connection manager

By sqlfriend

In the list of connection manager driver, I cannot  find MSOLEDBSQL, There is a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers