SSWUG.ORG

Other News

Some tips for using jobs in SQL Server 2014

by Alexander Chigrik

Some tips for using jobs in SQL Server 2014 Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs and locate any problems. Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can...

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

HTML 5 Elements in a Look: Part 2

by SSWUG Research

(Sibeesh Venu) In this article you will lean about HTML 5 Elements in a look.

Continue Reading →

Community

Primary on FileSystem and Standby on ASM

by SSWUG Research

(Anand) For one of the client, standby server went down. We had another standby server which was kept down for more than a month. Decision was taken to start the server and apply incremental SCN based backup on the standby database.

Continue Reading →

Community

Oracle MFT Part 1 – Transform Batch Files

by SSWUG Research

(James Taylor) I have been working with a customer looking at implementing an enterprise file transfer solution. Very timely as Oracle released Managed File Transfer (MFT) as part of the SOA 12c launch which is a great fit for this use case.

Continue Reading →

Community

Avoid temporary disk tables with MySQL

by SSWUG Research

(Shinguz) For processing SELECT queries MySQL needs some times the help of temporary tables. These temporary tables can be created either in memory or on disk.

Continue Reading →

Community

Except and Intersect

by SSWUG Research

(Kenneth Fisher) EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in any detail or used very often. I’ve been using them myself a bit recently and thought I would explore.

Continue Reading →

Community

Oracle: MERGE ‘Monkey-business’

by SSWUG Research

(David Fitzjarrell) Oracle can do some, well, strange things when fixing issues caused by the optimizer. For 10g releases up to 10.2.0.x Oracle chose to silently ignore a message and eliminate an outer join on the MERGE statement under certain conditions. Let’s examine this and see exactly what Orac

Continue Reading →

Community

Showing Header For Text Table With Single Measure in Tableau

by SSWUG Research

(Donabel Santos) I had a question from one of my students tonight about how to show the header for text table with a single measure. It’s not super straightforward to do this in Tableau. You can’t simply to go the measure pill and show the header (because it doesn’t have it).

Continue Reading →

Community

The Target of Your Defection

by SSWUG Research

(Rodney Landrum) I was a bit nervous this morning. I had been tasked with adding two SQL instances back into a master/target (MSX/TSX) relationship so that they would receive updated job code that had a new DFS share backup maintenance plans. Why was I nervous? Well, nervous might not be the right w

Continue Reading →

Community

DB2 License Management, new Offerings, and an hour of fun

by SSWUG Research

(Henrik Loeser) DB2 is really flexible in how it gets deployed. This includes platforms, resource usage, shared disk or database partitioning models, product names, and product features.

Continue Reading →

Other News

Some tips for using jobs in SQL Server 2014

HTML 5 Elements in a Look: Part 2

Primary on FileSystem and Standby on ASM

Oracle MFT Part 1 – Transform Batch Files

Avoid temporary disk tables with MySQL

Except and Intersect

Oracle: MERGE ‘Monkey-business’

Showing Header For Text Table With Single Measure in Tableau

The Target of Your Defection

DB2 License Management, new Offerings, and an hour of fun

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