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
Copied!
Home
Options
499

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 ...
421

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...
428

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...
787

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,064

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...
918

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...
573

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 ...
795

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...
489

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...
617

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...
469

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...
667

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
504

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...
705

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? 
495

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...
576

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...
377

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 '...
789

Cross Database Queries

fercobo on 08-27-2019 10:00 AM
700

Lesson Learned #106 - Azure SQL DB High transaction delay or maybe NOT

FonsecaSergio on 08-08-2019 08:25 AM
I got a recent case where a customer was worried with high transaction delays around 15sec and that would be really bad
780

AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #2 – ALERTS

FonsecaSergio on 08-08-2019 07:41 AM
As you could see on previous post (AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1) using Azure SQL DB + Log An...
1,007

AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1

FonsecaSergio on 08-08-2019 02:44 AM
As a DBA you may want to query SQL Audit and SQL Diagnostics information. The easiest way to do this is sending to Log a...
550

Lesson Learned #105: Error code 40613 in Azure SQL Database using DAC

Jose_Manuel_Jurado on 07-23-2019 06:28 AM
Today, I worked on a service request that our customer is connecting to Azure SQL Database using the port 1434 and they ...
447

Lesson Learned #104: Enough to measure CPU,DATAIO and TLOG when you are facing a performance issue?

Jose_Manuel_Jurado on 07-22-2019 08:59 AM
Today, I worked on a service request when our customer reported a performance issue for their Azure SQL Database. Howeve...
673

Lesson Learned #103: Performance issue retrieving the deadlock list in Azure SQL Database.

Jose_Manuel_Jurado on 07-17-2019 12:45 AM
Today, I worked on a service request that our customer is using one of our articles to obtain the deadlocks but the numb...
612

Lesson Learned #102: External Data Source and Allow Azure Service setting

Jose_Manuel_Jurado on 07-11-2019 04:16 PM
As you know when you are using cross database queries or external tables and you execute a query the connection will be ...
Latest Comments
Walter_P1972
in Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance? on 01-23-2020
Hi, I have been searching for some instructions regarding creation of linked server on managed instance on Azure to SQL server on premise. For some reason there are plenty of examples on creating linked server on-prem to Managed Instance. I tried different providers and get the error that server can...
0 Likes
v-ajprak
in Lesson Learned #119: What is the query that my stored procedure is running now? on 01-16-2020
This was very helpful while working on a query performance case. Good share!!
0 Likes
m60freeman
in How to get Azure SQL database size on 12-11-2019
It is a significant missing feature that there is no way to obtain the current MAXSIZE for a user database via TSQL from within master.
0 Likes
Jeffrey Chilberto
in Lesson Learned #114: Could Row Level Security changes the execution plan of a query? on 12-05-2019
Thanks Jose, very helpful post.
0 Likes
Yochanan_MSFT
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 11-21-2019
@woodsy1978 - I didnt include this as parameter as I would recommend to use FullScan to get better quality for the statistics. however, this is T-SQL code so you can modify it for your needs. HTH, Yochanan
0 Likes