SQL Server - How to validate email and email domain using SQLCLR (C#) 26 May 2022 2 Database CLR Data Formatting and Validation SQL Server
SQL Server - How to unlock a login without having to change/reset the password 21 May 2022 0 Database Maintenance SQL Server
SQL Server - Password Policies, Password Expiration, Mandatory Password Change, and Login Lockout after N attempts 21 May 2022 0 Database Security SQL Server
SQL Server - How to speed up your queries by changing server power setting 17 May 2022 2 Database Maintenance SQL Server
SQL Server – ISNULL x COALESCE: Knowing the Differences Between the Two Functions 8 May 2022 0 Database Query Development SQL Server
SQL Server and Azure SQL Database - How to return CPU and Memory usage using T-SQL 2 May 2022 0 Database Maintenance Monitoring SQL Server
SQL Server - How to identify the query that triggered a DML trigger on a table 2 May 2022 0 Database Monitoring SQL Server
SQL Server - How to identify and monitor the execution of triggers 2 May 2022 0 Database Monitoring SQL Server
SQL Server – Beware of server role securityadmin! Using privilege elevation to become sysadmin April 18th 2022 0 Database Security SQL Server
SQL Server and Azure SQL Database: How to Identify Key Lookup occurrences through the plancache April 14th 2022 0 Azure SQL Database Database Maintenance Performance tuning SQL Server