The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...
2018-07-20
14 reads
I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...
2018-07-20
14 reads
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement.
In short, ADLS Gen2 is...
2018-07-10 (first published: 2018-06-28)
2,577 reads
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement. In short, ADLS Gen2 is the combination of the current ADLS (now called...
2018-06-28
8 reads
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that...
2018-06-20 (first published: 2018-06-11)
3,542 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is...
2018-06-18
641 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is...
2018-06-18
608 reads
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that...
2018-06-11
428 reads
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
796 reads
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
364 reads
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data...
2018-05-11
801 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers