(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
Author: SSWUG Research
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.
Oracle 19c Automatic Indexing: Common Index Creation Trap (Rat Trap)
(Richard Foote) When I go to a customer site to resolve performance issues, one of the most common issues I encounter is in relation to inefficient SQL. And one of the most common causes for inefficient SQL I encounter is because of deficiencies the default manner by which the index Clustering Facto
Top 10 SQL Developer Tips for 2020
(Jeff Smith) I love tips, and I love lists. I’ve written a top 10 tips post, but it was way back in 2012. And those tips are still good, but the software and my perspective have definitely changed since then.