Tag: sql-server

Data change capture based on SQL Server

Typical uses Typical uses of change capture are defined in Microsoft’s official documentation Change Data Capture uses SQL Server Agent to record inserts, updates, and deletes that occur in a table. A typical example of a data consumer targeted by this technology is extract, transform, and load (ETL) applications. ETL applications incrementally load changed data […]

Solution and code for connecting to SQL Server using Java

The following shows the entire process of connecting to the SQL Server database: Load database driver Establish database connection Execute SQL statement process result close connection Before connecting, the premise is to ensure that the database is successfully downloaded, created, and the account and password are configured. Code that runs successfully: import java.sql.*; public class […]

Django migration file computer cannot access mysql on the virtual machine [django.db.utils.OperationalError: (2003, “Can’t connect to MySQL server …

(env) D:\python_learn\meiduo_project\meiduo_mall>python manage.py makemigrations Traceback (most recent call last): File “manage.py”, line 22, in execute_from_command_line(sys.argv) File “D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py”, line 401, in execute_from_command_line utility.execute() File “D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py”, line 377, in execute django.setup() File “D:\python_learn\meiduo_project\env\lib\site-packages\django\__init__.py”, line 24, in setup apps.populate(settings.INSTALLED_APPS) File “D:\python_learn\meiduo_project\env\lib\site-packages\django\apps\registry.py”, line 114, in populate app_config.import_models() File “D:\python_learn\meiduo_project\env\lib\site-packages\django\apps\config.py”, line 211, in import_models self.models_module = import_module(models_module_name) File “D:\Python\Python38\lib\importlib\__init__.py”, line […]

C# database (2)-sql server

2. Advanced operations 2.1. Three paradigms of database design 2.1.1. Paradigm principle: 2.1.2. Paradigm 2 principle: 2.1.3. Connection query 2.2. Table relationship 2.2.1, one-to-many 2.3. Introduction to sample database 2.3.1, Account information table 2.3.2, Bank card 2.3.3. Transaction information table Records of deposits and withdrawals of money 2.3.4. Transfer information table 2.3.5. Status information change […]

Steps to install MySQL Server in Windows 11 environment (recommended collection)

Directory illustrate: There are several problems you may encounter: 1. Download the installation package 2. Installation 3. Tool connection Description: If there is already a MySQL database on your computer, there is no need to install it, whether it is Windows, Linux or Docker, whether it is 5.7 or 8.0. If the MySQL database that […]

Sql Server data query optimization

Directory Key points for writing query statements Reasons for slow query speed: How to optimize queries: Key points for writing query statements To optimize the query, you should try to avoid full table scans, and first consider creating indexes on the columns involved in where and order by. You should try to avoid using the […]

Install SQL Server on CentOS and achieve public network access to the database through cpolar intranet penetration

Article directory Preface 1. Install sql server 2. LAN test connection 3. Install cpolar intranet penetration 4. Map sqlserver to the public network 5. Public network remote connection 6. Fixed connection public network address 7. Use a fixed public network address to connect Foreword In a few simple steps, you can install and deploy a […]

Linux centos installs SQL Server database, and combines cpolar intranet penetration to achieve public network access

Article directory Preface 1. Install sql server 2. LAN test connection 3. Install cpolar intranet penetration 4. Map sqlserver to the public network 5. Public network remote connection 6. Fixed connection public network address 7. Use a fixed public network address to connect Foreword In a few simple steps, you can install and deploy a […]