(Thomas Levesque) As a C# developer, there are obviously a lot of skills you need to master to be effective: language syntax, framework classes, third-party libraries, databases, regular expressions, the HTTP protocol, etc.
Other News
Capture DDL statements in Oracle DB
(Arun Gupta) There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database .
OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql
(Mike.Dietrich) Kudos to Robert Ortel who brought this nice misbehavior to my attention. And even though it looks like this would be an OJVM issue, it is caused by noncdb_to_pdb,sql, the script which is used to convert a non-CDB to a PDB.
RPG Academy: Database Modernization – Methodology, Part 8
(Rafael Victoria-Pereira) Now that you’ve streamlined your database, gotten rid of unnecessary columns and/or tables, and moved all or at least part of the data validation code out of your programs, you’re ready to dive a little deeper into DB2’s advanced functionalities.
Extend (Reduce/Contract/Skrink) Function for Oracle
(Simon Greener) Recently I was looking at some cadastral data with a view to working out how to polygonize the linestrings. The data contains this sort of boundary understood anomaly.
Web Service Data Integration
(David McGahey) In a previous post we wrote that every data integration and reporting task needs to start with a clear understanding of the source data.
Completing SQL. Part 1: The difficulties with parsing or tales of polishing ANTLR
(Andrey Podkolzin) I’ve been working for a company that develops IDEs for database interaction for more than five years. Before starting to write this article, I had no idea how many fancy tales would lie ahead. Thus after making 30 pages of it, I decided to group up the tales thematically and divid
Tracking Costs in Microsoft Azure via Tags
(blobeater) Moving to public cloud such as Azure, AWS or even private cloud services you need to be tracking costs and seeing if you are “effective”.
SQL Server 2019 Transact-SQL optimization tips (Part 1)
SQL Server 2019 Transact-SQL optimization tips (Part 1) Use table variables instead of temporary tables. Table variables require less locking and logging resources than temporary tables, so table variables should be used whenever possible. Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Demo App using React/Redux/Typescript and Hooks
(Sacha Barber) This is a small demo article which shows how to use React with Redux using Typescript and React/Redux hooks. It also makes use of a D3 graph and a few custom components.