The Curious Engineer

All blogs / Databases

Azure Database Support Blog

techcommunity.microsoft.com/category/azuredatabases/blog/azuredbsupport

DatabasesPerformance / optimizationSecurityMicrosoft blogsMicrosoft Tech Community

’19’20’21’22’23’24’25’26
Posts
1,017 from 14 Mar 2019 to 27 Oct 2026
Posting
weekly (132 in the last year)
Kind
company blog

2026 115

  1. Azure SQL Scaling Stuck? Investigating CDC and Transaction Log Pressure
  2. When Change Tracking Cleanup Falls Behind: A Safe Playbook for Azure SQL
  3. Seconds of Downtime, Hours of Confusion: Handling Transient Azure SQL Disconnects
  4. The Pipeline Is Slow, or Is SQL Waiting? Diagnosing Synapse-to-Azure SQL Regressions
  5. When More vCores Aren’t the Fix: Diagnosing Azure SQL CPU and Compilation Storms
  6. Lessons Learned #562: Measuring the Work Behind Statistics Updates in Azure SQL Database
  7. Lessons Learned #561: It is Fast on the Other Server —What Should We Compare First?
  8. What Really Happens When You Scale Azure SQL Database? How to Monitor Long-Running Scale Operations
  9. Lessons Learned #560: SQL Is Slow — What Can Query Store and SSMS Copilot Uncover?
  10. Azure SQL Performance Troubleshooting: When High Latency Is Not High CPU
  11. Lessons Learned #559: Understanding query timeouts in Azure SQL Database
  12. Lessons Learned #558: What an Execution Plan XML Can Tell Us in Azure SQL Database
  13. Lessons Learned #557: Investigating an unexpected query slowdown
  14. Azure SQL Data Sync After a Database Restore: Troubleshooting Leftover Sync Metadata
  15. Lessons Learned #556: Finding the SQL Statement Behind a Query Hash in Azure SQL Database
  16. Lessons Learned #555: The First 60 Seconds of a Production Incident: Stop, Scope, Correlate
  17. Automating Azure SQL DB index and statistics maintenance using Elastic Jobs.
  18. Lessons Learned #554: I Have Used BCP for Years — But How Does It Actually Work?
  19. Migrate a .bak to Azure SQL Database primary‑key violation (SQL Error 2627)
  20. Troubleshoot Azure SQL Error 18456 for Microsoft Entra Group Users
  21. Lessons Learned #553: Before Troubleshooting SQL Server, Find Out Who Generated the Error
  22. Lessons Learned #552:10 Lines in an SSMS MSAL Trace That Tell You Almost Everything You Need to Know
  23. Connectivity Errors caused by slow logins in a Microsoft Fabric SQL Database
  24. Getting Started with Azure SQL Data Sync Using User-Assigned Managed Identity (UAMI)
  25. Azure SQL Data Sync Fails with "Cannot Insert NULL": Understanding the Root Cause
  26. Closing the SQL Data Sync Monitoring Gap: Building Proactive Alerts with Azure Logic Apps
  27. Lessons Learned #551: Azure SQL Connection Timeouts: Three Things to Check
  28. Understanding Azure SQL Long-Term Retention Immutability Configuration with Terraform and AzAPI
  29. Troubleshooting SQL Authentication Failures on Azure SQL Database Geo-Secondary Replicas
  30. Lessons Learned #550: From a Support Case to Reusable Knowledge
  31. Lessons Learned #549: Reproduce, Challenge, and Validate – Testing Technical Assumptions
  32. Lesson Learned #548: From Symptoms to Evidence – How I Approach an Azure SQL Investigation
  33. Working Around the Lack of Partition Switching in Microsoft Fabric SQL Database
  34. Enabling DB Auditing in Azure SQL DB hangs for a long time
  35. Azure SQL Data Sync Retirement: Migration Insights and Modern Alternatives
  36. Lessons Learned #547:Some SQL DB Statistics Remain Outdated While Others Are Automatically Updated
  37. Lessons Learned #546: Maintaining a Local Azure Resource Inventory
  38. SQL Server 2016 Reaches End of Support: A Customer Engineer's Perspective on What's Next
  39. Understanding Microsoft Entra ID Group Membership Caching and Azure SQL Authentication Timing
  40. Lessons Learned #545:Understanding client_ip = 0.0.0.0 in Azure SQL Auditing
  41. Lessons Learned #544: How to Detect INT Identity Exhaustion Before Inserts Fail.
  42. Lessons Learned #543: Evaluating MultiSubnetFailover with Azure SQL Database
  43. Understanding % Characters in Azure Blob File Names Using SQL OPENROWSET (BULK)
  44. Lessons Learned #542: Reviewing Historical Azure SQL Database Storage Growth
  45. Generic Best Practices for HikariCP with Azure Database for PostgreSQL
  46. Lessons Learned #541:Automatic Plan Correction vs External Tables: A Practical Lesson from the Field
  47. Data sync fails with deadlock error
  48. Azure SQL DB Fabric Mirroring with Private Endpoint
  49. Troubleshooting Azure SQL Data Sync Failures Caused by Large Change Tracking Backlogs
  50. Lessons Learned #540:Bulk Insert Throughput in Azure SQL Hyperscale with Partitioned Heap Tables
  51. Why do I see many VDI_CLIENT_WORKER sessions in Azure SQL Database — and do they impact performance?
  52. Unexpected PITR Charges from restorableDroppedDatabases After BC → Hyperscale Migration
  53. Azure SQL BACPAC Export Failure with CDC & db_cdcreader (SQL71501)
  54. Azure SQL Database BACPAC Export Stuck with Private Link and Resource Locks
  55. How to recover Azure SQL Managed Instance access when the admin SQL login is disabled
  56. Azure SQL (LTR): You Don’t Need to Copy LTR Backups Across Regions to Restore Them
  57. Azure Data Sync: Fixing “Cannot find the user ‘DataSync_executor’” When Creating a New Sync Group
  58. Data Migration - From SQL MI to SQL DB migration
  59. Fix failover group creation errors with TDE CMK on Azure SQL Managed Instance
  60. How to take copy only backups with SQL Managed Instance.
  61. Understanding action_id discrepancies in Azure SQL Database Audit Logs (BCM vs AL / CR / DR)
  62. Monitoring Azure SQL Data Sync Errors Using PowerShell
  63. Fixing “There is not enough space on the disk” during Azure Data Sync initial sync (On‑prem ➜ Azure)
  64. Troubleshooting Azure SQL Data Sync Failure: SQL Error 8106 During Bulk Insert
  65. Azure SQL Audit Columns missing? Understanding AzureDiagnostics 500-Column Limit and Spill
  66. Connect to Azure SQL Database using a custom domain name with Microsoft Entra ID authentication
  67. Script to Export All Azure SQL Whitelisted Public IPs Within Your Subscription
  68. Understanding and Monitoring Class 2 Transactions in Azure SQL Database
  69. Understanding Azure SQL Data Sync Firewall Requirements
  70. Troubleshooting Azure SQL Data Sync Groups Stuck in Progressing State
  71. Why Long-Term Retention (LTR) Backups Don’t Attach After a PITR Restore in Azure SQL Database
  72. Azure SQL Hyperscale: Understanding PITR Retention vs Azure Portal Restore UI
  73. Hyperscale Azure SQL database shrink process- Tips & Tricks
  74. When Azure Portal/CLI Can’t Delete an Azure SQL DB: Check the Database Name (Unsupported Characters)
  75. How to Get Database‑Wise Session Details in an Azure SQL Elastic Pool Using T‑SQL
  76. CPU percentage vs SQL instance CPU percent: The Portal’s Favorite Misunderstanding
  77. Setup Alert for Azure SQL DB database status
  78. Lessons Learned #539: Azure SQL DB Scale-Down from S3 to S2 Can Fail When Change Feed Is Enabled
  79. Troubleshooting Azure SQL Managed Identity Authentication When SSMS Works but Applications Fail
  80. Recovering Missing Rows (“Gaps”) in Azure SQL Data Sync — Supported Approaches (and What to Avoid)
  81. Using Different Azure Key Vault Keys for Azure SQL Servers in a Failover Group
  82. Troubleshooting Intermittent Query Failures on Azure SQL DB Read Replicas (Error 3947)
  83. Part 2: Safely Cleaning Orphaned Records in Change Tracking Side Tables
  84. Troubleshooting Change Tracking cleanup growth and orphaned rows in Azure SQL Database
  85. Cannot enable Change Data Capture (CDC) on Azure SQL Database: Msg 22830 + Error 40529 (SUSER_SNAME)
  86. DORA exit planning for Azure SQL Database: a practical, “general guidance” blueprint
  87. Offline vs. Immutable Backups for Azure SQL Database (General Guidance)
  88. Renaming an Azure SQL DB encrypted with TDE using database level CMK can render it Inaccessible
  89. Identifying Orphaned Records in Change Tracking Side Tables (Read‑Only Health Check)
  90. SQL MI Private Endpoint in One Picture
  91. Azure PostgreSQL Lesson #15: Private DNS in Another Subscription Causing Server Deployment Failures
  92. SQLDBControlPlaneFirstPartyApp explained
  93. Mirrored Azure SQL Database Not Replicating: Running but No Data
  94. ImportExportJobError, SQL72012, SQL72014, SQL72045.
  95. Unable to configure Audit settings for Azure SQL.
  96. Multiple secondaries for Azure SQL Database failover groups (Public Preview)
  97. Export and import for Azure SQL database with a sequence
  98. Azure PostgreSQL Lesson Learned #14: Hitting the Max Storage Limits Blocking Further Scale‑Up
  99. Enable auditing to identify Change Tracking history table drops using Extended Events (Azure SQL Db)
  100. Wireshark walkthrough: observing an Azure SQL Database TDS connection on the wire
  101. Azure SQL Database and the TDS protocol: how it works (networking + protocol deep dive)
  102. Handling Duplicate Metadata Errors When Re‑Enabling Mirroring in Azure SQL Database
  103. Set up a linked server from SQL Managed Instance to Azure Synapse SQL
  104. "Invalid Managed Identity" error in vulnerability assessments for SQL Managed Instance
  105. Azure PostgreSQL Lesson Learned #13: Major Version Upgrade Failure Due to HypoPG Extension
  106. Using ClientConnectionId to Correlate .NET Connection Attempts in Azure SQL
  107. Understanding USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION') in Azure SQL DB
  108. Read-only queries are now captured in the Primary Query Store.
  109. Azure PostgreSQL Lesson Learned#12: Private Endpoint Approval Fails for Cross Subscription
  110. ‘TCP Provider: An Existing Connection Was Forcibly Closed by the Remote Host’ in MS Fabric SQL DB
  111. Why PITR Restore for Azure SQL Hyperscale Can Take Longer Than Expected
  112. When and How to Update Statistics in Azure SQL Database
  113. Kepner‑Tregoe: A Structured and Rational Approach to Problem Solving and Decision‑Making
  114. Real‑World Cloud & Azure SQL Database Examples Using Kepner‑Tregoe
  115. Geo‑Replication Redo Lag in Azure SQL Database

