Author Archives: sergeig888

XLStyles Tool for Win8.1 (release 4) submitted to the app store

Why and what is in this release? A user from Norway mentioned that he can’t see XLStyles Tool in the app store. This was weird because all apps are always published for all markets. App store tech support took about … Continue reading

Posted in Computers and Internet | Tagged , | Leave a comment

XLStyles Tool on Windows 10 Technical Preview

Happy to report that Windows App Store version of the XLStyles Tool app successfully tested on the latest version of Windows 10 technical preview. The builds before 9840 had an issue in full screen mode: file picker would remain hidden … Continue reading

Posted in Computers and Internet | Tagged | 2 Comments

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

MS Switch to OneDrive from SkyDrive Caused Download Disruptions

If you tried to download any of my apps in the last couple of days you may have received an error message for some older links that the service was temporarily unavailable. This happened because Microsoft was in the middle … Continue reading

Posted in Uncategorized | Tagged , , | 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

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 150,000 times in 2013. If it were an exhibit at … Continue reading

Posted in Uncategorized | Leave a comment

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