Troubleshooting VS Code, xDebug, and Laravel Valet on macOS

Problem: xDebug is not showing up in phpInfo() output Run <?php phpInfo(); in a browser and look for “with Xdebug” like is shown near the bottom left of this screenshot: There’s also a large section of xDebug settings near the bottom of the page. Here’s mine: If you do not see xDebug in these locations… Continue reading Troubleshooting VS Code, xDebug, and Laravel Valet on macOS

Extract WordPress databases and files with exfil

I have written and released a bash script that extracts WordPress websites and updates their local copies in my computer. It’s called exfil, it’s free and open-source, and lives on Github at https://github.com/csalzano/exfil/. To celebrate it’s release, I demoed exfil at the August 2020 burbswp.com virtual meetup, “What I’ve Learned Since Lockdowns Started”. I plan… Continue reading Extract WordPress databases and files with exfil

Published
Categorized as News

Entries To Google Sheet

I’ve built an add-on for Gravity Forms called Entries to Google Sheet. It’s a WordPress plugin I plan to begin selling later this year. I’m announcing it now to begin collecting email addresses and feedback before the launch. https://entriestogooglesheet.com

Published
Categorized as News

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