(Jayendra Viswanathan) Functions are objects that return values after some process and SQL Server offers many system functions that are used internally and things that we can use as well. There are table-valued functions and scalar functions and in this tip we will take a look at a couple of these
Other News
MySQL Shell 8.0 – What’s New?
(Rene Ramirez) In MySQL 8.0 a new stack of components is introduced, turning MySQL to a competitive Document Store solution.
Controlfile in Oracle Database
(Anuradha Mudgal) Today we are going to have look at the most important element of the Oracle Databases.Being Oracle DBA we must have good knowledge about Controlfile. It plays an important role in Oracle Database.
Using Angular Services for Component Communication using Event Subscription and Notifications
(Mahesh Sabnis) Use Angular services to communicate data across components using Event Subscription and Notifications.
Starting Angular With Visual Studio Code
(Vignesh Mani) This article explains how to start Angular with Visual Studio Code. Using Visual Studio code we can create an Angular project. Please follow the following steps to achieve this.
Staying up-to-date with .NET Container Images
(Rich Lander) This post describes the container images that we produce and update for you, that you can use with Docker, Kubernetes and other systems. When you are using .NET and Docker together, you are probably using the official .NET container images from Microsoft. We’ve made many improvements o
Causes and Workarounds for Slave Performance Too Slow with Row-Based Events
(Alex Poritskiy) Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log.
SQL SERVER – Parallel Redo on AlwaysOn Secondary – DIRTY_PAGE_TABLE_LOCK
(Pinal Dave) As most of you might know that my expert area in SQL Server in performance tuning. But, I also deal with almost every issue related to SQL Server engine. Many times, it so happens then clients call me for performance tuning and while fixing, we see some other problem.
Oracle Machine Learning Users on ADWC
(Brendan Tierney) One of the new features of the Autonomous Data Warehouse Cloud (ADWC) service is Oracle Machine Learning. This is a Zeppelin based notebook for your machine learning on ADWC.
Unexpected Token < in JSON at Position 0
(Dave Ceddia) Unhandled Rejection (SyntaxError): Unexpected token < in JSON at position 0 [membership level="0"] Register to Read [/membership]