Random material about computers, web and IT in general
“An important update is pending” – Edge WebView2
Did you ever start Power BI Desktop and this error showed-up out of nowhere?! Clicking “Install now” seems to be doing something but in the end it fails saying Microsoft Edge Webview2 Runtime is already installed? Restarting the machine does not help, don’t bother trying 🙂 Uninstalling and installing Power BI Desktop again – same…
How to turn off automatic upgrade of Power BI licenses
Go to https://app.powerbi.com/. Using the gear icon go to Admin Portal and make sure Tenant settings is selected. Here, there are 2 options you can use, depending on your organization’s needs. To prevent auto-assignment from happening again you need to disable the “Allow users to try Power BI paid features” option. Of course, if there…
Oracle SQL: Update table with data from another table
Suppose you have a column in Table1 that you need to update with data from another column in Table2. Let’s do it!
Windows PowerShell vs PowerShell
There are few differences in the PowerShell language between Windows PowerShell and PowerShell. The differences are most notable in the availability and behavior of PowerShell cmdlets between Windows and non-Windows platforms and the changes that stem from the differences between the .NET Framework and .NET Core.
“Must declare the scalar variable” error in Toad for SQL
There are different execution needs depending on what you are doing. See when you need to use F5 and F9.
Repost: Welcome to the New Normal
I couldn’t resist of not sharing this. Excelent post from P3 regarding our friendship with Corona virus.
Power Query – Week start and end dates in same column
Someone asked me the other day below thing: “On the same column I want a Range of dates not Duration between two dates So I have a Creation date and fulfillment date I need to come up with a column of weekly Range like for example 10/21 – 10/27 10/28 – 11/01 11/02 – 11/09…
Examples of Count, Count IF, Count duplicates in SQL
Count: SELECT [ProductModel], COUNT(1) CNT FROM [AdventureWorks2017].[Production].[vProductAndDescription] GROUP BY [ProductModel] ORDER BY CNT DESC Count “if”: SELECT [ProductModel], [Name],COUNT(1) CNT FROM [AdventureWorks2017].[Production].[vProductAndDescription] WHERE [ProductModel] LIKE ‘%Frame’ AND [Name] LIKE ‘%52’ –here’s the IF statement GROUP BY [ProductModel], [Name] ORDER BY CNT DESC Count duplicates: SELECT [ProductModel], COUNT(1) CNT — select a field you want to…
TRUE or FALSE?
ITIL 4 coming soon
A new version of ITIL will be released in early 2019.