Skip to content

Dirceu Resende

DBA SQL Server and BI Analyst (PowerBI, SSAS, SSIS, SSRS)

  • Consultancy
    • 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 542 other subscribers

Blog Views

1.733.139 views

Categories

  • Apache / .htaccess (9)
  • Database (307)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (293)
      • Audit (15)
      • Azure (2)
      • CLR (53)
      • Query Development (83)
      • DMVs and Catalog Views (31)
      • Errors (22)
      • Tools (12)
      • Data Formatting and Validation (23)
      • Little Known Features (19)
      • Hacks (17)
      • Easy (30)
      • File Handling (13)
      • Maintenance (80)
      • Monitoring (35)
      • What not to do (7)
      • OLE Automation (19)
      • Performance tuning (22)
      • Python (1)
      • Safety (39)
      • SQL Server Agent (11)
  • Business Intelligence (BI) (31)
    • Analysis Services (SSAS) (7)
    • Microsoft (7)
    • Power BI (12)
    • Reporting Services (SSRS) (8)
  • Career and Courses (13)
  • Career, Courses and Certifications (28)
  • Cell Phones (1)
  • Events and Lectures (63)
  • Programme (57)
    • C # (CSharp) (30)
    • CSS (1)
    • ERP (1)
    • javascript (1)
    • PHP (17)
    • Powershell / CMD (8)
    • SQLCLR (4)
  • Uncategorized (10)
  • SEO (4)
  • Virtualization (5)

Microsoft MVP Data Platform

My Certifications

Training

Posts Archive

Recent Posts

  • Black Friday discounts on SQL Server Trainings (Buy my kkkkk course) November 27th, 2020
  • SQL Server - The “new” GREATEST and LEAST functions November 27th, 2020
  • SQL Server - How to know the date of a user's last login November 9th, 2020
  • Azure in Free Practice # 07 - Administering Databases in Azure November 5th, 2020
  • Analysis Services - An error occurred while opening the model on the workspace database. Reason: An unexpected error occurred (file 'tmcachemanager.cpp', function 'TMCacheManager :: CreateEmptyCollectionsForAllParents') November 5th, 2020

Hacks

SQL Server - How to remotely stop, start and list Windows services

  • August 7st, 2016
  • 0
  • Database CLR Hacks Monitoring SQL Server

Using sequences in user defined functions in SQL Server

  • April 28 2016
  • 0
  • Database Query Development Hacks SQL Server

SQL Server - Querying instance information in Windows Registry using sys.dm_server_registry and xp_instance_regread

  • April 23 2016
  • 0
  • Database DMVs and Catalog Views Little Known Features Hacks SQL Server

How to retrieve the largest value between multiple columns in a SQL Server table

  • April 2 2016
  • 4
  • Database Query Development Hacks SQL Server

How to identify the port used by the instance of SQL Server

  • August 30st, 2015
  • 3
  • Database DMVs and Catalog Views Hacks Maintenance SQL Server

The undocumented SQL Server extended procedures

  • August 27st, 2015
  • 0
  • Database Little Known Features Hacks Maintenance 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 Easy SQL Server
  • " Previous page

Dirceu Resende © 2021. All Rights Reserved.