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

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

Blog Views

3.414.640 views

Power Alerts

Azure Banking Admin Course

SQL Server Security Course

My Certifications

Posts Archive

Categories

  • Apache / .htaccess (9)
  • Database (336)
    • Azure SQL Database (4)
    • MySQL / MariaDB (4)
    • Oracle (8)
    • SQL Server (319)
      • Audit (15)
      • Azure (2)
      • CLR (56)
      • 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 (40)
      • What not to do (7)
      • OLE Automation (19)
      • Performance tuning (25)
      • Python (1)
      • Security (41)
      • SQL Server Agent (12)
  • 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 (70)
  • 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)

Recent Posts

  • SQL Server - Is the execution history of SQL Agent jobs disappearing? 10 May 2023
  • Meet Power CLR: SQL Server Integration with APIs, Files, Webservices, FTP and more! 9 May 2023
  • Live on @cloud4developers – Azure SQL straight to the point April 27th 2023
  • PowerAlerts – The best SQL Server monitoring and alerting system you've ever seen! March 22th, 2023
  • SQL Server and Azure SQL: How to delete or update data in large tables November 9th, 2022

ssas

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

How to learn SQL / Azure Analysis Services (SAAS / AAS) for free – FOR FREE!

  • September 21th, 2021
  • 1
  • Business Intelligence (BI) 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
  • 3
  • Analysis Services (SSAS)

How was SQL Server ES # 14 - SQL Server 2019 and Analyzing big data with Power BI

  • December 23, 2019
  • 1
  • Events and Lectures

Analysis Services - Querying catalog views from SQL Server

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

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

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

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

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

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

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

Dirceu Resende © 2023. All Rights Reserved.