(Frits Hoogland) The primary source of information regarding any change or issue on a linux system is the /var/log/messages file. I am often annoyed when a linux system is setup in such a way that certain messages are written to syslog with a high frequency swamping the messages file with informatio
Community
How Insert Statement Works
(Shesadev Biswal) When Oracle receives sql/insert query, it requires to run some pre-tasks before actually being able to really run the query.
Database Migration from non-CDB to PDB – The Patch Level Pitfall
(Mike.Dietrich) There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well.
How to Enable SQL Server CLR Integration using T-SQL
(Daniel Farina) You work as a SQL Server Database Administrator. In your company there is a database application that has grown to a point that needs to be moved to a new server with more resources. You perform the server migration and everything goes fine without any issues.
Getting Started With Ionic 4, Angular And .NET Core 3
(Smiten Kalathiya) In this article, let’s talk about what Ionic framework is, why developers choose it, and how to implement it with Angular and .NET Core 3
Snapshot Isolation in SQL Server
(Gerald Britton) In this article, I’ll explore the use of snapshot isolation using row versioning as an alternative to the classic ANSI SQL transaction levels.
Power Query/M Optimisation: Getting The Maximum Value From A Column, Part 1
(Chris Webb) I’ve just learned some really interesting new Power Query/M optimisation tricks!
Profiler and Trace vs. Extended Events
(Grant Fritchey) It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents.
IBM Reference Architecture for High Performance Data and AI in Healthcare and Life Sciences
(Dino Quintero and Frank N. Lee) This IBM Redpaper publication provides an update to the original description of IBM Reference Architecture for Genomics. It expands the reference architecture to cover all major vertical areas of healthcare and life sciences industries, such as genomics, imaging, and
Reverse Lookups with JavaScript
(David Walsh) I’ve always loved exploring regular expressions because they’re one of those skills that’s never taught in school — you need to pick them up on the fly, messing up and fixing them along the way.