Browse by Tags

• .NET
• Adventure Works
• ASSP
• Attribute Relationships
• bi
• bids
• BIDS Helper
• cache
• CodePlex
• connect
• connection pooling
• create cache
• cube
• cumulative updates
• Development & Programming
• Discover
• distributed transactions
• dmv
• error messages
• Gemini
• hotfixes
• Manageability & Serviceability
• Manageability &amp
• Many to Many
• mdx
• memory
• metadata
• partitioning
• performance
• Performance and Scalability
• Performance Counters
• powershell
• PowerSSAS
• process
• query performance
• Reliability and Availability
• Sample Install
• server
• Serviceability
• shrinkfile
• sql
• SQL Analysis Service
• SQL Server
• SQL Server 2005
• SQL Server 2008
• statistics
• stored procedures
• TechEd Australia
• trace
• transaction
• usability
• XMLA

• Optimizing CREATE SET in Cube Calculation Scripts

  Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed often and Read More... Posted Wednesday, September 01, 2010 8:27 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, Performance and Scalability, bi

• PowerSSAS v0.3.1.0 released

  Today I put out a new release for PowerSSAS. This release adds the following new cmdlets: backup-ASDatabase clear-ASCache get-ASConnection get-ASRole restore-ASDatabase It also includes a Powershell v2 .psd1 module file and includes the option to just Read More... Posted Sunday, July 18, 2010 10:34 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services

• Poll Results: Foreign Key Constraints

  A few weeks ago I did the following post asking people – if they used foreign key constraints in their star schemas. The poll is still open if you are interested in adding to it, but here is what the chart looks like as of today. (at the bottom of the Read More... Posted Sunday, May 23, 2010 9:44 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• Poll: Foreign Key Constraints

  Do you create foreign key constraints between dimensions and facts in your relational star schemas? I don't want to bias the results in any way, so I won't post my opinion just yet. But a recent discussion got me thinking about the following question Read More... Posted Wednesday, March 24, 2010 3:05 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• SSAS: Automating the Scripting of an SSAS database

  I've been meaning to post this for a little while, and a recent post on the SSAS forum at ssas-info.com prompted me to finally get around to it. Basically the small Powershell script below will attach to the specified SSAS server and script all of the Read More... Posted Monday, February 22, 2010 10:43 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services, XMLA

• SSAS 2008 R2 – Improvements for slow Metadata

  There was a thread last year on the SSAS MSDN forum SSAS 2008 -- Why is metadata so slow??? in relation to slow metadata queries on a cube with 250+ measure groups. The good news is that despite the fact that the SSAS team has largely been focussed on Read More... Posted Monday, February 08, 2010 10:15 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• SSAS: Can I make my Distinct Count totals subtotal correctly?

  I've seen this question come up a couple of times. What is usually being asked is "can we make the subtotals additive for a distinct count measure?" – and the short answer is a resounding No! But the short answer does not really make for a compelling Read More... Posted Wednesday, January 13, 2010 4:29 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• Analysis Services 2008 Performance Counters showing zero

  I had an issue recently with my SSAS 2008 performance counters - they were all showing up as 0. I could see them listed in Performance Monitor, but none of them worked. The counters for my SSAS 2005 instance worked fine, but the 2008 ones did not. I had Read More... Posted Sunday, November 22, 2009 10:22 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, Performance Counters

• For Analysis Services users, you should be aware of this fix

  If you are using SQL Server 2005 or 2008 Analysis Services, and have been keeping up to date with hotfixes cumulative updates, you may have been adversely affected by a previous round (and your users might not have even noticed). Essentially you can get...( Read More... Posted Sunday, November 15, 2009 1:08 AM from Aaron Bertrand | (Comments Off) Filed under: Analysis Services, mdx, cumulative updates, hotfixes

• Gemini/PowerPivot MOSSIG Presentation

  I did a presentation earlier this month on PowerPivot (a.k.a Project Gemini) at the MOSSIG meeting and as promised here is the slide deck. If you've seen other "Gemini" presentations there will be nothing new in this presentation, I've really only posted Read More... Posted Wednesday, November 04, 2009 5:58 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• Which Edition is my Analysis Services Server?

  There was a question the other day on the MSDN SSAS forum asking how to find out the Edition of SSAS which is running on a given server. The answer to this question could be either Standard, Enterprise or Developer. The Object Explorer in Management Studio Read More... Posted Wednesday, October 14, 2009 8:20 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• SQL Downunder 2009 Presentation: SSAS Metadata – Knowledge is Power

  I just finished my talk at the 2009 SQL Downunder Code Camp on Analysis Services data. As promised, attached below are the scripts and Powerpoint slides that I used in the presentation. There is not that much information in the slides, they were really Read More... Posted Sunday, October 11, 2009 2:18 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• Book Review - Analysis Services 2008 Unleashed

  Full Disclosure: I was lucky enough to be sent a free review copy by the publisher But... if I had not been sent a review copy I would have gone out and bought a copy of this book anyway. Why is that? Because I had purchased the previous edition and I Read More... Posted Sunday, October 04, 2009 9:36 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• Gemini - Self Service BI!

  Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, Read More... Posted Sunday, August 16, 2009 10:25 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, bi, Gemini

• SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure

  A few weeks ago I did a post introduced the ExecuteSQL .net stored procedure for SSAS. Chris Webb asked if this function can be called from Excel 2007 when it is set this up as a rowset action and I figured that this would make a good topic for a blog Read More... Posted Thursday, July 02, 2009 7:42 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, .NET, ASSP, CodePlex, stored procedures