SSWUG.ORG

Other News

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 2)

by Basit Aalishan Masood-Al-Farooq

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 2) Autor: Basit A. Farooq Installing instance of SQL Server 2014 on Windows Server 2012 In the first of the five part article series, we discussed the SQL Server 2014 installation prerequisites and the steps that we must perform for the installation of SQL Server 2014 instance. In...

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

Case Sensitive Passwords in Oracle 11

by SSWUG Research

(Andrew Reid) In version 11, Oracle passwords became case sensitive. You can see what I mean in the example below:

Continue Reading →

Community

Removing Redundant Startup/Restart for the OMS Service in Windows

by SSWUG Research

(Kellyn Pot’Vin) I’ve been told many times that the OMS for EM12c can take quite some time to start on Windows. Some told me it took anywhere from three to up to fifteen minutes and wanted to know why. I’ve done some research on the challenge and it is a complex one.

Continue Reading →

Community

In Deference

by SSWUG Research

(David Fitzjarrell) An interesting ‘problem’ surfaced a while ago, one where a user with zero quota on every tablespace could successfully create tables. Of course once it was time to insert data the inserts failed, but this was confusing the user creating the tables.

Continue Reading →

Community

JavaScript Frontend Web App Tutorial Part 2: Adding Constraint Validation

by SSWUG Research

(Gerd Wagner) This article is an excerpt from JavaScript Frontend Web Apps Tutorial Part 2: Adding Constraint Validation, which is part of the open access book Engineering Frontend Web Apps with Plain JavaScript. It is Part 2 of a five part tutorial about engineering frontend web applications with p

Continue Reading →

Community

Pseudo GTID, Row Based Replication

by SSWUG Research

(Shlomi Noach) This post continues Pseudo GTID, in a series of posts describing an alternative to using MySQL GTIDs.

Continue Reading →

Community

Changing Delay Between Responses for SQL Alerts with Powershell

by SSWUG Research

(SQLDBAWithABeard) So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received the Blitz Result: No SQL Server Agent Alerts Configured and like a good and conscientious DBA you have set them up.

Continue Reading →

Community

Using T-SQL to populate a CMS

by SSWUG Research

(Kenneth Fisher) We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the uses for managing multiple servers (PBM etc) we use it primarily as a shared list of registered servers.

Continue Reading →

Community

Working with Ranged Buckets

by SSWUG Research

(Dave Cassel) One of my colleagues ran into an interesting problem a while ago. He had data with high and low values for some field, and he wanted to display bucketed facets on those values. Let’s take a look at how to implement that.

Continue Reading →

Community

SQL SERVER – What is Hypothetical Indexes?

by SSWUG Research

(Pinal Dave) If you ever thought this is some sort of trick to bring you to the blog, well you are wrong. This infact is something worth a look and interesting thing to know. Before I start to explain you the finer details, let me tell you that this is NOT a new feature for performance improvement o

Continue Reading →

Other News

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 2)

Case Sensitive Passwords in Oracle 11

Removing Redundant Startup/Restart for the OMS Service in Windows

In Deference

JavaScript Frontend Web App Tutorial Part 2: Adding Constraint Validation

Pseudo GTID, Row Based Replication

Changing Delay Between Responses for SQL Alerts with Powershell

Using T-SQL to populate a CMS

Working with Ranged Buckets

SQL SERVER – What is Hypothetical Indexes?

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