A look at new features Azure SQL Database Serverless and Hyperscale

Last May, the Microsoft Build 2019 conference took place in Seattle. A number of new features and capabilities were announced and demonstrated. This week, communities in the Asia Pacific held their own version of Build, bringing the best and the…

Read More >

Fix: SQL Server to PostgreSQL Linked Server Error – “Requested conversion is not supported.”

Problem: You created a linked server on SQL Server to a PostgreSQL database. You can open and navigate the linked server on SSMS up to listing the tables, but can not perform select to certain tables, returning the below errors:…

Read More >

Five ways to migrate your on-premises SQL database to Azure

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

Read More >

How to fix SQL backup to URL error: The remote server returned an error: (400) bad request

Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…

Read More >

How to fix SQL backup to URL failure – operating system error 50

Problem: You run an SQL backup to URL and get the following error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks_full_20190420.bak’. Operating system error 50(The request is not supported.). Msg 3013, Level 16, State 1,…

Read More >

How to fix SSIS deployment error “please create a master key”

Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to the point: “Please create a master key in the database or…

Read More >

How to restore SSISDB to another server and migrate the SSIS catalog

It is easy to get this one wrong. SSISDB is just a database, after all, and I’ve seen a number of instances where it was restored to another server and a number of errors/issues crop up. After all, SSISDB is…

Read More >

How to solve an SSIS Deployment Error

Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and it keeps on failing with the following error: The error seems daunting but the main information to take away is: The server may be running…

Read More >

Microsoft Ignite 2018 special cloudscape podcast

This episode of the Cloudscape podcast is dedicated to the announcements that were made at the recent Microsoft Ignite 2018 conference. We are joined solely by Warner Chaves to walk us through the most important and exciting announcements from the…

Read More >

Microsoft SQL Server 2019: data platform in a box

I’m writing this blog post the day after Microsoft has unveiled SQL Server 2019 at their flagship Ignite 2018 conference. Officially named SQL Server 2019, it comes hot off the heels of the SQL 2017 release. This should be no…

Read More >
Page 1 of 2112345...10...Last Page »