Stairway to SSAS Tabular Level 8: Multiple Fact Tables and Perspectives
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
3,686 reads
Stairway Series
Stairway to SQLCLR Level 2: Sample Stored Procedure and Function
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.
2019-09-24
14,265 reads
Stairway to SQLCLR Level 2: Sample Stored Procedure and Function
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.
2019-09-24
Stairway to SQLCLR Level 2: Sample Stored Procedure and Function
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.
2019-09-18
1 reads
Provisioning ADF - Level 2 of the Stairway to Azure Data Factory
In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.
2020-01-15 (first published: 2019-09-04)
2,726 reads
SQL Agent in Level 5 of the Stairway of SQL Server on Linux
In this level of the Stairway to SQL Server on Linux, we learn how to set up and use SQL Agent.
2019-08-06
698 reads
Stairway to Database Containers Level 3: Building Custom Container Images by Hand
In this next level of the Stairway to Database Containers learn how to customer a container and save the changes to a new image.
2019-07-18
1,900 reads
Stairway to SSAS Tabular Level 7: Time Intelligence
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 […]
2019-07-10
2,552 reads
The Basics - Level 1 of the Stairway to Query Store
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 […]
2019-05-13
3,363 reads
Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
2019-05-06
4,862 reads
Blogs
SQL Prompt and SSMS 18.5
By Steve Jones
I downloaded SSMS 18.5, as there were a lot of fixes in here and...
Jupyter Book Challenges in ADS
By Steve Jones
I was excited to try the Jupyter Book feature in the March Azure Data...
Join me (virtually) in Adelaide!
I will be presenting a session to the Adelaide SQL Server User Group on...
Forums
Issue with case statement
i have a table A where the data looks like ID Name Phone CODE...
Implementing Reporting Application Enhancements with No Downtime
Comments posted to this topic are about the item Implementing Reporting Application Enhancements with...
ADF Triggers
Comments posted to this topic are about the item ADF Triggers
Ask SSC