Fikrat Azizov

Fikrat Azizov has been working with SQL Server since 2002 and has earned two MCSE certifications. Hes currently working as a Solutions Architect at Slalom Canada.

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

CategoryTitle
AzureAutomate Azure Analysis Services Model Refresh using Logic App - Part 2
AzureAutomate Azure Analysis Services Model Refreshes with Small, Medium and Large Tables using Logic App - Part 3
AzureCross-database query performance in Azure SQL Database
AzureHow to Apply Pivot Transformations to Spark Streams
AzureOverview of Azure Analysis Services and Logic App Tasks - Part 1
AzureTerminate Long Running Azure Analysis Services Refresh Using Logic App - Part 4
Azure Cosmos DBBuild real-time data pipelines with Azure Event Hub, Stream Analytics and Cosmos DB
Azure Cosmos DBExplore Azure Cosmos Databases with Azure Synapse Analytics
Azure Data FactoryAzure Data Factory Control Flow Activities Overview
Azure Data FactoryAzure Data Factory Execute SSIS Package Activity
Azure Data FactoryAzure Data Factory Filter Activity and Debugging Capabilities
Azure Data FactoryAzure Data Factory ForEach Activity Example
Azure Data FactoryAzure Data Factory Get Metadata Example
Azure Data FactoryAzure Data Factory If Condition Activity
Azure Data FactoryAzure Data Factory Lookup Activity Example
Azure Data FactoryAzure Data Factory Overview
Azure Data FactoryAzure Data Factory Pipeline Variables
Azure Data FactoryAzure Data Factory Stored Procedure Activity Transformation Activities
Azure Data FactoryAzure Data Factory Until Activity Example
Azure Data FactoryBuild Azure Data Factory Pipeline Dependencies
Azure Data FactoryCreate Azure Data Factory inventory using Databricks
Azure Data FactoryCreate Azure Data Factory Pipeline
Azure Data FactoryCreate Event Based Trigger in Azure Data Factory
Azure Data FactoryCreate Schedule Trigger in Azure Data Factory ADF
Azure Data FactoryCreate Tumbling Window Trigger in Azure Data Factory ADF
Azure Data FactoryRun SSIS Packages with Azure Data Factory in a Cost Effective Way
Azure Data FactoryTransfer Data to the Cloud Using Azure Data Factory
Azure Data FactoryTransfer On-Premises Files to Azure Blob Storage
Azure Data FactoryTransfer On-Premises Files to Azure SQL Database
Azure Synapse AnalyticsAnalyze data skew issues with Azure Synapse Analytics
Azure Synapse AnalyticsAnalyze real-time data streams with Azure Synapse Analytics and Cosmos DB
Azure Synapse AnalyticsAzure Synapse Analytics Data Integration and Orchestration
Azure Synapse AnalyticsAzure Synapse Analytics Overview
Azure Synapse AnalyticsAzure Synapse Analytics vs Azure Data Factory for Building a Synapse Pipeline
Azure Synapse AnalyticsBuild Appealing Dashboards using Azure Synapse Analytics
Azure Synapse AnalyticsBuilding Scalable Lakehouse Solutions using Azure Synapse Analytics
Azure Synapse AnalyticsData Ingestion Into Landing Zone Using Azure Synapse Analytics
Azure Synapse AnalyticsExplore Spark databases with Azure Synapse Analytics
Azure Synapse AnalyticsExplore SQL databases with Azure Synapse Analytics
Azure Synapse AnalyticsExplore Your Data Lake Data Easily with Azure Synapse Analytics
Azure Synapse AnalyticsHandle Missing Values in Lakehouse using Azure Synapse Mapping Data Flow
Azure Synapse AnalyticsImplement Data Enrichment in Lakehouse using Synapse Analytics Mapping Data Flow
Azure Synapse AnalyticsImplement Dimension Denormalization Using Synapse Mapping Data Flow
Azure Synapse AnalyticsImplement Incremental Ingestion for Large Fact Tables on Lakehouse using Synapse Mapping Data Flow - Part 2
Azure Synapse AnalyticsImplement Late Arriving Dimensions on Data Lakehouse using Azure Synapse Mapping Data Flow
Azure Synapse AnalyticsImplement Surrogate Keys Using Lakehouse and Azure Synapse Analytics
Azure Synapse AnalyticsImplement Time Dimensions on Lakehouse using Azure Synapse Analytics Mapping Data Flow
Azure Synapse AnalyticsImplementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow
Azure Synapse AnalyticsImplementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability
Azure Synapse AnalyticsImplementing Fact-to-Dimension Mapping on Lakehouse using Synapse Mapping Data Flow
Azure Synapse AnalyticsImplementing Slowly Changing Dimensions on Lakehouse with Synapse Mapping Data Flow
Azure Synapse AnalyticsIncremental Ingestion of Fact Tables on Lakehouse using Azure Synapse Analytics Mapping Data Flow - Part 1
Azure Synapse AnalyticsIngest and process real-time data streams with Azure Synapse Analytics
Azure Synapse AnalyticsRaw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow
Data WarehousingCommon Data Warehouse Development Challenges
Functions User Defined UDFHow to find UDFs causing SQL Server performance issues
IndexingSQL Server Columnstore, B-Tree and Hybrid Index Performance Comparison for Data Warehouses
IndexingSQL Server Covering Index Performance
Integration Services Data Flow TransformationsDiagnose and Fix SSIS Performance Problems for ETL Loads
MaintenanceHow to Identify Useful SQL Server Table Statistics
MonitoringSQL Server Monitoring with PowerShell and the SQL Server Platform: Analysis and Reporting (Part 3 of 3)
MonitoringSQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3)
MonitoringSQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3)
Performance TuningCreating a Centralized Performance Collection Solution for SQL Server
Performance TuningCustom Solution to Measure SQL Server Query Performance Improvements
SQL Server 2016Identify the best tables for SQL Server 2016 Columnstore Index Migration
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (23)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (45)
CloudApache Spark (3)
CloudAzure (187)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (35)
CloudCloud Strategy (3)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (74)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (21)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (189)
Database AdministrationDatabase Configurations (17)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (10)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (69)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (128)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (3)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (12)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (68)
Database DevelopmentDates (47)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (65)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (76)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (39)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (38)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (27)
Database DevelopmentSynonyms (4)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (301)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (11)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (128)
Power PlatformPower BI Charts (44)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (22)
Professional DevelopmentProfessional Development Interview Questions Developer (6)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (31)
SecuritySecurity (194)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (11)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (76)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (32)