(Ben Nadel) Yesterday, we installed FusionReactor on some of our Lucee CFML servers in order to investigate curious JVM performance patterns. I’m still trying to understand what I’m seeing; but, I did notice something bizarre happening in some of the stack-traces.
Community
Back Up MySQL View Definitions
(Jesper Krogh) If you want to back up your table and views, stored procedures, or stored function definitions, you can use mysqldump or mysqlpump to export the schema without the data.
How to enable SQL Developer Web (SDW) on ORDS 19.4
(Matthias Hoys) ORDS (Oracle REST Data Services) 19.4 introduced a new feature called Oracle SQL Developer Web (SDW), a graphical user interface for querying & managing database objects.
SSIS Data Flow Parallel Processing
(Aleksejs Kozmins) In a big SQL Server data warehouse project, I had to provide an SQL Server Integration Services (SSIS) based ETL process to store historical data. The ETL flow is shown below.
Adding Angular 9 Routing and Material Design by Example
(Ahmed Bouchefra) In these steps of our Angular 9 tutorial, we’ll continue building our example app by setting up the router and adding routing for the home and about components.
Cannot Open Backup Device
(Jason Brimhall) Your success as a DBA is directly relational to your ability to ensure proper Database backups are occurring. There is a whole slew of considerations that go into effect when discussing what a proper Database backup actually is.
Running Database Console Commands (DBCCs) on Azure SQL Database
(Marcin Policht) Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands.
Dual Writes – The Unknown Cause of Data Inconsistencies
(Thorben Janssen) Since a lot of new applications are built as a system of microservices, dual writes have become a widespread issue.
Db2 for z/OS and RACF, Part 2: Db2-Internal Security
(Robert Catterall) In the Part 1 post of this two-part blog entry, I described how RACF can be used to provide “external” security for a Db2 for z/OS system – external security being concerned with who (i.e., which IDs) can connect to the Db2 system, and how (e.g., in the form of a batch program and
Refactoring Code to Use C# Local Functions
(Jason Roberts) In a previous post I talked about the potential use of local functions to replace comments. This generated some good discussion on Twitter and in the comments.