Sqlblog - sqlblog.com - SQLblog.com - The SQL Server blog spot on the web
General Information:
Latest News:
Dynamic Calculation of Inventory with #dax in #powerpivot and #ssas #tabular 27 Aug 2013 | 05:18 pm
I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock f...
Data Science and the Cloud 26 Aug 2013 | 08:56 pm
More than perhaps any other computing discipline, Data Science lends itself best to Cloud Computing in general, and Windows Azure in specific. That's a big claim, but before I offer some evidence, I n...
An ETL joke #fridayfun 23 Aug 2013 | 12:46 pm
I received a text from my bank recently where they appear to have mistaken me from someone with a rather strange first name. As an ETL developer by trade there really was only one possible response: ...
SSAS Maestro and MCM:BI, MCA:BI, MCSM:BI – make your voice heard #ssas #mcsm #sqlserver 22 Aug 2013 | 04:58 pm
Two years ago Microsoft started a certification program called SSAS Maestro, which was intended to be as a step towards a broader certification such as a Microsoft Certified Architect (MCA) or Microso...
SQL Server 2012 RTM Cumulative Update #9 is available! 22 Aug 2013 | 04:20 pm
The SQL Server team has released CU #9 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2867319 Build # is 11.0.2419 This build has 7 fixes, including an interesting one involving ...
One, Two, Three: SQL Saturday in Italy! 21 Aug 2013 | 01:34 am
As a friend of mine tells "The first time that something happens is a fortuity, the second time that it happens again is a probability and the third one is a certainty!" Therefore, this year, SQL Sat...
IF NOT EXISTS ( SELECT ‘thisPost’ ) CREATE POST thisPost AS 20 Aug 2013 | 11:46 pm
T-SQL deployment scripts are tedious to write and they get no love. As a result, they are very often the most horrible, error-prone step-children of scripts*. One basic principle that could help is to...
Incorrect Results Caused By Adding an Index 20 Aug 2013 | 08:11 pm
It’s not often that a SQL Server bug really surprises me or makes me wonder how it was never spotted before, but this is one of those. To get right into it, say you have the following two tables: Lo...
I'm speaking at SQL Saturday #250 in Pittsburgh! 20 Aug 2013 | 02:11 am
On September 14, 2013, I will be speaking at the 2nd SQL Saturday event to be held in Pittsburgh. I spoke at the last SQL Saturday event last year which was a blast. This year, I will be presenting a ...
Ultimate query tuning 19 Aug 2013 | 05:21 pm
Infinitely better. 100% of the reads removed. Roughly 4000 (okay, 3890), down to zero. None. Let me explain... Obviously if there’s data being returned, there are reads needed. And obviously there...
