Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Too often, people consider extraction, transformation, and loading (ETL) only in their data-warehousing environments. They completely overlook that the same ETL concepts and practices used with data warehousing also apply to data migration from...
When creating a financial report such as an income statement, you need to display the subtotals (which are parent members of a dimension) at the bottom of the statement—after the details (which are children). You can use the MDX Hierarchize() fun...
I knew nothing about business intelligence (BI) until I sat through a session about a new feature tentatively called the d-cube (for data cube) during the developer's conference several years ago for the beta version of SQL Server 7.0 (code-named...
Although the next release of SQL Server (code-named Yukon) is still a future topic, the information that Microsoft has revealed about the upcoming product release is both exciting and troubling. Some of the upcoming changes will require many DBAs...