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

Dirceu Resende - SQL Server, Azure and BI Expert Consulting

How to Fix SQL Server Data Tools (SSDT) Installation Error 2017 – Setup Failed: Incorrect function (0x80070001)

October 4th, 2021
0
Business Intelligence (BI) Errors

Azure Data Factory (ADF) – How to create offline documentation (in CSV) of your project

October 3th, 2021
0
Azure Data Factory (ADF) Business Intelligence (BI) Powershell / CMD

SQL Server – How to list the largest tables and indexes in the database and show the size of each

October 1th, 2021
0
Database Maintenance Monitoring SQL Server

SQL Server – How to identify timeout or broken connections using Extended Events (XE) or SQL Profiler (Trace)

September 29th, 2021
0
Database Query Development SQL Server

SQL Server – Using TRANSLATE to replace multiple REPLACE

September 28th, 2021
0
Database Query Development SQL Server

Certification exam simulations? RUN AWAY FROM THEM!

September 27th, 2021
0
Career, Courses and Certifications

How to learn SQL / Azure Analysis Services (SAAS / AAS) for free – FOR FREE!

September 21th, 2021
1
Analysis Services (SSAS) Business Intelligence (BI)

How to learn Azure Data Factory (ADF) for free – FOR FREE!

September 20th, 2021
0
Azure Data Factory (ADF)

Power Week has started! 8 TOP Lectures on SQL Server, SSIS, Azure Data Factory and Power BI

June 28st, 2021
0
Events and Lectures

SQL Server - How to identify the store closest to the customer (or the distance between 2 locations) from the zip code (without API)