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
Options
589

Query Design performance issues #02 - Column-side conversions and Function usage in WHERE

FonsecaSergio on 08-06-2020 04:28 AM
When designing queries and filters (WHERE) sometimes we need to convert some data before filtering, and depending on wha...
1,851

Query Design performance issues #01 - All-in-one query

FonsecaSergio on 08-04-2020 04:15 AM
When looking into performance issues on support cases there is one pattern called ALL-IN-ONE QUERY that we always sees t...
695

Collation conflict when moving Azure SQL DB to SQL server on-premises or Azure VM using SQLPackage.

Mousa_Janini on 07-27-2020 06:52 AM
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" whe...
1,003

Lesson Learned #132: Delays connecting to Azure SQL Database from SQL Server Management Studio.

Jose_Manuel_Jurado on 07-01-2020 11:46 AM
Today, I worked on a service request that our customer reported some delays when they are connecting to Azure SQL Databa...
657

Lesson Learned #131: ReadScale Out and Failover Group

Jose_Manuel_Jurado on 06-22-2020 06:55 AM
Today, I worked on a service request that our customer wants to use the parameter of ApplicationIntent=ReadyOnly to conn...
986

Lesson Learned #130: Does MARS work in Azure SQL Managed Instance?

Jose_Manuel_Jurado on 06-19-2020 11:39 AM
Today, we worked on a service request where our customer faced the following error message: "There is already an open Da...
1,051

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

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

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
3,399

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

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

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

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...
4,021

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

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

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

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

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

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

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

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

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

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

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

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

Latest Comments

Steve Hollingshead
in AAD Auth Error - Login failed for user '' on 08-11-2020
You are probably using a guest invite for someone who has access to multiple Azure tenants. If that's the case, they need to specify the tenant ID as well in the SSMS connection options at the bottom. The tenant ID is xxxx.onmicrosoft.com (the tenant containing the SQL DB)
0 Likes
PeterDanielsDenver
in Lesson Learned #10: Monitoring TempDB usage on 07-30-2020
Thank you, Jose. It would be helpful if the query results mentioned what was tempdb related. Would you be willing to describe the result set in more detail, por favor?
0 Likes
DianaLittle
in AAD Auth Error - Login failed for user '' on 07-23-2020
I'm running into a similar issue with being able to deploy a NEW database onto an Azure SQL Server using token-based authentication from an Azure VM. I've added the Azure VM to the database server's firewall, I've ensured that the Azure VM has a system-assigned identity. When I publish the DACPAC to...
0 Likes
FonsecaSergio
in AAD Auth Error - Login failed for user '' on 07-23-2020
@Edvard Gundersen this is not an issue. This is an expected behavior... When you create contained users, in this case was AAD user, but could be SQL login (contained user). You are only able to connect to the specified DB, if you want to connect to master db or to list the available dbs (master meta...
0 Likes
Edvard Gundersen
in AAD Auth Error - Login failed for user '' on 07-16-2020
Any progress on this issue?
0 Likes