(Martin Hubel) Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall performance. In the world of relational database, I/O can easily surpass all other considerations, particularly if an SQL statement asks for a very large result
Editorials
SQL Server Backups and The Cloud
March 10, 2020It used to be that SQL Server backups were the topic of every other webinar that was hitting the airwaves. Nowadays, that’s not the case; so [...]
Analytics, Reporting and Fine Line of Privacy
February 21, 2020It can be very challenging to pull together reporting, analytics, data privacy expectations and support for legislation for information in your [...]
Bridges Between Servers
February 12, 2020Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble [...]
Other News
Part II: Overview of B- Tree and B+ Tree
Introduction to B+ Tree The drawback of the B tree used for indexing is that it stores a data pointer (a pointer to a block of a disk file with a key value) that matches a given key value, along with that key value in the B tree node. This technique significantly reduces the number of entries that can be…...
Is it undermining or rude to email the boss to ask him to get his act together?
A busy professional asked me this question: Is it undermining or rude to email the boss to ask him to get his act together after 1am? This is one of the reasons- undermining management, the HR dismissed me for gross misconduct. I was a chef and finished very late every night. I would not do it. It’s…...
Getting Started With Deep Learning in Your Browser Using TensorFlow.js
(Raphael Mun) Here we look at: Setting up TensorFlow.js, creating training data, defining the neural network model, and training the AI.
SQL Server Collation Overview and Examples
(Aubrey Love) While installing SQL Server or creating databases and tables, we often run with the defaults. In most cases, that’s not a bad thing. However, when it comes to setting the COLLATION, we again often run with the default settings.
MySQL Escaping on the Client-Side With Go
(Max Dudin) Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections.
VS Code Gets New Python Language Server, Named After Monty Python Character
(David Ramel) Someone on the development team for Python in Visual Studio Code is a Monty Python fan.
How Hello World! changed – top level statements and functions (C# 9)
(Christian Nagel) C# 9 comes with many new features to enhance productivity and fix bugs. One productivity enhancement comes for small programs and learning C#: top level statements.
Upgrading the node image of an Azure Kubernetes Service cluster
(Daniel Neumann) Last year I have written a shell script to update the VMSS base image of an Azure Kubernetes Service cluster.
PL/SQL Generator for CFBF files
(Marc) As a preliminary step towards adding password encryption to ExcelGen (see previous post), I have enhanced my existing CFBF reader with file generation capabilities.