Giới thiệu và Cài đặt SQL Server 2025

docker run -e "ACCEPT_EULA=Y" \
           -e "MSSQL_SA_PASSWORD=YourStrong!Passw0rd" \
           -e "MSSQL_PID=Developer" \
           -p 1433:1433 \
           --name sql2025 \
           -d mcr.microsoft.com/mssql/server:2025-latest

# SQL Server 2025 trên Linux container — nhẹ, nhanh, dễ CI/CD
docker run -e "ACCEPT_EULA=Y" \
           -e "MSSQL_SA_PASSWORD=YourStrong!Passw0rd" \
           -e "MSSQL_PID=Developer" \
           -e "MSSQL_COLLATION=SQL_Latin1_General_CP1_CI_AS" \
           -p 1433:1433 \
           --name sql2025 \
           --memory=4g \
           --cpus=4 \
           -v sqldata:/var/opt/mssql \
           -d mcr.microsoft.com/mssql/server:2025-latest

# Tạo bằng Azure CLI
az sql server create --name my-sqlserver \
    --resource-group my-rg \
    --location southeastasia \
    --admin-user sqladmin \
    --admin-password "StrongPass123!"

az sql db create --resource-group my-rg \
    --server my-sqlserver \
    --name mydb \
    --service-objective S0 \
    --compute-model Serverless \
    --min-capacity 0.5 --max-capacity 2 \
    --auto-pause-delay 60

Server: localhost  (hoặc localhost,1433 nếu cổng khác)
Auth:   SQL Server Authentication
Login:  sa
Pwd:    [password đã set]

SELECT @@VERSION;
-- Microsoft SQL Server 2025 (RTM) - 17.x.x ...

SELECT @@SERVERNAME, DB_NAME(), SUSER_SNAME();

CREATE DATABASE LearnSqlServer;
GO

USE LearnSqlServer;
GO

CREATE TABLE Greetings (
    Id   INT IDENTITY PRIMARY KEY,
    Text NVARCHAR(200) NOT NULL,
    CreatedAt DATETIME2 DEFAULT SYSUTCDATETIME()
);

INSERT INTO Greetings (Text) VALUES (N'Xin chào SQL Server 2025!');

SELECT * FROM Greetings;

ALTER USER sa WITH DEFAULT_SCHEMA = dbo;

ALTER DATABASE LearnSqlServer
SET QUERY_STORE = ON (OPERATION_MODE = READ_WRITE);

-- Khi tạo DB
CREATE DATABASE LearnSqlServer
COLLATE Vietnamese_CI_AS;     -- CI = case insensitive, AS = accent sensitive

-- Đổi sau
ALTER DATABASE LearnSqlServer
COLLATE Vietnamese_CI_AS;