(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.
Other News
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.
Data Protection on Your (and Your User’s) Travel Times
Some really interesting posts coming out about proper caution when you’re connecting to networks as you travel about for the holidays. Of course, it really applies all the time, in all cases. But at this time when travel is such a key part of the year, some good reminders. One of the things I’ve personally seen more and more are […]
How to Deal with Rude and Difficult Team Members
This question came from a busy professional. Being a manager how do you deal with rude and difficult team members? This is difficult because often it’s a manner of perception or perspective. What some employees deem rude may seem “direct” or “accurate/precise” to others. What some employees find difficult may be diversity in the work place. Not many of us...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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.