Sunday, November 29, 2015

Analysis Services: How to stop showing records when unrelated dimensions are used with measures?

›
It is very common to see an Analysis Services database (or a cube) that holds multiple measure groups. If your cube holds multiple measure...
Saturday, November 28, 2015

Analysis Services: I see a new measure group when a measure is created with Distinct Count

›
Have you noticed that a new measure group is automatically created if you have created a new measure with Distinct Count   usage? Microsof...
Friday, November 27, 2015

Microsoft SQL Server Code Names for versions and features

›
Microsoft SQL Server team used/uses various code names for SQL Server versions and some of its features, here are some of them found in ...
Wednesday, November 25, 2015

How can I see the pages used by my table?

›
Not always, but there are instances that you need to see the data pages used by SQL Server for holding data in our tables. There are few wa...
Tuesday, November 24, 2015

Changing from FULL to SIMPLE recovery model reduces the log file size?

›
A concern related to large log file or ldf file still appears in many forums, it is very common to hear/see a questions like my database l...
Monday, November 23, 2015

Can I use Standard Edition of SQL Server for implementing my Business Intelligence solution?

›
I always get this questions from my clients, companies I consult and people who work on BI implementation. Most of the companies initially...
Sunday, November 22, 2015

SQL Server Brain Basher of the Week #035 - Database size

›
Microsoft SQL Server supports creating small databases as well as very large databases. This week question is based on database sizes, her...
Saturday, November 21, 2015

SQL Server Brain Basher of the Week #034 - Analysis Services Security

›
Security is the most important area that needs to be addressed with many solution and same goes to your Business Intelligence solutions im...
Friday, November 20, 2015

Storing datetime with time zone offset and retrieve with required time zone offset

›
Nothing new but posting as it is something important when working with multiple time zone offsets. If you have to store requests coming fr...
Thursday, November 19, 2015

SQL Server Management Studio - October 2015 Release

›
Have you tried out latest SQL Server Management Studio? It is available as the October release. It can be used with SQL Server 2016 throug...
Wednesday, November 18, 2015

Power BI: Showing YTD values

›
Still not all time intelligence functions are working but some of them can be used with DAX. If you have a requirement for showing YTD, QT...
Tuesday, November 17, 2015

Can we use user-defined hierarchies in the model with Power BI?

›
Power BI is becoming richer and richer with its functionalities and will be surly the best in terms of BI client tools. Since it is still ...
Monday, November 16, 2015

Understanding Reporting and Analysis in Business Intelligence solutions

›
Every company implements a business intelligence solution for tracking and improving the business performance through reporting and analys...
Sunday, November 15, 2015

Trying to connect on-prem Analysis Services using Power BI Analysis Services Connector?

›
Although Power BI Pro allows us to connect with On-Prem Analysis Services Tabular instances for consuming live data into dashboards and re...
Wednesday, October 28, 2015

Loading data from Microsoft SQL Server to DocumentDB in Azure

›
WIth my previous post ( How to create a DocumentDB in Azure ), I mentioned that there are multiple ways of loading documents into Document...
Tuesday, October 27, 2015

How to create a DocumentDB in Azure

›
Microsoft implementation of NoSQL database, documentDB is a cloud based, fully managed, massively scalable service for managing semi-struc...