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
  • 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.602 other subscribers

Blog Views

2.732.022 views

Categories

  • Apache / .htaccess (9)
  • Database (330)
    • Azure SQL Database (3)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (314)
      • 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 (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) (37)
    • Analysis Services (SSAS) (8)
    • Azure Data Factory (ADF) (2)
    • Microsoft (7)
    • Power BI (13)
    • Reporting Services (SSRS) (9)
  • Career and Courses (14)
  • Career, Courses and Certifications (34)
  • Cell Phones (1)
  • Events and Lectures (68)
  • 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

  • Live - How to Version and Deploy Models and Reports in Power BI with Azure DevOps June 13st, 2022
  • Live – PostgreSQL, MySQL, MariaDB, Managed Instance and Cosmos DB: Managing PaaS Banks Beyond Azure SQL Database June 6st, 2022
  • Live - How to get your Microsoft certification for free and an overview of data space exams in Azure June 3st, 2022
  • New Microsoft Certified Fundamentals portal for those looking to get their first certification June 1st, 2022
  • SQL Server - How to validate email and email domain using SQLCLR (C#) 26 May 2022

JSON, XML, CSV and Excel

SQL Server - How to export the contents of a column to XML files

  • April 12th 2020
  • 3
  • Database Query Development JSON, XML, CSV and Excel SQL Server

SQL Server - How to export and import tabular data files (Ex: CSV) using CLR (C #)

  • March 20th, 2017
  • 2
  • Database C # (CSharp) CLR JSON, XML, CSV and Excel File Handling SQL Server

SQL Server 2016 - Using Native JSON Support (JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, ISJSON, JSON_MODIFY)

  • February 18rd, 2017
  • 5
  • Database Query Development JSON, XML, CSV and Excel SQL Server

SQL Server - How to read, import, and export data from XML files

  • June 18st, 2016
  • 10
  • Database Query Development JSON, XML, CSV and Excel File Handling SQL Server

SQL Server - Importing and Exporting data from Excel spreadsheets

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

How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing to the bank and exporting to XML

  • 25 July 2015
  • 3
  • Database Query Development Data Formatting and Validation Little Known Features Hacks Integrations JSON, XML, CSV and Excel 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

Dirceu Resende © 2022. All Rights Reserved.

Posting ....