Azure SQL Database – Modify file failed – Size is greater than MAXSIZE.

This week I was working with a customer and when I tried to move one of the Azure SQL Database from the Elastic Poll I received the following message: Code: DeploymentFailed Message: At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details. Code: Conflict Message: The … Continue reading Azure SQL Database – Modify file failed – Size is greater than MAXSIZE.

Exam 70-473 – Designing and Implementing Cloud Data Platform Solutions

I spent around 2-3 weeks studying for the Microsoft Exam 70-473 (Designing and Implementing Cloud Data Platform Solutions) and I decided to write this post to help anyone in the same journey. This exam will test your knowledge on Microsoft Azure SQL DB, Azure SQL Data Warehouse and SQL Server in IaaS. You also need … Continue reading Exam 70-473 – Designing and Implementing Cloud Data Platform Solutions

Index Related Dynamic Management Views and Functions

Dynamic Management Views (DMV) was introduced in SQL Server 2005 and every SQL Server release Microsoft introduces additional DMVs, which helps to provide information about health of a Server instance, performance and Server issues. There are two types of DMV, the first type is server-scoped DMV which requires VIEW SERVER STATE permission on the Server and … Continue reading Index Related Dynamic Management Views and Functions

Power BI, Cognitive Services, IoT & Predictive Analytics – V:Inspire – Melbourne

This week I presented Power BI, Microsoft Cognitive Services, IoT and Predictive Analytics at V:Inspire event in Melbourne for over 100 people. In this session I presented: Power BI Overview; Demo face recognition (Microsoft Cognitive Services) with Flow & Power BI; What is IoT; Business Application of IoT leveraging Microsoft Cloud Platform; Demo IoT using IoT … Continue reading Power BI, Cognitive Services, IoT & Predictive Analytics – V:Inspire – Melbourne

Azure IoT Hub – Perth SQL Server User Group

It was great to present Streaming data with Azure IoT Hub, Stream Analytics, Blob Storage, Azure SQL DB and Power BI at Perth SQL Server User Group. In this session I presented the following: Overview of IoT and IIoT;Overview and provision of Azure SQL Database;Provision of Azure Blob Storage;Overview and Provision of Azure IoT Hub;Azure … Continue reading Azure IoT Hub – Perth SQL Server User Group

Azure IoT Hub – Perth SQL Server User Group

It was great to present Streaming data with Azure IoT Hub, Stream Analytics, Blob Storage, Azure SQL DB and Power BI at Perth SQL Server User Group. In this session I presented the following: Overview of IoT and IIoT; Overview and provision of Azure SQL Database; Provision of Azure Blob Storage; Overview and Provision of … Continue reading Azure IoT Hub – Perth SQL Server User Group

Power BI, Cognitive Services & IoT – V:Inspire – Adelaide

This week I presented Power BI, Microsoft Cognitive Services and IoT at V:Inspire event in Adelaide for over 120 people. In this session I presented: Power BI Overview; Demo face recognition (Microsoft Cognitive Services) with Flow & Power BI; What is IoT; Business Application of IoT leveraging Microsoft Cloud Platform; Demo IoT using IoT Hub, … Continue reading Power BI, Cognitive Services & IoT – V:Inspire – Adelaide

Power BI & IoT – V:Inspire – Perth

This week I presented Power BI and Azure IoT at V:Inspire event in Perth for over 150 people. In this session I presented: What is IoT;Business Application of IoT leveraging Microsoft Cloud Platform;Demo IoT using IoT Hub, Stream Analytics and Power BI;Power BI Overview; You can find the presentation in the following link: https://www.slideshare.net/szenatti/vel570-v-inspire-power-bi-iot-and-analytics-perth-feb17 Thanks … Continue reading Power BI & IoT – V:Inspire – Perth