Dirceu Resende - DBA SQL Server and BI Analyst (PowerBI, SSAS, SSIS, SSRS)

Dirceu Resende - SQL Server, Azure and BI Expert Consulting

TOP 25 best SQL blogs in the world!

13 May 2022
2
Uncategorized

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

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 – 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

Azure SQL Database - How to view automatic backup history

April 14th 2022
0
Azure SQL Database

SQL Server - How to identify all missing indexes (Missing indexes) of a database

April 7th 2022
0
Database DMVs and Catalog Views Maintenance Performance tuning SQL Server