(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.
Other News
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
AI-powered Search with spaCy — Part 15
In this part, we’ll continue with the discussion on how you might conduct an AI-powered search to discover phrases (certain sequence of tokens in a sentence) that satisfy a certain syntactic dependency pattern or several patterns at once. In the previous parts, you learned how this concept can be implemented when you are given a set of words describing a...
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
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
Post-Build Events and .NET Core
(Jeremy) I have used post-build events in Visual Studio for a long time, primarily to copy files from one location to another. But due to changes in how we work with .NET Core, I have changed the way I write build events.