Month: June 2019

Initial Update: Sunday, 02 June 2019 02:13 UTCWe are aware of issues within Application Insights and are actively investigating. Some customers in West Europe region may experience Latency and Data Gaps.Work Around: NoneNext Update: Before 06/02 04:30 … Continue reading Experiencing Latency and Data Gaps issue in Azure Portal for Many Data Types – 06/02 – Investigating→

Hello Team,
 
As we discussed in previous posts either Azure SQL Database and Azure SQL Managed Instance we have the partitioning option in both databases. In Azure SQL Database there is not possible to specify the filegroup however Azure SQL… Continue reading Lesson Learned #89: Splitting a partition of a partitioned table in Azure SQL Database→

Our customer is using a legacy application that they cannot change the user that is connecting to the database but they want to use Data Masking and Row Level Security features in Azure SQL Database. Unfortunately, they cannot impersonate the user when… Continue reading Lesson Learned #88: Implementing Data Masking with EXECUTE AS USER in Azure SQL Database→

 
 
Hello Team,
 
As you know, the support of SQL Server 2008 and SQL Server 2008 R2 is approaching to the end and some customers are using Linked Server to connect to Azure SQL Managed Instance for sending or retrieving data. We found a… Continue reading Lesson Learned #87: Connecting from SQL Server 2008/R2 to Managed Instance using Linked Server.→

Hello Team,
 
Today, I worked on a service request where our customer needs to encrypt some columns. Besides the options that we have using always encrypted or other like symmetric key and don’t forget that Azure SQL Database by default … Continue reading Lesson Learned #86: Encrypting columns data in Azure SQL Database→