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 T-SQL DML

Stairway to T-SQL DML

This Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server.

5 (3)

You rated this post out of 5. Change rating

2011-08-30

19,998 reads

Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server

When things are going well, there is no need to be particularly conscious of what the transaction log does or how it works. You just need to be confident that every database has the correct backup regime in place. When things go wrong, an understanding of the transaction log is important for taking corrective action, particularly when a point-in-time restore of a database is required, urgently! Tony Davis gives just the right level of detail that every DBA should know.

5 (1)

You rated this post out of 5. Change rating

2011-05-19

5,671 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)

You rated this post out of 5. Change rating

2011-02-04

7,413 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.

5 (1)

You rated this post out of 5. Change rating

2005-04-11

17,207 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Slip Streaming Installs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Slip Streaming Installs

Stairway to Azure SQL Hyperscale Level 4: Log Service and Transaction Management

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers