(Peter Vogel) When you call Entity Framework’s SaveChanges method, Entity Framework has to know what entities have changed in order to figure out what SQL Update/Delete/Insert statements to generate.
Community
Innotop for MySQL 8.0
(Frederic Descamps) Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution).
opatch versions
(Frits Hoogland) This blogpost is about oracle’s patching tool for the database and grid infrastructure: opatch. I personally have a love/hate relationship with opatch. In essence, opatch automates a lot of things that would be very error prone if it were to be done by hand, which is a good thing.
Preprocessing External Tables
(Michael McLaughlin) A question that comes up now and again is there a way in Oracle Database 11g Express Edition to mimic some behavior in the Oracle Standard or Enterprise editions. Many of these questions arise because developers want to migrate a behavior they’ve implemented in Java to the Expre
How Permissions Work for a Power BI Service Administrator
(Melissa Coates) A Power BI administrator is a role for managing various aspects of the Power BI Service. This role can be assigned in Office 365. Anyone with Office 365 global admin privileges is also a Power BI administrator by default.
SQL Join introduction and overview
(Bojan Petrovic) A SQL Join clause is put within a Select statement and at the end, it’s given a join condition, which tells the database how to fetch your data.
My backup script (where, how, how big, etc.)
(Kenneth Fisher) A while back I wrote about how to find where your backups are. And I’ve also written about I use a solution in SSMS to hold a bunch of my scripts. I was using this again today (I use it a lot!) and thought I would bring it back up with some additional detail.
Db2 for z/OS Global Variables: What is a ‘Session’?
(Robert Catterall) Has this ever happened to you? You’re looking at the Db2 for z/OS SQL Reference (or in the Db2 for z/OS Knowledge Center on the Web), and you see something like this (and the quote below is from the description of the CREATE VARIABLE statement in the SQL Reference, with highlighti
How to Unit Test Your Annotation Processor using jOOR
(lukaseder) Annotation processors can be useful as a hacky workaround to get some language feature into the Java language. The best example is Lombok, which enhances the Java language with quite a few annotation-based features.
Store User Options Using Enumeration, Bitwise Operators, And EF Core
(Bipin Joshi) At times you need to store a set of options, settings, or choices for a user. A common approach is to create three tables – Users, Options, and UserOptions – to store the data involved.