R Studio

SQL Monitoring in Power BI - Error Alerts (Real-Time)

  To make it possible, I built tables to save only the last status to it earns performance, these are the statements:   --================================================================= --// It saves the last status of Backup (used for Missing...

SQL Monitoring in Power BI - SQL Error Logs

First of all, I prepared the data in SQL, this is the statement:   --=============================================================== --// Created a table to save the last status --===============================================================   USE [DBA] GO   SET...

SQL Monitoring in Power BI - Fail SQL Jobs

First of all, I prepared the data in SQL, this is the statement:   --=============================================================== --// Created a table to save the last status --===============================================================   USE [DBA] GO   SET...

SQL Monitoring in Power BI - Missing Backups

First of all, I prepared the data in SQL, this is the statement:   --=============================================================== --// Created a main view to shows up the differences --=============================================================== USE [DBA] GO   SET...

SQL Monitoring in Power BI - Lock Wait Time

  First of all, I prepared the data in SQL, this is the statement: --=============================================================== --// Created a table to save all the Locks --=============================================================== USE [DBA] GO     SET...

Delta changes for ETL - DW

Is a solution to identify data changes:    --========================================================== --// Create a new Index --========================================================== drop table tbStockIndexTrack go Create table tbStockIndexTrack ( tnz_StockNumber...

Change Tracking Example -SQL Server

Following are the step by step instructions to enable and use the change tracking feature in SQL Server. If there is a requirement to get incremental or changed data from database frequently without putting a heavy load on database objects, then Change Tracking mechanism of SQL Server...

DW Loading dashboard control in PowerBI and Report Services

It has built in PowerBI, using PB Gateway for updating data, accessed by APS through the mobile:   DW Loading Dashboard Chart by DW Loading vs Affected rows DW Loading Dashboard KPI’s by DW Loading Accuracy DW Loading Dashboard - Last TDW Loading DW Loading Dashboard - KPI’s DW...

Autocomplete with ElasticSearch and JQuery and Python

  This is an example using ElasticSearch with JQuery and Python, I built that concept using synonyms in Windows. Thanks to my friend Ricardo for your support ;)  The challenge was to build a solution that would be able to search by a word to return the synonyms like that:   To...

SQL Performance in PowerBI Real-Time

Yes, it's a SQL Performance Monitoring in Real-Time, developed in Power BI, Json, C#, T-SQL, RestAPI and CLR. It has been building to show up the health performance environments:   Web Version:   Through the Power BI Apps, we can access the indicators online for SQL...

1 | 2 | 3 | 4 >>

Crie um site com

  • Totalmente GRÁTIS
  • Design profissional
  • Criação super fácil

Este site foi criado com Webnode. Crie o seu de graça agora!