2025 56

  1. Azure SQL Database High Availability: Architecture, Design, and Built‑in Resilience
  2. Azure SQL Database Data Sync Retirement: Migration Scenarios and Recommended Alternatives
  3. Azure SQL Database Data Sync Retirement: Migration Scenarios and Recommended Alternatives
  4. Azure SQL Database Sharding: How It Works, Why It Matters, and How to Distribute Data Across Shards
  5. Missing MSchange_tracking_history Table in SQL Server: Causes, Cleanup Behavior
  6. Azure PostgreSQL Lesson Learned#11: Major Version Upgrade Failure Due to Unsupported Extensions
  7. SqlError Number: 3961 Message: Snapshot isolation transaction failed in database 'DatabaseName'
  8. Backup immutability for short-term retention backup
  9. Azure PostgreSQL Lesson Learned #10: Why PITR Networking Rules Matter
  10. Azure PostgreSQL Lesson Learned#9: How to Stay Informed About Planned Maintenance and Alerts
  11. Azure SQL: Optimizing BACPAC Imports - SqlPackage Done Right!
  12. Azure PostgreSQL Lesson Learned #8: Post-Upgrade Performance Surprises (The One-Step Fix)
  13. Azure PostgreSQL Lesson Learned#7: Database Missing After Planned Maintenance
  14. Azure PostgreSQL Lesson Learned #6: Major Upgrade Blocked by Password Auth (The One-Change Fix)
  15. Azure PostgreSQL Lesson Learned#5: Why SKU Changes from Non-Confidential to Confidential Fail
  16. Azure PostgreSQL Lesson Learned #4: Fix Connection Error: No pg_hba.conf Entry, SSL off
  17. Azure PostgreSQL Lesson Learned #3: Fix FATAL: sorry, too many clients already
  18. Lessons Learned #538: Printing One Line Per Field in T-SQL in Azure SQL Database.
  19. Azure PostgreSQL Lesson Learned #2: Fixing Read Only Mode Storage Threshold Explained
  20. Persistent Version Store (PVS) can cause fluctuations in size of an Azure SQL DB
  21. Azure PostgreSQL Lesson Learned#1:Fix Cannot Execute in a Read-Only Transaction After HA Failover
  22. Creating alerts for custom errors with auditing and Log Analytics
  23. Lessons Learned #537: Copilot Prompts for Troubleshooting on Azure SQL Database
  24. Data Migration - Azure SQL MI and Azure SQL DB
  25. Lessons Learned #536: Error the database type is not understood by the data reader.
  26. How to automate the deployment of an Elastic Job Agent with a Private Endpoint via Bicep
  27. Configure Auditing for Azure SQL Database on a Specific table
  28. Data Migration - Collation mismatch error during an offline migration
  29. Lessons Learned #535: BACPAC Import Failures in Azure SQL Database Due to Incompatible Users
  30. How to setup alerts for deadlocks using Log Analytics
  31. Disallowing changing Azure SQL database connection policy using Azure policy
  32. QTip: Maintenance plan for performance issues demo
  33. Lessons Learned #534: Azure SQL Database Connections with Managed Identity and Python ODBC
  34. Lesson Learned #533: Intermittent Azure SQL Database Connectivity and Authentication Issues
  35. Lesson Learned #532:Power BI Refresh Failure Due to Connection Pool Exhaustion in Azure SQL Database
  36. Lesson Learned #531: Scalar UDF vs Parallelism
  37. Lesson Learned #530: Comparing Execution Plans to Expose a Hidden Performance Anti-Pattern
  38. Lesson Learned #529: Troubleshooting Application Slowness Using SSMS Copilot
  39. Lesson Learned #528: Arithmetic overflow error converting IDENTITY to data type int
  40. Lesson Learned #527:Calling Azure OpenAI with Managed Identity via sp_invoke_external_rest_endpoint
  41. Lesson Learned #526: How to Identify the REST API Version Used by Your PowerShell Commands?
  42. Lesson Learned #525: Tracking Command Timeouts in Azure SQL: Beyond Query Store with Extended Events
  43. Lesson Learned #524: Optimizing Power BI with DirectQuery
  44. QTip: Getting timeouts and exceptions using Azure SQL DB Query Store
  45. Lesson Learned #523: Measuring Import Time -Parsing SqlPackage Logs with PowerShell
  46. Lesson Learned #522: Troubleshooting TLS and Cipher Suites with Python connecting to Azure SQL DB
  47. Lesson Learned #521: Query Performance Regression with Multiple Execution Plans in Azure SQL
  48. How to Monitor Automated Backups in Azure SQL Managed Instance Using T-SQL and SQL Agent
  49. Lesson Learned #520: Troubleshooting Azure SQL Database Redirect Connection over Private Endpoint
  50. Avoid Intermittent Errors After Adding/Dropping Always Encrypted Columns
  51. Connecting to the Fabric SQL Database using the on premise gateway (OPD)
  52. Lesson Learned #519: Reusing Connections in Azure SQL DB: How Connection Pooling Caches Your Session
  53. How to skip external data source references while doing export/Restore of an Azure SQL DB
  54. Lesson Learned #518:Configuring Database Watcher
  55. Lesson Learned #517:Connection Timeouts to Azure SQL Database Using Private Endpoint with HikariCP
  56. Setting up SQL Managed Instance Link to an Availability Group (Updated September 2025)

2024 83

  1. Understanding Optimized Locking in Azure SQL Database
  2. Lesson Learned #516:Measuring and Optimizing Application Performance
  3. Lesson Learned #515:Recommendations for Troubleshooting - Login failed for user 'XXX'. (18456)
  4. Lesson Learned #514: Optimizing Bulk Insert Performance in Parallel Data Ingestion - Part1
  5. Lesson Learned #513: Using SQL Copilot and Python Retry Logic to Resolve Deadlocks in Azure SQL DB
  6. Lesson Learned #512: Handling Connection Reuse in ODBC After a Critical Error
  7. Lesson Learned #511: Timeout Attempting to Open the Connection in High-Thread Applications
  8. Lesson Learned #510: Using CProfiler to Analyze Python Call Performance in Support Scenarios
  9. How to query .xel log files in Azure SQL DB using T-sql
  10. Error SQL71627 exporting BACPAC file in Azure SQL Database
  11. Serverless is not supported for Elastic Pool
  12. A few ways to monitor performance for the geo replica of an Azure SQL Database
  13. Demonstrating Scenarios Where Query Store Does Not Capture Runtime Statistics for Unfinished Queries
  14. Lesson Learned #509: KeepAliveTime parameter in HikariCP
  15. The Azure SQL database export/import process might sometimes take a lot of time
  16. Configuring TLS Updates on Server/Client to Implement TLS 1.2 - Azure SQL
  17. CurrentBackupStorageRedundancy of my master database on Azure SQL Server
  18. Lesson Learned #508: Monitoring Wait Stats and Handling Large Data Set
  19. Installation/Validation of extension-based hybrid worker
  20. Automate shrink database in Azure SQL
  21. General Purpose to Business Critical Azure SQL database upgrade
  22. How to check if Azure SQL Managed Instances are enrolled (or not) on November 2022 Feature Wave?
  23. Lesson Learned #507:Error 4429 - View or function 'XYZ' contains a self-reference.
  24. Lesson Learned #506:Why Custom DNS Returns Public IP Instead of Private IP Azure Private Endpoints
  25. Lesson Learned #505: Verifying IP Resolution in Azure SQL Database in Private Link
  26. How to remove the credential for legacy Threat Detection feature from Azure SQL Database
  27. Qtip: Connect Windows Azure VM to Azure SQL DB using Managed Identity
  28. Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB
  29. Connect from Azure SQL database to Storage account using Private Endpoint
  30. Lesson Learned #503: Lessons Learned Using JDBC Logging with Microsoft JDBC Driver for SQL Server
  31. Lesson Learned #502: Comparing and Transferring Azure SQL Databases Table Structures Using SMO
  32. Lesson Learned #501: Exporting Multiple Databases Simultaneously with SqlPackage
  33. TempDB space in Azure SQL DB appears much less than the published values
  34. Mitigate- Error 2767 "Could not locate statistics" when query against the secondary replica fails
  35. Lesson Learned #500: Connection Leaks and Query Execution using HikariCP
  36. Lesson Learned #499: HikariCP Retry Policy - The connection is closed
  37. Lesson Learned #498:Understanding the Role of STATMAN in SQL Server and Its Resource Consumption
  38. Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server
  39. Lesson Learned #496:Verifying Network Route to Azure SQL Database via VPN in Windows
  40. Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server
  41. Lesson Learned #494: High number of Executions Plans for a Single Query
  42. Lesson Learned #493: Monitoring Application Performance with Server Performance Counters
  43. Lesson Learned #492: Improving Extended Events in Azure SQL
  44. Lesson Learned #491: Monitoring Blocking Issues in Azure SQL Database
  45. Lesson Learned #490: Monitoring Access from Specific Applications to Azure SQL Database
  46. Lesson Learned #489:Investigating CPU Spikes with Query Store Overall Resource Consumption Report
  47. Lesson Learned #488: A severe error occurred on the current command. Operation cancelled by user.
  48. Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database
  49. Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement
  50. Lesson Learned #485: Index Recomendation or the Importance of Index Selection in SQL Server
  51. Lesson Learned #484: Database Performance Monitoring with PowerShell and ReadScale-Out Environments
  52. Lesson Learned #483: Optimizing Performance in Azure SQL Database ReadScale Out Databases
  53. SQL MI Restore with valid SAS key failing with Operating System Error 86
  54. Lesson Learned #482: Identifying Potential Duplicate Statistics
  55. Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access
  56. HelloRetryRequest of the TLS 1.3 handshake messages during a connection to Azure SQL Database
  57. RestorableDroppedDatabases in Azure SQL DB & their naming convention
  58. Lesson Learned #481: Query Performance Analysis Tips
  59. Lesson Learned #479:Loading Data from Parquet to Azure SQL Database using C# and SqlBulkCopy
  60. Restore LTR backup after database migrated to Hyperscale edition
  61. Decoding the TLS 1.3 protocol handshake during a connection to an Azure SQL DB with Wireshark
  62. Reading Azure SQL audit log from Azure Storage using sys.fn_get_audit_file returns empty result
  63. Azure SQL DB - Failed to add database to failover group - find out why
  64. Migrating an Azure SQL DB to a SQL MI by utilizing SqlPackage/ADF
  65. How to Change Collation of an Azure SQL Managed Instance When There Are Dependency Errors
  66. QTip: Connect to Azure SQL DB using Entra SPN (service principal)
  67. How to create linked servers from SQL managed instance using Entra Authentication (part 1)
  68. Lesson Learned #478: Identifying TLS Version Using Azure SQL Auditing
  69. Lesson Learned #477:NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set
  70. Lesson Learned #476:Identifying Sleeping Sessions with Open Transactions in Azure SQL Database
  71. QTip: Configure Azure SQL DB to receive alert when failover occurs in failover group or geo replica
  72. Lesson Learned #475:Cross-Database Queries Read and Write in Azure SQL Database.
  73. Lesson Learned #474:Identifying and Preventing Unauthorized Application Access to Azure SQL Database
  74. Lesson Learned #473:Harnessing the Synergy of Linked Server, Python, and sp_execute_external_script
  75. Lesson Learned #472:Why It's Important to Add the TCP Protocol When Connecting to Azure SQL Database
  76. Lesson Learned #471: Why Can't I Expand the Database Table List from my Application?
  77. Lesson Learned #470: Resolving 'EXECUTE Permission Denied' Error on sp_send_dbmail in Azure SQL MI
  78. Lesson Learned #469:Implementing a Linked Server Alternative with Azure SQL Database and C#
  79. Lesson Learned #468: Understanding and Resolving the "Could not find prepared statement with handle"
  80. Lesson Learned #467:Enhancing SQLCMD Script Reliability with C# and JSON
  81. Lesson Learned #466:Managing SQL Server Workloads:Resolving Error Msg 10928 with DAC and SQL Queries
  82. Lesson Learned #465:Unraveling DNS Errors in "myserver.database.windows.net": Nonauthoritative host
  83. Lesson Learned #464: Utilizing SMO's Scripting Option in Azure SQL Database.

2023 242

  1. Lesson Learned #463: Synchronizing Large Data Volumes Between SQL Databases: A Python Solution
  2. Lesson Learned #462: Understanding the Key Updates in SQL Server Management Studio (SSMS) 19.1
  3. Lesson Learned #461:Effective Load Balancing in Azure SQL Database: A Practical Approach
  4. Auto Scale - Azure SQL elastic pools
  5. Lesson Learned #460: DataIO vs Buffer Pool
  6. Lesson Learned #459:HikariCP - Unusual system clock change detected, soft-evicting connections pool
  7. Lesson Learned #458: High Login Impact on Azure SQL Database Worker Utilization: A Case Study.
  8. Lesson Learned #457:Optimizing SQL Connection Management with Single Token Authentication
  9. Lesson Learned #456: Invalid Key Column Type Error in Azure SQL Database DataSync
  10. Lesson Learned #455:Optimizing Connection Pooling for Application Workloads: Exploring Login Rates
  11. Lesson Learned #455:Optimizing Connection Pooling for Application Workloads: Thread Contention
  12. Lesson Learned #454:Optimizing Connection Pooling for Application Workloads: Active Connections
  13. Lesson Learned #453:Optimizing Connection Pooling for Application Workloads: A single journey
  14. Lesson Learned #452: Understanding CPU Time and Elapsed Time in SQL Query Execution
  15. Lesson Learned #451:Deep Dive into Physical and Logical Reads in Azure SQL Database: Hands-On-Lab
  16. Lesson Learned #450: Automating Alert Notifications for Query Data Store Usage in Azure SQL Database
  17. How to Avoid Transaction Isolation Level Issues on Azure SQL Managed Instance
  18. Azure custom policy to prevent backup retention period to be below X number - Azure SQL
  19. Lesson Learned #449: Unleashing Concurrent Threads for Robust Database Health Checks in C#
  20. How to copy Azure SQL database to a different subscription and different tenant
  21. Lesson Learned #448:Implementing Retry Logic for BCP Command in Linux
  22. Lesson Learned #447:Deep Dive into JDBC isClosed() vs isValid():Ensuring Resilient DB Connectivity
  23. Lesson Learned #446: Simplifying SQLPackage Log Debugging with PowerShell
  24. Lesson Learned #445:Unlocking the Mystery of Recompilations in SQL Server: A Practical Lab
  25. Troubleshooting High Log Utilization Due to ACTIVE_TRANSACTION
  26. Lesson Learned #444:Handling the "Row Value Expressions Exceeds Maximum Allowed" Error in SQL Server
  27. Lesson Learned #443:Improve Application Resilience:Connection,Execution,and ResultSet Retry Policies
  28. Lesson Learned #442: Determining CPU Usage in Azure SQL Database: One Query or Many?
  29. In-memory table in Azure SQL DB doesn’t release memory- Msg 41823, Level 16, State 109, Line 1
  30. Lesson Learned #441: Monitoring TempDB Transactions Space in Azure SQL Elastic Pools with PowerShell
  31. Lesson Learned #440: Introducing Our Connectivity Probe for Reliable Database Interaction in C#
  32. Lesson Learned #439: Solving Connectivity and Execution Issues in Java and JDBC for VLDB Databases
  33. Lesson Learned #438:Sync failed with state: SyncSucceededWithWarnings, Syncgroup: XXX
  34. Lesson Learned #437:Why Does Your SQL Query Run Faster Here Than There?
  35. Configuring backups retention for all Azure SLQ Managed instances under same subscription
  36. Lesson Learned #436: Implementing Retry Mechanism with sqlcmd in Bash (Linux)
  37. Lesson Learned #435:How to Know the Status of Your Azure SQL Database:Service Health-Resource Health
  38. Lesson Learned #434:Adjusting NSG Port Ranges:Azure SQL Manage Instance Tier Migration from GP to BC
  39. Lesson Learned #433:Azure SQL Pre-login Handshake Error 64:"The specified network name is no longer"
  40. Lesson Learned #432: Resolving DataSync Failures in Azure SQL Database Caused by Custom Triggers
  41. Lesson Learned #431: Determining Connection Type to Azure SQL Database: Proxy or Redirect
  42. Lesson Learned #430: Addressing Error 3201 with Azure Blob Storage: "Operating system error 86"
  43. Lesson Learned #429:Leveraging the Full Range SQL Server INT Data Type: Negative and Positive Values
  44. Lesson Learned #428: SqlError Number:229 provisioning DataSync in Azure SQL Database
  45. Lesson Learned #427:BUFFER IO in Azure SQL Database (Query Data Store): An Expert's Guide
  46. Lesson Learned #426:Identifying and Mitigating Query Regressions in Azure SQL using Query Data Store
  47. Lesson Learned #425:Azure SQL Database Failover Group Endpoint: A Deep Dive into DNS Resolution
  48. Lesson Learned #424:Detecting and Notifying Deadlocks in Azure SQL Managed Instance
  49. Lesson Learned #423:Distinguishing Between PING and TNC: The Advantage of Identifying Source IPs
  50. Lesson Learned #422: Retrieving Database Connection Strings with Azure Key Vault
  51. Lesson Learned #421:Understanding and Troubleshooting Transaction Log Truncation in Azure SQL DB
  52. Lesson Learned #420: Monitoring Azure SQL Transaction Log Usage with PowerShell
  53. Calculating CPU percentage for active queries
  54. Lesson Learned #419: System.Net.Sockets.SocketException (00000005, 0xFFFDFFFF) in Azure Data Studio
  55. Lesson Learned #418: Understanding SQL Events: Attention Signal and User Error Message
  56. Tips & Tricks #5: Unable to login to Azure SQL Managed Instance using AAD Integrated
  57. Lesson Learned #417: Resolving Synchronization Error in Azure SQL DataSync: Mismatched ColumnMapping
  58. Lesson Learned #416: Unveiling User Activity Insights in Azure SQL Databases
  59. Lesson Learned #415:PerfStat: Performance Stats Collection for Azure SQL Managed Instance
  60. Stop Azure SQL Database
  61. Lesson Learned #414: Demystifying Execution Plans and Query Optimization in Azure SQL Database
  62. Lesson Learned #413:PerfStat: Performance Stats Collection for Azure SQL Database
  63. Lesson Learned #412:PerfStat: Performance Stats Collection for SQL Server (OnPrem) Using DiagManager
  64. Investigating Issue "Security token could not be authenticated" After Upgrading to Latest Tedious.
  65. Lesson Learned #411:Troubleshooting "Statement(s) could not be prepared" Error ODBC API Connection
  66. Lesson Learned #410:Custom CPU Management in Azure SQL DB: Implementing a Pseudo-Resource Governor
  67. Lesson Learned #409:Resilient Azure SQL DB: Powering Performance with OpenAsync and ExecuteAsync
  68. Lesson Learned #408: The Strange Case of the Failover Conundrum
  69. Lesson Learned #407:Exploring Azure SQL Database Performance with sys.dm_os_performance_counters
  70. Lesson Learned #406:Monitoring Resource Usage and Open Ports with PowerShell & Bash Script
  71. Lesson Learned #405: How many TSQL operations you said?
  72. Connect from Azure VM (VNet) to an Azure SQL Database
  73. Lesson Learned #404: Understanding and Addressing 100% Worker Utilization
  74. Lesson Learned #403:Using Azure SQL Database Activity Monitor for Query Performance Insights
  75. Migrate Column Encrypted Database to Azure SQL Managed Instance
  76. Lesson Learned #402:Automated Monitoring of Table Growth in SQL Databases Using PowerShell
  77. Lesson Learned #401:Creating Dynamic Views from Multiple Tables using Stored Procedure
  78. Lesson Learned #400:Reigniting a Dormant Extended Event in Azure SQL Database with PowerShell
  79. Lesson Learned #399:Why is Private Link Still Resolving to Private IP Despite Its Removal in Azure?
  80. Lesson Learned #398: Recommended Automatic Indexes Are Excluded from BACPAC Data Export
  81. Lesson Learned #397: Azure SQL Database and Azure SQL Managed Instance vs Ole Automation Process
  82. Lesson Learned #396: Fixing 'Invalid value for key 'authentication' using System.Data.SqlClient
  83. Query performance impact due to a poorly managed mapping Index on an Azure SQL DB
  84. Lesson Learned #395:Token Management and Retry Strategy for Azure Active Directory Authentication
  85. Lesson Learned #394:Resolving Azure SQL DataSync Error: Login Failed During Database Reprovisioning
  86. Lesson Learned #393:Troubleshooting Azure SQL DataSync Error:Cannot Insert NULL Value into Column ID
  87. Lesson Learned #392:Querying Extended Events and Sending Results via Email using PowerShell
  88. Lesson Learned #391: Data Loading - Parallel BULK INSERTs with JDBC and Azure Blob Storage
  89. LicenseType parameter when you scale your Azure SQL Managed Instance
  90. Lesson Learne #390:The timeout period elapsed while attempting to consume the pre-login handshake
  91. Lesson Learned #389:SLO Update operation cannot succeed as the memory usage XYZ exceeds the quota
  92. Lesson Learned #388:Retrying Execution in case of Connection Drops/Command Timeouts using ODBC API
  93. Lesson Learned #387:Monitoring Query Data Store State Changes in Azure SQL Database using PowerShell
  94. Lesson Learned #386: Can I log when Query Data Store (QDS) fails to capture a query?
  95. Lesson Learned #385: Failed to validate the server name in a certificate during Secure Sockets Layer
  96. Lesson Learned #384: ODBC driver not supporting AKS workload identity
  97. Lesson Learned #383: Loading multiple extended file using sys.fn_xe_file_target_read_file
  98. Lesson Learned #382: Loading multiple Audit Log files using sys.fn_get_audit_file
  99. Error “TSQL CRUD has been disallowed via policy for this Azure subscription“
  100. Lesson Learned #381: The connection is broken and recovery is not possible message using API ODBC
  101. Lesson Learned #380:Unable to load adalsql.dll (Authentication=XYZ).Error code:0x2
  102. Lesson Learned #379: ADALNativeWrapper.ADALGetAccessToken error using AAD - Password Authentication
  103. Lesson Learned #378: What does mean Pool Blocking Period?
  104. Lesson Learned #377:Running Multiple Instances of SqlBulkCopy in Parallel from PowerShell
  105. Lesson Learned #376: Resolving 'Msg 15151' error when modifying SQL Login in Azure Active Directory
  106. Lesson Learned #375: Playing with Hikari Connection Pooling Logging
  107. Lesson Learned #374: Execution of class com.microsoft.aad.adal4j.AcquireTokenCallable failed.
  108. Lesson Learned #373: Improving download transfer rate for LOB columns in Azure SQL Database
  109. Lesson Learned #372:Combining retry policy capabilities for connection and execution in PowerShell
  110. Lesson Learned #371: Playing with the ODBC tracing file: connecting to the database
  111. Lesson Learned #370: SQL Server Error Code '0' and SQL state 'The connection is closed'
  112. Lesson Learned #369:Size NNN from table 'XYZ' cannot fit within the specified batch size of 24576KB
  113. Impact of Memory Grant Feedback on Azure SQL Managed Instance
  114. Lesson Learned #368: Connection Retry-Logic using ODBC API code
  115. Lesson Learned #367: Query Antipattern and Ring Buffer in Azure SQL Database
  116. Lesson Learned #366: Cannot open server microsoft.com using authentication = ActiveDirectoryPassword
  117. Lesson Learned #365: TSQL Execution Client Statistics using PowerShell
  118. Enabling TDE on Azure SQL DB Server using Python
  119. Lesson Learned #364: Getting all conversion implicit warnings using Query Data Store Repository
  120. Lesson Learned #363: Incorrect syntax near the keyword 'NOT' using DataSync
  121. Lesson Learned #362: Keyword or statement option 'default_language' is not supported in this version
  122. Lesson Learned #361: OS Error 53 connecting to Azure storage account using Transactional Replication
  123. Lesson Learned #360: Unsupported Key Size or Key Type. The supported RSA Key Size is 2048 or 3072.
  124. Lesson Learned #359: TCP Provider: Error code 0x68 (104) (SQLExecDirectW)
  125. Lesson Learned #358:Error SQL46010-contains a statement that is not supported on Azure SQL Database
  126. Lesson Learned #357:Login failed due to client TLS version being less than minimal TLS version allow
  127. Lesson Learned #356: Transaction log full in Azure SQL due to CDC job.
  128. Lesson Learned #355: Testing the connection latency from Python to Azure SQL Database
  129. Lesson Learned #354: Why is Python using a lot of CPU of Azure SQ Database?
  130. Lesson Learned #353: Sync failed with Inner exception: Exception of type System.OutOfMemoryException
  131. Lesson Learned #352: Could not update the metadata that indicates database enabling CDC.
  132. Lesson Learned #351: Troubleshooting FullText issues
  133. Lesson Learned #350: Improve bulk insert process in a ColumnStore Index Table
  134. Lesson Learned #349: ColumnStoreIndex in a Temporary Table
  135. Lesson Learned #348: Global Azure 2023 Sessions (Spanish sessions)
  136. Lesson Learned #347: String or binary data would be truncated applying batch file in DataSync.
  137. Lesson Learned #346: Monitoring a ReadScale Replica using a PowerShell script
  138. Lesson Learned #345: How to get the most from Azure SQL Database - Session Delivered
  139. Lesson Learned #344:Managed Instance needs permissions to access Azure Active Directory.
  140. Lesson Learned #343:DISABLE_VERSIONING wait type and ALLOW_SNAPSHOT_ISOLATION
  141. Custom solution to Omit Azure SQL Auditing Data
  142. Azure SQL Dbs are in an inaccessible state on the Azure Portal
  143. Large number of OR in predicate "IN Clause" SQL Server
  144. Use Azure SQL Audit policy to filter Audit data.
  145. Lesson Learned #342: Slow communication between our applications and Azure SQL
  146. Lesson Learned #341: Index Disabled vs Performance issues
  147. Lesson Learned #340: Storage and Memory allocated by Columnstore Indexes
  148. Lesson Learned #339: WAITFOR wait type delay
  149. Lesson Learned #338: A Hybrid SQL Journey: The daily routine of a Hybrid DBA - Session Delivered
  150. Lesson Learned #337: HADR_SYNC_COMMIT wait type delay in Azure SQL Database
  151. Connections rejected by DoSGuard (error 18456 state 113)
  152. Error 18452 connecting from Windows domain joined to Managed Instance with Windows Authentication
  153. Scale multiple Azure SQL databases on a logical server
  154. Msg 3930, Level 16, State 1, Line 13 The current transaction cannot be committed
  155. Lesson Learned #336: Using STARTUP_STATE option in an extended event in Azure SQL Database
  156. Handling Error 40619 while copying database using T-SQL
  157. Lesson Learned #335: BACKUP WITH COPY_ONLY cannot be performed until after the next automatic BACKUP
  158. Lesson Learned #334: The login already has an account under a different user name
  159. How to prevent Page corruption scenarios while restoring SQL DB backup from On-prem to Azure SQL MI
  160. Lesson Learned #333: RESOURCE_SEMAPHORE Wait Type
  161. Lesson Learned #332: High latency on simple query
  162. Lesson Learned #331: ALTER DATABASE XXX SET READ_ONLY WITH NO_WAIT
  163. Lesson Learned #330: Blocking issues Sch-M and Sch-S
  164. Lesson Learned #329: DATABASEPROPERTYEX( DB_NAME() , 'Updateability' ) and db_datareader role
  165. Lesson Learned #328: Login failed for user 'xyz'
  166. Common Data Sync Errors received in Azure SQL DB_DSS035_13535_Invalid Records
  167. Remarks on setting up Azure Data Factory SSIS IR using Express virtual network injection method
  168. How to connect Azure Data Factory to SQL Managed Instance over private network
  169. Lesson Learned #327: Why is important to use SQL Service Tag in your NSG?
  170. We couldn't find an account with that username. While sign into Azure SQL from SSMS.
  171. Lesson Learned #326:Target, 'XXX.package0.event_file', encountered a configuration error
  172. Lesson Learned #325: RESOURCE_SEMAPHORE_QUERY_COMPILE in Elastic Database Pool on Server 'XXX'
  173. Lesson Learned #324: Query Recompilation in Azure SQL
  174. Lesson Learned #323: Cannot perform creation/scaling of the managed instance due to not enough IPs
  175. Lesson Learned #322: Error: 40971- Cannot open Failover Group 'xyz.database.windows.net' requested.
  176. Azure Database creation using T-SQL or SSMS currently allows Unsupported characters in it's name.
  177. Lesson Learned #321:Useful Kusto Monitoring Queries for Azure SQL Database and Elastic Database Pool
  178. Lesson Learned #320:Database 'XXX' on server 'xyz' is not currently available using ServerLess tier.
  179. Error 25740: Unable to start event session ‘EventSession’ because system is busy
  180. Lesson Learned #319: Lock request time out period exceeded using SSMS
  181. Lesson Learned #318: Using Archive Access Tier in a blob storage
  182. Lesson Learned #317: Update to service objective for Hub DBs
  183. Lesson Learned #316: Connecting to Private Endpoint of Azure SQL from OnPremise using NGINX
  184. Lesson Learned #315: 'XTP' name is reserved for the files containing In-Memory OLTP data.
  185. Lesson Learned #314: Cannot start the job 'XXX' because it does not have any job server
  186. Lesson Learned #313: how to configure Azure SQL Managed Instance Link
  187. Lesson Learned #312: Cannot drop the login 'xyz', because it does not exist or you do not have
  188. Lesson Learned #311:Error-1117 the request could not be performed because of an I/O device error
  189. Lesson Learned #310: Parameter Sniffing
  190. Lesson Learned #309: Create a DDL Trigger on Database in Azure SQL
  191. Lesson Learned #308:Extended properties are not permitted on 'dbo.xyz', or the object does not exist
  192. Lesson Learned #307:Reference to database and/or server name is not supported in this version
  193. Lesson Learned #306: TCP Provider, error: 2 - Connection was terminated
  194. Lesson Learned #305: Client Connection marked as broken because of SQLSTATE(08S01)
  195. Lesson Learned #304: TCP Provider, error: 35 - An internal exception was caught
  196. Lesson Learned #303: Can not connect to the database in its current state.
  197. Lesson Learned #302: System.InvalidCastException: Specified cast is not valid
  198. Lesson Learned #301:How to check the performance of my database? Resource Consumption and Wait Stats
  199. Lesson Learned #300: Exporting a database to storage account that is behind a firewall
  200. Lesson Learned #299: Blocking user connections in Azure SQL Managed Instance
  201. Lesson Learned #298: Huge duration of database export using sqlpackage
  202. Lesson Learned #297: High SATELLITE_SERVICE_SETUP waits stats in Azure SQL Managed Instance
  203. Lesson Learned #296:The value of the property '' is invalid: Value does not fall within the expected
  204. Lesson Learned #295:The specified buffer size is less than the minimum size.
  205. Lesson Learned #294: Logins are not syncing in failover group
  206. Lesson Learned #293: Common errors connecting to Azure SQL DB using Azure Active Directory
  207. Lesson Learned #292: The database 'UserDB' has reached its size quota. Partition or delete data
  208. Lesson Learned #291: Cannot find SSL Trust Store File connecting to Azure SQL Database
  209. Lesson Learned #290: Elastic pool SQL server extended not able to start
  210. Lesson Learned #289: Hands-On-Labs: Understand and reading an execution plan
  211. Read only replica corrupted statistics
  212. Lesson Learned #288:Server principal 'XXX' is not able to access the database under current security
  213. Lesson Learned #287: Contains an unresolved reference to an object due to database collation
  214. Windows Authentication for SQL Managed Instance - LsaCreateTrustedDomainEx 0x549
  215. Subquery returned more than 1 value when open Azure Managed Instance Database properties
  216. Lesson Learned #286: Compilation vs Execution time running a TSQL query
  217. Lesson Learned #285: Why can I still telnet to port 1433?
  218. Lesson Learned #284:Error requesting access token,HTTP status 400,expected 200.SQL State was: CE275
  219. Lesson Learned #283: Import operation interrupted because insufficient local disk
  220. Lesson Learned #282: Troubleshooting the element cannot be deployed as the script body is encrypted
  221. Lesson Learned #281: Troubleshooting CHECK constraint issue importing a bacpac due to business logic
  222. Lesson Learned #281: Export fails due to system out of memory exception
  223. Lesson Learned #280: Cannot bulk load. The file "xyz" does not exist or you don't have file access
  224. Lesson Learned #279: Slow between calls to Azure SQL Elastic Database Pool
  225. Lesson Learned #278: TCP Provider, error: 0 - The specified network name is no longer available
  226. Troubleshooting SQL Insights
  227. Lesson Learned #277: Failed to connect to xyz.database.windows.net:1433-Could not connect (sequence)
  228. Lesson Learned #276: ALTER TABLE statement conflicted with the CHECK constraint importing a bacpac
  229. Lesson Learned #275: Timeout: Request failed to complete in Node.Js
  230. Lesson Learned #274: Security token could not be authenticated or authorized in Node.js
  231. Lesson Learned #273:UsernamePasswordCredential: tenantId,clientId,username and password are required
  232. Lesson Learned #272: Execution Timeout Expired error message importing a Bacpac file
  233. Lesson Learned #271: ApplicationIntent parameter when is not available option in connection string
  234. Lesson Learned #270:DBCC FLUSHAUTHCACHE vs Client with IP address is not allowed to access server
  235. Lesson Learned #269: Unable to connect - Is unavailable or does not exist - Connection Time out
  236. How to move Azure SQL managed instance cross subscriptions
  237. Setting up Row Level Security (RLS) on an Azure SQL DB/SQL MI by utilizing Azure AD groups
  238. Lesson Learned #268:Error occurred during the pre-login handshake-The semaphore timeout period
  239. Lesson Learned #267: Rename failed for Database 'XXX' in Azure SQL Database
  240. Lesson Learned #266: Avoiding duplicate statistics
  241. I can't access my database! I deleted my "Azure Key Vault" / "key" and the TDE doesn't work.
  242. Lesson Learned #265: Deadlock due to Non-Optimized Queries

2022 157

  1. Lesson Learned #264: Python and PyODBC error messages.
  2. The session limit for the elastic pool is 30000 and has been reached.
  3. Lesson Learned #263:Mail could not be sent to the recipients because of the mail server in DBMail
  4. Lesson Learned #262: Database Wait Stats and Log Analytics.
  5. Lesson Learned #261: Java vs Permission denied: connect
  6. Lesson Learned #260: Java vs Connection is closed error message.
  7. Lesson Learned #259: Capturing all blocking TSQL in Azure SQL DB and Managed Instance
  8. Lesson Learned #258: Python vs Connection Refused with Login timeout expired
  9. Lesson Learned #257: Encryption scheme mismatch for columns/variables
  10. Lesson Learned #256: Connection was denied since Deny Public Network Access and DNS resolution.
  11. Lesson Learned #255: SSL is required but not requested using JDBC.
  12. Lesson Learned #254: Checking Execution Timeouts in Azure Log Analytics
  13. Lesson Learned #253: Retry Logic for Execution Timeout Expired
  14. Lesson Learned #252: SELECT TOP 100 FROM HeapTable is taking too much time
  15. Lesson Learned #251: Error 40532 using Private Endpoint IP in the server name
  16. Initialize a Managed Instance replication Subscriber with a PITR backup
  17. Initialize a Managed Instance replication Subscriber with a backup
  18. Lesson Learned #250: All started with the phrase: In PowerBI Direct Query is slow-ColumnStore Index
  19. Lesson Learned #249: All started with the phrase: In PowerBI Direct Query is slow-Partitioned table
  20. Lesson Learned #248: Working with sp_wait_for_database_copy_sync and SQL Auditing.
  21. Lesson Learned #247: All started with the phrase: In PowerBI Direct Query is slow - Indexed views
  22. [Azure SQL DB] - How to create and manage your cross subscription Auto-Failover groups (FoG)
  23. Error during enabling CDC on an Azure SQL DB- 'Msg 22830, Level 16, State 1, Line 274'
  24. [Replication consistency] Compare all tables between two databases at once with Table Diff
  25. Can Certain SQL User Roles Avoid Blocking?
  26. Lesson Learned #246: Performance Series-Detectando un problema de rendimiento en Azure SQL (Spanish)
  27. Getting Error 666 when creating non-clustered index- Msg 666, Level 16, State 2, Line 25
  28. Azure SQL Hyperscale Named replica audit files "There are no audit files for the selected criteria"
  29. Root certificates of Azure SQL DB and SQL Managed Instance
  30. Lesson Learned #245: Azure SQL Database - Lessons Learned from the Trenches in PASS Summit 2019
  31. How monitor PITR restore in Managed Instance
  32. The-connection-is-broken-and-recovery-is-not-possible-()-and-other-errors-4891-1326-2250-13800-21036
  33. Lesson Learned #244: No such host is known connecting to Azure SQL Managed Instance Private Endpoint
  34. Lesson Learned #243: Enabling ODBC connection pooling in PHP
  35. SSMS Performance Dashboard for Managed Instance shows different percent of CPU usage
  36. Restore or copy an Azure SQL Database with resource tags
  37. Lesson Learned #242: The server principal "xyz" is not able to access the database "Yzxxx"
  38. Can we access Change Data Capture and Change Tracking on readable replica?
  39. Lesson Learned #241: Lessons Learned from the Azure Database Support Blog Series with Anna Hoffman
  40. TDE High availability with customer-managed key for Azure SQL Databases
  41. Lesson Learned #240: Checking connection and execution latency in Azure SQL DB and Managed Instance
  42. Tales From the Field channel
  43. Tips & Tricks #4: Monitoring Backup History for Azure SQL Database & Azure SQL Managed Instance
  44. Lesson Learned #239: Attempt was made to access a socket in a way forbidden by its access permission
  45. How to use Sqlpackage with Managed Identity
  46. Azure SQL Database idle sessions are killed after about 30 minutes when "Proxy" connection policy
  47. Deleted Azure SQL Database with existing diagnostic settings
  48. Could not connect to mail server. (No such host is known)
  49. Azure SQL and Azure SQL Managed Instance - Backup retention polices Loading ...
  50. Lesson Learned #238: Configuring Private Endpoint Connections in Azure SQL Managed Instance
  51. Tips & Tricks #3: Unable to set AAD Admin for Azure SQL Managed Instance
  52. Invoke-Sqlcmd with Azure Automation for Azure SQL database
  53. Auto scale up/down the Managed instance
  54. Error “SameKeyMaterialNotFoundOnRemoteServer” while coping Azure SQL DB to a different server
  55. Principle 'XYZ' could not be found or this principal type is not supported - Azure SQL DB and MI
  56. Lesson Learned #237: Long running operation failed with status 'NotFound' managing databases
  57. Lesson Learned #236: What? .... How much time you said? (CloudShell version)
  58. Lesson Learned #235: Finding how Indexed Views impact in my database update performance?
  59. Lesson Learned #234: Parallel vs Single Running a Bulk Insert with Python
  60. Considerations on Bidirectional Transactional Replication
  61. How to Capture the Actual Execution Plan in Azure SQL Database
  62. Resolve tempdb-related errors in Azure SQL Database
  63. Lesson Learned #233: What? .... How much time you said?
  64. Bidirectional Transactional Replication in SQL Managed Instance
  65. Testing connectivity against a Managed Instance using a CNAME
  66. Lesson Learned #232: Microsoft Reactor- Identify an Azure SQL Performance Issue (Spanish Version)
  67. Resolve Elastic Query issues in Azure SQL Database
  68. Lesson Learned #231: Hands-On-Labs: What is Azure SQL working on
  69. Improving Performance with AUTO_UPDATE_STATISTICS_ASYNC
  70. Lesson Learned #230: Microsoft Reactor -Azure SQL Developer and DBA Best Practices (Spanish Version)
  71. Lesson Learned #229: Hands-On-Labs - Connection is busy with results for another command
  72. Lesson Learned #228: Using sp_validatelogins in Azure SQL Database
  73. SQL Error Code 40532 Cannot open server 'azuresqlserver1' requested by the login.
  74. Lesson Learned #227: How much data is using my database per table
  75. Lesson Learned #226: Using a connectivity Retry-Logic with SQLCMD command line
  76. Lesson Learned #225: Has an unresolved reference to object using Linked Server or External Table
  77. Lesson Learned #224:Hands-On-Labs: Checking the performance with Perf Collector Analyzer
  78. Lesson Learned #223:Hands-On-Labs: How to improve a bulk insert process
  79. Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance
  80. Lesson Learned #221:Hands-On-Labs: Activity Monitor in my Azure SQL Managed Instance
  81. Lesson Learned #220:Hands-On-Labs: Activity Monitor in my Elastic Database Pool
  82. Lesson Learned #219:Hands-On-Labs: What do I need to do in case of high CPU wait time
  83. Lesson Learned #218:Hands-On-Labs: What do I need to do in case of high LOG_RATE_GOVERNOR wait time
  84. Lesson Learned #217:Hands-On-Labs:40197-The service has encountered an error processing your request
  85. Lesson Learned #216: Hands-On-Labs: How redirect connection policy type works
  86. Lesson Learned #215: Hands-On-Labs: Communication link failed error message using ODBC.
  87. Lesson Learned #214: Hands-On-Labs: How to manage an idle connection state issue
  88. Lesson Learned #213: Cannot set the AccessToken property if the Integrated Security has been set
  89. Lesson Learned #212: Hands-On-Labs:TCP Provider: The semaphore timeout period has expired
  90. Lesson Learned #211: Monitoring SQLPackage Import Process
  91. SQL Server Performance: Upper and Lower functions and Database collation.
  92. Azure SQL connectivity error 10060 example : a DNS resolution issue.
  93. Lesson Learned #210: Hands-On-Labs:A transport-level error has occurred when receiving results.
  94. Lesson Learned #209: Hands-On-Labs:10928-Resource ID:1.The request limit for the database is reached
  95. Lesson Learned #208: Hands-On-Labs:10928-Resource ID:2.The session limit for the database is reached
  96. Lesson Learned #207: Hands-On-Labs: 40613-Database ‘xyz' on server ‘xyz2' is not currently available
  97. Lesson Learned #206: Hands-On-Labs: The timeout period elapsed prior to obtaining a connection
  98. Lesson Learned #205: Best Practices connecting to Azure SQL Database and Managed Instance
  99. How to restore database using LTR backups with PowerShell
  100. Learning from Expertise#10: Why no restore point available?!
  101. Azure SQL Data Exfiltration Controls: Outbound Firewall Rules aka OFRs
  102. Control Data Exfiltration using Outbound Firewall Rules
  103. Azure SQL Database to ADF connectivity using Azure Private Endpoint
  104. Cross-Subscription Failover Group - Azure SQL Managed Instance
  105. How to setup email alerts to monitor automation jobs for Azure SQL DB maintenance
  106. Lesson Learned #204: Elastic Query and firewall issues
  107. Lesson Learned #203: How can I know that my connection is using Redirect connectivity policy?
  108. Global Azure 2022 - No encuentro donde esta el problema de la query (Spanish Version Delivered)
  109. Global Azure 2022 - Azure SQL Journey: The daily routine of a Cloud DBA (Session Delivered)
  110. Global Azure 2022 - How to get the most from Azure SQL Database (Session Delivered)
  111. [ARM template conflict]: Azure SQL Database Deployment Fails with ARM template setting AAD admin
  112. Lesson Learned #202: How to reproduce and find a SQL command timeout
  113. Lesson Learned #201: Performance comparison using INSERT with and without Begin Transaction
  114. Lesson Learned #200: Slow when fetching large volume of data compared with PYODBC.
  115. Additional Endpoints Required for AAD Authentication and CRL Checks for Azure SQL DB
  116. Fixing Problematic Index Spools
  117. VA Failed message: Could not authenticate to storage account 'storageaccount.blob.core.windows.net'
  118. Lesson Learned #199:Collect data for performance comparison Azure SQL Managed Instance vs SQL Server
  119. Lesson Learned #198: Getting the error "has an unresolved reference to object " exporting to bacpac
  120. Lesson Learned #197: Getting the error "Could not discover a user realm" using AAD
  121. Learning from Expertise#9: How to restrict users from enabling Azure defender on resource level?
  122. Lesson Learned #196: Latency and execution time in Azure SQL Database and Azure SQL Managed Instance
  123. Tips & Tricks #2: SQL Server Profiler (xEvents) for Azure SQL DB
  124. Lesson Learned #195: Performance Best Practices for Azure SQL Database and Managed Instance.
  125. How to mitigate VA alert "VA1219: Transparent data encryption should be enabled"
  126. Lesson Learned #194: Remote Query Timeout vs Application Command Timeout
  127. Lesson Learned #193: MARS vs Connection Retry-Logic
  128. Azure SQL Troubleshooting Power BI dataset refresh failures
  129. Selective Auditing for Azure SQL Database
  130. AAD auth failure caused by TLS 1.0,1.1 + PKCS disable
  131. Connect to Azure SQL DB & Managed Instance with AAD managed identity from ADO.NET app
  132. Lesson Learned #192: MSIS7068-Access denied error message connecting to Azure SQL Database using AAD
  133. Lesson Learned #191: Performance comparison using Inner vs Left Join in Linked Server/Elastic Query
  134. Lesson Learned #190: SQL function will not be executed remotely
  135. How to connect ADF to SQL Server on Azure VM using Private Endpoint across different VNETs
  136. How to get the Query Text of Azure database for PostgreSQL
  137. Lesson Learned #189: Connection and Execution Tests running in Parallel
  138. Lesson Learned #188: Tracing/logging the JDBC and ODBC driver operation
  139. Lesson Learned #187: How to measure the connection latency in Azure SQL DB/Managed Instance
  140. Lesson Learned #186: Firewall protection using Private Endpoint
  141. Export Azure SQL Database | Advanced Scenarios
  142. Lesson Learned #185: Could not find any endpoints error message using PingFederated
  143. Configure extended events in SQL Azure to the blob storage with Private Endpoint
  144. Certificate Based Authentication for Azure SQL Database
  145. Create and Assign Managed Identity using Powershell to SQL MI
  146. How to enable Outbound firewall rules for Azure SQL Databases
  147. Lesson Learned #184: Row Level Security and Parallelism
  148. Automating DB maintenance for all SQL Databases in a single server using Azure Data Factory pipeline
  149. Automate native database backup of Azure SQL Managed instance to Azure blob storage
  150. Primary Key Violation in Bidirectional Replication between SQL Managed Instance and SQL server on VM
  151. Lesson Learned #183: TDSDump in Python connecting to Azure SQL Managed Instance
  152. Automating Azure SQL DB index and statistics maintenance using Azure Data Factory - Single Database
  153. How to create a Network trace from Azure WebApp PaaS
  154. SQl Injection: example of SQL Injections and Recommendations to avoid it.
  155. Learning from Expertise #8: Why cannot move SQL database from provisioned to serverless?!
  156. Cannot enable Advanced Threat Protection on Managed Instance server
  157. Lesson Learned #182: The server name provided doesn't match the server name on the SQL Server SSL

