Lesson Learned #27: We would like to access tables from a database to another database

It is very frequently, that our customers ask about how to access tables from a database to another database. In Azure SQL Database there is not possible to access tables from another database in the same connection directly, for example, using database.dbo.table. We have a solution called Cross Database Queries in Azure SQL Database -…


Best Practices for Azure SQL DataSync 2.0 tasks

The Azure SQL DataSync workflow is carried by different tasks at different stages. The first task is to provision destination databases (Initial Synchronization). Then data changes (update/insert/delete) are propagated to the destination by sync tasks. If any changes are made in dataset or schema, re-provisioning occurs. Deprovisioning is engaged when a database is removed from…

0

Reset lost admin account password

Symptom: If you lost your admin account password, or you need to change the password for any reason follow this article to reset your admin account password. Resolution: Option 1: Using Azure Portal Using Azure Portal open your Azure SQL Server blade. Make sure you are in the Overview blade. Click on “Reset password” at…


How to check connectivity to Azure SQL DB

Scenario: Sometimes when connection to Azure SQL DB failed you want to test the network layer to confirm this is not network issue that prevent you from accessing your Azure SQL DB. Note that this is relevant only for connections originated out of Azure as described here: Ports beyond 1433 for ADO.NET 4.5 Using these…


Azure Data Warehouse Health Check Query

We have been sharing this query with the customers to have a quick health check on their environment. The query covers these items: Checking basic statistics information (actual row count vs row count for control node) Table data skew Small CCI tables (<102400 rows per partition) – This is just for their reference for reviewing…


Errors Configuring Azure SQL DataSync 2.0 agent

When adding an on-premise member database to a datasync 2.0 sync group, you will need to configure the local sync agent following these steps: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync Sometimes, the you may run into errors. Error Type 1: “Submitted agent key is invalid. The agent key could not be parsed as expected. Please resubmit a valid agent key”…

0

Troubleshooting Connectivity Common Scenarios

Connectivity troubleshooting. Connectivity issues are quite common in Azure DB and SQL in general. We have a great article that can assist in resolving these which is here: https://support.microsoft.com/en-us/help/10085/troubleshooting-connectivity-issues-with-microsoft-azure-sql-database This article is great, and I encourage you to review its content and consider using it when you have a connectivity problem in the future. However, I’d…


GRANT SUPER privilege on Azure Database for MySQL

The SUPER privilege is not supported on Azure Database for MySQL. The closest you can get is to create another admin level user with the same rights as the server admin you created to do this you can run: You can get the privileges the admin account has by logging in as the admin account…


Example Python Program Reading SQL Azure Blob Auditing Data

I recently had a case that a customer needed a way to read the blob auditing data from Linux. This was the quickest and easiest way I could think of. First install msodbcsql following the instructions here https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server You will also need to install the pyodbc module.


Protecting deletions of Azure SQL Resources

In Azure, there is a feature called Azure Resource Management Locks which can help prevent accidental deletion resources such as a SQL Server by adding a level of protection. While it may not happen all the time, sometimes we make mistakes and delete the wrong server. Be it that there was a typo in an…

0