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
1,396 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
11,656 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.
2019-09-04
1,149 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
554 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,644 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
1,693 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,195 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,491 reads
Blogs
How a new custom PowerPoint template is helping us to be more effective presenters
DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for...
New Event Calendar
Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...
Databricks Delta Lake
By James-Serra
Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...
Forums
More Network Restrictions
Comments posted to this topic are about the item More Network Restrictions, which is...
Finding out mismatch between time lines.
CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE...
development of encrypted password field
I want to be able to: encrypt a password column display characters x &...
Ask SSC