Author Archive
Creating TOP X queries with SSAS 2008
Once you start working with BI, one of the most popular requests is “Can you create a TOP 5 Products report”? So let’s see how SSAS 2008 can help us with that. There are different ways to create TOP X queries/reports with SSAS.
The way I prefer is creating a new Named Set. So let’s create [...]
SQL Server 2008 Auditing
In an era of increasingly concern regarding regulations and their impact in the production environment, auditing is one of the most important topics. And, SQL Server 2008 introduces a new SQL Server Audit feature. This post will not cover all the details of it, but it will give you an opportunity to taste it.
In a [...]
