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

Blog Views

3.272.304 views

Categories

  • Apache / .htaccess (9)
  • Database (333)
    • Azure SQL Database (4)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (316)
      • 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 (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)
  • Search Engine Optimization (4)
  • Virtualization (5)

Azure Banking Admin Course

SQL Server Security Course

My Certifications

Posts Archive

Recent Posts

  • 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
  • Online Event – ​​Database Tips for Developers – SQL Server, PostgreSQL, MongoDB and more! 20 July 2022

Other Languages

Are you looking for something?

Subscribe to Blog by Email

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

Join 1.764 other subscribers

Total Views

3.272.304 views

Courses and training

Courses and Training

Microsoft MVP

Acknowledgments and Certificates

Microsoft MCSE Certification

Categories

  • Apache / .htaccess (9)
  • Database (333)
    • Azure SQL Database (4)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (316)
      • 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 (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)
  • Search Engine Optimization (4)
  • Virtualization (5)

Archives

Recent Posts

  • 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
  • Online Event – ​​Database Tips for Developers – SQL Server, PostgreSQL, MongoDB and more! 20 July 2022

string

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

SQL Server - Table-valued function to break a string into lines up to N characters long

  • 21 July 2017
  • 0
  • CLR Query Development Database SQL Server

Working with cryptographic functions (MD4, MD5, SHA1, SHA2_256, and SHA2_512) using the SQL Server HASHBYTES function

  • February 18rd, 2015
  • 0
  • Query Development Data Formatting and Validation Database SQL Server

Performing a textual search on all columns of all tables in SQL Server

  • June 14st, 2014
  • 7
  • Query Development DMVs and Catalog Views Database SQL Server

Searching for a string in a job (or step) in SQL Server

  • June 14st, 2014
  • 1
  • Maintenance DMVs and Catalog Views SQL Server Agent Database SQL Server

Dirceu Resende © 2023. All Rights Reserved.