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.800.414 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

jobs

SQL Server - How to fetch a code string from SP's that are called by SQL Agent jobs

  • September 16th, 2017
  • 0
  • Database SQL Server SQL Server Agent

SQL Server - Understanding SQL Agent Permissions and Roles (SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole)

  • February 28rd, 2017
  • 4
  • Database Maintenance Safety SQL Server SQL Server Agent

SQL Server - How to back up all SQL Agent jobs via command line (CLR C # or Powershell)

  • February 22rd, 2017
  • 3
  • Database C # (CSharp) CLR Maintenance Powershell / CMD SQL Server SQL Server Agent

How to list jobs (schedules, commands, steps) via Query in SQL Server

  • March 28th, 2016
  • 8
  • Database DMVs and Catalog Views Maintenance SQL Server SQL Server Agent

How to identify jobs running via Query in SQL Server

  • August 22st, 2015
  • 0
  • Database DMVs and Catalog Views Maintenance Monitoring SQL Server SQL Server Agent

Running PHP scripts automatically through crontab on Linux

  • March 16th, 2015
  • 3
  • PHP Programme

Searching for a string in a job (or step) in SQL Server

  • June 14st, 2014
  • 0
  • Database DMVs and Catalog Views Maintenance SQL Server SQL Server Agent

Dirceu Resende © 2021. All Rights Reserved.