(Lucas Jellema) In a number of recent articles, I have described how to provision an instance of Oracle Data Warehouse Cloud in Oracle Cloud’s Always Free tier. I have also described how to connect both SQL Developer and Data Visualization Desktop to this ADW instance. In this article, we take this
Community
Using hash values in SSIS to determine when to insert or update rows
(Koen Verbeeck) When you want to load data into your data warehouse, for example into one of your dimensions, you need to determine if an incoming row is either an update – a historical change – or an insert, which is a new occurrence of a record.
Create Dynamic Row With Custom MultiSelect Dropdowns In Angular 8
(Siddharth Gajbhiye) In this article, you will learn how to create dynamic Row with Custom MultiSelect Dropdowns in Angular 8.
Creating Angular Synchronous and Asynchronous Validators for Template Validation
(Rick Strahl) This isn’t a new topic, but I’ve had a hard time to find consolidated information on Validators for the scenario I describe here so I decided to write this down.
Replication with restricted privileges
(Pedro Figueiredo) Up until MySQL 8.0.18, the slave executes replicated transactions without checking privileges. It does so to be able to apply everything that its upstream server (the master) tells it to. In practice this means that the slave fully trusts its master.
Oracle on Azure- Options, Options, Options
(Kellyn Pot’Vin-Gorman) I’ve been very busy allocating 60% of my time towards Oracle on Azure migrations. The biggest challenge right now isn’t getting Oracle on Azure, but keeping my percentage of time allocated to only 60%.
Configure Azure SQL Database Performance Insight – Analyzing SQL Server Query Plans – Part 5
(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query P
Angular Js Custom Directive for Beginners
(R S Dodiya) In this article, I will discuss how to create custom directive in Angular JS and use in our project. This tutorial is for beginners or students. I have also explained the use of directive operation in one page coding.
A Beginner’s Guide to SQL String Functions
(Hannes Du Preez) There are quite a few string functions in the SQL language, and today I will present most of them.
What Happened To @Helpers In ASP.NET Core?
(Mike Brind) When you port your Razor-based application to ASP.NET Core, whether its an MVC application or a Web Pages application, you might notice that adding a @functions block to your .cshtml file works as expected, but any attempt to add a @helpers block doesn’t work at all.