Using Query Store in SQL Database V12

Recently the SQL Product group released Query Store for SQL Database V12. The basic concept and usage is explained in this blog post. SQL Server Management Studio (SSMS) for SQL 16 has also been released as a standalone download (available here) so that SQL Database V12 customers can install it independently of the SQL Server…

0

Stopping or Postponing an upgrade to SQL Database V12

As a customer running SQL Database on V11, you might have received an email informing you are about a scheduled upgrade of your database to V12 on a specific date. This will also be reflected in the portal.  It will look like the following. **** UPDATE 8/6/2015 **** Upgrades for Web & Business edition databases…

2

Configuring the firewall for Client Access

YouTube Video (Better Quality) Information good as of 4/29/2015 and is subject to change! We get questions regarding client access to someone’s Azure SQL Database.  I wanted to go through and show what options you have to configure the firewall to allow access to known clients.  To start with, you may see an error, like…

0

BACPAC: Could not load schema model from package

When trying to import a BACPAC file, you could run into the following error. Count not load schema model from package. (Microsoft.SqlServer.Dac) Additional Information: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid…

5