Stairway Series

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

2013-12-27

2,189 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

2,868 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

2,019 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

3,264 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

197 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI

  • Stairway

Data Analysis Expressions (DAX) can be used in formulas or expressions to calculate and return information from data already in our Power BI models. This Stairway series serves as a progressive introduction to DAX within the context of Power BI, examining the functions, operators and values involved, and examining their operation in practice examples. As a part of introducing DAX functions and overall capabilities, the Levels of the series will also offer a wealth of practical exposure to Power BI features as a part of putting DAX to work in our data models and visualizations.

4 (2)

2011-08-09

3,515 reads

Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server

  • Stairway

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)

2011-05-19

991 reads

Blogs

New Power BI Report Design Pre-Con in 2020

By

I’m excited to announce that I will be offering a full-day pre-con about Power...

Resetting an Azure SQL Database Admin Password

By

This is likely something that most people know, but it was a bit confusing...

Read the latest Blogs

Forums

Suddenly getting UTC datetime from SSIS System StartTime Variable

By Vertigo44

I have an SSIS package where I have a derived column: Load_Dte Expression =...

Windows Server 2012 R2 cluster

By as1981

All, I'm trying to create a Windows Cluster so I can setup an availability...

SSRS Export to word - error: the rectangle is too complex to export to Word

By keneangbu

There is a report that has been in production for years but now is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers