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 Streaminsight

Stairway to StreamInsight

Microsoft StreamInsight™ is designed to assist in developing Complex Event Processing (CEP) applications in .NET This is appropriate for stream sources tsuch as those in manufacturing applications or financial trading applications. StreamInsight provides the means to monitor, manage, and mine several sources simultaneously for conditions,trends, exceptions, opportunities, and defects almost instantly. It is ideal for performing low-latency analytics on the events and triggering response actions, and for mining historical data to continuously refine and improve definitions of alerting conditions. Johan provides a simple explanation of the system in a series of practical articles.

2019-03-26 (first published: )

411 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

2,453 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 (4)

2018-06-13

11,062 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.

5 (3)

2018-06-05

6,294 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

3,790 reads

Technical Article

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.

5 (1)

2016-06-07

5,631 reads

Blogs

Function Vs. Performance

By

Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Read the latest Blogs

Forums

subscriber part of ALWAYSON

By SQL Galaxy

Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover.  It seems...

SQL Server Licensing Question

By atangvels

I'm in the process of replacing a sql server 2012 with 2019. How do...

SSRS Reporting

By kharllevinn

Anyone can give me a sample program on how to pass parameters from SSRS...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers