(Chris Webb) This post is really just a quick follow-on from my post earlier this week on using Process Monitor to troubleshoot Power Query performance issues with file-based data sources, which I suggest you read before carrying on. I realised, after playing around with Process Monitor some more, t
Community
Optimization Thresholds – Grouping and Aggregating Data, Part 5
(Itzik Ben-Gan) When SQL Server optimizes a query, during an exploration phase it produces candidate plans and chooses among them the one that has the lowest cost. The chosen plan is supposed the have the lowest run time among the explored plans. The thing is, the optimizer can only choose between s
Guru: Serve Web Pages Safely Using A Reverse Proxy
(Alan Seiden) If you are hosting a website or API from your IBM i server, but wish to reduce your worry about allowing access from the Internet, we often recommend a reverse proxy (or “gateway”) server.
What is the JDK? Introduction to the Java Development Kit
(Matthew Tyson) The Java Development Kit (JDK) is one of three core technology packages used in Java programming, along with the JVM (Java Virtual Machine) and the JRE (Java Runtime Environment). It’s important to differentiate between these three technologies, as well as understanding how they’re c
Fixing Visual Studio Intellisense Errors
(Rick Strahl) It’s always fun when Visual Studio (ie @drunkvs) can’t recite the alphabet backwards: The code below builds just fine when running through the compiler, but Visual Studio displays Intellisense errors in the Error Window and in the code with underlined squiggles:
Deciding When to Use Weak References in .NET
(Tapas Pal) The .NET WeakReference Class represents a weak reference, which references an object while still allowing that object to be reclaimed by garbage collection. Now, let’s see an example. Create a console application from Visual Studio and name it MyWeakReference.
Using style.setProperty() To Keep CSS Property Names Consistent In JavaScript
(Ben Nadel) This morning, while reading an article on theming Angular components by Austin McDaniel, I saw something that I don’t think I’ve ever seen before. Austin was using a .setProperty() method to define an element’s CSS properties in JavaScript.
SQL MYSTERIES: Tracing BCP Might Fool You
(RDORR) Today I was tracking a large BCP.exe ‘IN’ operation and monitoring the sys.dm_exec_requests entries. The ‘BULK INSERT’ command entry appeared, showing the CPU, reads, writes, … but these values where getting reset from time to time.
The Best (and Worst) Cloud Services for MySQL
(Rob Gravelle) Each and every day, new cloud-based database providers are cropping up to meet the demands of Big Data.
Trusting a self signed certificate in Oracle Visual Builder Cloud
(Gerard Davison) When you are setting up a development environment you sometimes need to use self signed certificates or a separate developer CA, in order to use this in VBCS you will need to make sure that these certificates are trusted by the kss://system/trust store and have the latest 18.3.3 pat