SSWUG.ORG

Other News

Tips for using Transactional Replication in SQL Server 2019 (Part 2)

by Alexander Chigrik

Tips for using Transactional Replication in SQL Server 2019 (Part 2) Consider increasing the -CommitBatchThreshold parameter of the Distribution Agent. This parameter specifies the number of replication commands to be issued to the Subscriber before a COMMIT statement is issued. The default value is 1000. If you do not need continuous replication, avoid configure the Distribution Agent to run continuously....

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 →

Community

Database Design and Logical Asseveration for SQL Query Optimization

by SSWUG Research

(Jignesh Raiyani) Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate.

Continue Reading →

Community

Creating or Altering an Objects with a Single Statement

by SSWUG Research

(Gregory Larsen) Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this as much as I do.

Continue Reading →

Community

IBM Power Systems Infrastructure I/O for SAP Applications

by SSWUG Research

(Dino Quintero, Edmund Haefele, Gerd Kehrer, Katharina Probst) This IBM Redpaper publication outlines experience gained by the authors on architectures working well in client environments.

Continue Reading →

Community

Java’s Missing Features: Five Years Later

by SSWUG Research

(Ben Evans) Almost five years ago, I wrote an article outlining some feature ideas from other languages that I felt could be of benefit to Java.

Continue Reading →

Community

Oracle multi-tenant and library cache isolation

by SSWUG Research

(Frits Hoogland) This post is the result of a question that I got after presenting a session about Oracle database mutexes organised by ITOUG, as a response to the conference cancellations because of COVID-19.

Continue Reading →

Community

Oracle Database on YouTube

by SSWUG Research

(Jeff Smith) I’ve been working from home since about 2008, but for many of you it’s no longer just a perk. It’s a side effect of the worldwide response to the Corona virus. Obviously I’m hoping all of your are well and safe at home, and things are back to ‘normal’ as quickly as possible.

Continue Reading →

Community

Compute in Oracle Cloud Infrastructure(OCI)

by SSWUG Research

(Jagruti Jasleniya) Compute is one of the key component in Oracle Cloud Infrastructure. Compute is a machine with Instance Type ,OCPUs(Oracle Compute Unit) , RAM , local disk , network bandwidth and number of VNICs you can attach to your instance.

Continue Reading →

Community

Using the OAuth 2.0 device flow to authenticate users in desktop apps

by SSWUG Research

(Thomas Levesque) Over the last few years, OpenID Connect has become one of the most common ways to authenticate users in a web application.

Continue Reading →

Community

Make your C# applications faster with LINQ joins

by SSWUG Research

(Tim Deschryver) I’ve experienced a handful of times that an application has slowed down sufficiently without a code change.

Continue Reading →

Other News

Tips for using Transactional Replication in SQL Server 2019 (Part 2)

Database Design and Logical Asseveration for SQL Query Optimization

Creating or Altering an Objects with a Single Statement

IBM Power Systems Infrastructure I/O for SAP Applications

Java’s Missing Features: Five Years Later

Oracle multi-tenant and library cache isolation

Oracle Database on YouTube

Compute in Oracle Cloud Infrastructure(OCI)

Using the OAuth 2.0 device flow to authenticate users in desktop apps

Make your C# applications faster with LINQ joins

Recent Posts

Debugging Multi-Cloud Performance

Mixing Flavors of SQL Server

July Spotlight – Db2 LUW: Types of I/O

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

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

Debugging Multi-Cloud Performance

Mixing Flavors of SQL Server

July Spotlight – Db2 LUW: Types of I/O

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

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

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

SQL Server Collation Overview and Examples

MySQL Escaping on the Client-Side With Go

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

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

SSWUG.ORG