Seagate Momentus XT Hybrid Drive
I thought I’d take a break from writing posts about Business Intelligence and SQL Server, and instead share with you my elation at finding a laptop hard disk that […] Continue Reading…
MDX Calculated Member Spanning Multiple Date Dimensions
It’s common in most cubes to have a number of different date dimensions, whether role playing, distinct, or a combination of both. Say for example, Entry Date, Posting Date […] Continue Reading…
Data Warehousing: Kimball vs Inmon
Anyone involved in the Business Intelligence space has had their head in the sand if they are not aware of the long running, and more often than not misunderstood, […] Continue Reading…
Leap before you can land
Leap before you can land…
Research scientists at the Southern Illinois University have concluded that primitive frogs learned to jump before they learned to land. The result being a rather […] Continue Reading…
SQL User Group Session 24 June 2010
I’m excited to be presenting another session to the South Wales SQL Server User Group.
On Thursday 24th June 2010, Eversheds in Cardiff are kindly hosting the event, to run […] Continue Reading…
SQL Server 2008 R2 – PowerPivot and Master Data Services
Purple Frog spent a very interesting day at Microsoft last week, at one of their many events promoting the launch of SQL Server 2008 R2. Rafal Lukewiecki presented an […] Continue Reading…
SQLBits and Microsoft BI conferences
Following the launch of SQL Server 2008 R2 this week, the ever dedicated SQL Bits team are putting on the next installment tomorrow with SQL Bits VI – ‘the […] Continue Reading…
Clearing SSRS Query cache
When developing SQL Server Reporting Services (SSRS) reports, BIDS caches the query results when you preview the report. This cache is then used next time you run a preview. […] Continue Reading…
Excel Cube Pivot drillthrough limited to 1000 rows
When browsing a cube using Excel 2007, you can drillthrough the measures to display up to 1000 rows of the transaction level source data.
I often get asked whether this […] Continue Reading…
Loan Amortisation in SQL Server (PMT, FV, IPMT, PPMT)
Whilst designing a data warehouse for a banking client recently, I needed to calculate projected future loan payments (including breaking this down by interest and capital payments) for every […] Continue Reading…