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.

Azure

Cross-database query performance in Azure SQL Database (last update: 4/25/2018)

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)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Fikrat Azizov

More SQL Server Solutions