Sunday, May 18, 2014

Book Review: Reporting with Microsoft SQL Server 2012

I have just finished reading this book (Reporting with Microsoft SQL Server 2012) and wanted to let you know my opinion.

I believe the book is a very good starting point for beginners in SSRS or Power View. I also got some gotcha's out of it, so there may be interesting points for more experienced users.

Overall I feel the content described is correct (some minor typos aside), thorough and easy to read, but it is on a pretty basic level. So if you have (almost) never worked with Reporting Services I believe it is worthwhile reading the chapters on SSRS, but if you're already a(n) (more) experienced user, I don't believe this will add very much to your knowledge.
While chapter 2 also covers new features in SQL 2012 (like data alerts) and could therefore be of use for experienced users, chapter 3 will not cover many new things in my opinion.

Because Power View is a much younger product than SSRS, this book might also be a good starting point. It covers the differences between SharePoint and Excel as a starting point for a Power View report very well. It also let's you create a basic report and publish this to SharePoint.

All in all a good and easy read on the subject.

Thursday, May 15, 2014

Dashboarding for Power Pivot and Excel

Last week I heard the exciting news that Kasper de Jonge's ( B | T ) book Dashboarding for Power Pivot and Excel will be available shortly. I understand the e-book is also only available when the paperback is on Amazon, so we'll have to wait for that too.



What you cán do is you can already pre-order your copy here of course.

Thursday, May 8, 2014

Cannot delete Evernote shortcut from desktop

I have had this annoying issue for a while now and decided to fix it.
After installing Evernote (and Toggl also), I wasn't able to delete the shortcut from my desktop.
I found some hints in the right direction on the Evernote support site, but they didn't quite solve the issue.

Apparently it resides in the User\Public folder, but I couldn't Del or Shift+Del it there either. However, when I right click and choose Delete (as Admin) I was finally able to delete the shortcut.



Hope this helps..


Friday, May 2, 2014

70-461

You could say: -391. Because that's what 70 minus 461 is.. :)

But I actually meant to say 70-461: Querying Microsoft SQL Server 2012, that's the exam I finally did last friday and succeeded with a score of 981!

Now up to 70-462 for my MCSA.


Featured Post

Governance & Administration - Tenant Settings: Visual Cues

With all the Fabric announcements in the last months, some of the Admin announcements might have slipped through. As you might know, the Adm...