-
SSAS Tabular Video Course
Interfacing with Tabular: Automate Deployment
…a database using SQL Server… using the […] implementing a task in SQL Server agent. However, in reality this… Watch now
-
video course
VertiPaq storage engine: What is VertiPaq?
…Imagine for example if this was a SQL Server table and you had a… Watch now
-
Optimizing DAX Video Course
Understanding DirectQuery over SQL: Calculated columns
…became part of the SQL code. […] becomes part of the SQL code […] but also the SQL code executed. […] into SQL code, any DAX statement that is not supported […] So anything that will not be supported in… Watch now
-
This video describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. There are two related articles and downloads: Optimizing duplicated DAX expressions using variables Optimizing IF… Watch now
-
SSAS Tabular Video Course
Introduction to Analysis Services: SSAS Server Mode
…depending on the mode of Analysis Services you will see that SQL Server Management […] for example SQL Server Management Studio to Analysis Services you can […] hierarchies. So the user interface of SQL Management Studio is […] Services “on-prem” installed as part… Watch now
-
SSAS Tabular Video Course
Guided Tour of Tabular: Project Properties
…deployment server. And then if you want to process it you can use SQL Server Management Studio and […] edition. There are several editions of SQL Server, and… Watch now
-
SSAS Tabular Video Course
Guided Tour of Tabular: Calculated Columns
…also do with SQL”. In reality as of today I think they are probably one of the […] And I don’t have to read the data from SQL Server again, you already said that but I think it is important to… Watch now
-
SSAS Tabular Video Course
Guided Tour of Tabular: DAX Editor
…Besides, it’s free, it provides you syntax highlighting; it’s not perfectly integrated with SQL […] Server Data Tools. It’s an add-in. It’s not built in inside SQL Server Data Tools, but so […] SQL Server Data Tools which is called DAX Editor – you can… Watch now
-
SSAS Tabular Video Course
Loading Data: Data Sources
…how to load some table from SQL Server previously, but now we have to go in more detail in all the… Watch now
-
SSAS Tabular Video Course
Loading Data: Impersonation
…”this data source will connect to SQL Server using the […] Data Source…” and by choosing SQL Server, and we click Next… We have to […] from SQL Server using Alberto’s credentials. Now there would have […] is going in SQL Server, and in the administration of SQL Server we… Watch now
