Power BI Create a dashboard showing temperature data from Azure SQL db

Install Power BI Desktop…

open Power BI Desktop and add Azure SQL DB as datasource:

Choose full qualified server name and database name (can be found in the Azure Portal https://portal.azure.com

HINT: you can choose between “Import” and “DirectQuery” data connectivity mode – since “DirectQuery” sound´s good, it has a few limitations working with time based data – see: Limitations of DirectQuery (ie. Time intelligence capabilities are not available in DirectQuery. For example, special treatment of date columns (year, quarter, month, day, so on) are not supported in DirectQuery mode.)

Choose Database as authentication method:

Power BI Create a dashboard showing temperature data from Azure SQL db

Install Power BI Desktop… open Power BI Desktop and add Azure SQL DB as datasource: Choose full qualified server name and database name (can be found in the Azure Portal https://portal.azure.com HINT: you can choose between “Import” and “DirectQuery” data connectivity mode – since “DirectQuery” sound´s good, it has a few limitations working with time…

Install SystemCenter DPM 2016 – HowTo…

Prerequisites: We need the following prerequisites first: VM: 2 vCPU 4096MB Memory dynamic min. 512MB – max. 8192MB Systemdrive – 128GB Dynamic Backupdrive – <whatever you need>GB User Accounts: SQL: Install SQL Server local on DPM Server or use a remote SQL Server (DPM 2016 does not support AlwaysOn Groups – so i will install…

Create a SET Team in Server 2016 – HowTo…

SET (Switch Embedded Teaming) is a new technology in Windows Server 2016 and the successor to the “standard” teaming technology in Server 2012R2 (LBFO Team) – read more: https://technet.microsoft.com/en-us/library/mt403349.aspx HINT: only available if you have added the Hyper-V role in Windows, because otherwise no PS-CMDLets are available to configure… Create a vSwitch First you have…

Time Synchronizing Domain Controllers with NTP – HowTo

…to synchronize your DC(s) with a correct timesource and make the DCs authorative to the clients you have to follow these steps: If you have more than one domain-controller only the PDC-Emulator should sync his time with NTP – all other DCs should sync with NT5DS against PDC-emulator – we can easily filter the PDCe…

Create policy to put users/groups in local admin group…

Prerequisites: i want to put ie my service account named _svc_vmmservice to the local admin group in my vmm nodes. following the microsoft AGLP (accounts->global groups->local groups->permissions) first i create a global group named “_gg_localAdminVMM” and a local group named “_lg_localAdminVMM” – put _svc_vmmservice in global group and put global group in local group: …in…