(Marcelo Altmann) In this 101 article, I will show how to drop/remove a column from a table in MySQL.
Community
Azure SQL Data Warehouse and Backups
(blobeater) Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills and no doubt you will (one day) create Azure SQL Data Warehouse (DW) in Azure.
Tips and tricks to cut your SQL Server cloud costs
(Lindsay Moore) Running SQL Server in the cloud can be expensive, but it doesn’t have to be. These tips show you where wasteful spending happens and how to keep your database cloud bill low.
Troubleshooting Problems With Native (Off-Heap) Memory in Java Applications
(Misha Dmitriev) Are you having trouble with native (off-heap) memory in your Java applications? Check out this post on how to troubleshoot those problems.
Replacing Double-Dashes With Em Dashes While Typing In JavaScript
(Ben Nadel) One of the little delighters that I see many applications baking into their user experience (UX) is the auto-injection of Em Dashes whenever the user enters two normal dashes (hyphens) in a row.
‘Suck it and See’ development – A DB2 Support Nightmare!
(Mark Gillis) This could be strongly related to the Support Nightmare #1, but not necessarily always. We have many clients who have rigorous change and version control procedures, where nothing goes into a downstream environment until it’s been tested and signed off and where database changes to giv
Advisory serializing/deserializing a CultureAwareComparer with .NET Framework 4.6+
(Rich Lander) An issue with serializing/deserializing a CultureAwareComparer was discovered with .NET Framework 4.7.1. This issue was resolved earlier this year, with the May 2018 Preview of Quality Rollup.
SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid
(Pinal Dave) I was helping a client to install SQL Server using script/automation (without using UI). They wanted to do command-line install rather than hitting next, next, fill values in the UI as they have to deploy more than 100 servers with SQL installed on it.
What’s New in Visual Studio 2017 15.8
(David Ramel) New features in Visual Studio 2017 15.8 focus on productivity and performance.
Using –login-path with MySQL Cluster Manager
(Thomas Nielsen) Recent versions of MySQL has an added security feature, the –login-path option. This feature puts your username and password in an encrypted file, and you refer clients to this file instead of typing plain text passwords on the console, or putting them in scripts.