Tag: sql

The back-end

Learn more about how multithreading works

January 16, 2024

by Noah Castillo

No Comments

Improve manageability of threads: Threads are scarce resources. If created without limit, they will consume resources and reduce system stability. Thread pools can be used...

Read More

reading

MaxCompute Initial user experience

January 16, 2024

by Madison Johnson

No Comments

As a first-time user of MaxCompute, I know a lot. Out of the box, MaxCompute has an integrated interface that you don't have to worry...

Read More

The back-end

Hadoop stable release: DKHadoop

January 16, 2024

by George Kerr-Allen

No Comments

Hadoop is already very familiar to those who work on the Internet. I believe there are many people around us who are switching careers to...

Read More

reading

SQL Server- COMPILE – when OPTION(COMPILE) is used

January 16, 2024

by Julie Best

No Comments

WHERE Column= @param OR @param IS NULL WHERE Column= @param IS NULL WHERE Column= @param IS NULL WHERE Column= @param OR @param IS...

Read More

The back-end

SQL Server 2016 installation and configuration for MSSQL penetration environment

January 16, 2024

by Ms. Sara Sexton

No Comments

Operating system: Windows Server 2019 Standard Download SQL Server 2016 Installation file Download SQL Managerment Studio The installation starts

Read More

The code of life

IOS programmers use paging and fuzzy query techniques to implement an App interface

January 16, 2024

by 王雅玲

No Comments

(2) MySQL provides two types of wildcards for SQL matching. (4), ^: starts with a character or a string. ^ A: starts with a (5)....

Read More

reading

The development history of Ali Cloud analytical database

January 16, 2024

by Kaitlyn Bowden-Larsen

No Comments

AnalyticDB is a cloud computing service independently developed by Alibaba, which enables you to conduct real-time multi-dimensional analysis perspective and business exploration for hundreds of...

Read More

reading

SQLServer index introduction

January 16, 2024

by Keith Johns

No Comments

An index is an on-disk structure associated with a table or view that speeds up the retrieval of rows from a table or view. Indexes...

Read More

reading

How to read source code quickly

January 16, 2024

by 嶽靜宜

No Comments

XML: Configuration, Environments, transactionManager, dataSource, mappers And what do the attributes of these tags mean? Let's see the implementation of SqlSession! SqlSession has two implementation...

Read More

The back-end

What a lie! Is new index in SQL optimization really better than Explain? Interviewer: You go out

January 16, 2024

by 錢佩珊

No Comments

A few days ago the boss asked me how to carry out SQL optimization, I answered the new index. Ha ha ha, then the boss...

Read More

reading

SQLMap (Part1)

January 16, 2024

by Cody Todd

No Comments

When it comes to SQL injection, the first thing that comes to mind is SQLMAP, an open source tool for SQL injection detection and utilization....

Read More

reading

WordPress4.2.3 Rights Raising and SQL Injection Vulnerability (CVE-2015-5623) Analysis

January 16, 2024

by Timothy Jones

No Comments

This is a bug that has been on my mind for a few days. Wordpress released version 4.2.4 last week, which fixes possible SQL vulnerabilities...

Read More

reading

JSON data migration from MongoDB to MaxCompute best practices

January 16, 2024

by Mark Martin

No Comments

This article shows you how to extract JSON fields directly from MongoDB to MaxCompute using DataWorks data integration. First you need to upload the data...

Read More

reading

For product operations and other non-technical students SQL tutorial

January 16, 2024

by 張婷婷

No Comments

The main goal of this article is to help beginners quickly get started with SQL queries to solve 80% of the SQL query problems in...

Read More

reading

SQLServer to create scalar functions

January 16, 2024

by Brittany Robinson

No Comments

Create user-defined functions in SQL Server and Azure SQL Database. User-defined functions are Transact-SQL or common Language runtime (CLR) routines that take parameters, perform operations...

Read More

The back-end

