Java routinely hits inside the top five most popular programming languages and understandably so; it’s versatile, fairly easy to learn being that it’s a high-level language, and it satisfies a number of use cases.
Author: SSWUG Research
Behind the Scenes with Foreign Keys Part 2
(Mark Gillis) The previous blog (Behind the scenes with Foreign Keys part 1) was looking at the impact on your data of switching Foreign Keys (FKs) off and how to clean up the ensuing orphan data. I’m going to move on now to what can happen to your access paths regardless of any data manipulation.
Testing Performance Of Power BI Reports In The Browser, Part 2
(Chris Webb) In the first part of this series I talked about why you might want to test the performance of a Power BI report in the browser, as opposed to using Performance Analyzer in Power BI Desktop, and the different factors you have to take into account when doing this kind of testing.
Azure SQL Database – Automatic Tuning – Have you enabled it?
(blobeater) Do you enable this setting to allow automatic tuning to care of all your performance needs?
Db2 SQL for the DBA – Using Modern SQL for DBA Tasks
(Brian Laube) Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
Client-Side Caching In Angular 8 Using HTTP Interceptor
(Sarathlal Saseendran) In this post, we will see how to achieve client-side caching in Angular 8 application using HTTP Interceptor. We will create an ASP.NET Core 3.0 application with SQL server as backend to save and retrieve the employee data.
UNION vs. UNION ALL in SQL Server
(Greg Robidoux) Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for tables with similar data within the same database or maybe there is a need to combine similar data across databases or even across servers.
Database Link to 9.2 Database from 19c
(Bobby Durrett) I have mentioned in previous posts that I am working on migrating a large 11.2 database on HP Unix to 19c on Linux.
Oracle internal data dictionary oddity
(Frits Hoogland) This blogpost is about an inconsistency I found in the X$ tables X$KQFTA and X$KQFCO. This is very specific. If you don’t care about that, you can skip this post.
Getting Started with APEX Plugins
(Jeffrey Kemp) There is a great deal you can build in APEX without even thinking about using a plugin. The development platform has an excellent range of built-in functionality and components so that almost all user requirements can be covered using standard APEX features.