(Pinal Dave) Having a scattered Microsoft SQL Server database platform is cumbersome to maintain, as you continue to accumulate waste capacity to your database servers.
Community
Your ORM and SELECT FOR UPDATE
(Baron Schwartz) If you use a programming language framework such as Django or Ruby on Rails, chances are you use an ORM to help you construct queries.
Intro: Initial Thoughts On Oracle Autonomous Database Cloud Services (Automatic For The People)
(Richard Foote) I’m currently writing up a few blog pieces on indexing in the Oracle Autonomous Database environments, but I thought I’ll begin by introducing what exactly are Oracle Autonomous Database Cloud Services and some of my initial thoughts, as there’s still some confusion on all this.
Error (CLSD|CLSU-00100|CLSU-00103: error location: sclsdgcwd2|CLSD00183) Running ggsci
(mdinh) Rant: Any application requiring strace for a simple problem to determine root cause is poorly written.
Lateral view decorrelation(VW_DCL) causes wrong results with rownum
(Sayan Malakshinov) Everyone knows that rownum in inline views blocks many query transformations, for example pushing/pulling predicates, scalar subquery unnesting, etc, and many people use it for such purposes as a workaround to avoid unwanted transformations(or even CBO bugs).
Understanding JSON Web Tokens (JWT)
(Vivek Kumar) JSON Web Token is known as JWT. It is an open standard that is used for transmitting information between parties as a JSON object. JWT is a secure way for Authentication and Authorization because it is digitally signed.
Dem queries
(Kenneth Fisher) Dem queries, dem queries, dem slow queries, Dem queries, dem queries, dem fast queries, Dem queries, dem queries, dem big queries, Now write dem crazy queries!
Shrinking SQL Server Backup Files and Speeding Up Backups
Microsoft first introduced backup compression in SQL Server 2008. With backup compression you can speed up our backups, while making your backups smaller.
Digital ethics, trusted AI and IBM
(Henrik Loeser) Last week I gave a talk followed by a discussion at a university. The presentation was about the current state of Artificial Intelligence (AI) and AI research topics. A good chunk of the discussion was dedicated to fairness, trust and digital ethics. In the following, I am sharing so
Java XML and JSON: Document processing for Java SE, Part 2
(Jeff Friesen) In this post, we’ll continue exploring XML and JSON in Java 11 and beyond.