#bis

My next book titled Building Custom Tasks for SQL Server Integration Services is available for pre-order! The current release date is scheduled for late July 2017. The Cost of Custom SSIS Tasks There ... Read more

I interviewed Jayne Landry, who heads up BI at SAP, on the latest hot trends and new products from SAP Analytics. Read more

Bringing a Treasure Trove Back into the Light Guess how many articles are here on PowerPivotPro.com?  Go ahead and think of a number, I’ll wait. The answer, at time of writing, is 923.  Rob alone has ... Read more

As noted in my previous post , I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table, but then ... Read more

Drill to Detail Podcast with Mark Ritter on the big trends in analytics Read more

Sharing with the community why we decided to move back from ElasticSearch to SQL Server Sometimes it happens: you move to something that is considered cool and bleeding edge back to something that has ... Read more

My SAPPHIRENOW interviews with Byron Banks, SAP Analytics Marketing VP, on the launch of SAP Leonardo and new analytics products & partnerships Read more

Guess Which One Grows Your Career (or Company) More? (Hint: It’s the One on the Right) (But Individual Excellence is a Prerequisite for Org-Wide Impact) “Cuz we need a little, Con-tro-versy…”   -Marsh ... Read more

The Public Preview of the Office 365 Adoption Content Pack combines the intelligence of the Office 365 usage reports that are available for you in the admin center with the interactive analysis capabi ... Read more

Azure Cosmos DB is Microsoft’s new global scale, distributed database as a service that supersedes Azure Document DB. Cosmos is a technology that enables you to create applications that are unimaginab ... Read more

Today at the Preakness horse racing event, Classic Empire dominated and led the race appearing to be the certain winner with Always Dreaming staying a close second and appearing to be a possible conte ... Read more

Azure uses Role Based Access Control (RBAC), which is something people generally don’t pay at lot of attention to when initially learning how to use the Azure portal. Take a close look at the screen c ... Read more

As I wrote in Parsing SSIS Catalog Messages for Lookup Performance, v2 : I prefer to passively gather performance metrics – even if it’s a little convoluted and more work (for me). I don’t often need ... Read more

Slides from my session on the latest big trends in BI & Analytics at the SAPPHIRENOW SAP User Conference +ASUG Annual Conference this week in Orlando, Florida. Read more