(Pinal Dave) Earlier this week, I wrote about SQL SERVER – Simple Example of Batch Mode in RowStore. It was very well received and lots of people started to ask questions after reading the blog post. The most asked question was about the Performance difference between RowMode and BatchMode.
Other News
Why oh Why? Effects of Antivirus on a DB Server
(Jason Brimhall) The second Tuesday of the month is upon us once again. That means it is time for another group blog party called TSQLTuesday.
Performing CRUD operations with a Python SQL Library for SQL Server
(Ben Richardson) This article covers how to connect a Python application to Microsoft SQL Server using a 3rd party Python SQL library. The library that we are going to use is called “pyodbc”, which is freely available.
Setting up MySQL Cluster on local machine using AutoInstaller
(Mikael Ronstrom) We have a new version of the MySQL Cluster Auto Installer. I have prepared 3 Youtube videos that shows how to make use of the Auto Installer to install and set up a cluster on your local machine.
Using Ubuntu Virtual Machine in Azure
(Tapas Pal) Developers now can create an Ubuntu Server virtual machine (VM) from the Azure portal. By default, in Azure Stack Marketplace, a Linux image is not available.
Recommended Asynchronous Pattern in .NET
(Damir Arh) The recommended pattern for asynchronous programming in the .NET framework is the task-based asynchronous programming (TAP). This tutorial gives a brief info about this pattern.
Microsoft Plugs Away at ‘Huge Technical Challenge’ of Creating WinForms Designer on .NET Core
(David Ramel) Microsoft developers keep plugging away at the “huge technical challenge” of duplicating the Windows Forms designer found in the aging, Windows-only .NET Framework in .NET Core, the new open-source, cross-platform default approach for .NET coding.
Hibernate Tip: How to customize the association mappings using a composite key
(Thorben Janssen) Hibernate Tips is a series of posts in which I describe a quick and easy solution for common Hibernate questions. If you have a question for a future Hibernate Tip, please post a comment below.
Does Your DBMS Support Temporal Data?
(Craig S. Mullins) Data changes over time, and many applications and users need to access data at different points in time. A traditional DBMS stores data that is implied to be valid now — at the current point-in-time.
APEX 19.2: Faceted Search
(Jeff Smith) I’ve heard quite a bit about this killer, new feature in Oracle Application Express (APEX) version 19.2..so I wanted to give it a go, and share it with you folks.