T-SQL.dk

A blog on code, coffee & curiosities

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

Tag: SQL Server

Programming

[Issue] – The Mystery of the Hidden Column

Jens Vestergaard30/09/2015 Leave a comment

Yesterday I was trying to setup a new Power BI dashboard for our SQL Server Analysis Services logging data. We are running traces on most of our servers, in order to keep up with what is going on – this mainly because all other access to the boxes is restricted. Now, having the data in a […]

Read the article
Programming

Run your cubes in Warp Speed – Really Really Fast!

Jens Vestergaard01/04/2014 1 Comment

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 unlocked some underlying functionality in the Windows OS, to enable the MOLAP cubes to operate […]

Read the article
Programming

How to Process Multiple Dimensions via BIDS and SSMS

Jens Vestergaard31/03/2014 1 Comment

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 to Visual Studio Business Intelligence Development Studio [BIDS] or SQL Server Data Tools [SSDT], which […]

Read the article
Community

Speaking at #SQLSatCambridge

Jens Vestergaard28/07/2013 4 Comments

Do you sometimes drift off, thinking/dreaming crazy scenarios, that you almost instantly know won’t ever become a reality? I had one of those moments, when I spotted, that #SQLSatCambridge and the NFL game at Wembley between The Pittsburgh Steelers and Minnesota Vikings were scheduled only a day apart. Oh how I wished to be in England […]

Read the article
Programming

Rolling period with shell dimension SSAS

Jens Vestergaard10/05/2012 2 Comments

Often I meet the business requirement of listing data for the last X months. In this blog post, I will try to give my shot at, how this is done elegantly and with maximum flexibility. We start of backwards and enhance the Data Source View in the cube with a custom Named Calculation called UtilityKey (or whatever you like). […]

Read the article

Posts navigation

  • 1
  • 2
  • 3
  • 4

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