SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: May 2022

Back to Archive

SQL Server - How to Validate Email and Email Domain Using SQLClr (C#)

May 26, 2022 14 min read

Continue reading

Voucher to Take a Microsoft Certification Exam for Free - Including the PL-300 Power BI

May 24, 2022 3 min read

Continue reading

SQL Server - How to unlock a login without changing/resetting the password

May 21, 2022 2 min read

Continue reading

SQL Server - Password Policies: Expiration, Mandatory Change and Login Lockout After N Attempts

May 21, 2022 11 min read

Continue reading

DataOps - DevOps applied to data projects (Power BI, Azure Data Factory, Azure Analysis Services and Database Objects)

May 19, 2022 1 min read

Continue reading

Invitation to the Live "Is a college degree important in the tech industry?" - May 20th at 8PM

May 18, 2022 1 min read

Continue reading

Live #45: Best Practices for Administering Databases on Azure (05/17 at 9 PM)

May 18, 2022 1 min read

Continue reading

SQL Server - How to increase query speed by changing the server power plan

May 17, 2022 6 min read

Continue reading

Top 25 Best SQL Blogs in the World

May 13, 2022 2 min read

Continue reading

Azure SQL Database - How to Create and Manage Users and Logins with SQL and Azure Active Directory (Azure AD) Authentication

May 13, 2022 11 min read

Continue reading

SQL Server - ISNULL vs COALESCE: Understanding the Differences Between the Two Functions

May 8, 2022 6 min read

Continue reading

SQL Server and Azure SQL Database - How to Return CPU and Memory Usage Using T-SQL

May 3, 2022 4 min read

Continue reading

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

May 2, 2022 6 min read

Continue reading

SQL Server - How to identify and monitor trigger execution

May 2, 2022 7 min read

Continue reading