(Pedro Lopes) Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model.
Community
Java 8: Comparator Example [Snippet]
(Behzad Khosrojerdi) Want to learn more about how to use the Comparator class in Java 8? Check out this code snippet on using the Comparator and Person class!
Tutorial on how to apply end to end security to a cloud application
(Henrik Loeser) Before you head out to the weekend I wanted to point you to a new cloud security tutorial. If you read this at the beginning of your week: What a great start… 😉
How to set up session state in our ASP.NET Core and MVC Core Web applications?
(Satyaprakash Samantaray) In this article, we will learn how to use our C# coding prowess to set up the session state in our ASP.NET Core and MVC Core Web applications.
Checking To See If An IP v4 Address Is In A CIDR Range Using ColdFusion And SubnetUtils
(Ben Nadel) At work, I need to build a feature that allows an IP address to be validated against a CIDR (Classless Inter-Domain Routing) range. CIDR – as I just learned – is range notation that defines a High and Low IP address by identifying how many bits in a given IP address are “locked down” and
How the Next Delegate Works In ASP.NET Core Middleware
(K. Scott Allen) How does next know how to call the next piece of middleware in the HTTP processing pipeline? I’ve been asked this question more than once when helping to write middleware components for ASP.NET Core.
A Nice Introduction to MySQL Window Functions III
(Dave Stokes) Windowing Functions can get quite complex very quickly when you start taking advantage of the frame clause. Ranges and rows can get confusing. So for review lets look at how the specification looks:
Create Oracle Database 18c on Windows – Advanced Configuration for the pros
(biju.thomas) Oracle Database 18c (18.3) is available for download for windows platform since August 22, 2018.
SQL Join overview and tutorial
(Prashanth Jayaram) The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause.
Query Store and Log Backups
(Grant Fritchey) A question that came up recently around Query Store is what happens when there are log backups in use on the database. Let’s talk about it.