In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.
2020-01-29 (first published: 2018-07-18)
3,744 reads
In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.
2021-10-06 (first published: 2018-07-11)
18,015 reads
In Level 7, we looked at optimizing rowgroup elimination for a nonclustered columnstore index. For a clustered columnstore index, the same technique can be used but the steps and syntax change a bit. This will be covered later – but first, let’s take a look at another significant difference between nonclustered and clustered columnstore indexes, […]
2019-03-26 (first published: 2018-06-20)
8,998 reads
SSAS (SQL Server Analysis Services) is available in two modes, tabular and multidimensional. The new tabular model is easier for those companies who are not already invested in the traditional, multidimensional model. In this stairway, Thomas LeBlanc will teach you how to create tabular models used for reports and dashboards.
2018-06-13
10,769 reads
In this first level, learn how to get started with Azure and Azure SQL Database.
2018-06-13
5,491 reads
In Level 2, we look at the architecture and structure of the Machine Learning Services server process.
2020-06-03 (first published: 2018-05-16)
4,961 reads
This first installment of the Stairway to Machine Learning Services explains the installation process for this subsystem in SQL Server.
2020-02-12 (first published: 2018-05-02)
7,747 reads
In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.
2018-04-11
6,488 reads
Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.
2022-04-04 (first published: 2018-01-31)
4,721 reads
Learn the basics of how Row-Level Security works in SQL Server.
2020-07-15 (first published: 2017-12-28)
4,765 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers