cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Azure Database Support Blog
Home
Options
468

Lesson Learned #127: Using Azure SQL Database Private Link and PowerBI

Jose_Manuel_Jurado on 03-25-2020 06:51 PM
Today, I worked on a service request that our customer received an error message connecting from PowerBI to Azure SQL Da...
809

Lesson Learned #126:Deny Public Network Access,Allow Azure Services and Private Link in SQL Database

Jose_Manuel_Jurado on 03-21-2020 08:46 AM
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-settings In the latest days, we received a...
523

Lesson Learned #125: Azure Storage Firewall and BCP

Jose_Manuel_Jurado on 03-20-2020 12:54 PM
We received some questions from our customers that they want to enable the firewall of their Azure Storage Account that ...
623

Lesson Learned #124: Improving the Linked Server connectivity performance using Azure SQL Database

Jose_Manuel_Jurado on 03-17-2020 02:02 PM
Today, I've worked on an interesting service request that I would like to share with you. Our customer reported that con...
357

Lesson Learned #123: Testing PrivateLink connection time using Azure Database for MySQL and PHP

Jose_Manuel_Jurado on 03-12-2020 10:11 AM
Some time ago, I wrote an article about how to improve the connection speed in Azure Database using the best practices. ...
910

Lesson Learned #122: Checks to perform on your database before using Data Sync?

Jose_Manuel_Jurado on 03-11-2020 01:54 AM
During these last days I've been working with some service requests related with DataSync based on some limitations of t...
485

Lesson Learned #121: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'

Jose_Manuel_Jurado on 01-27-2020 04:09 AM
We have been working on an issue that our customer reported this error message - The transaction log for database 'tempd...
629

Lesson Learned #120: What is the impact of having an Indexed View during a data import process?

Jose_Manuel_Jurado on 01-16-2020 10:28 AM
Today, we have been working on an important issue that our customer reported that during a data import process, in this ...
539

Lesson Learned #119: What is the query that my stored procedure is running now?

Jose_Manuel_Jurado on 01-15-2020 12:18 PM
Today, we have been working on a performance issue where our customer is running a stored procedure but we don't know ex...
527

Lesson Learned #118: Having ALTER DATABASE failed because a lock could..after creating a MI database

Jose_Manuel_Jurado on 01-13-2020 08:18 AM
Today, we worked on a new service request where our customer tried to modify a parameter of a new database, just a coupl...
922

Lesson Learned #117: Testing the connection time using Azure Database for MySQL and PHP

Jose_Manuel_Jurado on 12-30-2019 04:25 AM
Today, I worked on a very interesting service request that our customer noticed some milliseconds of difference connecti...
1,186

Lesson Learned #116: Replication Monitor and Azure Manage Instance public endpoint

Jose_Manuel_Jurado on 12-20-2019 04:06 PM
I've found that launching replication monitor feature from SQL Server Management Studio connected to Azure Manage Instan...
1,028

Lesson Learned #115: Time-saving in a Managed Instance restore process.

Jose_Manuel_Jurado on 12-20-2019 03:48 PM
Today, I found a very interesting trick to reduce the time spent in the restoring process of a database in Managed Insta...
675

Lesson Learned #114: Could Row Level Security changes the execution plan of a query?

Jose_Manuel_Jurado on 12-02-2019 02:02 PM
Today, I worked on a service request that remember me the impact that we could have using row level security afterwards ...
927

AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #3 - Query AUDIT data or Who dropped my TABLE?

FonsecaSergio on 11-27-2019 09:37 AM
On Azure SQL DB you can have AUDIT data saved to Storage Account, Log Analytics and Event Hub. Log Analytics will be the...
577

Lesson Learned #113: Experimenting with Database Experimentation Assistant tool

Jose_Manuel_Jurado on 11-18-2019 12:04 PM
Today, we worked in an interesting service request when our customer is using DEA - Database Experimentation Assistant t...
689

Lesson Learned #112: Exporting Azure Database for MySQL to a Blob Storage

Jose_Manuel_Jurado on 11-17-2019 04:42 AM
We received multiple questions about how to export databases of Azure Database for MySQL, PostgreSQL or MariaDB to an Az...
531

Lesson Learned #111: Running the Web App backup service for Azure Database for PostgreSQL

Jose_Manuel_Jurado on 11-15-2019 10:12 AM
I would like to share my lessons learned working with a customer that wants to use the WebApp backup service for Azure D...
800

Azure SQL DB around the globe and latency - An architecture talk

FonsecaSergio on 11-15-2019 09:45 AM
How to develop globally distributed queries
580

Azure Portal - Provide permissions to only one Azure SQL Database

Ricardo_NS_Marques on 11-06-2019 09:44 AM
Scenario: You have a set of user`s that need to access just one Azure SQL database on the Azure Portal. This users shoul...
875

Is this possible to set virtual cluster name when deploying Azure SQL Managed Instance?

Yochanan_MSFT on 09-16-2019 01:17 AM
Can we change the Virtual Cluster name when deploying Managed Instance? 
550

Lesson Learned #109: Issues exporting an Azure Database for MySQL database using mysqldump

Jose_Manuel_Jurado on 09-10-2019 03:57 AM
Today, I worked on a service request that our customer was not able to dump the data using mysqldump and the process too...
709

Lesson Learned #108: How the data is purged or destroyed in Azure Database for MySQL.

Jose_Manuel_Jurado on 09-05-2019 08:57 AM
Today, I had a very cool question raised by our customer about how they could be sure that when they deleted the databas...
434

Lesson Learned #107 - pg_hba.conf entry for host error using Hyperscale Citus Database.

Jose_Manuel_Jurado on 09-05-2019 05:30 AM
Today, I worked on a service request that our customer got the following error message: "no pg_hba.conf entry for host '...
889

Cross Database Queries

fercobo on 08-27-2019 10:00 AM
Latest Comments
Jeff Walzer
in Lesson Learned #126:Deny Public Network Access,Allow Azure Services and Private Link in SQL Database on 04-01-2020
@Jose_Manuel_Jurado Jose, quick question if you don't mind as we have a SQL server that is set for 'No' for 'Deny public access network access' but has one public IP listed for access. I just got an ASC alert for 'Logon from an Unusual Azure Data Center' from a public IP that is not configured for a...
0 Likes
Jeff Walzer
in Lesson Learned #126:Deny Public Network Access,Allow Azure Services and Private Link in SQL Database on 04-01-2020
@Jose_Manuel_Jurado Thx so much for posting the chart - greatly appreciated!
0 Likes
Johannes_Vink
in Lesson Learned #123: Testing PrivateLink connection time using Azure Database for MySQL and PHP on 03-13-2020
Hi Jose, thanks for this interesting information! One question, how much difference is there when accelerated networking is disabled? Regards, Johannes Vink
0 Likes
Rubén Garrigós
in How to use different domain name to connect to Azure SQL Server on 03-12-2020
Can you please specify which options will work for MI and if there are any extra requirements? For example, using CNAME we found that we need to add the username@servername but we also need to set TrustServerCertificate property to true to work. This property seems not needed if we use the original ...
0 Likes
Narges1475
in Cross-database Query in Azure SQL Database on 03-01-2020
Thank you so much. I wish every article was this clear and useful.
0 Likes