Stairway Series

Stairway to Columnstore Indexes

• by Hugo Kornelis

• SQLServerCentral

• Stairway Series

• Stairway

SQL Server 2012 and later offer a very different type of index from the traditional b-tree, the in-memory columnstore index. These indexes use a column-based storage model, as well as a new 'batch mode' of query execution and can offer huge performance increases for certain workloads. But how are they built, how do they work, and why do they manage to have such a dramatic impact on performance? In this stairway, Hugo Kornelis explains all, with his usual mix of concise description and detailed demonstration.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (4)

Log in or register to rate

2015-01-22

5,445 reads

Stairway to Advanced T-SQL

• by Gregory Larsen

• SQLServerCentral

• Stairway Series

• 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2014-12-11

8,014 reads

Stairway to AlwaysOn

• by Perry Whittle

• SQLServerCentral

• Stairway Series

• 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)

Log in or register to rate

2014-06-25

6,595 reads

Stairway to SQL Server Virtualization

• by David Klee

• SQLServerCentral

• Stairway Series

• 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2014-06-25

1,383 reads

Stairway to Database Source Control

• by Dave Green

• SQLServerCentral

• Stairway Series

• Stairway

The goal of this Stairway series is to provide a brief, practical and systematic guide to source controlling your SQL Server databases, so that you can then manage your ongoing development and deployment from a known version, within source control.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2014-04-16

1,321 reads

Stairway to SQLCLR

• by Solomon Rutzky

• SQLServerCentral

• Stairway Series

• 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.2 (5)

Log in or register to rate

2013-12-27

3,922 reads

Stairway to T-SQL: Beyond The Basics

• by Gregory Larsen

• SQLServerCentral

• Stairway Series

• Stairway

Following on from his Stairway to T-SQL DML, Gregory Larsen covers more advanced aspects of the T-SQL language such as subqueries.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2013-11-11

5,984 reads

Stairway to Biml

• by Andy Leonard

• SQLServerCentral

• Stairway Series

• 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2013-07-09

3,921 reads

Stairway to XML

• SQLServerCentral

• Stairway Series

• 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2012-08-14

2,902 reads

Stairway to SQL PowerShell

• by Ben Miller (DBAduck)

• SQLServerCentral

• Stairway Series

• 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)

Log in or register to rate

2012-06-14

4,921 reads