SSWUG.ORG - SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help

Editorials

Old Guidelines Still Apply
January 17, 2019
Back in the day… standard advice was to get that SQL Server off the Internet, public-facing access, if at all possible. Sometimes this [...]
A New Variable in the RFQ Process – (Recognizable) Brand Names
January 15, 2019
Some interesting things happening in the process of RFQs and software platform analysis prior to purchase. More and more we’ve been seeing [...]
Australian Law Could Easily Impact All Data Professionals
December 7, 2018
Australia is currently putting into place has passed a law that would make it possible for the government to compel “backdoors” and [...]

More in this category »

SQL Server

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2)
January 23, 2019
Useful Undocumented SQL Server 2017 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, [...]
How to Grow Your Business with Minimal Investment
January 18, 2019
How can I grow my business with minimal investment? I have started my event management services business but I’m not sure how to convert [...]
Useful Undocumented SQL Server 2017 DBCC Commands (Part 1)
January 16, 2019
Useful Undocumented SQL Server 2017 DBCC Commands (Part 1) In this article, you can find the description of some useful undocumented DBCC commands, [...]

More in this category »

From the Community

Making JSON with SQL Functions
January 23, 2019
(David Churn) In our connected world, we send and receive messages with other businesses using different [...]
Experimenting with ASP.NET Core Authentication Schemes
January 23, 2019
(K. Scott Allen) Some software is easier to understand if you remove the software from it’s usual environment and try some experiments. ASP.NET [...]
Using A ‘Drag Shield’ To Block Mouse Events During A Drag-And-Drop Workflow In Angular 7.1.2
January 23, 2019
(Ben Nadel) The other day, I ran into an issue within a drag-n-drop feature in an Angular 1.6 application in which the drag action kept interacting [...]
Lesson Learned #51: Managed Instance – Import via Sqlpackage.exe doesn’t allow autogrow
January 23, 2019
(Jose M Jurado) Some days ago, I have been working in a service request that our customer faced the following [...]
Writing xUnit Tests in .NET Core
January 23, 2019
(Peter Vogel) In a previous column, I talked about why you might want to switch to xUnit, the new testing framework that’s part of the .NET [...]
How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse
January 23, 2019
(Marco Tusa) Let’s talk about MySQL high availability (HA) and synchronous replication once [...]
Data Guard Unexpected Lag
January 23, 2019
(Neil Chandler) When configuring a physical standby database for Oracle using Data Guard, you need to create Standby Redo logs to allow the redo to [...]
await in turn by mistake
January 23, 2019
(Gerard Davison) I really enjoy working with the new async functions but it is really easy to set up a situation where code that could be running in [...]
Log in to Ubuntu VMs in Oracle Cloud Infrastructure
January 23, 2019
(Martin Bach) When I learned that Oracle was providing Ubuntu images in Oracle Cloud Infrastructure (OCI) I was a bit surprised at first. After all, [...]
Managing Maximum Number of Concurrent Connections in SQL Server
January 23, 2019
(Ben Richardson) By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously [...]
Hot Reloading Using JRebel For Java Application
January 23, 2019
(Ethan Millar) JRebel is one of the Java agents which helps make development much faster by skipping the packaging and deploying steps of the [...]

More in this category »

Other News

await in turn by mistake

by SSWUG Research

(Gerard Davison) I really enjoy working with the new async functions but it is really easy to set up a situation where code that could be running in parallel is force to run in sequence.

Continue Reading →

Lesson Learned #51: Managed Instance – Import via Sqlpackage.exe doesn’t allow autogrow

by SSWUG Research

(Jose M Jurado) Some days ago, I have been working in a service request that our customer faced the following issue:

Continue Reading →

Making JSON with SQL Functions

by SSWUG Research

(David Churn) In our connected world, we send and receive messages with other businesses using different formats.

Continue Reading →

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2)

by Alexander Chigrik

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register

Continue Reading →

Writing xUnit Tests in .NET Core

by SSWUG Research

(Peter Vogel) In a previous column, I talked about why you might want to switch to xUnit, the new testing framework that’s part of the .NET Core package (I also discussed why porting existing test code to xUnit probably isn’t an option).

Continue Reading →

How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse

by SSWUG Research

(Marco Tusa) Let’s talk about MySQL high availability (HA) and synchronous replication once more.

Continue Reading →

Data Guard Unexpected Lag

by SSWUG Research

(Neil Chandler) When configuring a physical standby database for Oracle using Data Guard, you need to create Standby Redo logs to allow the redo to be applied in (near) real time to the Standby.

Continue Reading →

Using A ‘Drag Shield’ To Block Mouse Events During A Drag-And-Drop Workflow In Angular 7.1.2

by SSWUG Research

(Ben Nadel) The other day, I ran into an issue within a drag-n-drop feature in an Angular 1.6 application in which the drag action kept interacting with other parts of the page.

Continue Reading →

Node.js Module Exports – Demystified

by SSWUG Research

(Lou Bichard) When I started out in Node.js, I remember being struck by the weird-looking module.exports code.

Continue Reading →

Experimenting with ASP.NET Core Authentication Schemes

by SSWUG Research

(K. Scott Allen) Some software is easier to understand if you remove the software from it’s usual environment and try some experiments. ASP.NET Security components, for example.

Continue Reading →