Azure External Tables: Please verify that the shards are accessible

Are you getting this error from Azure SQL Server? Login failed on ServerName.database.windows.net.DatabaseName Please verify that the shards are accessible and that the credential information affiliated with external data source ExternalDataSourceName is correct. When I ran into this error while migrating a SQL Server instance to Azure and designing External Tables, it was because the… Continue reading Azure External Tables: Please verify that the shards are accessible

Published
Categorized as How to

How to fix “Computed columns are not supported with external tables for sharded data.”

This post was written the first day I encountered this error on Azure SQL Server because I could not find any web page that contained this error message. If you’re getting the error, Computed columns are not supported with external tables for sharded data. while trying to create External Tables, remove the computed column definitions.… Continue reading How to fix “Computed columns are not supported with external tables for sharded data.”

Published
Categorized as How to

Solving a Confusing MigrationBlocker While Moving to Azure SQL Database

This week, I’m altering functions and stored procedures in a SQL Server 2008 database so that it can be migrated to Azure. The Data Migration Assistant does a great job of generating reports identifying MigrationBlockers, but one type of error was vague enough to confuse me for a few minutes. Here’s an example of that… Continue reading Solving a Confusing MigrationBlocker While Moving to Azure SQL Database

Hiding Specific Terms When Creating or Editing Posts

The WordPress block editor uses the REST API to manipulate all information in the post object, so hiding terms from the category, tags, or a custom taxonomy meta box can be achieved by removing those terms from REST API responses. One hook that makes this easy is the rest_{taxonomy}_collection_params filter. Here is an example that… Continue reading Hiding Specific Terms When Creating or Editing Posts

Published
Categorized as WordPress

WordPress Memes

This is the collection of all the WordPress memes I’ve created. You Should Make Plugins Is This a PHP File? But Her Editors

Published
Categorized as WordPress

Using register_setting() and the REST API

Here is a comment I just requested be added to the bottom of the register_setting() page. If you plan to use your setting in the REST API, use both the rest_api_init and admin_init hooks when calling register_setting() instead of just admin_init. The show_in_rest argument is ineffective when hooked into admin_init alone. Corey Salzano Someday, when my comment is approved, you’ll be able to see it on… Continue reading Using register_setting() and the REST API

Published
Categorized as WordPress

Editing Terms & Term Meta with the WordPress REST API

Here are some JavaScript snippets to manipulate WP_Term objects in WordPress using the REST API and the Backbone JavaScript client library. Insert a term Delete a term This next example assumes you’ve used wp_localize_script() to make the REST API endpoint and a nonce available in an object myplugin. If you need help doing this, please… Continue reading Editing Terms & Term Meta with the WordPress REST API

Published
Categorized as WordPress