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 548 other subscribers

Blog Views

1.798.689 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

Analysis Services (SSAS)

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
  • 0
  • Analysis Services (SSAS)

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
  • Analysis Services (SSAS) Database Business Intelligence (BI) Easy Powershell / CMD SQL Server

Analysis Services - Querying catalog views from SQL Server

  • April 2 2017
  • 0
  • Analysis Services (SSAS) Database Business Intelligence (BI) Easy SQL Server

Analysis Services (SSAS) - How to query information and process command line (XLMA) commands through SQL Server

  • April 2 2017
  • 0
  • Analysis Services (SSAS) Database Business Intelligence (BI) Easy Maintenance SQL Server

Analysis Services - How to use XLMA to backup and restore cubes via the T-SQL command line

  • March 5th, 2017
  • 1
  • Analysis Services (SSAS) Database Business Intelligence (BI) Maintenance SQL Server

Analysis Services - Creating Your First Multidimensional Cube in the Star Model (Star Schema)

  • February 28rd, 2017
  • 8
  • Analysis Services (SSAS) Business Intelligence (BI)

Analysis Services - Deserialization failed: The 'AllowedRowsExpression' element in the namespace

  • 9 May 2016
  • 0
  • Analysis Services (SSAS) Business Intelligence (BI)

Dirceu Resende © 2021. All Rights Reserved.