2021 66

  1. Learning from Expertise #7: Where is my server storage taken - Azure PostgreSQL?
  2. Learnings from the Trenches - Unable to query sys table via Linked Server
  3. Lesson Learned #181: Reading a JSON compressed file from OPENROWSET function from Azure SQL Database
  4. Lesson Learned #180: Creating a retry-logic for TSQL command execution.
  5. Lesson Learned #179: Why is important to have a correct command execution error handling?
  6. Learning from Expertise #6: Where is my server storage taken - Azure MySQL?
  7. Get creation dates of all Azure resources under an Azure subscription
  8. Imported database is smaller than original database
  9. InvalidMaxSizeTierCombination error while performing scaling up operation
  10. Create table and and insert into within same transaction blocks sys.tables catalog view
  11. Learning from Expertise #5: Ops! What should I do after accidentally deleted SQL DB Server?
  12. set-AzSqlInstance : Cannot find the Azure Active Directory object in Azure automation for SQLMI
  13. Audit Specific Actions and Users in Azure SQL DB
  14. Add wait operation to ARM template deployment
  15. How to copy an Azure SQL Database to a different server or subscription using Azure Automation
  16. Learning from Expertise #4: Why cannot add instance Failover Group to Azure SQL Managed Instance?!
  17. Azure SQL Database - GEO Replication across subscription with private endpoints
  18. Azure SQL Database unavailable after switching from BYOK CMK to service-managed TDE key
  19. Performance degradation due to implicit conversion
  20. Tagging all the Columns to Data classification in the Azure SQL DB
  21. Cross database queries between Azure SQL database and Managed instance using external table
  22. Restore database across servers(Azure SQL Database and Azure SQL managed instance)- Azure Automation
  23. Troubleshooting Azure Active Directory Integrated Authentication in Azure SQL
  24. Database Parameterization
  25. PKIX path building failed - unable to find valid certification path to requested target
  26. Using extended events to capture deletion operations
  27. Learning from Expertise #3: Why cannot remove AD Admin or set a new one on Azure PostgreSQL Server?!
  28. Lesson Learned #178: What is the command timeout when we are querying an External Table?
  29. Automate exporting of azure sql database as .bacpac to blog storage.
  30. Lesson Learned #177: Is possible to use Private Endpoint with Azure SQL External Tables?
  31. Import BACPAC fails if schema has a large number of tables, indexes and/or views
  32. Lesson Learned #176: Using Polybase to connect from SQL OnPremises to Azure Managed Instance/SQLDB
  33. Lesson Learned #175: Connecting to Private EndPoint of Azure SQL Database from Managed Instance
  34. Lesson Learned #174: Using Synonyms in Azure SQL Managed Instance for Linked Server tables
  35. Managed Instance - WASDRGTenantMonitoringRO and xtsuser logins
  36. Tips & Tricks #1: Creating alerts for Azure SQL Managed Instance
  37. Lesson Learned #173: MSDTC on server 'xxxxx' is unavailable
  38. Lesson Learned #172: ApplicationIntent=Readonly in General Purpose database tier?
  39. 'Lock request time out period exceeded' when connecting to the database from SSMS
  40. Troubleshooting high lock wait time and lock time-out
  41. Lesson Learned #171: Testing a connection from multiple PowerShell script instances
  42. Lesson Learned #170: Connection Pooling caches IP address
  43. Azure SQL DB and Managed Instance tempdb
  44. Revocation of the SSL certificate failed for AAD authentication
  45. How-to auto-scale Azure SQL Databases
  46. Lesson Learned #169: Bulk Insert using Python in Azure SQL
  47. Custom RBAC to access QPI's query text with minimal permissions
  48. Lesson Learned #168: Connection is not available error message using Hikari connection pooling
  49. Lesson Learned #167: Working with Get-AzSqlDatabaseSecureConnectionPolicy
  50. Lesson Learned #166: How to reduce the time inserting 10 millions of rows
  51. Monitor replication lag for Auto-Failover Groups in SQL Managed Instance
  52. Why my tables are empty after importing the BACPAC file ????
  53. Lesson Learned #165: How to reduce the time spent of downloading a large resultset
  54. Azure SQL Database or SQL Managed Instance Database used data space is much larger than expected
  55. Learning from Expertise #2: Who Dropped my Azure SQL DB?
  56. Lesson Learned #164: Why SQL Server Management Studio runs the query faster than my application
  57. Lesson Learned #163: Failed to save Auditing settings for server: xxx .Principal xxx does not exist
  58. Lesson Learned #162: Cannot show requested dialog obtaining properties database in Managed Instance
  59. Lesson Learned #161: Error 0 - No such host is known in Azure SQL Managed Instance
  60. Script to restore all the deleted databases from an Azure SQL Server
  61. Lesson Learned #160: DDL Trigger FOR ALL SERVERS in Azure SQL Managed Instance
  62. Lesson Learned #159: Compressing data and LOB data type in Azure SQL Managed Instance
  63. Lesson Learned #158: Running a Insert Into .... Select when the source table is a Heap Table
  64. Lesson Learned #157: Connecting to Azure Managed Instance Using Oracle Database Gateway for ODBC
  65. Lesson Learned #156: Creating a Linked Server connecting to Read-Scale Managed Instance Replica
  66. Importing bacpac failed to Azure SQL with User, group, or role ‘XXX’ already exists

