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
409

Lesson Learned #129:Using Data Source External from Azure SQL Database to Azure SQL Managed Instance

Jose_Manuel_Jurado on 06-05-2020 08:34 AM
Today, I worked on a service request that our customer asked about how to connect from Azure SQL Database to Azure SQL M...
448

Lesson Learned #128: How to track the automated backup for an Azure SQL Managed Instance

Jose_Manuel_Jurado on 06-05-2020 01:48 AM
In this last week we received a question about how to track the automated backup performed in Azure SQL Managed Instance...
383

How to generate alerts for DDL statements on Azure PostgreSQL using Log Analytics

Ricardo_NS_Marques on 05-22-2020 02:44 AM
The example below will show you how you can setup alerts for DDL commands, like CREATE TABLE, on Azure PostgreSql
1,130

Reaching Azure SQL DB connection limits in many ways

FonsecaSergio on 05-15-2020 09:52 AM
When supporting Azure SQL DB Connectivity case we sometimes receive errors message saying that was an Azure SQL DB issue...
1,931

Using Managed Service Identity (MSI) to authenticate on Azure SQL DB

FonsecaSergio on 04-08-2020 05:36 AM
In this article we will explore system-assigned identity one type of Managed Identity
1,248

Tips & Tricks #1: Creating alerts for Azure SQL Managed Instance

Mustafa_Ashour on 04-04-2020 08:29 AM
Azure SQL Analytics collects and visualizes key performance metrics with built-in intelligence for performance troublesh...
758

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...
2,815

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

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

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

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. ...
1,041

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

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

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

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

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...
1,063

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

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

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

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 ...
1,150

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

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

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

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...
Latest Comments
platar
in Lesson Learned #128: How to track the automated backup for an Azure SQL Managed Instance on 06-05-2020
This looks like it could help. Question: how does the credential created on the blob storage relate back to the creation of the extended event?
0 Likes
sreedxc
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 06-02-2020
Hi Yochanan,Does the proc update both rowstore and column indexes? when i run the query from microsoft site for column store and rowstorehttps://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15after running your maintenance procedure all ...
0 Likes
FonsecaSergio
in Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting on 05-29-2020
Tks for the feedback @saikovvuri And yes this link you posted also have the official version published to https://docs.microsoft.com/en-us/azure/private-link/private-endpoint-dns I will add it to the post to be more clear on this more complex environment configurations
0 Likes
sripu
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 05-27-2020
also what DB permission are needed ? will the schema /database suffice or we require sa/admin privilege?
0 Likes
sripu
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 05-27-2020
if we want to run the proc on multiple database in azure sql how to run it one by one on each database ?
0 Likes