Blue Monday: MySQL Native In Web Apps; Use JSON In SQL Server
Web App native MySQL instances are in public preview; use JSON to CRUD your Azure SQL Sever records ...
Tag: MySQL
The Fault In WordPress Security Lies Not In The Updates, But In Ourselves
Automatic updates of plugins and themes won't make WordPress better; less reliance on third-party plugins and themes would. Both are pipe dreams.
Efficiency vs. Good Design: When NULL Is Not A (Wise) Option
If you find yourself using NULL MySQL database columns, you're trading at-best minuscule performance boosts for a litany of trouble from bad design.
Setting Up Scalable WordPress Installs On Microsoft Azure
A walkthrough on setting up Scalable WordPress installs on Microsoft Azure -- even though other cloud providers are a better choice.
Using WordPress Transients To Speed Up Your PHP-Heavy Templates: Introduction
Transients allow us to "selectively cache" parts of a WordPress template, speeding up your pages and reducing errors.
Microsoft’s Advice On Avoiding SQL Injection Attacks
Sanitize and normalize those inputs; grant and use the bare minimal permissions needed for a task.
The Basics Of Avoiding MySQL Injection Attacks In ASP.NET Web Forms
Never send unescaped arguments to a MySQL command, even if you're using ASP.NET.
How To Increment A Counter In MySQL Based On A Radio Button Click
You want to count how many times an element on your page was clicked. There's two ways to do it: with a PHP postback and, of course, via JavaScript with an AJAX...
Automatically Hash Tagging Text With PHP And MySQL Part 2: Adding New Hash Tags To The Database Table
Expanding on my earlier post about auto-hashtagging text: Now, we can put the hashtagged text into a MySQL table.
Automatically Hash Tagging Text With PHP And MySQL
Use PHP to extract terms from a MySQL database table and automatically tag an input string with those terms.