(Ben Nadel) When I recently got around to trying out the CSS property “position: sticky” for the first time, I was quite shocked at how magical it was.
Community
Practical DB2: DB2 Services for OUTQ Management
(Joe Pluta) I’ve been doing a lot more infrastructure-related tasks lately. These are not naturally my forte, and I can often use a little help from my friends.
NULL comparisons in MySQL, PostgreSQL, and SQLite
(Federico Razzoli) Any comparison involving at least one NULL operand will return NULL. This is expected, as it is implicit in how NULL works. But somtetimes developers write verbose conditions to handle NULL.
Example of coe_xfr_sql_profile force_match TRUE
(Bobby Durrett) Monday, I used the coe_xfr_sql_profile.sql script from Oracle Support’s SQLT scripts to resolve a performance issue.
Enterprise Manager 13c – Resolve Pending Status of Systems Infrastructure Server Components
(Dirk Nachbar) From time to time you can observe, that some Systems Infrastructure Server Components are turning into a “Pending Status”. Mostly the reason for this status change is not clear, a restart of the underlying Oracle Agents also doesn’t resolve this pending state.
Where’s my Oracle SQL Plan Baseline?
(Neil Chandler) No so long ago I was having fun creating SQL Plan Baselines in a old 11.2.0.3 database due to be decomissioned but which needs to keep running for a while (no doubt several years) – so minimal time/money to be expended on it.
Azure Data Catalog Register Data Source – Part 2
(Haroon Ashraf) As a Business Intelligence (BI) developer you just deployed a Data Model on Azure Analysis Services along with sourcing your Tabular Data Model through Azure SQL Database and your organization has now asked you to help them with data discovery assuming there are several data models t
How to Implement Data Polling with React, Redux, and Thunk
(Valerii Tereshchenko) In my previous article, How to load Data in React with Redux-Thunk, Redux-Saga, Suspense & Hooks, I compared different ways of loading data from the API.
Working with the IIF Statement in T-SQL
(Hannes du Preez) You can use the IIF statement to check quickly for conditions.
Indexed Views – Performance Panacea or Plight
(Jason Brimhall) An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view.