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.
SQL Server's extended stored procedures extend the power of T-SQL by letting your T-SQL batches interact with the OS and other objects outside the SQL Server database. Last month, I looked at some undocumented extended stored procedures that you...
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...