[MSSQL]Kill session

kill_session_mssql.pdf

Migration de sqlserver vers postgresql

Un bon guide à suivreHow to Convert SQL Server to PostgreSQL – Complete Migration Guide.PDF

https://dbconvert.com/blog/sql-server-to-postgresql-migration-guide/

[SQL SERVER] Practical guidance to make your tier-1 SQL Server roar - BRK3155

Yes we are in 2025 but this is sill under review ! 

PRACTICAL GUIDANCE

[MSSQL] Disable/Enable FK

disable FK

DECLARE @sql NVARCHAR(MAX) = N'';

;WITH x AS 
(
  SELECT DISTINCT obj = 
      QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.' 
    + QUOTENAME(OBJECT_NAME(parent_object_id)) 
  FROM sys.foreign_keys
)
SELECT @sql += N'ALTER TABLE ' + obj + ' NOCHECK CONSTRAINT ALL;
' FROM x;

EXEC sp_executesql @sql;

enable FK 

DECLARE @sql NVARCHAR(MAX) = N'';

;WITH x AS 
(
  SELECT DISTINCT obj = 
      QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.' 
    + QUOTENAME(OBJECT_NAME(parent_object_id)) 
  FROM sys.foreign_keys
)
SELECT @sql += N'ALTER TABLE ' + obj + ' WITH CHECK CHECK CONSTRAINT ALL;
' FROM x;

EXEC sp_executesql @sql;

Découpage fichiers BDD MSSQL

split_db_mssql.pdf

Check READ ONLY MSSQL

check_read_only_MSSQL.pdf

Voir les comptes de l'AD

PS C:> get-adgroupmember _DIR_DBA | select name

Mise en place d'un cluster SQL Server avec Always ON

JJLOGDB_SQLServerClustering.pdf

Utiliser Powershell pour envoyer une notification par e-mail pour le basculement de cluster SQL Server

source

Surveiller les noeuds d'un cluster SQL via un script powershell

Pour voir le script, cliquer sur lire la suite.