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 →