(Jon P Smith) This article gives an “under the hood” view of what happens when EF Core reads in data from a database. I look at two types of database read: a normal query and a query that contains the AsNoTracking method in it.
Author: SSWUG Research
(Syed Jaffar Hussain) In this part of Migration methods to Autonomous Database (ADB) article series, we will see how to load data into ADB database using the DBMS_CLOUD package.
(Martin Berger) Recently a friend asked me how to write a query for a SQL query which was slightly above simple SQL demo cases you can find all around.
(Bobby Curtis) Over the last few months, I’ve been working to convert my skills from a core DBA/Replication specialist into a from dynamic DevOps persona.
(James Cockayne) Recently I was running a workshop for some customers to demonstrate various features of DB2 on the Linux platform.
(Rafal Borowiec) As of Java 14, the switch expression has an additional Lambda-like (case … -> labels) syntax and it can be used not only as a statement, but also as an expression that evaluates to a single value.
(Kenneth Fisher) The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you the man is amazing. In a very brief exchange where he tossed a few T-SQL scripts at me, my brain hurt and I learned some really interesting stuff.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
(Pinal Dave) One of my clients of Comprehensive Database Performance Health Check recently asked me if there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show in the report. Let us see how we can fix that.
(Ted Wennmark) For more information on how to create a service look at man systemd.service