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

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.

You rated this post out of 5. Change rating

2024-07-28 (first published: )

7,613 reads

Stairway to AlwaysOn

Stairway to Always On

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

You rated this post out of 5. Change rating

2024-07-23 (first published: )

16,741 reads

Stairway to Server Management Objects (SMO)

This stairway series tries to help the reader become comfortable with server management objects (SMO). These objects are a programmatic way of accessing SQL Server functions and objects through an API from .NET. This series will help you learn the basics with practical applications for your work.

5 (1)

You rated this post out of 5. Change rating

2024-01-20 (first published: )

1,082 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI

Data Analysis Expressions (DAX) can be used in formulas or expressions to calculate and return information from data already in our Power BI models. This Stairway series serves as a progressive introduction to DAX within the context of Power BI, examining the functions, operators and values involved, and examining their operation in practice examples. As a part of introducing DAX functions and overall capabilities, the Levels of the series will also offer a wealth of practical exposure to Power BI features as a part of putting DAX to work in our data models and visualizations.

4 (6)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

18,276 reads

Technical Article

Stairway to SQL Server Automated Database Testing

Automated testing is a way to ensure you can repeatedly examine your code as you make changes by running a series of tests. Since these are automated, you have the ability to execute all tests with one programmatic call rather than hoping a developer runs all tests. This also allows the effort of writing tests […]

You rated this post out of 5. Change rating

2023-10-15 (first published: )

728 reads

Blogs

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Using SQL Compare in Read-Only Databases

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

T-SQL Tuesday #179 Roundup: The Data Detective Toolkit

By

Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...

Read the latest Blogs

Forums

Concatenating Multiple Row Values into a Single Comma-Separated List

By Sukhdevsinh Dhummad

Comments posted to this topic are about the item Concatenating Multiple Row Values into...

From each string extract Numbers following a '#' and create separate row

By SqlRookie

Hi there, I've tried CROSS APPLY, PATINDEX and many other functions, but can't nail...

Looping SQL Agent Job

By paul.farnell

What is the best way to continually loop a SQL Server Agent Job? I...

Visit the forum

Question of the Day

The LAGing data

I have some simple sales data in a SQL Server 2022 database that looks like this:

TransactionDate SalesAmount
2023-01-15      1200.00
2023-02-22      1500.50
2023-03-10      900.75
If I run this query, what are the sales growth amounts returned?
SELECT
  ms.TransactionDate
, ms.SalesAmount
, ms.SalesAmount - LAG (ms.SalesAmount, 1) OVER (ORDER BY ms.TransactionDate) AS SalesGrowth
FROM dbo.MonthlySales AS ms;

See possible answers