Come and join us on Monday, September 28th, for our next Atlanta MS BI Group meeting. The topic this time is "Enhancing Data Analysis and Predictive Analytics with NoSQL" delivered to you by RDA Consulting. Presentation:Enhancing Data Analysis and Predictive Analytics with NoSQL Level: IntermediateDate:Monday, September 28th, 2015Time6:30 – 8:30 PM ETPlace:South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346Overview:The pervasiveness of Big…
For years I've been harassing Microsoft to support embedding interactive reports connected to SSAS on custom apps. This feature has been sorely missing in the Microsoft BI stack. Yet, it's a must-have feature that enables a wide range of integration scenarios, such as customer-facing reporting. Imagine your customers being able to ask natural questions for data exploration. This is a killer feature! It looks like…
I'm optimizing a SQL Server OLTP mirrored database hosted on an Azure VM. After load testing, it was clear that CPU is the primary resource constraint so I suggested an upgrade to a higher A-series machine alongside other reconfiguration and storage changes. Meanwhile, I've noticed that starting in October, the D-Series pricing goes down. Moreover, D-series include a SSD temporary drive to host the temp…
Scenario: You're conducting a capacity planning effort and load testing an Azure website (Azure App Service) that saves data to SQL Server running on Azure VM. You've created a load test, e.g. using Visual Studio, and you've realized that the throughput caps for no obvious reason. SQL Server and Azure performance counters indicate that both layers are not under pressure. Solution: Although no specifics are…
