(benjamin perkins) I am updating, or should I say, re-coding a website I have from ASP.NET Web Forms (aspx) to ASP.NET Core Razor Pages (chtml). The database it connects to only has a global admin, full access user identity.
Community
Speeding Up Queries: How to Think About Query Plans
(Peter Vogel) Often, designing databases and speeding up SQL Server queries are treated as a kind of abstract problem: A just “Find this problem, apply this solution” approach to problem solving.
A small dive into the MySQL 8.0 X-DevAPI
(Gabriela D’Ávila Ferrara) What is the X-DevApi? From insidemysql.com there is a definition of the X-DevAPI and its features in the following paragraphs:
Optimistic Locking 8: double-checking with flashback
(stewashton) Some optimistic locking methods, including the SCN method, can detect intervening updates even when column values have not really changed. With the SCN method, we can use flashback queries to confirm that real changes occurred.
Hide certain objects on an APEX page
(Dimitri Gielis) A few days ago I got a question on how to hide the title row from the Interactive Report Pivot view. So the person didn’t want to show the red area:
PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)
(Simon Greener) Previously I created the following Java stored procedures to enable the import/export of ZM aware WKT.
Graph processing with SQL Server
(Jayendra Viswanathan) I came across Graph processing in SQL Server which to me is an advanced version of using Common Table Expressions (CTE). SQL Server offers graph database capabilities to model many-to-many relationships.
Generate App Skeleton Using Express-Generator In Node.js
(Manav Pandya) In this article, we are going to learn how to create the application skeleton using express application generation tool, which provides us a basic file structure to get started by writing a series of commands.
Multiple ways how to limit parallel tasks processing
(Kaduk Frantisek) I decided to write this post because I saw several implementations how to solve the following interesting exercise across several reviews last days.
SQL SERVER – FIX: Error 17836: Length Specified in Network Packet Payload Did Not Match Number of Bytes Read; the Connection has been Closed
(Pinal Dave) One of my clients reported that they are seeing below error in SQL Server ERRORLOG. He noticed a strange error of the network packet.