Categories
Top Posts & Pages
- SSIS Script Task and Proxy Auto Configuration (PAC) Script
- SQLBits X PreCon SSAS Deep Dive Summary - Part 1
- Restored database konflikter med et opdaterings deploy fra VS DB Ed.
- Why I need to go to SQLskills Immersion Training
- SQL Server Quick Tip 1 - 5
- Never loose your server list in SSMS again...
- CTE - Common Table Expressions Issue
- HierarchyID datatypen
- Using a Custom Assembly to search an Analysis Services dimension
- Microsoft Visual Studio is unable to load this document
Recent Comments
- TSQL Tuesday #63 – How do you manage security: Rollup - SQL Server - SQL Server - Toad World on TSQL Tuesday #63 – How do you manage security
- TSQL Tuesday #63 – How do you manage security: Rollup - SQL Server - SQL Server - Toad World on TSQL Tuesday #63 – How do you manage security
- Donald Parish on Run your cubes in Warp Speed – Really Really Fast!
- Kenneth M. Nielsen (@DoktorKermit) on How to Process Multiple Dimensions via BIDS and SSMS
- Jens Vestergaard on Teradata based Data Source Views in Analysis Services
Tags
.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL Personal Powershell Presenting Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQL Server SQLServer SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata vandkøling VS2008 VS2010LinkedIn
I am happy to connect on LinkedIn:
Tag Archives: SSAS
TSQL Tuesday #63 – How do you manage security
This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and the topic is security. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to … Continue reading
Run your cubes in Warp Speed – Really Really Fast!
So, finally Microsoft came up with a new feature for the MOLAP part of Analysis Services. The community has been hungering for updates ever since the new kid Tabular came around. Now it apears that the SQL Server team has … Continue reading
How to Process Multiple Dimensions via BIDS and SSMS
This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned … Continue reading
Teradata based Data Source Views in Analysis Services
Now here’s a catch. I was trying all night long to figure out why Visual Studio was hanging on me, every time I wanted to add a Teradata based relational data source. Turns out that the list of available objects … Continue reading
Using Powershell to view Partition Slice Information in Excel
Challenge In a blog post written by Chris Webb (b|t), years ago, Chris displays how to query the ASSP.DiscoverPartitionSlices(…). I stumbled upon the post while investigating solutions to problems with partition slicing. But since there were about 20 cubes, each containing … Continue reading