Stairway Series

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL

  • Stairway

This stairway will contain a series of articles that will expand on the T-SQL foundation that you learned in the prior two T-SQL stairways, Stairway to T-SQL DML and T-SQL Beyond the Basics. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.

5 (1)

2014-12-11

14,288 reads

Stairway to AlwaysOn

Stairway to AlwaysOn

  • Stairway

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

2014-06-25

12,010 reads

Stairway to SQL Server Virtulization

Stairway to SQL Server Virtualization

  • Stairway

Virtualization is becoming more and more common, and without an understanding how virtualization works, the DBA will have blind spots when attempting to resolving performance issues, such as reduce resource contention, or improve the backup and restore operations, and so on.

2014-06-25

2,868 reads

Stairway to SQLCLR

Stairway to SQLCLR

  • Stairway

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)

2013-12-27

9,382 reads

Stairway to Biml

Stairway to Biml

  • Stairway

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.

2013-07-09

5,980 reads

Stairway to XML

Stairway to XML

  • Stairway

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.

2012-08-14

5,413 reads

Stairway to SQL PowerShell

Stairway to SQL PowerShell

  • Stairway

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.

5 (1)

2012-06-14

9,477 reads

Stairway to SQL Dialects

Stairway to SQL Dialects

  • Stairway

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.

2012-04-13

1,000 reads

Blogs

Using Sessionize for Your User Group – Part 2

By

Now that your CFS has been setup it’s time to get the word out...

Daily Coping 1 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Updates from Coping Tips

By

I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

Read the latest Blogs

Forums

status of database in availibility group

By sqlfriend

I setup a staging environment to test basic always on availability group on SQL...

Updating a table from another table or a query.

By chaunnahrailey@gmail.com

I have a procedure that creates a table.  One of the fields labeled delay...

Questions about SQL Server 2016 (and later) High Availability Groups (HADr)

By sayagi1

I'm looking into implementing availability groups for our organization after we upgrade from SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers