Get Free Tips
MSSQLTips.com

Author: Fikrat Azizov

Home » Archives for 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.

  • MSSQLTips Awards: Author of the Year Contender - 2019-2022 | Rising Star (50+ tips ) - 2021

TitleCategoryDate
Enforce Data Integrity with Delta Lake Tables using Azure SynapseAzure Synapse Analytics2022-12-08
Reporting from Lakehouse data using Azure Synapse AnalyticsAzure Synapse Analytics2022-07-08
Delta Lakes Time Travel Functionality for ETL loggingAzure Synapse Analytics2022-06-10
Late Arriving Dimensions on Data Lakehouse using Azure SynapseAzure Synapse Analytics2022-05-31
Azure Synapse Analytics Fact to Dimension MappingAzure Synapse Analytics2022-05-19
Incremental Ingestion for Large Fact Tables on LakehouseAzure Synapse Analytics2022-04-21
Incremental Processing for Fact Tables with Azure Synapse AnalyticsAzure Synapse Analytics2022-04-15
Time Dimensions for Data Modeling in Azure Synapse AnalyticsAzure Synapse Analytics2022-03-08
Slowly Changing Dimensions on Lakehouse with Synapse Mapping Data FlowAzure Synapse Analytics2022-02-18
Create Surrogate Keys in Azure Synapse Analytics for Data WarehousingAzure Synapse Analytics2022-02-01
Dimension Denormalization with Synapse Mapping Data FlowAzure Synapse Analytics2022-01-19
Missing Values in Lakehouse using Azure Synapse Mapping Data FlowAzure Synapse Analytics2022-01-06
Data Enrichment in Lakehouse using Synapse Analytics Mapping Data FlowAzure Synapse Analytics2021-12-14
Data Deduplication for Azure Synapse Analytics with Mapping Data FlowsAzure Synapse Analytics2021-12-06
Data Ingestion into Delta Lake Bronze tables using Azure SynapseAzure Synapse Analytics2021-11-26
Copy Data Tool in Azure Synapse Analytics StudioAzure Synapse Analytics2021-11-16
Data Warehouse Development Challenges UncoveredData Warehousing2021-10-20
Scalable Lakehouse Solutions for Azure Synapse AnalyticsAzure Synapse Analytics2021-10-08
Analyze real-time data streams Azure Synapse Analytics and Cosmos DBAzure Synapse Analytics2021-04-08
Data pipelines with Azure Event Hub, Stream Analytics and Cosmos DBAzure Cosmos DB2021-03-23
Process Real Time Data Streams with Azure Synapse AnalyticsAzure Synapse Analytics2021-03-02
Analyze data skew issues with Azure Synapse AnalyticsAzure Synapse Analytics2021-02-17
Azure Synapse Analytics Dashboard ReportingAzure Synapse Analytics2021-02-03
Azure Synapse Analytics vs Azure Data Factory for Building a PipelineAzure Synapse Analytics2021-01-27
Azure Synapse Analytics Data Integration and OrchestrationAzure Synapse Analytics2020-12-18
Explore Azure Cosmos Databases with Azure Synapse AnalyticsAzure Cosmos DB2020-12-03
Spark Data Exploration with Azure SynapseAzure Synapse Analytics2020-11-11
Azure Synapse Analytics for SQL Server DataAzure Synapse Analytics2020-10-26
Pivot Transformations for Spark StreamingAzure2020-10-05
Explore Data Lake Data with Azure Synapse AnalyticsAzure Synapse Analytics2020-09-18
Azure Synapse Analytics OverviewAzure Synapse Analytics2020-09-08
Create Azure Data Factory inventory using DatabricksAzure Data Factory2020-07-31
Terminate Long Running Azure Analysis Services Refresh Using Logic App – Part 4Azure2020-07-02
Automate Azure Analysis Services Model Refreshes – Part 3Azure2020-06-12
Automate Azure Analysis Services Model Refresh with Logic App – Part 2Azure2020-06-02
Overview of Azure Analysis Services and Logic App Tasks – Part 1Azure2020-05-13
Run SSIS Packages with Azure Data Factory in a Cost Effective WayAzure Data Factory2019-12-06
Azure Data Factory Execute SSIS Package ActivityAzure Data Factory2019-11-29
Azure Data Factory Get Metadata ExampleAzure Data Factory2019-11-28
Azure Data Factory Until Activity ExampleAzure Data Factory2019-10-24
Azure Data Factory ForEach Activity ExampleAzure Data Factory2019-10-16
Azure Data Factory Filter Activity and Debugging CapabilitiesAzure Data Factory2019-09-27
Azure Data Factory Lookup Activity ExampleAzure Data Factory2019-09-25
Azure Data Factory If Condition ActivityAzure Data Factory2019-08-28
Azure Data Factory Control Flow Activities OverviewAzure Data Factory2019-08-20
Azure Data Factory Pipeline VariablesAzure Data Factory2019-08-14
Build Azure Data Factory Pipeline DependenciesAzure Data Factory2019-07-29
Azure Data Factory Stored Procedure Activity Transformation ActivitiesAzure Data Factory2019-07-12
Create Event Based Trigger in Azure Data FactoryAzure Data Factory2019-07-01
Create Schedule Trigger in Azure Data Factory ADFAzure Data Factory2019-06-20
Create Tumbling Window Trigger in Azure Data Factory ADFAzure Data Factory2019-06-11
Transfer On-Premises Files to Azure SQL DatabaseAzure Data Factory2019-05-29
Transfer On-Premises Files to Azure Blob StorageAzure Data Factory2019-05-21
Transfer Data to the Cloud Using Azure Data FactoryAzure Data Factory2019-03-08
Create Azure Data Factory PipelineAzure Data Factory2019-02-22
Azure Data Factory OverviewAzure Data Factory2019-02-05
Diagnose and Fix SSIS Performance Problems for ETL LoadsIntegration Services Data Flow Transformations2019-01-16
Cross-database query performance in Azure SQL DatabaseAzure SQL Database2018-04-25
Identify the best tables for SQL Server 2016 Columnstore Index MigrationSQL Server 20162016-08-05
Custom Solution to Measure SQL Server Query Performance ImprovementsPerformance Tuning2016-06-06
How to Identify Useful SQL Server Table StatisticsMaintenance2016-05-18
Creating a Centralized Performance Collection Solution for SQL ServerPerformance Tuning2016-05-04
SQL Server Columnstore, B-Tree and Hybrid Index Performance Comparison for Data WarehousesIndexing2016-02-08
How to find UDFs causing SQL Server performance issuesFunctions User Defined UDF2015-12-07
SQL Server Monitoring and Reporting with PowerShell – Part 3Monitoring2015-06-03
SQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3)Monitoring2015-05-21
SQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3)Monitoring2015-05-14
SQL Server Covering Index PerformanceIndexing2015-02-20

Categories

Recent Articles

  • SSMS Copilot to Boost Productivity and Efficiency

  • Challenges of Managing Hybrid SQL Server Environments

  • SQL Concat Operator and UNISTR Function in Azure

  • DBSCAN Algorithm in SQL Server

  • Unlock the Power of Clean Up-To-Date Data

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide