Database

SQL Server and Azure SQL: How to delete or update data in large tables

November 9th, 2022
4
Query Development SQL Server Database

Azure Data Factory (ADF) - How to change the Service Objective and resize an Azure SQL Database using T-SQL commands

August 13st, 2022
0
Azure SQL Database Azure Data Factory (ADF)

SQL Server - How to synchronize data from a table between different databases using Trigger

August 13st, 2022
1
Maintenance SQL Server Database

SQL Server - How to validate email and email domain using SQLCLR (C#)

26 May 2022
2
Database CLR SQL Server Data Formatting and Validation

SQL Server - How to unlock a login without having to change/reset the password

SQL Server - Password Policies, Password Expiration, Mandatory Password Change, and Login Lockout after N attempts

SQL Server - How to speed up your queries by changing server power setting

Azure SQL Database - How to create and manage users and logins with SQL authentication and Azure Active Directory (Azure AD)

SQL Server – ISNULL x COALESCE: Knowing the Differences Between the Two Functions

SQL Server and Azure SQL Database - How to return CPU and Memory usage using T-SQL

2 May 2022
0
SQL Server Database Maintenance Monitoring