MaxCompute understands data, operations, and the user’s brain: a cost-based optimizer

January 15, 2024

by Arnav Mane

No Comments

Abstract: Looking back on the big events in the field of big data technology, the earliest date can be traced back to the official launch...

Read More

reading

The next generation of big data processing engine, Ali Cloud real-time computing exclusive mode was released

January 15, 2024

by Anay Agarwal

No Comments

On November 14, Ali Cloud released the real-time computing exclusive mode, which means that users can share part of physical resources independently from other users...

Read More

reading

Windows Security Log Analysis logParser

January 15, 2024

by Leslie Hansen-O'Neill

No Comments

In the process of work, especially in emergencies, you need to analyze Windows security logs when encountering security events related to the intrusion of Windows...

Read More

The development tools

Black tech behind Singles’ Day: How big data real-time computing can be customized for you?

January 15, 2024

by 張雅惠

No Comments

In the era of data, big data computing has penetrated into all walks of life. Business precipitates data and data computing generates new business value....

Read More

reading

Time is running out for traditional DBAs? See ele. me how to build database platform automation

January 15, 2024

by Kathryn Webster

No Comments

My name is CAI Peng. I joined Ele. me in 2015 and witnessed the development process of ele. me business and technology from zero to...

Read More

reading

Large attribution + small attribution, first rise network to help you restore the true value of SEM

January 15, 2024

by Fiona Atkinson

No Comments

Search Engine Marketing (SEM) can help enterprises show brand, promote activities, and drainage to their own platform, bring business transformation, so enterprises pay more attention...

Read More

The back-end

DoNet development tools necessary for efficient development

January 15, 2024

by Christopher Decker

No Comments

If you want to do a good job, you must first sharpen your tools. Without good tools, how can you develop high-quality code efficiently? This...

Read More

reading

NoSql is a survival of the fittest

January 15, 2024

by Kiara Manda

No Comments

NoSql on wikipedia is "non SQL" or "non relational", which translates to non-SQL or non-relational. We usually interpret it as Not only SQL, Not only...

Read More

The back-end

New Java8 features you should know about!

January 15, 2024

by Barry Hill

No Comments

The release of Java8 is clearly a milestone release for Java developers, with a number of exciting new features that, if taken advantage of, can...

Read More

Artificial intelligence (ai)

Kaiyuan Big Data Weekly – Issue 31

January 15, 2024

by Alia Andra

No Comments

In the "Open Source Big Data Technology Special Session" of hangzhou Cloud Computing Conference 2016, Yang Zhi, head of Pear Video Big data, brought the...

Read More

The back-end

Shen Jian chat micro service: do your service split first

January 15, 2024

by Mr. Matthew Thomas

No Comments

With the development of automation and other related technologies, microservices become easier to manage, which gives a good opportunity for the development of microservices architecture....

Read More

reading

Single example of 100 billion telecom big data scenario, using Spark+CarbonData to replace the Impala case

January 15, 2024

by Kelly Vincent

No Comments

This article mainly introduces how to use Spark + CarbonData to replace impala solution, technology selection introduction, implementation effect, etc

Read More

The development tools

Received boss demand at 8:00 PM on the subway: Draw out the relationship of more than 400 tables for the customer tomorrow morning!

January 15, 2024

by Rebecca Davies-Grant

No Comments

1. Background: I was working on a project recently, so I got off work a little late. I used to take out my Ipad and...

Read More

reading

That’s a good summary! SQL Join Join; SQL Join

January 15, 2024

by Saira Mahal

No Comments

The SQL JOIN clause is used to JOIN rows from two or more tables based on the common fields between the tables. SQL LEFT JOIN;...

Read More

The front end

Think of GraphQL in terms of interfaces

January 15, 2024

by 陳志豪

No Comments

An interface is a definition of behavior that defines the interface through which the system interacts. The entity of the behavior is the function, which...

Read More