Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented by Akshai Mirchandani and Allan Folting of Microsoft.
Tabular Design Principles
- Speed and performance
- Optimize query performance over processing performance, focus on end-user experience.
- Accommodate changes without forcing reload, if…
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or replace characters. I recently used the Script Component in SSIS to cleanse some ticket tracking data and thought I’d write a blog post that outlines the implementation.
The data from… Read more
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL Community Mean to You?’ I’m fortunate to live in an area with a SQL PASS chapter (MadPASS) and have attended many chapter meetings as… Read more
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a SQL Server Analysis Services book….I know it will good. This book is no exception! I can say with 100% honesty that this is one of the best technical books I’ve… Read more
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on the column. The syntax is IsFiltered(<columnName>). More details regarding this function can be found on MSDN.
I recently used the IsFiltered function to create a measure that is only… Read more
- Introducing Microsoft SQL Server 2012
- 31 Days of SSIS with SQL Server 2008 R2
- SQL Server Interview Questions and Answers
- Performance Tuning with SQL Server Dynamic Management Views
- SQL Queries Joes to Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2
- SQL Architecture Basics Joes 2 Pros: Core…
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16, State 1, Line 1
Failed to update database ‘UAT_US_SS02′ because the database is read-only. Please contact your Azure service owner. There may be billing related issues with your Azure…
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member of our local PASS chapter. Adam has his pilot’s license so we flew to Minneapolis the morning of the event. It was a beautiful and warm fall day – perfect… Read more
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need Somebody’ inspired by The Beatles. The challenge is to write about a person, community or resource that helped you when you were stuck on a SQL… Read more
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually a hard drive connected to the underlying physical hardware, so it should offer better performance then the persisted data and OS disks. The persisted disks are located on Azure Blob… Read more
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming year. I hope to generate momentum in fall and winter and get a good start on this list:
- Write three blog posts per month
- Participate in TSQLTuesday and Meme15…
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended to write a book review for quite awhile and thought I’d start off with this book for several reasons:
It can easily be read from cover-to-cover. This book is organized…
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started working as a Business Intelligence developer at Trek Bikes. Working at Trek has been a great experience and I feel very fortunate to have the opportunity, so I thought I’d… Read more
Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging about a cool process or trick you implemented that is related to SQL Server and the lessons or insight gained from the experience. As a BI developer, I… Read more
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for a little over a year and work with the Microsoft BI tools: SSIS, SSAS and SSRS. The BI team at Trek consists of 4 analysts (2 in US, 1… Read more
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write a blog post! I’ve been working with MDX quite a bit recently and thought I’d share a few more bits of knowledge I’ve acquired….
I recently received a request to… Read more
I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a cube with the following measures: Shipped Quantity, Forecast Quantity, and ABS Variance to Forecast.
ABS Variance to Forecast is a calculated member in the cube, the MDX is pretty… Read more
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message is similar to the following:
<Warning WarningCode=”1092550658″ Description=”Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: ‘dbo_DimClaim’, Column: ‘ClaimCanceledReasonCode’, Value: ”. The attribute… Read more
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the GUI interface in SQL Server Management Studio (SSMS).
To process all dimensions:
1. Connect to an SSAS instance in SSMS.
2. Expand the appropriate node / cube.
3. Select ‘Dimensions’… Read more
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for synchronous outputs, then each input row is processed as it passes through the component. Asynchronous outputs can be configured to wait until multiple input rows have been received before processing. Read more