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 10.335 other subscribers

Blog Views

3.400.317 views

Power Alerts

Azure Banking Admin Course

SQL Server Security Course

My Certifications

Posts Archive

Categories

  • Apache / .htaccess (9)
  • Database (336)
    • Azure SQL Database (4)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (319)
      • Audit (15)
      • Azure (2)
      • CLR (56)
      • 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 (12)
  • 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 (70)
  • 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)

Recent Posts

  • SQL Server - Is the execution history of SQL Agent jobs disappearing? 10 May 2023
  • Meet Power CLR: SQL Server Integration with APIs, Files, Webservices, FTP and more! 9 May 2023
  • Live on @cloud4developers – Azure SQL straight to the point April 27th 2023
  • 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

Database

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

SQL Server - Is the execution history of SQL Agent jobs disappearing?

  • 10 May 2023
  • 1
  • Database SQL Server SQL Server Agent

Meet Power CLR: SQL Server Integration with APIs, Files, Webservices, FTP and more!

  • 9 May 2023
  • 0
  • CLR Database SQL Server

PowerAlerts – The best SQL Server monitoring and alerting system you've ever seen!

  • March 22th, 2023
  • 0
  • Database SQL Server Monitoring

SQL Server and Azure SQL: How to delete or update data in large tables

  • November 9th, 2022
  • 4
  • Database SQL Server Query Development

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

SQL Server - How to synchronize data from a table between different databases using Trigger

  • August 13st, 2022
  • 1
  • SQL Server Maintenance Database

SQL Server - How to validate email and email domain using SQLCLR (C#)

  • 26 May 2022
  • 2
  • Database SQL Server CLR Data Formatting and Validation

SQL Server - How to unlock a login without having to change/reset the password

  • 21 May 2022
  • 0
  • Database SQL Server Maintenance

SQL Server - Password Policies, Password Expiration, Mandatory Password Change, and Login Lockout after N attempts

  • 21 May 2022
  • 0
  • Database SQL Server Security

SQL Server - How to speed up your queries by changing server power setting

  • 17 May 2022
  • 2
  • Maintenance Database SQL Server
  • Next page "

Dirceu Resende © 2023. All Rights Reserved.