(Mike Brind) At its heart, the Razor Pages routing story is a simple one. It uses a convention of mapping URLs to files on disk. There are ways to customise how pages are found on an individual basis, but what if you want to change the default convention in its entirety?
Community
Playing with JDK 12’s Switch Expressions
(Dustin Marx) In the blog post “JDK Language Feature Preview in Action: Switch Expressions,” I discussed how JEP 325 [“Switch Expressions (Preview)”] is an early application of a designated “preview language feature” as spelled out by JEP 12 [“Preview Language and VM Features”].
.NET Tools – Amazing list of OpenSource .NET tools and resources
(Lee Stott) This is a great set of resources complied by Nate McMaster, Senior software engineer on the ASP.NET Core project
When You’re Your Own DBA: Speeding Up SQL Server
(Peter Vogel) I’m supposed to be a software developer/consultant. However, I’m also the guy people look at when the application isn’t running “fast enough.”
Loading data into TByte sized NDB data nodes
(Mikael Ronstrom) One of the main design goals with MySQL Cluster 7.6 was to support much larger data sets in each data node.
Autonomous Database: Creating an Autonomous Data Warehouse Instance
(Gerald) In my previous post I have shown how quick and easy it is to create an Oracle Autonomous Transaction Processing instance. In this post I want to show that the same applies for an Oracle Autonomous Data Warehouse, short ADW, instance.
JSON, BLOB column and Check Constraint
(Alex Nuijten) Last week I attended Neil Chandler’s session on JSON during the POUG conference in beautiful Sopot, Poland.
Tuning Oracle Queries with an Optimizer Trace
(David Fitzjarrell) Query tuning is a combination of art, science and intuition. Elegant tuning solutions are art, based on science, that science using two of Oracle’s events, 10046 and 10053. Which one is more beneficial depends on the query and the ‘bad’ execution plan.
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
(Kenneth Fisher) Anything that happens in a trigger happens within the same transaction of the command that called it.
MAXDOP and Azure SQL DB
(blobeater) The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when using Azure SQL Database?