(Michael McLaughlin) It’s been a couple releases trying to fix the following error thrown by SQL Developer on Fedora 30 and shown as the following dialog:
Community
Restoring a lost Datafile on a Standby Database and knowing about V$RECOVER_FILE
(Hemant K Chitale) Continuing with my configured Standby database ….
All the best combined: Cloud, Db2, Python, Serverless and Security
(Henrik Loeser) Earlier this year, I wrote about how to use an API key or access token to connect to Db2 (on Cloud). Today, I am going to show you how to set up a service ID (technical user) on IBM Cloud, assign it a Db2 user ID (see screenshot) and grant database privileges.
What is the datatype SQL_VARIANT
(Kenneth Fisher) The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. So a date, decimal, int, varchar etc. can be stored in this single data type. This sounds great right? Well there are a few issues here.
Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ
(lukaseder) SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR JSON syntaxes. This is really convenient and less verbose than the standard SQL/XML or SQL/JSON APIs – although the standard ones are more powerful
Introducing MVVM Architecture in JavaScript (TypeScript Edition)
(Volodymyr Kopytin) The project explains MVVM design pattern implementation in JavaScript front-end application.
Load Data Lake files into Azure Synapse Analytics Using Azure Data Factory
(Ron L’Esteve) In my previous article, Azure Data Factory Pipeline to fully Load all SQL Server Objects to ADLS Gen2, I demonstrated how to create a dynamic, parameterized, and meta-data driven process to fully load data from a On-Premises SQL Servers to Azure Data Lake Storage Gen2.
Data Clustering with K-Means++ Using C#
(James McCaffrey) Data clustering is the process of grouping data items so that similar items are in the same cluster. In some cases clustered data is visually examined by a human to see if any interesting patterns have emerged.
Why We’re Debugging MySQL Server and How?
(Tomer Shay) Building MySQL from its source code sounds like something you won’t normally do, though it can be useful for several scenarios:
Making a Small Lotto Game in VB.NET
(Hannes DuPreez) If you are one of the many unlucky ones who has never won anything in a lottery, well, this article is for you. Because I didn’t win the lottery so that I could live a more comfortable life without stress and being tired all the time because of the three jobs I do, I decided to see