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 Server-side Tracing

Stairway to Server-side Tracing

Learn how to use the SQL Trace subsystem in SQL Server to audit your instances. This series will examine the basics of SQL Trace and teach you how to set up, schedule, and manage traces and the data generated.

5 (1)

2011-02-17 (first published: )

1,649 reads

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)

2011-02-17 (first published: )

2,537 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.

2011-02-17 (first published: )

248 reads

Stairway to MDX

Stairway to MDX

Multidimensional Expressions (MDX) is a standard query language, derived from SQL but geared specifically for OLAP databases. It also includes a calculation language, with syntax similar to spreadsheet formulas. It is an important skill for PowerPivot. Bill's new series for MDX starts right at the very beginning and takes us through all the basic functions of MDX, with plenty of practical examples.

5 (1)

2011-02-04

4,347 reads

Stairway to SQL Server Indexes

Stairway to SQL Server Indexes

Indexes are fundamental to database design, and tell the developer using the database a great deal about the intentions of the designer. Unfortunately indexes are too often added as an afterthought when performance issues appear. Here at last is a simple series of articles that should bring any database professional rapidly "up to speed" with them.

2005-04-11

8,393 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Synapse Analytics and .NET for Apache Spark Example 3 - CTE()

By

The next example is how to do a CTE (Common Table Expression). When creating...

Read the latest Blogs

Forums

Reversing a String in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reversing a String in Python

Group By and JOIN within SQL Server (when dealing with multiple columns)

By lynhudson1

I have 2 tables, df1, and df2. I would like to join the two...

Select "New Customer"

By gjoelson 29755

Hi , Has anyone tried to do this...I'm trying to select only "new customers"...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers