SSWUG.ORG

Editorials

Debugging Multi-Cloud Performance
December 1, 2021
We’ve been chasing issues with performance across a series of applications where there are multiple cloud providers (specifically AWS and [...]
Mixing Flavors of SQL Server
November 22, 2021
It’s been an interesting ride, optimizing SQL Server, figuring out best use cases for the different flavors of SQL Server that we have come to [...]
SQL Server Backups and The Cloud
March 10, 2020
It 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 [...]

SQL Server

Debugging Multi-Cloud Performance
December 1, 2021
We’ve been chasing issues with performance across a series of applications where there are multiple cloud providers (specifically AWS and [...]
Part II: Overview of B- Tree and B+ Tree
August 10, 2020
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 [...]
Is it undermining or rude to email the boss to ask him to get his act together?
August 7, 2020
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? [...]

From the Community

July Spotlight – Db2 LUW: Types of I/O
August 12, 2020
(Martin Hubel) Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall [...]
Getting Started With Deep Learning in Your Browser Using TensorFlow.js
August 5, 2020
(Raphael Mun) Here we look at: Setting up TensorFlow.js, creating training data, defining the neural network model, and training the [...]
SQL Server Collation Overview and Examples
August 5, 2020
(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 [...]
MySQL Escaping on the Client-Side With Go
August 5, 2020
(Max Dudin) Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things [...]
VS Code Gets New Python Language Server, Named After Monty Python Character
August 5, 2020
(David Ramel) Someone on the development team for Python in Visual Studio Code is a Monty Python [...]
How Hello World! changed – top level statements and functions (C# 9)
August 5, 2020
(Christian Nagel) C# 9 comes with many new features to enhance productivity and fix bugs. One productivity enhancement comes for small programs and [...]
Upgrading the node image of an Azure Kubernetes Service cluster
August 5, 2020
(Daniel Neumann) Last year I have written a shell script to update the VMSS base image of an Azure Kubernetes Service [...]
PL/SQL Generator for CFBF files
August 5, 2020
(Marc) As a preliminary step towards adding password encryption to ExcelGen (see previous post), I have enhanced my existing CFBF reader with file [...]
Top 10 SQL Developer Tips for 2020
August 5, 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 [...]
Oracle 19c Automatic Indexing: Common Index Creation Trap (Rat Trap)
August 5, 2020
(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 [...]
Db2 Location Statistics Traces for Remote Applications
August 5, 2020
(James Pickel) Do you have a significant amount of work coming into your Db2 for z/OS subsystems through the Distributed Data Facility? If so, this [...]

Other News

Debugging Multi-Cloud Performance

by SiteAdmin

We’ve been chasing issues with performance across a series of applications where there are multiple cloud providers (specifically AWS and Azure) in play. The application is a fairly typical .net web-based application that does calls to Azure SQL DB and AWS RDS at various times and places. The issue we’ll see from time to time surrounds lag time between the...

This content is for Pro Member, Pro, Standard Member, Standard, Free, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register

Already a member? Log in here

Continue Reading →

Amazon AWS Amazon RDS Azure Azure SQL Database Editorials

Mixing Flavors of SQL Server

by Stephen Wynkoop

It’s been an interesting ride, optimizing SQL Server, figuring out best use cases for the different flavors of SQL Server that we have come to rely on, and we’re seeing those choices pay off in terms of management, performance, and cost savings. The “flavors” I’m speaking of? AWS RDS SQL Server, Azure SQL DB specifically. Our event platform is based […]

Continue Reading →

Community

July Spotlight – Db2 LUW: Types of I/O

by SSWUG Research

(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

Continue Reading →

Pro Members SQL Server Standard Members

Part II: Overview of B- Tree and B+ Tree

by Sunny Singh

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...

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

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Is it undermining or rude to email the boss to ask him to get his act together?

by Laura Lee Rose

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...

Already a member? Log in here

Continue Reading →

Community

Getting Started With Deep Learning in Your Browser Using TensorFlow.js

by SSWUG Research

(Raphael Mun) Here we look at: Setting up TensorFlow.js, creating training data, defining the neural network model, and training the AI.

Continue Reading →

Community

SQL Server Collation Overview and Examples

by SSWUG Research

(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.

Continue Reading →

Community

MySQL Escaping on the Client-Side With Go

by SSWUG Research

(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.

Continue Reading →

Community

VS Code Gets New Python Language Server, Named After Monty Python Character

by SSWUG Research

(David Ramel) Someone on the development team for Python in Visual Studio Code is a Monty Python fan.

Continue Reading →

Community

How Hello World! changed – top level statements and functions (C# 9)

by SSWUG Research

(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.

Continue Reading →

Other News

Recent Posts