Fikrat Azizov

Fikrat Azizov (MCSE Data Platform and MCSE Azure Solutions Architect) has been working with SQL Server since 2002. Fikrat's main passions are SQL Server performance optimization, cloud data technologies and machine learning. Fikrat is currently working as a Solutions Architect at Slalom Canada.

2021 Awards
  

2020 Awards
  

2019 Awards
     

• Automate Azure Analysis Services Model Refresh using Logic App - Part 2 (last update: 6/2/2020)
  
• Automate Azure Analysis Services Model Refreshes with Small, Medium and Large Tables using Logic App - Part 3 (last update: 6/12/2020)
  
• Cross-database query performance in Azure SQL Database (last update: 4/25/2018)
  
• How to Apply Pivot Transformations to Spark Streams (last update: 10/5/2020)
  
• Overview of Azure Analysis Services and Logic App Tasks - Part 1 (last update: 5/13/2020)
  
• Terminate Long Running Azure Analysis Services Refresh Using Logic App - Part 4 (last update: 7/2/2020)
  

• Build real-time data pipelines with Azure Event Hub, Stream Analytics and Cosmos DB (last update: 3/23/2021)
  
• Explore Azure Cosmos Databases with Azure Synapse Analytics (last update: 12/3/2020)
  

• Azure Data Factory Control Flow Activities Overview (last update: 8/20/2019)
  
• Azure Data Factory Execute SSIS Package Activity (last update: 11/29/2019)
  
• Azure Data Factory Filter Activity and Debugging Capabilities (last update: 9/27/2019)
  
• Azure Data Factory ForEach Activity Example (last update: 10/16/2019)
  
• Azure Data Factory Get Metadata Example (last update: 11/28/2019)
  
• Azure Data Factory If Condition Activity (last update: 8/28/2019)
  
• Azure Data Factory Lookup Activity Example (last update: 9/25/2019)
  
• Azure Data Factory Overview (last update: 2/5/2019)
  
• Azure Data Factory Pipeline Variables (last update: 8/14/2019)
  
• Azure Data Factory Stored Procedure Activity Transformation Activities (last update: 7/12/2019)
  
• Azure Data Factory Until Activity Example (last update: 10/24/2019)
  
• Build Azure Data Factory Pipeline Dependencies (last update: 7/29/2019)
  
• Create Azure Data Factory inventory using Databricks (last update: 7/31/2020)
  
• Create Azure Data Factory Pipeline (last update: 2/22/2019)
  
• Create Event Based Trigger in Azure Data Factory (last update: 7/1/2019)
  
• Create Schedule Trigger in Azure Data Factory ADF (last update: 6/20/2019)
  
• Create Tumbling Window Trigger in Azure Data Factory ADF (last update: 6/11/2019)
  
• Run SSIS Packages with Azure Data Factory in a Cost Effective Way (last update: 12/6/2019)
  
• Transfer Data to the Cloud Using Azure Data Factory (last update: 3/8/2019)
  
• Transfer On-Premises Files to Azure Blob Storage (last update: 5/21/2019)
  
• Transfer On-Premises Files to Azure SQL Database (last update: 5/29/2019)
  

• Analyze data skew issues with Azure Synapse Analytics (last update: 2/17/2021)
  
• Analyze real-time data streams with Azure Synapse Analytics and Cosmos DB (last update: 4/8/2021)
  
• Azure Synapse Analytics Data Integration and Orchestration (last update: 12/18/2020)
  
• Azure Synapse Analytics Overview (last update: 9/8/2020)
  
• Azure Synapse Analytics vs Azure Data Factory for Building a Synapse Pipeline (last update: 1/27/2021)
  
• Build Appealing Dashboards using Azure Synapse Analytics (last update: 2/3/2021)
  
• Building Scalable Lakehouse Solutions using Azure Synapse Analytics (last update: 10/8/2021)
  
• Data Ingestion Into Landing Zone Using Azure Synapse Analytics (last update: 11/16/2021)
  
• Explore Spark databases with Azure Synapse Analytics (last update: 11/11/2020)
  
• Explore SQL databases with Azure Synapse Analytics (last update: 10/26/2020)
  
• Explore Your Data Lake Data Easily with Azure Synapse Analytics (last update: 9/18/2020)
  
• Handle Missing Values in Lakehouse using Azure Synapse Mapping Data Flow (last update: 1/6/2022)
  
• Implement Data Enrichment in Lakehouse using Synapse Analytics Mapping Data Flow (last update: 12/14/2021)
  
• Implement Dimension Denormalization Using Synapse Mapping Data Flow (last update: 1/19/2022)
  
• Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow (last update: 12/6/2021)
  
• Ingest and process real-time data streams with Azure Synapse Analytics (last update: 3/2/2021)
  
• Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow (last update: 11/26/2021)
  

• Common Data Warehouse Development Challenges (last update: 10/20/2021)
  

• How to find UDFs causing SQL Server performance issues (last update: 12/7/2015)
  

• SQL Server Columnstore, B-Tree and Hybrid Index Performance Comparison for Data Warehouses (last update: 2/8/2016)
  
• SQL Server Covering Index Performance (last update: 2/20/2015)
  

• Diagnose and Fix SSIS Performance Problems for ETL Loads (last update: 1/16/2019)
  

• How to Identify Useful SQL Server Table Statistics (last update: 5/18/2016)
  

• SQL Server Monitoring with PowerShell and the SQL Server Platform: Analysis and Reporting (Part 3 of 3) (last update: 6/3/2015)
  
• SQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3) (last update: 5/14/2015)
  
• SQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3) (last update: 5/21/2015)
  

• Creating a Centralized Performance Collection Solution for SQL Server (last update: 5/4/2016)
  
• Custom Solution to Measure SQL Server Query Performance Improvements (last update: 6/6/2016)
  

• Identify the best tables for SQL Server 2016 Columnstore Index Migration (last update: 8/5/2016)