T-SQL.dk

A blog on code, coffee & curiosities

Search
  • About
  • Contact
  • Engagements
    • Delivering BI Continuously
  • Volunteering
Skip to content

Tag: SSAS

Programming

Extracting SSAS Tabular Models w/ PowerShell

Jens Vestergaard06/08/201906/08/2019 Leave a comment

As a response to a comment on a previous blog post on how to extract SSAS Multidimensional [MD] databases with PowerShell, I decided to write a new blog post, to address the tabular version [Tab]. The main differences working with MD and Tab, programatically, is that MD is represented by XML for Analysis and Tab […]

Read the article
Programming

SSAS(MD) Time Intelligence w/ a Twist

Jens Vestergaard20/02/2017 Leave a comment

Introduction There are a lot of great examples out there on how to build your own custom Time Intelligence into Analysis Services (MD). Just have a look at this, this, this, this and this. All good sources for solid Time Intelligence in SSAS. One thing they have in common though, is that they all make […]

Read the article
Community, Programming, tsql2sday

T-SQL Tuesday #85- SSAS(MD) Backup Galore

Jens Vestergaard13/12/201621/12/2016 1 Comment

This months T-SQL Tuesday is hosted by Kenneth Fisher(b|l|t) and the invitation is found following this link. T-SQL Tuesday was started by Adam Machanic (b|t), and this is the SQL Server community’s monthly blog party, where everyone is invited to write about a single common topic. This time, the topic is Backup (and Recovery). Admitted, […]

Read the article
Community, Entry Level, Programming

How to fire up Azure Analysis Services

Jens Vestergaard29/11/201629/11/2016 Leave a comment

This is my twelfth (12th) post in a series of entry-level posts, as suggested by Tim Ford (b|l|t) in this challenge. I have not set any scope for the topics of my, at least, twelve (12) posts in this blog category of mine, but I can assure, it’ll be focused on SQL Server stuff. This time it’s going to be about […]

Read the article
Programming

Testing your SSAS partitioning strategy w/ PowerShell

Jens Vestergaard23/11/201623/11/2016 Leave a comment

During a presentation of mine, there was a discussion going on, about what partitioning strategy to use when partitioning cubes. Most frequently it seems people are partitioning by some form of period, e.g. by Years, Months or Weeks. Rationally it may seem like a good idea, at the time. But wouldn’t it be a more fact based approach […]

Read the article

Posts navigation

  • 1
  • 2
  • 3
  • …
  • 8

Categories

  • Coffee (9)
  • Community (56)
  • Entry Level (12)
  • Family (3)
  • Mixed (50)
  • Music (5)
  • Personal (4)
  • Programming (179)
  • Roleplay (6)
  • The Who (3)
  • tsql2sday (13)

Tags

.Net Analysis Services azure BI Business Intelligence C# Coffee Community D&D entrylevel Espresso FAIL Fejl Humor iot IWantToShare MCP MDX MsBIP MSConnect NFL Personal PowerBI Powershell Security Speaking SQL SQL2012 sqlfamily SQLPASS sqlsaturday SQLServer SQL Server SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata TSQL2SDAY VS2008 VS2010

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Subscribe

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

  • Coffee
  • Community
  • Entry Level
  • Family
  • Mixed
  • Music
  • Personal
  • Programming
  • Roleplay
  • The Who
  • tsql2sday

Archives

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Social

  • View vestergaardj’s profile on Twitter
  • View vestergaard_jens’s profile on Instagram
  • View jvestergaard’s profile on LinkedIn
Theme: Ameno by BG Web Agency
ASStoredProcedurethisthis