sql server

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

August 13st, 2022
0
Database SQL Server Maintenance

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

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

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

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
Monitoring Database SQL Server Maintenance

SQL Server - How to identify the query that triggered a DML trigger on a table

SQL Server - How to identify and monitor the execution of triggers

SQL Server and Azure SQL Database: How to Identify Key Lookup occurrences through the plancache

April 14th 2022
0
Azure SQL Database Database SQL Server Performance tuning Maintenance