Lesson Learned #72: Is my database still encrypted (TDE)

A quick lesson learned from the field when dealing with TDE (Transparent Data Encryption). After running something like ALTER DATABASE [AdventureWorks] SET ENCRYPTION OFF One quick spot where people usually will look for information if a database is encrypted or not is sys.databases SELECT database_id, name, is_encrypted FROM sys.databases   Even though it shows the state…

0

Lesson Learned #71: Fixing an orphaned users using a copy database process in Azure SQL Databases.

Hello Team, Some days ago, I worked in a service request in this following scenario: Using the portal, our customer, copied the database from one server to another. After it, our customer was not able to connect to the copied database in the destination server. I would like to explain why, performing the following example:…


How to get Azure SQL database size

There are multiple ways to achieve this and there are also some storage types you should be aware There is a good doc about this at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management

0

Lesson Learned #70: Is ASP Classic able to connect to Azure SQL Database using Azure Active Directory?

Hello, Today, I worked on a service request that our customer has an application developed in ASP Classic and they want to use Azure Active Directory using the validation of User/Password, it is not possible. Initially, Azure Active Directory is possible to use .NET 4.6 based on this URL . I suggested to use the ODBC v.13…


Lesson Learned #69: Azure SQL Database – How are the statistics updated automatically by SQL engine

Hello, Today I worked on a service request that our customer needs to know how the statistics are automatically updated by SQL Engine and what is the impact of this process in terms of consumption resources and distribution of the statistics. STEP 1 – Created the table and statistics. I have created an example table with…


How to Migrate Azure SQL Database to Azure SQL Managed Instance

The latest version of SQLPackage supports migration to Azure SQL Managed Instance (MI) from multiple SQL sources such as Azure SQL Database. Export: Following the below steps, you can export a SQL database using the SQLPackage command-line utility. If possible, use a workstation that has access to the Azure SQL Database and the MI to avoid having…

0

Lesson Learned #68: Azure Database – SQL Connectivity Checker

Hello, Yesterday, I worked in a support case that our customer needs to review the connection and if possible the execution time spent for Azure Database for PostgreSQL using PGBouncer and not. I developed and upload a new option in our AzureSQLConnectivityChecker for PostgreSQL in our GitHub project, in order to review this connection time spent for…


Lesson Learned #67: Azure SQL Database – SSH, VNET and Firewall

Hello, Today I worked in a service request when our customer tries to connect using SSH to the 1433 port from a Linux environment using a JumpBox in Azure to perform the connection. In this situation, we need to know that in Azure, depending on where is the connection coming, the Gateway that Azure SQL Database has…


Lesson Learned #66: Azure Active Directory – Universal with MFA authentication – Output Window Trace Level

Hello Team, I worked on a service request where our customer faced a connectivity issue using Active Directory- Universal with MFA authentication. After our basic troubleshooting we’re used to suggest taking a network and https traces in order to review the communication between the Application, Azure Active Directory and  Database server. I found a very useful option in SQL Server Management Studio that…