(David Fitzjarrell) Sometimes conventional wisdom isn’t so conventional, or common. As a case-in-point DBAs may believe that the STREAMS pool is reserved strictly for streams processes.
Other News
SQL SERVER – Creating a Nonclustered Columnstore Index on Temp Table
(Pinal Dave) Recently I was delivering training on SQL Server Performance Tuning and during the session, I received a very simple question about the nonclustered columnstore index on a temp table.
Angular Js Components for Beginner
(R S Dodiya) How to create reusable component in Angular js. It is a good part to create component and reduce code of program in Angular js.
Db2 for z/OS: The Potential Performance Impact of 100% CPU Utilization
(Robert Catterall) Twice during the current calendar year, I’ve worked on a Db2 for z/OS performance issue that I’ve encountered at various times over the past couple of decades: a transactional Db2 for z/OS workload (versus batch – more on that in a moment) has periods characterized by major increa
Replacing ColdFusion Query-of-Query (QoQ) INNER JOIN And LEFT OUTER JOIN With Array Functions In Lucee CFML 5.3.3.62
(Ben Nadel) Earlier this week, I took a look through the InVision codebase, pulled-out several ColdFusion Query-of-Query (QoQ) examples, and then demonstrated how those query-of-queries could be re-implemented using Array functions in Lucee CFML.
The dark side of super_read_only
(Jean-François Gagné) There is an interesting feature in MySQL 5.7+: the global variable super_read_only. MySQL 5.6 and before only had the read_only global variable which is not preventing a user with SUPER privilege to write to the database.
Deploying an Oracle WebLogic Domain on a Kubernetes cluster using Oracle WebLogic Server Kubernetes Operator
(Marc Lameriks) At the Oracle Partner PaaS Summer Camp IX 2019 in Lisbon, held at the end of August, I followed a 5 day during workshop called “Modern Application Development with Oracle Cloud”.
Splitting a SQL Server Table Over Multiple Files
(Kenneth Igiri) There are situations where a SQL Server databases is handed over to you and you find that the primary data file is unnecessarily huge.
Learning Angular 8 – Lab One
(Abhishek Singh) Recently, Angular 8 versions have been released and developers stared, getting confused, with so many questions like what will be the new feature , how to upgrade, and so on.
Simple Scraping API with zenscrape
(David Walsh) So many developers believe that scraping a URL’s content is easy — just a simple curl and you’re done, right? Nope. CAPTCHAs, rate limitations, origin-specific limitations — they make getting content off the web a nightmare.