Category Archives: Computers and Internet

Creating Rolling Periods Dimension in PowerPivot or Tabular models

If you created trend reports in Power View and then created some more and then when the next month came you cursed at yourself for being so prolific, then you will really benefit from the latest article I co-authored with … Continue reading

Posted in Computers and Internet | Tagged , , , | 1 Comment

Windows XP is no Longer Supported

As of today Windows XP won’t be getting any updates or security patches. If you didn’t upgrade because you didn’t want to move your files here is free Windows XP data migration tool.

Posted in Computers and Internet | Leave a comment

Analysis Services Session Terminator App

I ran into a situation where the users of the SQL 2012 tabular cube started running extremely large queries that began to interfere with our weekly PowerPivot model refresh. The user queries were so CPU and RAM intensive that they … Continue reading

Posted in Computers and Internet | Tagged , , , , | 3 Comments

Sharing Simplest WinForms Timer App

A while ago when I worked on a complex ASP.NET app I created the simplest performance timer that operates on just mouse clicks: left-click to start/stop and right-click to reset to zero. Today I had to use it myself and … Continue reading

Posted in Computers and Internet | Tagged | 2 Comments

XLStyles Tool updated for Windows 8.1 is in the App Store

I submitted Windows 8.1 update (Release 3) to the App store on Friday afternoon and received notification at 11PM PST on Sunday that it is published. Windows 8.1 version of the executable is 1.1.0.10 to differentiate it from Windows 8 … Continue reading

Posted in Computers and Internet | Tagged , , | 3 Comments

XLODCTool.exe got updated to ignore PowerPivot connection

PowerPivot model connection in Excel 2013 caused an error in the XLODCTool. The tool has been upgraded to ignore ThisWorbookDataModel connection that resulted in “array index out of bounds” error message. Get the update.

Posted in Computers and Internet | Leave a comment

Windows App Store Version of the XLStylesTool

Privacy Policy: XLStyles Tool for Microsoft Excel doesn’t collect any information about the user. The permission to use Internet connection is requested to support delivery of in application advertisement content administered by Microsoft AdCenter (see Microsoft Online Privacy Policy) which … Continue reading

Posted in Computers and Internet | Tagged , , , , | 78 Comments