(Paul White) The ANY aggregate is not something we can write directly in Transact SQL. It is an internal only feature used by the query optimizer and execution engine.
Community
The DB2Night Show #216: Db2 LUW Problem Determination Class (3hr)
100% of our HUGE audience learned something! In show #211, Pavel shared his favorite Db2 problem determination tricks. In our special Season #10 finale, Pavel teaches his full THREE HOUR problem determination class covering his tricks, best practices, and various techniques for chasing down a variet
Install and Use C# 8 in Visual Studio 2019
(Claudio Bernasconi) Are you curious about the new language features coming in C# 8? Great, me too. C# 8 will be available starting with the release of .NET Core 3.0 in September 2019.
Developing Web Applications in .NET (Different Approaches and Current State)
(Damir Arh) There are many approaches available for developing a web application in .NET. In this article, I will give an overview of frameworks that you can choose for your .NET projects.
Java 101: Class and object initialization in Java
(Jeff Friesen) Classes and objects in Java must be initialized before they are used. You’ve previously learned that class fields are initialized to default values when classes are loaded and that objects are initialized via constructors, but there is more to initialization.
Microsoft Revamps Azure SDKs for Java, Python, JavaScript and .NET
(David Ramel) Microsoft is previewing a new set of Azure SDKs as part of a revamp undertaken as the cloud development platform has matured, allowing the company to better identify patterns and practices critical to developer productivity.
How To Restore MySQL Data Folder Using Persistent Disk Snapshots (GCP)
(Rafa Alvarez) There are already many tools for MySQL to perform backups and consistent restores, but this time I’d like to elaborate on how to take advantage of the kindness the cloud, which gives us Persistent Disk Snapshots (PSD) to restore our data set in a consistent way.
OEM 13.2 Issues
(amitzil) I’ve worked with OEM in the past, but these days I’m working with it much more than before. I have a client who uses it as their main monitoring system, so we upgraded it to 13.2, and since then I created custom alerts (metric extensions), installed patches, used it to diagnose issues and
Back to basics
(Mathias) We’re all very excited to read a new blog with a neat trick or a cool and complex feature or even a very useful undocumented function. However that is preaching to the choir.
Create and adjust the config file for AutoUpgrade 19c
(Mike.Dietrich) In this blog post here I will explain and demonstrate how you can create a sample config file and adjust it for a standard database upgrade.