Passing In Filters to Embedded Power BI Charts

Customizing your embed experience using URL Settings The ability to create experiences without advanced coding skills, what’s know as low-code, is truly special with this capability. The embed URL supports several input settings that help you customize your user’s experiences. If you’re using the HTML snippet provided, make sure you update the URL in the... » read more

SQL Server Build Verions

RTM SP1 SP2 SP3 SP4 Most Recent Version ↓SQL Server 2019 15.0.1600.8 (CTP 3.0) ↓SQL Server 2017 14.0.1000.169 14.0.3192.2 (CVE-2019-1068) ↓SQL Server 2016 13.00.1601.5 13.0.4001.0 13.0.5026.0 13.0.5366.0 (CVE-2019-1068) ↓SQL Server 2014 12.00.2000.8 12.0.4100.1 12.0.5000.0 12.0.6024.0 12.0.6293.0 (CVE-2019-1068) ↓SQL Server 2012 11.00.2100.60 11.0.3000.0 11.0.5058.0 11.0.6020.0 11.0.7001.0 11.0.7469.6 (FIX for SP4) ↓SQL Server 2008R2 10.50.1600.1 10.50.2500 10.50.4000 10.50.6000 10.50.6560.0 (KB4057113) ↓SQL Server 2008... » read more

Database Backup Encryption

Restoring encrypted database on another server (using Backup Encryption). Only works with SQL Server 2014 and later. Backup If a certificate is not backed up prior to backing up a database in T-SQL the following warning will be displayed in the results: Warning: The certificate used for encrypting the database encryption key has not been... » read more

Path

System.IO.Path Path.* Path.Combine Sources: https://docs.microsoft.com/en-us/dotnet/api/system.io.path.combine?view=netframework-4.8

continue (C# Reference)

The continue statement passes control to the next iteration of the enclosing while, do, for, or foreachstatement in which it appears. Sources: https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/continue

Regex

Expression Example String ^TestFile-.+.txt$ TestFile-03Jul2019150038.txt ^FILE-(OUTPUT|INPUT|ALL)-.+.txt$ FILE-OUTPUT-03Jul2019150038.txt Regex Tools https://regex101.com/

Key Performance Indicators (KPI)

Reasons for measuring performance Organizations measure performance for three main reasons: Learn and improve performance Provide external reporting (for shareholders and compliance requirements) Monitor and control internally within the organization Only what gets measured gets done. Unless something is measured, it cannot be managed and controlled Measure: Is a unit or standard of measurement, which... » read more

Dashboard vs Scorecard

Dashboard Scorecard Measures performance Chart progress Used by staff Used by Executives Real-time Date Periodic snapshots Shorter time shorizon Longer time spans Operational Strategic and Tactical Require immediate action