Stairway Series

Stairway to TDE icon

Restore a Backup of a TDE Database to Another Server: Level 2 of the Stairway to TDE

  • Stairway Step

In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.

5 (3)

You rated this post out of 5. Change rating

2024-06-26 (first published: )

46,693 reads

Stairway to TDE icon

Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE

  • Stairway Step

The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.

5 (3)

You rated this post out of 5. Change rating

2024-06-26 (first published: )

10,098 reads

Stairway to SQLCLR

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

  • Stairway Step

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.

5 (6)

You rated this post out of 5. Change rating

2020-07-09 (first published: )

26,767 reads

Stairway to SSAS Tabular

Stairway to SSAS Tabular Level 7: Time Intelligence

  • Stairway Step

Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]

You rated this post out of 5. Change rating

2022-10-24 (first published: )

5,783 reads

The Basics - Level 1 of the Stairway to Query Store

  • Stairway Step

Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]

4.8 (5)

You rated this post out of 5. Change rating

2020-10-07 (first published: )

6,581 reads

Blogs

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Read the latest Blogs

Forums

Query Help to show record in single row

By sqldba20

Hi All, need help with an SQL query. We have an existing table that's...

MSDTC not available on Windows 2022 clustered SQL 2019 CU30

By Johan Bijnens

I connect to this clustered instance and run : begin distributed transaction Msg 8501,...

Time Outs Here

By Ahr Aitch

Several times in the last couple of days I've had submissions time out with...

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers