Posted by: Colin Smith
DBA, Education, SSAS, Training
I recently attended a deep dive bootcamp course in SQL Server Analysis Services. The class was geered more towards developers but it gave me a better understanding of what a cube is and how it works. The part that I was most interested in was the security portion and the 2008 version gives us a lot of ways that we can lock down access to the cubes. This was a good part of the class for me as securing our data is very important to me. I am currently working on a data mart project so the class was very timely for me. If you have the chance I highly recommend looking into classes like this. They are expensive but they really do give you some good insights of how the system works and how you as a DBA can make it better faster and more secure.