2020 74

  1. Replication configuration between Managed Instance and On-premises common issues
  2. Automate and Send Alerts for Elastic Jobs Failures
  3. Lesson Learned #155: Timeout period elapsed prior to obtaining a connection from the pool.
  4. Lesson Learned #154: JAVA Console Script for Testing connection in Azure SQL
  5. Lesson Learned #153: PHP Console Script for Testing connection in Azure SQL
  6. Import database when policy "Azure SQL DB should avoid using GRS backup" is enforced
  7. Enhance performance techniques:use index on computed column
  8. Lesson Learned #152: When the transaction context matters in a blocking issue!
  9. Principal ***** does not exist in the directory ****
  10. Lesson Learned #151: External Tables and Private Link connectivity
  11. Lesson Learned #150: Calculating the space used by table and per column
  12. Lesson Learned #149: Extracting data from Azure SQL DB using different drivers
  13. Learning from Expertise #1: How to audit SQL DB with PITR retention period < 35
  14. Using partitioned tables or multiple tables to improve big deletes performance
  15. Lesson Learned #148: High wait time due to Parameter Sniffing
  16. How to cancel Azure SQL Database Import or Export operation
  17. Lesson Learned #147: Checking the connectivity to Azure SQL DB and MI
  18. Lesson Learned #146: Restoring a backup from Azure SQL Managed Instance to OnPremises
  19. Lesson Learned #145: Cannot communicate, because they do not possess a common algorithm
  20. Lesson Learned #144: Identifying the query that is taking too much time/resources
  21. Lesson Learned #143: (Spanish) - I'm not able to find where is the problem in my query
  22. Lesson Learned #142: Login Timeout Expired connecting to Azure SQL Database
  23. REST API call does not list SQL resources on Azure subscription
  24. Learnings from the Trenches - Azure SQL Database Best Practice Performance recommendations
  25. Snapshot isolation transaction fails when querying metadata
  26. Orphaned transactions and distributed deadlocks
  27. Restore a DB encrypted with a TDE key into a server/instance having a different encryption key
  28. Azure SQL Database Auditing not writing to Storage Account behind firewall
  29. Lesson Learned #141: The target principal name is incorrect connecting to Azure SQL Database.
  30. Lesson Learned #140: Is it possible to connect from Azure SQL DB to Synapse using External Tables?
  31. Techniques to enhance Linked Server performance
  32. SSMA dropping connection
  33. SSIS package fails with 'Communication link failure'
  34. Logins in secondary server not mapped correctly from primary server
  35. How to reconcile Orphan stretch databases
  36. How to query Azure SQL Metrics using Powershell
  37. Lesson Learned #138: Transferring data between two tables is taking too much resources
  38. Lesson Learned #139: Operating system error code 80(The file exists.) running a bulk insert
  39. How to Change collation for production Azure SQL databases
  40. Step By Step: How to use SQLPackage with Access Token
  41. Scale database up or down when geo replication is in use
  42. Lesson Learned #137: Running SQLPackage .NET Core
  43. Lesson Learned #136: Deadlock inserting data with multiple threads running at the same time
  44. Lesson Learned #135: Row Level Security based on Is_RoleMember
  45. Lesson Learned #134: Row Level Security and Session Context
  46. Lesson Learned #133: Running Bulk Insert command using Managed Identity credential.
  47. Azure SQL DB and TEMPDB usage tracking
  48. Change the Elastic Pool Storage Size using Azure Monitor and Azure Automation
  49. Query Design performance issues #02 - Column-side conversions and Function usage in WHERE
  50. Query Design performance issues #01 - All-in-one query
  51. Collation conflict when moving Azure SQL DB to SQL server on-premises or Azure VM using SQLPackage.
  52. Lesson Learned #132: Delays connecting to Azure SQL Database from SQL Server Management Studio.
  53. Lesson Learned #131: ReadScale Out and Failover Group
  54. Lesson Learned #130: Does MARS work in Azure SQL Managed Instance?
  55. Lesson Learned #129:Using Data Source External from Azure SQL Database to Azure SQL Managed Instance
  56. Lesson Learned #128: How to track the automated backup for an Azure SQL Managed Instance
  57. AAD Auth Error - Login failed for user '<token-identified principal>'
  58. How to generate alerts for DDL statements on Azure PostgreSQL using Log Analytics
  59. Reaching Azure SQL DB connection limits in many ways
  60. Using Managed Service Identity (MSI) to authenticate on Azure SQL DB
  61. Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting
  62. Lesson Learned #127: Using Azure SQL Database Private Link and PowerBI
  63. Lesson Learned #126:Deny Public Network Access,Allow Azure Services and Private Link in SQL Database
  64. Lesson Learned #125: Azure Storage Firewall and BCP
  65. Lesson Learned #124: Improving the Linked Server connectivity performance using Azure SQL Database
  66. Lesson Learned #123: Testing PrivateLink connection time using Azure Database for MySQL and PHP
  67. Lesson Learned #122: Checks to perform on your database before using Data Sync?
  68. Azure SQL DB Connectivity Troubleshooting
  69. How to use different domain name to connect to Azure SQL DB Server
  70. The session limit for the database is 640 and has been reached
  71. Lesson Learned #121: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'
  72. Lesson Learned #120: What is the impact of having an Indexed View during a data import process?
  73. Lesson Learned #119: What is the query that my stored procedure is running now?
  74. Lesson Learned #118: Having ALTER DATABASE failed because a lock could..after creating a MI database

