Recent Comments
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
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
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
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
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 Analysis Services Session Managment, Cube, DAX, MDX, Performance
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
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
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
