SQL Guatemala

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...

2018-10-03

14 reads

Query to determine XE Session status

by Eduardo Pivaral

SQL Guatemala

On a previous post, we discussed what is an extended event (XE) and how to create one.

With the following T-SQL...

2018-10-03

269 reads

how to embed a PowerBI report into HTML code

by Eduardo Pivaral

SQL Guatemala

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...

2018-10-16 (first published: 2018-10-03)

3,013 reads

Pride and Prejudice... and Triggers

by Eduardo Pivaral

SQL Guatemala

This post is part of #tsql2sday event 🙂
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...

2018-09-11

11 reads

Pride and Prejudice... and Triggers

by Eduardo Pivaral

SQL Guatemala

This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...

2018-09-11

548 reads

Different methods to generate query execution plans

by Eduardo Pivaral

SQL Guatemala

One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....

2018-09-10

13 reads

Different methods to generate query execution plans

by Eduardo Pivaral

SQL Guatemala

One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...

2018-09-10

758 reads

Format Query as JSON

by Eduardo Pivaral

SQL Guatemala

JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it also used to stored NoSQL unstructured data, and because...

2018-08-22

6 reads