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

Thomas LeBlanc

2018-06-13

522 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.

Phil Factor

2016-07-15

120 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.

Mike McQuillan

2016-06-07

211 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.

Erin-Stellato

2015-12-01

275 reads

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes

  • Stairway

SQL Server 2012 and later offer a very different type of index from the traditional b-tree, the in-memory columnstore index. These indexes use a column-based storage model, as well as a new ‘batch mode’ of query execution and can offer huge performance increases for certain workloads. But how are they built, how do they work, and why do they manage to have such a dramatic impact on performance? In this stairway, Hugo Kornelis explains all, with his usual mix of concise description and detailed demonstration.

Hugo Kornelis

2015-01-22

479 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL

  • Stairway

This stairway will contain a series of articles that will expand on the T-SQL foundation that you learned in the prior two T-SQL stairways, Stairway to T-SQL DML and T-SQL Beyond the Basics. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.

Gregory Larsen

2014-12-11

789 reads

Stairway to AlwaysOn

Stairway to AlwaysOn

  • Stairway

AlwaysOn is a complex set of technologies that is often mis-understood. In this Stairway you will learn about the AlwaysOn technologies, how they fit into the High Availability stack, and how to make good use of them.

5 (1)

Perry Whittle

2014-06-25

546 reads

Stairway to SQLCLR

Stairway to SQLCLR

  • Stairway

The possibilities for programming SQL Server platform were greatly enhanced with the addition of the SQLCLR subsystem. This allows code written in any .NET language to be incorporated into your SQL Server instance and called from a stored procedure or function. You can also create your own data types or aggregates for specialized purposes. This Stairway series will teach you how to get started writing your own CLR code and integrating it into SQL Server.

5 (2)

Solomon Rutzky

2013-12-27

314 reads

Blogs

CISA Accredited Trainer!

By Brian Kelley

My certification came in! I’m now accredited to provide training for the Certified Information...

Correlated Subqueries vs Derived Tables

By Bert Wagner

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...

Video – Creating Azure SQL Database

By Arun Sirpal

A quick 2 minute upload (with sound, my voice) showing you how easy it...

Read the latest Blogs

Forums

dput()

By Steve Jones - SSC Editor

Comments posted to this topic are about the item dput()

Can Azure Stack Reduce Software Development Costs?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can Azure Stack Reduce Software...

Splitting a multi-dimensional Array in SQL Server 2012

By Slady

Hello, I have data from an Orders table has the following columns; OrderId (int)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

dput()

See possible answers