(Jagruti Jasleniya) Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS.
Community
Access XML SOAP services in .NET Core and client certificates (SSL)
Peter Groenewegen) Only a few years back Windows Communication Foundation (WCF) was the way to do communication on the Microsoft platform based on SOAP protocol.
SQL Server – Formatted Date and Alias Name in ORDER BY Clause
(Pinal Dave) CONVERT function can be used to change the format of DATE to various formats like MM/dd/yyy, dd/MM/yyy, yyy/MM/dd, etc.
JSON Paths and the MySQL JSON Functions
(Dave Stokes) I wrote MySQL and JSON: A Practical Programming Guide to help developers find their way around the MySQL JSON data type and the supporting functions.
Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID
(Franck Pachot) Did you ever try to query DBA_EXTENTS on a very large database with LMT tablespaces? I had to, in the past, in order to find which segment a corrupt block belonged to.
SQL Server 2019 Big Data Clusters
(James Serra) At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage.
Can You Use Power Query In Power BI Or Excel To Write Data To A Data Source?
(Chris Webb) The short answer: no.
SQL Server on Amazon Web Services (AWS)
(Anoop Kumar) In this article we will discuss options to make Microsoft SQL Server (MS SQL Server) available on Amazon Web Service (AWS).
Shortening Your Long URLs with the TinyURL API and .NET
(Hannes DuPreez) It is quite easy and not a lot of work to use the TinyURL API to shorten burdensome URLs. Examples are in both C# and VB.NET.
Use [Controller] And [NonController] Attributes In ASP.NET Core
(Bipin Joshi) ASP.NET Core MVC uses certain conventions when it comes to naming the controllers. Although these defaults work as expected in many cases, at times you may want to take charge of the controller naming.