2019 224

  1. Lesson Learned #117: Testing the connection time using Azure Database for MySQL and PHP
  2. Lesson Learned #116: Replication Monitor and Azure Manage Instance public endpoint
  3. Lesson Learned #115: Time-saving in a Managed Instance restore process.
  4. Lesson Learned #114: Could Row Level Security changes the execution plan of a query?
  5. AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #3 - Query AUDIT data or Who dropped my TABLE?
  6. Memory Grant Feedback - SQL 2019 new feature applied to Azure SQL DB
  7. Lesson Learned #113: Experimenting with Database Experimentation Assistant tool
  8. Lesson Learned #112: Exporting Azure Database for MySQL to a Blob Storage
  9. Lesson Learned #111: Running the Web App backup service for Azure Database for PostgreSQL
  10. Azure SQL DB around the globe and latency - An architecture talk
  11. Azure Portal - Provide permissions to only one Azure SQL Database
  12. Lesson Learned #110 Azure SQL Managed Instance and Azure DNS
  13. Is this possible to set virtual cluster name when deploying Azure SQL Managed Instance?
  14. Lesson Learned #109: Issues exporting an Azure Database for MySQL database using mysqldump
  15. Lesson Learned #108: How the data is purged or destroyed in Azure Database for MySQL.
  16. Lesson Learned #107 - pg_hba.conf entry for host error using Hyperscale Citus Database.
  17. Cross Database Queries
  18. What caused the sudden DTU/CPU spikes to the limit
  19. Lesson Learned #106 - Azure SQL DB High transaction delay or maybe NOT
  20. AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #2 – ALERTS
  21. AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1
  22. Performance Considerations and Expectations when migrating from IaaS or on-prem to PaaS database
  23. Point in Time Restore in Azure database for MySQL and Azure Database for PostgreSQL
  24. Lesson Learned #105: Error code 40613 in Azure SQL Database using DAC
  25. Lesson Learned #104: Enough to measure CPU,DATAIO and TLOG when you are facing a performance issue?
  26. Lesson Learned #103: Performance issue retrieving the deadlock list in Azure SQL Database.
  27. Lesson Learned #102: External Data Source and Allow Azure Service setting
  28. One specific query runs slower in Azure DB than on-premises SQL Server?!
  29. How to configure bi-directional transaction replication between SQL MI and SQL VM
  30. Lesson Learned #101: PHP and public endpoint of Azure SQL Managed Instance.
  31. Lesson Learned #100: How to monitor the queries when you are using Read Scale Out feature?
  32. Lesson Learned #99: Azure SQL Database - Adding Audit Actions in SQL Azure Auditing
  33. Lesson Learned #98: Is possible to create an extended event on the server in Azure Managed Instance?
  34. Lesson Learned #97: Which is the server collation in Azure SQL Database?
  35. Lesson Learned #96: Updating a non-clustered index in a partitioned table.
  36. Lesson Learned #95: Updating the auto-created and user defined statistics only
  37. Lesson Learned #94: What is the TempDB configuration for Azure SQL Database and Managed Instance?
  38. Lesson Learned #93: Defining a custom SQL role to someone logging in via Azure AD
  39. Lesson Learned #92: Connecting to SQL Server - IaaS from Azure SQL Managed Instance
  40. Lesson Learned #91: How to connect to Azure Database for MySQL using PhpMyAdmin in WAMP environment
  41. Lesson Learned #90: SQL Server replication requires the actual server name to make a connection.
  42. Lesson Learned #89: Splitting a partition of a partitioned table in Azure SQL Database
  43. Lesson Learned #88: Implementing Data Masking with EXECUTE AS USER in Azure SQL Database
  44. Lesson Learned #87: Connecting from SQL Server 2008/R2 to Managed Instance using Linked Server.
  45. Lesson Learned #86: Encrypting columns data in Azure SQL Database
  46. Lesson Learned #85: The impact of having a proxy server when you are connecting with AAD
  47. Lesson Learned #83: How to create my own SQL Auditing file in Azure SQL
  48. Lesson Learned #74: The importance of having the Application Name configured in connection string
  49. Lesson Learned #84: How to synchronize views definitions between databases
  50. Lesson Learned #73: Azure Database for MySQL – CONVERT_TZ returns null
  51. Lesson Learned #72: Is my database still encrypted (TDE)
  52. Lesson Learned #71: Fixing an orphaned users using a copy database process in Azure SQL Databases.
  53. How to get Azure SQL database size
  54. Lesson Learned #70: Is ASP Classic able to connect to Azure SQL Database using Azure Active Directory?
  55. Lesson Learned #69: Azure SQL Database &#8211; How are the statistics updated automatically by SQL engine
  56. How to Migrate Azure SQL Database to Azure SQL Managed Instance
  57. Lesson Learned #68: Azure Database - SQL Connectivity Checker
  58. Lesson Learned #67: Azure SQL Database - SSH, VNET and Firewall
  59. Lesson Learned #66: Azure Active Directory - Universal with MFA authentication - Output Window Trace Level
  60. How to auto-scale an Azure Database for MySQL/PostgreSQL instance with Azure run books and Python
  61. Lesson Learned #65: Azure SQL Database &#8211; Using Read Scale Out option
  62. Lesson Learned #64: Azure SQL Database - 'The type 'xml' is not supported with external tables for sharded data.'
  63. Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?
  64. Lesson Learned #62: Using Cross Database Queries in Azure SQL Managed Instance
  65. Lesson Learned #61: Using Schemas in Azure SQL Managed Instance
  66. Lesson Learned #60: Using Partition Option in Azure SQL Managed Instance
  67. Lesson Learned #60: How to connect from Azure SQL Managed Instance to Azure SQL Database using Linked Server Option
  68. Lesson Learned #59: I would like to upload my own certificate to connect to Azure SQL Database.
  69. Lesson Learned #58: Virtual Machine and its Load Balancer IP
  70. Lesson Learned #57: Bacpac export process doesn't include the automatic statistics
  71. Lesson Learned #56: External tables and performance issues
  72. Lesson Learned #55: Azure SQL Managed Instance - Backup failed for Server "servername". Failed: 1117 -The request could not be performed because of an I/O device error
  73. Lesson Learned #54: The specified schema name name@domain.com either does not exist or you do not have permission to use it
  74. Lesson Learned #53: Why do you need to use dm_operation_status dynamic management view?
  75. Lesson Learned #52: Azure Database for MySQL &#8211; Server is not configured to allow ipv6 connections
  76. Lesson Learned #51: Managed Instance - Import via Sqlpackage.exe doesn't allow autogrow
  77. Lesson Learned #50: Adding PK led to transaction log full error
  78. Move to Azure Resource Manager REST APIs for Azure SQL Database
  79. Understanding Performance in Basic Tier for Azure Database PostgreSQL and MySQL
  80. Azure Database for MySQL server has gone away
  81. How to Scale up Azure Database for MySQL from Basic Tier to General Purpose Tier
  82. Azure SQL DB with more than 4 readable secondaries
  83. Cross-database Query in Azure SQL Database
  84. Azure Database for PostgreSQL performance Quick Tips
  85. Unable to view LTR Backups for Azure SQL Database servers
  86. Change collation of existing Azure SQL database
  87. Long Retention policies configuration are not saved
  88. Understanding Dynamic Data Masking in Azure SQL DB
  89. &#8220;Cannot OPEN BACKUP device&#8221; error seen when backing up Azure SQL Managed Instance to Azure Blob Storage
  90. &#8220;Cannot OPEN BACKUP device&#8221; error seen when backing up Azure SQL Managed Instance to Azure Blob Storage
  91. Extended Events: Azure Storage Account Types Matter
  92. How-to set up point-to-site peering with Azure SQL Managed Instance and self-signed certificates
  93. How to create a native PowerShell app registration to connect to Azure SQL DB
  94. Azure SQL Database Token-based authentication with PowerShell
  95. Connect to Azure SQL Database Managed Instance with Virtual Network peering
  96. I cannot see the Long-Term Retention (LTR) backups
  97. Database Copy may cause Azure SQL Database to run out of transaction log space
  98. Connect to SQL Managed instance
  99. Exporting a database that is/was used as SQL Data Sync metadata database
  100. Updated ARM Template to deploy server with Auditing and Threat Detection turned ON
  101. Providing the server name explicitly in user names Part 2: DNS alias for Azure SQL Database
  102. Tips & Tricks : What you need to do to create SQL Login to authenticate to Azure SQL DBs members in Auto-Failover Group
  103. Lesson Learned #49: Does Azure SQL Database support Azure Active Directory connections using Service Principals?
  104. Lesson Learned #48: Does Azure SQL Database Managed Instance support Resource Governor?
  105. Export Azure SQL DB Error: "Missing the required 'administratorLogin' parameters for ImportExport operation."
  106. Lesson Learned #47: Do you have connectivity issues to Azure SQL DB from your PC?
  107. Lesson Learned #46: Showing hidden Azure SQL Database types in the Portal
  108. Lesson Learned #45: CPU at 100% using nvarchar parameter data type in the filter against varchar column data type.
  109. Lesson Learned #44: What is the error message The index IX_MyIndex is dependent on column MyColumnData?
  110. Lesson Learned #43: Using partitioning option for Azure SQL database
  111. Lesson Learned #42: Creating an alias for my Azure SQL Database Server
  112. Lesson Learned #41: Using VNET with Azure SQL Database
  113. Lesson Learned #40: Could it be possible to use Intellisense with an Azure Active Directory user in SQL Server Management Studio?
  114. Lesson Learned #39: Best Practices using BCP in Azure SQL Database
  115. Lesson Learned #38: Which is the impact using connection pooling in my application
  116. Lesson Learned #37: How to use distributed transactions in Azure SQL Database
  117. Lesson Learned #36: Best Practices connecting and executing queries using Azure SQL Database
  118. Lesson Learned #35: How to transfer the login and user from OnPremise to Azure SQL Database
  119. Export Azure SQL Database to local path
  120. Lesson Learned #34: Does Azure SQL Database support OPENJSON?
  121. Lesson Learned #33: How to make "cliconfg" to work with SQL Alias (on-premises) to Azure SQL Azure (PaaS)
  122. Lesson Learned #32: How to export multiple databases from SQL Server to Bacpac
  123. Stop / Cancel ongoing Azure SQL DB scale operation
  124. Extended Events Capture Step by Step Walkthrough
  125. Tips and tricks on how to properly create Azure SQL DB
  126. Azure Data Sync - Resolve slow initial sync (especially on two way sync)
  127. Schedule Data Sync with Azure SQL Database use an Automation account
  128. What will happen with CATALOG_COLLATION and Case Sensitive vs Case Insensitive
  129. Automating Azure SQL DB index and statistics maintenance using Azure Automation
  130. Copy production database to stage or test environment using PowerShell or TSQL
  131. Lesson Learned #31: How to measure a TSQL execution time against Azure Database for MySQL
  132. Lesson Learned #30: How to measure a TSQL execution time against Azure SQL Database
  133. Issue Modifying search_path Parameter for Azure Database for PostgreSQL
  134. Restoring Deleted Database to Specific Point in Time
  135. Tracking Azure SQL Data Sync Service data changes
  136. Using Certificates in Azure SQL Database : Backup
  137. How to troubleshoot slow performance after moving to azure due to network latency
  138. Using Certificates in Azure SQL Database : Import
  139. Deployment fails with 'Unable to connect to master or target server 'mydb_svr'. You must have a user with the same password in master or target server 'mydb-db'
  140. How to change Azure SQL DB LTR Recovery Service Vault ?
  141. Providing the server name explicitly in user names for Azure SQL DB, MySQL and PostgreSQL
  142. How to get more information about failed import to Azure SQL DB
  143. REST API Sample for exporting a database
  144. How to create an Azure AD application in PowerShell
  145. PolyBase export of datetime values does not use DATE_FORMAT
  146. Editing a .bacpac file
  147. Lesson Learned #29: Getting the error message : The login already has an account under a different user name while importing a bacpac
  148. Initializing Azure SQL Database with SQL Server Transactional Replication
  149. Lesson Learned #28: Why does SQL SERVER Management Studio report that my Azure SQL Database version is 12?
  150. Where are my Long Term Retention backups (using PowerShell)
  151. Lesson Learned #27: We would like to access tables from a database to another database
  152. Best Practices for Azure SQL DataSync 2.0 tasks
  153. Reset lost admin account password
  154. How to check connectivity to Azure SQL DB, Managed Instance, Azure Database for MySQL and PostgreSQL
  155. Azure Data Warehouse Health Check Query
  156. Errors Configuring Azure SQL DataSync 2.0 agent
  157. Troubleshooting Connectivity Common Scenarios
  158. GRANT SUPER privilege on Azure Database for MySQL
  159. Example Python Program Reading SQL Azure Blob Auditing Data
  160. Protecting deletions of Azure SQL Resources
  161. Database Blob Auditing Policy using .NET C#
  162. Azure Database for MySQL &#8211; Can't restore database with error "Got error 1 from storage engine"
  163. SQL Azure Blob Auditing Basic Power BI Dashboard
  164. Sizing an Elastic Pool eDTU and Storage resources use Graphical runbook
  165. Deadlock analysis for SQL Azure Database
  166. Azure SQL Database Auditing &#8211; Move from Azure Table Storage to Blob Storage
  167. Lesson Learned #26: How to change the definition of table triggers at the same time
  168. Connect from Power BI to Azure SQL Database using AAD authentication
  169. Database scale error: The database cannot proceed with pricing-tier update as it has memory-optimized objects
  170. Lesson Learned #25: Export/Import Azure SQL Database using Azure File Service?
  171. Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server
  172. Lesson Learned #24: How to read or import Azure SQL Auditing Blob file?
  173. Quickly test connectivity from Azure Website to SQL DB
  174. Lesson Learned #23: How to add AAD Security Groups to Azure SQL Database?
  175. Lesson Learned #22: How to identify blocking issues?
  176. How to automate Export Azure SQL DB to blob storage use Automation account
  177. Lesson Learned #21: There is not enough space on the disk exporting BacPac using SSMS
  178. Using SQLPackage to import or export SQL Server and Azure SQL DB
  179. Lesson Learned #20: What happen with my connection inside Azure when SQL Auditing is enabled?
  180. Connect to your Azure SQL DB behind MsAccess web application
  181. Lesson Learned #19: How to obtain the deadlocks of your Azure SQL Database or Managed Instance?
  182. Lesson Learned #18: Database cannot be downgraded to a lower database tier.
  183. Lesson Learned #17: Should I cancel or kill a session running a huge transaction?
  184. Lesson Learned #16: How to change the default language of Azure SQL Database
  185. Lesson Learned #15: Securing our Azure SQL Datawarehouse
  186. ARM Template to deploy server with Auditing and Threat Detection turned ON
  187. Accessing Azure SQL DB from Azure VM using a static Public IP adress
  188. Lesson Learned #14: Is it possible to upload a SQL server backup to an Azure database
  189. Sample: Joining tables from different Azure SQL Databases
  190. Lesson Learned #13: SQL Server instance in use does not support column encryption
  191. Lesson Learned #12: What types of temporary tables can I use in Azure SQL Datawarehouse?
  192. Lesson Learned #11: Connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse
  193. Fix identities after migrating through SQL Replica
  194. Lesson Learned #10: Monitoring TempDB usage
  195. Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remote
  196. BACPAC Export failing with Unable to reconnect - Timeout expired
  197. Azure Support Academy (Spanish): SQL Server, Next Station Azure
  198. ARM template outputs for Azure SQL Database
  199. Azure Support Academy: How to troubleshoot connectivity issues in Azure SQL DB - Part 1
  200. Elastic Database Jobs: Sample for Running T-SQL Code in Multiple Databases
  201. Lesson Learned #8: Monitoring the geo-replicated databases.
  202. Lesson Learned #7: Monitoring the transaction log space of my database
  203. Lesson Learned #6: Working with HAS_PERMS_BY_NAME function and Database Name with dots
  204. No Azure SQL V2 (or as called sometimes V11) anymore
  205. Create SQL Login and SQL User on your Azure SQL DB
  206. Azure SQL DB MAXSIZE - what can I do with that?
  207. Azure SQL DW - column name is case sensitive with hash distribution
  208. Does Azure SQL DB support automatic indexed views?
  209. Unexpected Select queries seen in the Performance Overview of the Azure Portal
  210. Timeout and ADALGetAccessToken Error with AAD connections
  211. How big is my Azure SQL database?
  212. Lesson Learned #5: Deploy SQL DB V12 from ARM templates
  213. Lesson Learned #4: Modifying the default time zone for your local time zone.
  214. Lesson Learned #3: Modifying the fulltext stopword list in Azure SQL Database.
  215. The easy way to manage SQL Logins and users in Azure SQL DB
  216. Lesson Learned #2: Do you need SQL Server Agent for Azure SQL DB?
  217. Lesson Learned #1: Capturing a TSQL Command Timeout
  218. How to move Azure SQL server to another subscription
  219. Server name has already been used after you deleted it
  220. How to maintain Azure SQL Indexes and Statistics
  221. Using Query Store in SQL Database V12
  222. Stopping or Postponing an upgrade to SQL Database V12
  223. Configuring the firewall for Client Access
  224. BACPAC: Could not load schema model from package