Azure Synapse Link for SQL: From production to a data warehouse in a few clicks
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
2022-07-06
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
2022-07-06
The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how to get to the data and ways to use it.
2022-06-20
You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.
2022-05-06
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.
2022-04-29
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.
2022-04-15
To return detail data using DAX, use the table functions. Adam Aspin covers UNION, EXCEPT, INTERSECT, and CALCULATETABLE in this article.
2022-03-09
Several DAX table functions can be used for paginated reports when you want all the data, not a summary. Adam Aspin explains how to use DAX table functions for paginated reports.
2022-02-16
Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage it.
2022-02-11
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
2022-01-10
SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.
2021-12-10
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
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