Browse by Tags

SSAS Multithreaded sync with Windows 2008 R2

This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2012/07/07/ssas-multithreaded-sync-with-windows-2008-r2/

Posted to Andrew Calvett (Weblog) by ACALVETT on Sat, Jul 7 2012
SSAS: Utility to check you have the correct data types and sizes in your cube definition

This blog describes a tool I developed which allows you to compare the data types and data sizes found in the cube’s data source view with the data types/sizes of the corresponding dimensional attribute. Why is this important? Well when creating named queries in a cube’s data source view, it is often...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Thu, Mar 15 2012
SSAS: Utility to export SQL code from your cube's Data Source View (DSV)

When you are working on a cube, particularly in a multi-person team, it is sometimes necessary to review what changes that have been done to the SQL queries in the cube's data source view (DSV). This can be a problem as the SQL editor in the DSV is not the best interface to review code. Now of course...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Fri, Feb 24 2012
Working with SSAS traces and the dreaded Textdata in SSMS

This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2012/02/04/working-with-ssas-traces-and-the-dreaded-textdata-in-ssms/

Posted to Andrew Calvett (Weblog) by ACALVETT on Sat, Feb 4 2012
SSAS Crash Dump behavior

This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2012/01/17/ssas-crash-dump-behavior/

Posted to Andrew Calvett (Weblog) by ACALVETT on Tue, Jan 17 2012
SSAS - What is running ?

I saw a tweet today from respected blogger john sansom asking how a SQL DBA should attempt to performance tune SSAS. I've been through a similar scenario - and one of the tools I developed as part of my troubleshooting was my own 'SSAS version' of sp_who. I've written a stored procedure...

Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Thu, Dec 15 2011
SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience by the best in the business. The key to Technitrain...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Nov 23 2011
Introduction to MDX–Training–London

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 5 2011
Extreme load and “the operation has been cancelled”

This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2011/09/18/extreme-load-and-the-operation-has-been-cancelled/

Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Sep 18 2011
SSAS 2008 R2 Operations Guide

This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2011/06/02/ssas-2008-r2-operations-guide/

Posted to Andrew Calvett (Weblog) by ACALVETT on Thu, Jun 2 2011

Page 1 of 6 (58 items) 1 2 3 4 5 Next > ... Last »