Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server

Symptoms:  When using blob auditing on Azure SQL Server or Database, after you export database to .bacpac file if you import the database to another Azure SQL DB that already have blob auditing enabled at the server level you may get this error message: Could not import package. Error SQL72014: .Net SqlClient Data Provider: Msg…


Quickly test connectivity from Azure Website to SQL DB

In case you have an Azure Website and you need to confirm that your website can reach SQL Database service here is a quick and simple way to test it: 1) navigate to Kudu (it can be accessed at https://{yourwebsitename}.scm.azurewebsites.net ) (Kudu is the engine behind git/hg deployments, WebJobs, and various other features in Azure…


Lesson Learned #23: How to add AAD Security Groups to Azure SQL Database?

In these days, we are receiving multiples cases where our customer needs to add Azure SQL Database groups from Azure Active Directory. This is an example to how to archive it. Using the Portal in Azure: I created a user called SQLMember. I created a group called SQLGroup, adding the member SQLMember.   Using SQL…


What’s new in IIS 10 – Microsoft Internet Information Services 10 New Features

With each version of Microsoft Windows Server comes a new version of Internet Information Services (IIS).  With the recent release of Windows Server 2016 comes IIS version 10.  Before I cover these new features, here are a few articles which I have already written which you may be interested in: What’s new in IIS 8.5…


Fast acquisition of vswhere

I introduced vswhere last week as an easy means to locate Visual Studio 2017 and newer, along with other products installed with our new installer that provides faster downloads and installs – even for full installs (which has roughly doubled in size with lots of new third-party content). vswhere was designed to be a fast,…


Accelerated Continuous Testing with Test Impact Analysis – Part 1

Continuous Testing in DevOps In older testing strategies, large software changes were tested as a complete product after a so called “release to QA”, running almost all tests just before release. We know the downsides to that. On the other hand, DevOps is all about a fast development to delivery pipeline and continuous delivery of…


Support for Google Mail, Calendar, and Contacts

Outlook for Mac 2016 Now Supports Google Calendar and Contacts (Preview) Starting in March, Office 365 subscribers receiving Insider Fast releases will have access to Google contacts and calendar by adding a new “Google” account.  Because this feature is still under development, we will be ramping up availability to customers over several weeks and actively monitor…