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

How to find WordPress theme’s stylesheet handle

A few moments ago, I wanted to append an inline style to the theme’s stylesheet from within a plugin. This requires knowing the current theme’s stylesheet handle, so here is a function that finds that string. private function find_theme_stylesheet_handle() { global $wp_styles; foreach( $wp_styles->registered as $handle => $style_obj ) { if( $style_obj->src === get_template_directory_uri() .… Continue reading How to find WordPress theme’s stylesheet handle

Published
Categorized as How to

How to fix WordPress filter robots_txt not working

WordPress provides a filter hook, robots_txt, that dynamically generates robots.txt if the file does not exist. This filter allows developers to create unique robots.txt files for each site in a multisite network, since all the sites in the network share the same root directory (and therefore the same robots.txt file). If this filter is not… Continue reading How to fix WordPress filter robots_txt not working

Published
Categorized as How to

How To Market An Event On Twitter

While writing the companion piece, What It’s Like To Co-Organize Your First WordCamp, I realized that I had created a list of Twitter marketing tips that should really live in their own post. Here’s that. I run a number of Twitter accounts, and some people seem to enjoy following them. A few of them, @LititzBeerFest and @WordCampLanc promote… Continue reading How To Market An Event On Twitter

Published
Categorized as How to

aspSmartUpload.dll usage

aspSmartUpload.dll Q&A Frequently asked questions IIS7 installation and configuration Registry key and properties Troubleshooting errors Downloads and official documentation What is aspSmartUpload.dll? A 32-bit library to facilitate file uploads via ASP Classic and IIS. Will aspSmartUpload.dll work on Windows Server 2008 64 bit with IIS7? Yes. IIS7 Installation and configuration Install at C:\Windows\SysWOW64\ Register the… Continue reading aspSmartUpload.dll usage

Published
Categorized as How to