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

Blog Views

3.287.659 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

powershell

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

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

Powershell – Script to list and export to CSV all files a directory with name, directory, size and duration attributes

  • June 13st, 2021
  • 1
  • Powershell / CMD

SQL Server - How to Convert an RTF String to Text (Remove RTF Tags) Using CLR (C #) or Powershell

  • August 8st, 2017
  • 2
  • Database SQL Server C # (CSharp) CLR Query Development Data Formatting and Validation Powershell / CMD

Analysis Services - How to use XLMA or Powershell to process cubes and dimensions via command line (T-SQL) or SQL Agent Job

  • August 6st, 2017
  • 0
  • Business Intelligence (BI) Integrations Powershell / CMD Database SQL Server Analysis Services (SSAS)

SQL Server - How to back up all SQL Agent jobs via command line (CLR C # or Powershell)

  • February 22rd, 2017
  • 3
  • C # (CSharp) Maintenance CLR Powershell / CMD Database SQL Server Agent SQL Server

SQL Server - How to Run PowerShell and Prompt-DOS (MS-DOS) Scripts Using CLR (C #)

  • September 11th, 2016
  • 0
  • CLR Hacks Integrations File Handling Powershell / CMD Database SQL Server

Dirceu Resende © 2023. All Rights Reserved.