An interesting new tool (in preview) added to Azure SQL database. Now Azure portal provides flexibility to query azure sql database from a browser!! Interesting! you can simply connect to Azure portal from any browser, view the database and then launch this tool to get connected to the database. When you are in support this is nice to have feature. If you are not in front of your system you can connect to the database to perform health, connectivity check etc. Continue reading Query Editor – Azure Portal
Category Archives: Azure
Always Encrypted – An Over View – Part 1
Always encrypted is a new feature introduced to encrypt the in rest as well as during transport. It’s been quite long time the feature has been released to general public. In this encryption method the encryption will be done at the client side. Encryption keys can be stored in Azure vault, Windows certificate store in client server or in hardware module. Since the encryption keys doesn’t sit in the database engine it doesn’t reveal the actual data and even this is applicable for an administrators. Continue reading Always Encrypted – An Over View – Part 1
Clear Procedure Cache in SQL Azure database
When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache. Continue reading Clear Procedure Cache in SQL Azure database
Issues restoring SQL Azure bacpac due to QueryStoreStaleQueryThreshold
In our environment we have inhouse and SQL Azure databases. We will be refreshing the DEV environments weekly once from the production SQL Azure databases. As you know backups are taken care by Azure itself, so we can simply add the storage in our inhouse server and extract it as data tier application. Continue reading Issues restoring SQL Azure bacpac due to QueryStoreStaleQueryThreshold
SQL Azure – Dynamic Data Masking
Yesterday i covered what’s data masking and how can we implement in SQL Server 2016. Today I would like to continute the same topic in SQL Azure. Continue reading SQL Azure – Dynamic Data Masking