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.406 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

auditing

SQL Server - How to Monitor and Audit Data Changes in Tables Using Change Data Capture (CDC)

  • February 7rd, 2018
  • 6
  • Audit Database Security SQL Server

SQL Server - Trigger to prevent and prevent changes to tables

  • February 4rd, 2018
  • 3
  • Audit Database Security SQL Server

SQL Server - Permissions and privileges audit trigger at database and instance level (GRANT and REVOKE)

  • 18 July 2017
  • 5
  • Audit Database Security SQL Server

SQL Server - Implementing access control and audit logs when using the CLR (C #)

  • February 28rd, 2017
  • 0
  • Audit Database CLR SQL Server

SQL Server - How to copy / replicate a user's permissions

  • February 19rd, 2017
  • 6
  • Audit Database DMVs and Catalog Views Maintenance Security SQL Server

SQL Server - How to Create a Data Change History for Your Tables (Audit Logs)

  • 17 July 2016
  • 14
  • Audit Database Query Development Monitoring SQL Server

Using SQL Server Standard Trace to Audit Events (fn_trace_gettable)

  • April 23th 2016
  • 4
  • Audit Database Little Known Features Security SQL Server

Audit on SQL Server (Server Audit)

  • October 21th, 2015
  • 7
  • Audit Database Little Known Features Maintenance Security SQL Server

SQL Server - How to implement audit and control of logins (Logon Trigger)

  • 18 July 2015
  • 6
  • Audit Database Maintenance Monitoring Security SQL Server

How to create an Audit trigger to log object manipulation in SQL Server

  • 18 July 2015
  • 2
  • Audit Database Maintenance Monitoring Security SQL Server
  • Next page "

Dirceu Resende © 2022. All Rights Reserved.