(Carlos Tutte and marcos.albe) During our work in support, we see this again and again: “I try to connect to MySQL and am getting a 1045 error”, and most times it comes accompanied with “…but I am sure my user and password are OK”.
Community
GoLang: Querying records from Oracle Database using goracle
(brendantierney) Continuing my series of blog posts on using Go Lang with Oracle, in this blog I’ll look at how to setup a query, run the query and parse the query results.
Swapping (paging) for DBAs
(savvinov) Classic symptoms of memory pressure (free physical memory running low + swapping) are often more difficult to interpret than they seem, especially on modern enterprise grade servers.
Database Migration from non-CDB to PDB – The Minimal Downtime Challenge
(Mike.Dietrich) There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well.
SQL SERVER – Changing Max Worker Count for Performance
(Pinal Dave) Earlier this week, I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I got quite a lots of questions via email, LinkedIn and on Twitter to share my when it is appropriate to change Max Worker Count.
Json: A Fairly Powerful JSON Engine in a Small Package
(honey the codewitch) Use JsonPath, and builtin RPC support to easily communicate with all the JSON / REST services out there, or otherwise manipulate JSON with this little library.
Using Function LocalMode Modern To More-Safely Render ColdFusion Templates In Lucee 5.3.2.77
(Ben Nadel) Historically, when you set an unscoped, non-var’ed variable inside a ColdFusion Function, the variable is applied to the variables scope (except for when that assignment is inside a CFThread tag).
Troubleshooting MySQL InnoDB Cluster GTID Inconsistency
(Ivan Ma) This tutorial is showing how manual fix of GTID inconsistency but it can be VERY RISKY to mess up the InnoDB Cluster.
Index Partitioning
(Jagruti Jasleniya) In previous article we saw what is partitioning in oracle and the benefits it brings .
Find the Last Windows Server Reboot Time and Last SQL Server Restart
(Eli Leiba) I need to quickly find the last reboot time of the server and the last time the SQL Server service was restarted. In this tip we look at a simple stored procedure you can add to your SQL Server DBA toolbox to do this.