Using Azure Data Factory V2 to Pause and Resume Azure SQL Data Warehouse

In this post, I will show how to automate the process to Pause and Resume an Azure SQL Data Warehouse instance in Azure Data Factory v2 to reduce cost. I am assuming that you already know how to provision an Azure SQL Data Warehouse, Azure Logic Apps and Azure Data Factory V2. Before deep dive … Read moreUsing Azure Data Factory V2 to Pause and Resume Azure SQL Data Warehouse

Exam 70-475 Designing and Implementing Big Data Analytics Solutions

In this post, I would like to share my experience on how to study to Microsoft Exam 70-475 Designing and Implementing Big Data Analytics Solutions. This exam will test your knowledge on Azure HDInsight, Data Lake Analytics, Azure Data Factory, Azure Machine Learning, Azure IoT, Azure Event Hub, Azure Stream Analytics and Azure SQL Database. … Read moreExam 70-475 Designing and Implementing Big Data Analytics Solutions

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 on 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 … Read moreExam 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 the 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 … Read moreIndex Related Dynamic Management Views and Functions