-
The Baker’s Dozen State of the Union: 13 Points on SQL Server Data Warehousing and Business Intelligence
By:
Kevin Goff
Last updated: Thursday, July 15, 2021
Published in: CODE Magazine: 2015 - May/June
Kevin takes a look at SQL Server “then and now,” and shows us just how important it is to understand the various tools involved in BI.
-
The Baker’s Dozen: 13 Productivity Tips for Building OLAP Databases with Microsoft SQL Server 2008 Analysis Services
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2011 - March/April
rewarding experience of writing and speaking is taking a seemingly complex topic and making it more understandable and accessible. In this article, I’ll show how to create and use OLAP databases and cubes using SQL Server Analysis Services 2008 (SSAS 2008). The benefits of OLAP are significant, even monumental - but like most technologies, reaping the benefits means considerable research and effort into leveraging the tools. In the case of OLAP databases, developers need to learn the differences between OLAP databases and relational databases, and how to use the tools that SSAS provides. In this article, I’ll walk through how to create an OLAP database and how to use the tools in Analysis Services to enhance the OLAP database. By the end, you’ll see why businesses and other organizations see the value of OLAP databases. I’ll also briefly cover some of the plans Microsoft has announced for the next generation of OLAP tools.
-
2 - Making Software a Service
Last updated: Saturday, January 18, 2020
Published in: Book Excerpts
“This excerpt is from the book, ‘Building Applications in the Cloud: Concepts, Patterns, and Projects’ by Christopher Moyer. (Pearson/Addison-Wesley Professional, April 2011, ISBN 0321720202, Copyright 2011 Pearson Education, Inc. For more information, please visit the publisher site: www.informit.com/title/0321720202)
- Home
Articles filed in category 'Analysis Services'