A minor DMV with SQL Server this particular one doesn’t really provide much information about the OS other than the version and service pack level. It is nowhere […]
sys.Dm_db_database_page_allocations()
This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a […]
Business Intelligence on a Phone Bill
I often tell my trainees that BI can be done on pretty much anything. A common example of this is the Phone Bill or the Bank statement. Your […]
Why BI professionals should believe in Aliens
I am pretty serious about this one, not because I believe in UFOs or any other extra-terrestrial theory but because as a DBA who implements Business Intelligence solutions […]
A new video on DB mirroring
Well it’s not new exactly it was created many years back and I somehow never uploaded it. Yesterday a former client came back asking about DB mirroring and […]
Configure Email Subscriptions in SSRS
In this blog we are going to look at how to configure Email subscriptions in SSRS. Subscriptions like its names suggests is a way for the user to […]
administration / Azure / MSSQL
MS SQL Server 2014 to Cloud Backups – Part 1
In this series of blog posts the focus is going to be on the MS SQL Server 2014 Cloud backups feature. Most companies will easily be able to […]
SSAS: – Dimension Hierarchies
Most of the time there will be a relationship between different attributes in the dimension. We saw an example of this kind when we created the date dimension […]
SSAS: Working with Dimensions, what is a dimension?
In this post we now create our first dimension. A dimension is the data on which the question is being asked. The purpose of the cube is to […]
SSAS: Working with Dimensions, what is a dimension?
In this post we now create our first dimension. A dimension is the data on which the question is being asked. The purpose of the cube is to […]