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
  • Contacts

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

Blog Views

2.628.505 views

Categories

  • Apache / .htaccess (9)
  • Database (329)
    • Azure SQL Database (3)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (313)
      • Audit (15)
      • Azure (2)
      • CLR (54)
      • Query Development (91)
      • DMVs and Catalog Views (32)
      • Errors (23)
      • Tools (12)
      • Data Formatting and Validation (23)
      • Little Known Features (19)
      • Hacks (17)
      • Integrations (31)
      • JSON, XML, CSV and Excel (7)
      • File Handling (13)
      • Maintenance (86)
      • Monitoring (39)
      • What not to do (7)
      • OLE Automation (19)
      • Performance tuning (25)
      • Python (1)
      • Security (41)
      • SQL Server Agent (11)
  • Business Intelligence (BI) (36)
    • Analysis Services (SSAS) (8)
    • Azure Data Factory (ADF) (2)
    • Microsoft (7)
    • Power BI (12)
    • Reporting Services (SSRS) (9)
  • Career and Courses (14)
  • Career, Courses and Certifications (31)
  • Cell Phones (1)
  • Events and Lectures (67)
  • 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

Microsoft MVP Data Platform

My Certifications

FREE check-up of your BD!

Posts Archive

Recent Posts

  • SQL Server - How to unlock a login without having to change/reset the password 21 May 2022
  • SQL Server - Password Policies, Password Expiration, Mandatory Password Change, and Login Lockout after N attempts 21 May 2022
  • DataOps – DevOps applied to data projects (Power BI, Azure Data Factory, Azure Analysis Services and Database Objects) 19 May 2022
  • Invitation to the Live “Is going to college important in the area of ​​technology?” – May 20th at 05pm 18 May 2022
  • Live #45: Best Practices in Database Administration in Azure (17/05 at 21pm) 17 May 2022

database

Compressing all tables in a database in SQL Server

  • March 17th, 2015
  • 13
  • Database Maintenance SQL Server

Installing Oracle Database 11g R2 on Windows

  • March 16th, 2015
  • 1
  • Database Oracle

Validating CPF, CNPJ, Email, Phone, and Zip Code in SQL Server

  • February 17rd, 2015
  • 19
  • Database Query Development Data Formatting and Validation SQL Server

Similarities and Differences between DELETE, TRUNCATE and DROP TABLE

  • February 17rd, 2015
  • 0
  • Database Query Development MySQL / MariaDB Oracle SQL Server

Importing CSV Files into the SQL Server Database

  • June 14st, 2014
  • 2
  • Database Query Development JSON, XML, CSV and Excel File Handling OLE Automation SQL Server

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

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

File Operations Using OLE Automation in SQL Server

  • June 14st, 2014
  • 0
  • Database File Handling OLE Automation SQL Server

SQL Server - Breaking strings into sub-strings using a separator (Split string)

  • June 14st, 2014
  • 7
  • Database Query Development SQL Server

Removing HTML Tags from a String in SQL Server

  • June 7st, 2014
  • 0
  • Database Query Development Data Formatting and Validation SQL Server

Generating Reverse Engineering (Creation DDL) from Oracle Database Users, Tablespaces, Roles, Jobs, and Profiles

  • June 7st, 2014
  • 0
  • Database Oracle
  • Next page "

Dirceu Resende © 2022. All Rights Reserved.

Posting ....