Stairways

To keep up to date with all the technologies in SQL Server, the DBA or developer who wants to stay ahead is faced with the struggle of constant learning. How do you keep up while avoiding information overload, unnecessary detours and dead-ends?

The SQL Server Stairways is our solution to this problem. Designed to smooth out even the steepest learning curve, each Stairway is a SQL tutorial series focused on a single topic and is arranged into no more than a dozen easily-navigable tutorials that we call 'steps'. Each step is the length of a typical magazine tutorial, and emphasizes practical, hands-on learning, with just enough background theory to help you understand the topic at a deeper level.

Using straightforward language and avoiding jargon and marketing babble, each Stairway tutorial series is designed to take you from zero knowledge of a particular SQL Server topic to a level of practical understanding that will allow you to start using that feature in a production environment. The learning gradient is steady and manageable, but also brisk. You won't be wasting time.

Happy climbing!

Stairway to Database Containers

Containers are a lightweight way of building applications that run on a host. Similar to virtualization, the container is a virtual OS rather than a full machine. This stairway will walk you through the basis of containers using Docker for Windows and SQL Server inside of a container.

2019-07-06

2,026 reads

Stairway to SQL Server on Linux

Stairway to SQL Server on Linux

SQL Server 2017 is the first SQL Server version that can be installed on Windows, Linux and inside a Docker container. This stairway series serves as a guide for the experienced SQL Server DBA to acquire skills and knowledge on this platform. This is an introductory series to installing Linux and SQL Server on Linux.

2018-08-09

945 reads

Stairway to SSAS Tabular

Stairway to SSAS Tabular

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

3,624 reads

Stairway to Azure SQL Database

Stairway to Azure SQL Database

Azure SQL Database is Microsoft’s fully managed cloud relational database service in Microsoft Azure. With many companies moving to cloud based solutions Azure SQL Database is a leading option for the data tier that many consider.

The aim of this stairway course is to give you a comprehensive practical guide on how to begin creating Azure SQL Databases whilst trying to convey some very important practical knowledge on the way. This stairway course assumes that you have absolutely no knowledge of Azure and after completing it you will become comfortable with creating logical SQL servers, databases, correct security configuration around firewalls and logins hence allowing you to connect to the database via SQL Server Management Studio.

2018-06-05

2,752 reads

Stairway to Exploring Database Metadata

Stairway to Exploring Database Metadata

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

1,318 reads

Stairway to U-SQL

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

2,648 reads

Blogs

How Many Bytes Per Character in SQL Server: a Completely Complete Guide

By

A Completely Complete Guide to how many bytes are used to represent characters in...

Power BI Monthly Digest – November 2019

By

In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson...

Data Masker Reads Column Classificiations

By

One of the newer features in Data Masker for SQL Server is the ability...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Row Level Security based on multiple factors

By peterg417

Hey there, I recently got a request from some people here to implement another...

Determining if more CPU is needed

By dan-572483

We have a data import & processing process that often longer than expected, often...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The CTE Insert

See possible answers