Fikrat Azizov

Fikrat Azizov

Fikrat Azizov (MCSE:Data Platform (SQL 2014),MCITP:SQL Server 2008,MCDBA SQL 2000) has been working with SQL Server since 2002.Fikrat's main passion is SQL Performance optimization, however he's also interested in Business Intelligence technologies on the base of SSIS/SSAS/SSRS, High Availability solutions for SQL Server and Big Data. Fikrat is currently working as Senior BI Consultant at BDO Canada.

2019 Awards
MSSQLTips award

MSSQLTips award

Azure

Azure Data Factory Control Flow Activities Overview (last update: 8/20/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 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 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)
Cross-database query performance in Azure SQL Database (last update: 4/25/2018)
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)

Functions - User Defined UDF

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

Indexing

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)

Integration Services Data Flow Transformations

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

Maintenance

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

Monitoring

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)

Performance Tuning

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)

SQL Server 2016

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

More SQL Server Solutions

download

get free sql tips