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

Editorials

Data is Like Evidence
April 16, 2019
When you hear about breaches, so many times it’s because someone didn’t do their job protecting their SQL Server, protecting the data, or [...]
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 [...]

SQL Server

Troubleshooting problems with deadlock in SQL Server 2017
June 26, 2019
Troubleshooting problems with deadlock in SQL Server 2017 If you have problems with deadlock in SQL Server 2017, review this troubleshooting [...]
Using Linguistic Features in NLP
June 25, 2019
If you had to describe what NLP is about, what would you point out as the most important thing? Is there something that is vital for many use cases [...]
Database Development Life Cycle, Normalization, Errors and Security of Database – Part 5
June 24, 2019
Database Security The database security means to practice a broad range of information security controls to safeguard databases (which include data, [...]

From the Community

Bad Idea Cowboy Hat: Using a foreign key to prevent updates
June 26, 2019
(Kenneth Fisher) When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that since I live in Texas it would [...]
Common Data Model
June 26, 2019
(James Serra) The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data [...]
Java tip: When to use composition vs inheritance
June 26, 2019
(Jeff Friesen) In Java 101: Inheritance in Java, Part 1, you learned how to leverage inheritance for code reuse, by establishing is-a relationships [...]
May sum up at IDUG
June 26, 2019
(Javier Estrada Benavides) What have you missed during month of [...]
Machine Learning with ML.NET in UWP: Binary Classification
June 26, 2019
(Diederik Krols) In this article we will use ML.NET to build and compare four Machine Learning Binary Classification pipelines. Each model uses [...]
Most Of Your Modal Windows Should Be Directly Accessible By Route In Angular 7.2.15
June 26, 2019
(Ben Nadel) After years of working on various InVision SPAs (single-page applications) in Angular, I have come to believe – quite strongly [...]
Visual Studio 2019 Productivity Cheat Sheet
June 26, 2019
(David Ramel) Sure, there are plenty of cheat sheets showing keystroke combinations that can increase productivity in Visual Studio, but many new [...]
PHP JWT & REST API Authentication Tutorial: Login and Signup
June 26, 2019
(Ahmed Bouchefra) In this tutorial, we’ll learn how to add JWT authentication to our REST API PHP [...]
Run Oracle VBCS Application on Your Own Server
June 26, 2019
(Andrejus Baranovskis) Latest VBCS release brings an option to export VBCS application and run on your own server (or different cloud [...]
Raw partitions?
June 26, 2019
(Connor McDonald) Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition key is defined as [...]
Quick Tip: Spooling to ‘Excel’
June 26, 2019
(Jeff Smith) Problem: I have 3 queries I want to run. I want the end result to be a single spreadsheet that has all the query results [...]

Other News

Troubleshooting problems with deadlock in SQL Server 2017

by Alexander Chigrik

Troubleshooting problems with deadlock in SQL Server 2017 If you have problems with deadlock in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Keep transactions as short as possible. This can be used to reduce deadlock, because problems with locking typically occurs when several long-running transactions execute concurrently in the same database. The shorter the transaction,…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register

Continue Reading →

Community

Java tip: When to use composition vs inheritance

by SSWUG Research

(Jeff Friesen) In Java 101: Inheritance in Java, Part 1, you learned how to leverage inheritance for code reuse, by establishing is-a relationships between classes.

Continue Reading →

Community

May sum up at IDUG

by SSWUG Research

(Javier Estrada Benavides) What have you missed during month of May?

Continue Reading →

Community

Most Of Your Modal Windows Should Be Directly Accessible By Route In Angular 7.2.15

by SSWUG Research

(Ben Nadel) After years of working on various InVision SPAs (single-page applications) in Angular, I have come to believe – quite strongly – that most of the modal windows within an application should be directly accessible by route.

Continue Reading →

Community

PHP JWT & REST API Authentication Tutorial: Login and Signup

by SSWUG Research

(Ahmed Bouchefra) In this tutorial, we’ll learn how to add JWT authentication to our REST API PHP application.

Continue Reading →

Community

Run Oracle VBCS Application on Your Own Server

by SSWUG Research

(Andrejus Baranovskis) Latest VBCS release brings an option to export VBCS application and run on your own server (or different cloud provider).

Continue Reading →

Community

Common Data Model

by SSWUG Research

(James Serra) The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources.

Continue Reading →

Community

Visual Studio 2019 Productivity Cheat Sheet

by SSWUG Research

(David Ramel) Sure, there are plenty of cheat sheets showing keystroke combinations that can increase productivity in Visual Studio, but many new ones have been introduced with the April 2 launch of VS 2019, including those in subsequent previews.

Continue Reading →

Community

Machine Learning with ML.NET in UWP: Binary Classification

by SSWUG Research

(Diederik Krols) In this article we will use ML.NET to build and compare four Machine Learning Binary Classification pipelines. Each model uses another algorithm to predict the quality of wine from 11 physicochemical features.

Continue Reading →

Community

Raw partitions?

by SSWUG Research

(Connor McDonald) Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition key is defined as RAW. To be honest,

Continue Reading →

Other News

Recent Posts