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 Security

Stairway to SQL Server Security

SQL Server has everything you need to secure your server and data against today’s sophisticated attacks. But before you can use these security features effectively, you need to understand the threats you face and a few basic security concepts. This first stairway level provides a foundation so that you can take full advantage of the security features in SQL Server without wasting time on features that do nothing to protect against specific threats to your data.

You rated this post out of 5. Change rating

2014-05-19

6,583 reads

Stairway to SQLCLR

Stairway to SQLCLR

The possibilities for programming SQL Server platform were greatly enhanced with the addition of the SQLCLR subsystem. This allows code written in any .NET language to be incorporated into your SQL Server instance and called from a stored procedure or function. You can also create your own data types or aggregates for specialized purposes. This Stairway series will teach you how to get started writing your own CLR code and integrating it into SQL Server.

4.33 (6)

You rated this post out of 5. Change rating

2013-12-27

13,654 reads

Stairway to Biml

Stairway to Biml

Biml is a markup language that enables you to quickly represent a variety of database related models and constructs, including SSIS packages, models, permissions and more. This stairway helps you get started using the language to represent your objects.

You rated this post out of 5. Change rating

2013-07-09

7,245 reads

Stairway to SQL Server Replication

Stairway to SQL Server Replication

SQL Replication can solve many problems in running database-driven applications. The publication/subscriber model isn't completely easy to understand, the complexities of scripting and monitoring replication systems takes some thought. Here, at last, is a series of articles that takes care to produce a jargon-free approach to SQL Server Replication of all types.

5 (1)

You rated this post out of 5. Change rating

2012-12-26

9,640 reads

Stairway to XML

Stairway to XML

XML has been part of the SQL Standard since 2003, and it is also essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML. In this series of articles, Robert Sheldon flexes his talent to make the complicated seem simple.
Note: This series of articles is now available as an eBook.

You rated this post out of 5. Change rating

2012-08-14

6,263 reads

Stairway to SQL PowerShell

Stairway to SQL PowerShell

PowerShell is a powerful scripting tool that allows you to automate routine tasks, and script administrative tasks, allowing you to automate a lot of the routine work in a SQL environment. Ben Miller's Stairway Series introduces PowerShell from the beginning, guiding you through how to configure and get started with the framework before working towards more advanced scripting.

3.5 (2)

You rated this post out of 5. Change rating

2012-06-14

11,766 reads

Stairway to SQL Dialects

Stairway to SQL Dialects

The SQL language has developed many dialects over the years, with MySQL, PostgreS and Oracle all popular extensions of the core language. This Stairway Series gives an overview of how SQL dialects formed and looks at some of the most commonly-used dialects in detail.

You rated this post out of 5. Change rating

2012-04-13

1,238 reads

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,140 reads

Blogs

Advice I Like: Apologies

By

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Build a Serverless Todo App With AWS, Pulumi, and Python

By

Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...

Master SQL Subqueries with This Free Course

By

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Read the latest Blogs

Forums

Temp table security

By Brandie Tarvin

So, I have an interesting situation that I need a double-check on. One of...

Hello sqlserer centrel

By queens

I am new here and will like to learn as days goes

Searching a Form (using "Find") after an Access to SQL Migration

By delboy

I have completed a successful migration of an access database to SQL Express. Most...

Visit the forum

Question of the Day

Escaping Like I

I have this data in a SQL Server 2022 table:

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive
How many rows are returned by this code in SQL Server 2022?
select PlayerName from player
where playername like 'The\_C%' escape '\'
 

See possible answers