Author: Pio Balistoy

Migrating SQL Server On-Premise to Azure SQL

Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. Let’s break them down into sections in case you want to jump to specific ones. Deployment Options SQL…

Read More >

How To Export Collections in SCCM to CSV Using Powershell

Your mission: Gather a list of servers in a specific collection on System Center Configuration Manager (SCCM) so you or your client can verify the servers in the collection. How will you do it? First, a disclaimer. I’m a data…

Read More >

Ten Tips When Working from Home During These COVID-19 Times

During COVID-19, business is no longer as usual. Recently I have had a few contacts ask me for tips on how to work remotely. Why? Well, I have been working from home for ten years now. Working remotely is just…

Read More >

Webinar | Azure SQL Database: Serverless & Hyperscale

I wrote a blog post on this subject last year when Azure SQL Database Serverless was first introduced. This year I was excited to present it for Microsoft Ignite: The Tour Singapore before it was canceled because of the growing…

Read More >

How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…

Read More >

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 >

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 >
Page 2 of 3123