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 21 May 2022 0 Maintenance SQL Server Database
SQL Server - Password Policies, Password Expiration, Mandatory Password Change, and Login Lockout after N attempts 21 May 2022 0 Security SQL Server Database
SQL Server - How to speed up your queries by changing server power setting 17 May 2022 2 Maintenance SQL Server Database
Azure SQL Database - How to create and manage users and logins with SQL authentication and Azure Active Directory (Azure AD) 13 May 2022 0 Azure SQL Database Database
SQL Server – ISNULL x COALESCE: Knowing the Differences Between the Two Functions 8 May 2022 0 Query Development SQL Server Database
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