Stairway Series

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

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

3 (3)

2011-08-09

7,830 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

2,117 reads

Stairway to Data

Stairway to Data

  • Stairway

IT projects can hit problems that turn out to be due to an insufficient understanding of the basic data and data-types, rather than the database design. It is a sorely neglected topic that might seem to be trivial, but certainly isn't. The DBA, with a broad perspective on corporate data can do a great deal to help application developers to avoid the common mistakes that so often happen, and Joe Celko's Stairway gives the busy IT professional a crash course to understanding the nature of the data being processed.

2011-04-19 (first published: )

1,639 reads

Blogs

Daily Coping 28 Oct 2020

By

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

Azure Databricks and Azure Key Vault

By

The key vault should always be a core component of your Azure design because...

Why I am running for the PASS Board in 2020

By

This blog post lists the reasons why I felt the need to run for...

Read the latest Blogs

Forums

Login to SQL Server cross domain AD Group user

By Papote

Our MS SQL Server is on another trusted domain (Trusted Domain T). We created...

Process to failback after an AG failover using asynchronous mode

By askcoffman

I'm testing the failover process in my AG that is using Asynchronous availability mode. ...

Cannot remove growth restriction from log files

By Lippy

I have an instance where I have sysadmins. There a number of databases created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers