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 SQL Server Agent

Stairway to SQL Server Agent

SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.

3 (1)

You rated this post out of 5. Change rating

2019-03-26 (first published: )

4,444 reads

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.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

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

You rated this post out of 5. Change rating

2018-08-09

2,751 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)

You rated this post out of 5. Change rating

2018-06-13

12,071 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)

You rated this post out of 5. Change rating

2018-06-05

6,918 reads

Blogs

SQL Saturday Denver 2023–VCS Primer for the Database slides

By

My slides are here: VCS Primer Denver 2023 This was an overview of what...

Future Data Driven 2023 is This Week

By

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Read the latest Blogs

Forums

post steps for Table PARTIONING

By sqlguy80

Any one did Table partitioning in Prod, please list steps here. we have a...

Delegated rights to Enable/Disable TSQL Jobs (Specific Jobs)

By nathanlbell

All, In attempts thinking that I am smarter than your average bear, I attempted...

Hello i am new to Sql and idk why i get this error and also not getting results.

By imon

CREATE DATABASE dbsubjects; CREATE TABLE tblstudent( ID INTEGER PRIMARY KEY, TheName Varchar (100), TheAddress...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers