Blog

I needed a place to express myself, share my discoveries and reach more people. Here you are!

SSIS – Export SSIS Catalog Environments

SSIS – Export SSIS Catalog Environments

You need to: Export your SSIS Environments (Variables)Replicate it on your new serverAssign these variables to your new project SSIS Catalog is not complex, but we don’t really want to spend our time to copy manually our configuration from one server to another...

Power BI Desktop: Print in the A4 size

Power BI Desktop: Print in the A4 size

As you know, the August 2018 update of Power BI Desktop grants us the possibility to export in PDF directly from the Desktop. Two clicks and it's done. Great news right? I remember all the steps I had to go through to make it before, it still give me headache... But...

SP_WHO3 – Running Queries (Toolbox)

SP_WHO3 – Running Queries (Toolbox)

Display all running queries Source:http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3 Code: SELECT SPID = er.session_id ,BlkBy = CASE WHEN lb.lead_blocker = 1 THEN -1 ELSE er.blocking_session_id END ,ElapsedMS = er.total_elapsed_time ,CPU = er.cpu_time...

Learn DAX from examples: Lazy DAX

Learn DAX from examples: Lazy DAX

Concrete cases in DAX Working with Power BI (or SSAS Tabular) does not require much effort. It's quite intuitive and easy to set up. However, to fully enjoy it, it is recommended to take the time to learn DAX. Create a measure, in the formula bar, is done through an...

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.