(Imran Siddique) Azure DevOps Search (Search) service is one of the microservices of Azure DevOps that powers its search functionality and makes it easy to locate information across all your projects using just a web browser. This article discusses the inner workings of DevOps Search.
Author: SSWUG Research
The Secret Code: ASP.NET MVC Conventions
(Jeremy) ASP.NET MVC is filled with hidden conventions: put a controller or view in a certain place and give it a special name, and it magically works.
materialized WITH query
(Martin Berger) Sometimes I have to improve a SQL query where the same (or similar) subquery is used several times within the whole statement.
GROUP BY might be distinctly better than DISTINCT
(Connor McDonald) One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the source table(s) from which they are derived from, in real time or near real time.
OCI Data Science – Create a Project & Notebook, and Explore the Interface
(brendantierney) In my previous blog post I went through the steps of setting up OCI to allow you to access OCI Data Science. Those steps showed the setup and configuration for your Data Science Team.
Using Websocket with Spring Framework and Vuejs
(Mohamed Sanaulla) Websockets are full duplex (persistent) connections between client and server such that both can share information with each other without the need for repeatedly establishing a new connection.
Spark SQL – Beware of Implicit datatype conversions (TypeCoercion)
(Manoj) While working on some data analysis I saw one Spark SQL query was not getting me expected results. The table had some good amount of data, I was filtering on a value but some records were missing.
Quick tip: Quickly bulk edit lines in SSMS
(Daniel Janik) Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?
Export Excel File using ExcelJS in Angular Service
(Satheesh Elumalai) Let’s explore exporting an Excel file using Exceljs using Angular service. Basically, there are two open-source libraries available to read/write an Excel in client-side applications include
SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5
(Pinal Dave) In the past, I have written a few blogs where I explained a few issues about the failure of listener creation Failure in a cluster. In this blog, we would see another cause of listener creation failure.