(Hannes du Preez) You can create an HTML Table with SQL. You make use of the ‘FOR XML RAW’ and ‘FOR XML PATH’ statements to organize the Table Body (TBODY), Table Header (THEAD) and Table Footer (TFOOT).
Author: SSWUG Research
(Jeff Smith) The 18.4 version product lines of SQL Developer, SQLcl, Data Modeler, and ORDS we’re pretty much limited to bug fixes.
(Chris Webb) A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh an
(Fred Song) In this article, you will build an Angular 7 app with .NET Core 2.2.
(Ben Nadel) For the last couple of weeks, we’ve been working to migrate some Adobe ColdFusion 10 code over to Lucee 5 code. And, we’ve been debugging little discrepancies along the way.
(kabilesh) In this blog, I will provide a step by step procedure to migrate from on-premise MySQL to Amazon RDS/Aurora using Percona-xtrabackup
(Uwe Hesse) The technique to recover only certain objects from an ordinary backup is called Virtual Access Restore.
Little things worth knowing: the latest public-yum-ol7.repo configuration file enables an upgrade to UEK R5
(Martin Bach) For a little while now I have been using Ansible for all installation/configuration tasks I do in the lab.
(Kenneth Fisher) Sometimes you need a table that is read only. You don’t want anyone to be able to write to it for various reasons.
(stewashton) I frequently use what I call “SQL templates”, where I replace multiple placeholders by calculated values. Here are two methods that don’t require a stored procedure.