Unleash the power of Azure Data Factory (Webinar)

On Thursday 14th of June 2018, I presented a webinar for Integration Down Under about Azure Data Factory. Thanks to the organizers for this opportunity to talk about one of my favourite Azure product. Integration Down Under is a group organized by Bill Chesnut, Martin Abbott, Dan Toomey, Wagner Silveira and Rene Brauwers that decided to have an Integration focused webcast on … Continue reading Unleash the power of Azure Data Factory (Webinar) →

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 … Continue reading Using Azure Data Factory V2 to Pause and Resume Azure SQL Data Warehouse →

Perth SQL User Group – Azure Analysis Services

On Thursday 22nd of March, I presented an overview on Azure Analysis Services for around 25 IT professionals. In this session I presented: What is Azure Analysis Services (AAS) AAS Benefits Demo – Provision AAS, Deploy and Explore a model in AAS You can find the presentation below: https://www.slideshare.net/SabrinaMotta4/azure-analysis-services-91945068 Thanks all for attending!

Global Integration Bootcamp 2018 – Unleash the power of Azure Data Factory

Last Saturday 24th of March, I presented Unleash the power of Azure Data Factory at GIB (Global Integration Bootcamp - Microsoft Perth) for over 35 IT professionals. In this session I presented: Azure Data Factory (ADF) Overview Understand how ADF Works ADF v1, v2 and new features Understand ADF components Be able to deploy, build … Continue reading Global Integration Bootcamp 2018 – Unleash the power of Azure Data Factory →

Deployment failure with Azure Analysis Services

Today when I was deploying an Azure Analysis Services in Australia Southeast region, I got the error below. STATUS: Conflict PROVISIONING STATE: Failed TYPE: Microsoft.AnalysisServices/servers System.Fabric.FabricTransientException: The operation failed because the service is currently offline. I tried to deploy AS in another Azure region (WEST US), which was completed successfully. After that, I realized the issue … Continue reading Deployment failure with Azure Analysis Services →

PSSUG – Discover Azure Data Lake Store and Analytics

This week I presented Discover Azure Data Lake Store and Analytics at PSSUG (Perth SQL Server User Group) for over 25 IT professionals. In this session I presented: What is Data LakeOverview of Azure Data Lake StoreAzure Data Lake Store SecurityHow to ingest data to Azure Data Lake StoreAzure Data Lake Store CostOverview of Azure … Continue reading PSSUG – Discover Azure Data Lake Store and Analytics →

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. … Continue reading Exam 70-475 Designing and Implementing Big Data Analytics Solutions →

SQL Server Row-Level Security (RLS)

In this post, I will explain how to setup and use Row-Level Security (RLS) which is available from SQL Server 2016 and on Azure SQL database. RLS enables you to control access to rows (records) in your database table, restricting employees to ONLY access rows related to their department, region or any other criteria required … Continue reading SQL Server Row-Level Security (RLS) →

Azure SQL Database cross-database queries

In Azure SQL Database, you need to use Elastic Queries to run a query that access data from other databases, which is called cross-database queries. You probably have done it in SQL Server on-premises or IaaS, where you access tables from other databases by typing <database name>.<schema name>.<table name>. In this post, I will show … Continue reading Azure SQL Database cross-database queries →

Checking Queries Performance on Azure SQL Database (DMVs)

In this post, I will share a couple of important queries that I am using to check performance on Azure SQL Database. Show locking information: SELECT t1.resource_type, t1.resource_database_id, t1.resource_associated_entity_id, t1.request_mode, t1.request_session_id, t2.blocking_session_id FROM sys.dm_tran_locks as t1 INNER JOIN sys.dm_os_waiting_tasks as t2 ON t1.lock_owner_address = t2.resource_address; For further details read: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql Show Top 5 worst performance … Continue reading Checking Queries Performance on Azure SQL Database (DMVs) →