Skip to content

Dirceu Resende

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

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

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.774 other subscribers

Blog Views

3.295.668 views

Power Alerts

Azure Banking Admin Course

SQL Server Security Course

My Certifications

Posts Archive

Categories

  • Apache / .htaccess (9)
  • Database (334)
    • Azure SQL Database (4)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (317)
      • Audit (15)
      • Azure (2)
      • CLR (55)
      • Query Development (92)
      • 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 (40)
      • 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)
  • Search Engine Optimization (4)
  • Virtualization (5)

Recent Posts

  • PowerAlerts – The best SQL Server monitoring and alerting system you've ever seen! March 22th, 2023
  • SQL Server and Azure SQL: How to delete or update data in large tables November 9th, 2022
  • 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

azure sql

Click on the banner to learn about and purchase my database training on Azure

Azure Data Factory (ADF) - How to change the Service Objective and resize an Azure SQL Database using T-SQL commands

  • August 13st, 2022
  • 0
  • Azure Data Factory (ADF) Azure SQL Database

Live – PostgreSQL, MySQL, MariaDB, Managed Instance and Cosmos DB: Managing PaaS Banks Beyond Azure SQL Database

  • June 6st, 2022
  • 0
  • Events and Lectures

Live #45: Best Practices in Database Administration in Azure (17/05 at 21pm)

  • 17 May 2022
  • 0
  • Events and Lectures

Azure SQL Database - How to create and manage users and logins with SQL authentication and Azure Active Directory (Azure AD)

  • 13 May 2022
  • 1
  • Azure SQL Database Database

SQL Server and Azure SQL Database: How to Identify Key Lookup occurrences through the plancache

  • April 14th 2022
  • 0
  • Performance tuning Maintenance Azure SQL Database Database SQL Server

Azure SQL Database - How to view automatic backup history

  • April 14th 2022
  • 0
  • Azure SQL Database

Azure SQL Database – STRING_SPLIT function finally gets parameter to include number of positions

  • November 5th, 2021
  • 0
  • Database SQL Server News Query Development

SQL Server - The “new” GREATEST and LEAST functions

  • November 27th, 2020
  • 1
  • Database SQL Server Query Development

Dirceu Resende © 2023. All Rights Reserved.