Skip to content

Dirceu Resende

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

  • Courses and Training
  • Consulting
    • BI Consulting
    • Power BI Consulting
    • SQL Server Consulting
  • File
  • Series
    • Certification
    • Security and Audit
    • Performance tuning
    • What has changed in T-SQL?
    • Data Protection
  • Jobs
  • Data Platform Events
  • About Us
  • Contact Us

Other Languages

Subscribe to a blog by email

Enter your email address to subscribe to this blog and receive notifications of new publications by email.

Join 1.697 other subscribers

Blog Views

2.834.421 views

Categories

  • Apache / .htaccess (9)
  • Database (332)
    • Azure SQL Database (4)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (315)
      • Audit (15)
      • Azure (2)
      • CLR (55)
      • Query Development (91)
      • DMVs and Catalog Views (32)
      • Errors (23)
      • Tools (12)
      • Data Formatting and Validation (24)
      • Little Known Features (19)
      • Hacks (17)
      • Integrations (31)
      • JSON, XML, CSV and Excel (7)
      • File Handling (13)
      • Maintenance (87)
      • Monitoring (39)
      • What not to do (7)
      • OLE Automation (19)
      • Performance tuning (25)
      • Python (1)
      • Security (41)
      • SQL Server Agent (11)
  • Business Intelligence (BI) (38)
    • Analysis Services (SSAS) (8)
    • Azure Data Factory (ADF) (3)
    • Microsoft (7)
    • Power BI (13)
    • Reporting Services (SSRS) (9)
  • Career and Courses (14)
  • Career, Courses and Certifications (35)
  • Cell Phones (1)
  • Events and Lectures (69)
  • News (11)
  • Programme (59)
    • C # (CSharp) (30)
    • CSS (1)
    • ERP (1)
    • javascript (1)
    • PHP (17)
    • Powershell / CMD (10)
    • SQLCLR (4)
  • Uncategorized (12)
  • SEO (4)
  • Virtualization (5)

Azure Banking Admin Course

SQL Server Security Course

My Certifications

FREE check-up of your BD!

Posts Archive

Recent Posts

  • Microsoft Azure Data Fundamentals DP-900 Exam – Free Certification Exam Study Material August 14st, 2022
  • Azure Data Factory (ADF) - How to change the Service Objective and resize an Azure SQL Database using T-SQL commands August 13st, 2022
  • SQL Server - How to synchronize data from a table between different databases using Trigger August 13st, 2022
  • Online Event – ​​Database Tips for Developers – SQL Server, PostgreSQL, MongoDB and more! 20 July 2022
  • Live - How to Version and Deploy Models and Reports in Power BI with Azure DevOps June 13st, 2022

oracle

Creating and restoring logical backups (DUMPs) in Oracle Database 11g (exp and imp)

  • March 21th, 2015
  • 16
  • Database Oracle

Installing SQL * Plus and Oracle Client 10g

  • March 17th, 2015
  • 0
  • Database Oracle

Installing Oracle Database 11g R2 on Windows

  • March 16th, 2015
  • 1
  • Database Oracle

Similarities and Differences between DELETE, TRUNCATE and DROP TABLE

  • February 17rd, 2015
  • 0
  • Database Query Development MySQL / MariaDB Oracle SQL Server

Creating a virtual machine with Oracle VirtualBox

  • November 29th, 2014
  • 0
  • Virtualization

Deleting All Objects of an Owner in Oracle Database

  • June 7st, 2014
  • 0
  • Database Oracle

Generating Reverse Engineering (Creation DDL) from Oracle Database Users, Tablespaces, Roles, Jobs, and Profiles

  • June 7st, 2014
  • 0
  • Database Oracle

Generating AWR Reports via Script in Oracle Database 11g

  • June 7st, 2014
  • 1
  • Database Oracle

Generating Object Reverse Engineering (DDL Backup) in Oracle Database 11g

  • June 7st, 2014
  • 0
  • Database Oracle

Dirceu Resende © 2022. All Rights Reserved.