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

Editorials

Environment normalization and challenges
November 1, 2018
When you start working in the cloud, you end up making choices, of course, for how you want to implement things. If you look at options for your [...]
Who Decides What’s Good Enough for Data?
October 25, 2018
We are working with a software solution and setting up the SQL Server and general installation configuration for this environment and I stumbled on [...]
Multi-Database Solutions
October 23, 2018
tl;dr There is no easy answer. But it’s important. It can be really challenging to work efficiently in a world where not only is the hosting [...]

More in this category »

SQL Server

Tips for using SQL Server 2017 Integration Services (Part 1)
November 14, 2018
Tips for using SQL Server 2017 Integration Services (Part 1) If you need to distribute data rows to multiple downstream data flow components, you can [...]
Categories of Database and Database Users – Part 5
November 13, 2018
Mapping Cardinalities The cardinalities is the number of entities to which any other entity can be linked through any relation set is known as [...]
Relevant Metrics for Tracking ROI on Social Media
November 9, 2018
What are the relevant metrics for tracking ROI on social media and to determine the success of a digital marketing campaign? This is an impossible [...]

More in this category »

From the Community

Troubleshooting missing projects while using VSTS continuous deployment for Azure App Service
November 14, 2018
(Gaurav Patole) This article shows you how to troubleshoot a specific symptom that you may encounter when configuring continuous deployment for Azure [...]
Configuring GTID and binary logging
November 14, 2018
(Gabriela D’Ávila) This tutorial demands a service restart since some flags here presented can not be dynamically [...]
ORDS: The Easy Way to Protect All Services for a REST Enabled Schema
November 14, 2018
(Jeff Smith) It’s easier to run things [...]
IO Calibration
November 14, 2018
(mgogala) One of the long time problems with Oracle is IO calibration. I am talking, of course, about DBMS_RESOURCE_MANAGER.CALIBRATE_IO [...]
SQL UNION overview, usage and examples
November 14, 2018
(Prashanth Jayaram) This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some [...]
Windows Server Is Still a Thing and SQL Server Still Runs on Top of It
November 14, 2018
(Allan Hirt) If you’ve been in hibernation, today you woke up to a world where Microsoft has embraced open source and Linux. What was once [...]
Db2 12 SQL Pagination
November 14, 2018
(Meg Bernal) Db2 12 for z/OS became generally available in October 2016. Last summer, Chris Crone and I wrote a two-part blog on two highly requested [...]
Micronaut Tutorial: How to Build Microservices with This JVM-Based Framework
November 14, 2018
(Sergio del Amo Caballero) Unlike applications built using traditional JVM frameworks, Micronaut has 100% compile-time, reﬂection free, [...]
Adding Ordinal Indicators with .NET
November 14, 2018
(Hannes DuPreez) If you know me or have read some of my articles, you would know that I am very inquisitive. I also love languages. I have always [...]
Updating Entity Framework Objects with Changed Data
November 14, 2018
(Peter Vogel) Assuming you’re using the latest version of Entity Framework, the easiest way to update your database is to use DbContext’s [...]
JDK Bug System Time Wasters
November 13, 2018
(Dustin Marx) Several possibilities of the message’s possible contents crossed my mind when I saw the title of Jesper Wilhelmsson‘s message [...]

More in this category »

Other News

Updating Entity Framework Objects with Changed Data

by SSWUG Research

(Peter Vogel) Assuming you’re using the latest version of Entity Framework, the easiest way to update your database is to use DbContext’s Entry class: It’s just two lines of code no matter how many properties your object has.

Continue Reading →

Micronaut Tutorial: How to Build Microservices with This JVM-Based Framework

by SSWUG Research

(Sergio del Amo Caballero) Unlike applications built using traditional JVM frameworks, Micronaut has 100% compile-time, reﬂection free, dependency injection and AOP.

Continue Reading →

Db2 12 SQL Pagination

by SSWUG Research

(Meg Bernal) Db2 12 for z/OS became generally available in October 2016. Last summer, Chris Crone and I wrote a two-part blog on two highly requested SQL enhancements.

Continue Reading →

Configuring GTID and binary logging

by SSWUG Research

(Gabriela D’Ávila) This tutorial demands a service restart since some flags here presented can not be dynamically changed

Continue Reading →

Adding Ordinal Indicators with .NET

by SSWUG Research

(Hannes DuPreez) If you know me or have read some of my articles, you would know that I am very inquisitive. I also love languages. I have always wanted to study further, something like drama or writing; sadly, I never had the chance.

Continue Reading →

IO Calibration

by SSWUG Research

(mgogala) One of the long time problems with Oracle is IO calibration. I am talking, of course, about DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure.

Continue Reading →

Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 Integration Services (Part 1)

by Alexander Chigrik

Tips for using SQL Server 2017 Integration Services (Part 1) If you need to distribute data rows to multiple downstream data flow components, you can use the Conditional Split and Multicast transformation. This transformation was first added in SQL Server 2005 Integration Services and make easy for developers to build packages with complex data flow without writing any code. Try...

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 →

SQL UNION overview, usage and examples

by SSWUG Research

(Prashanth Jayaram) This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL.

Continue Reading →

Troubleshooting missing projects while using VSTS continuous deployment for Azure App Service

by SSWUG Research

(Gaurav Patole) This article shows you how to troubleshoot a specific symptom that you may encounter when configuring continuous deployment for Azure App Service.

Continue Reading →

ORDS: The Easy Way to Protect All Services for a REST Enabled Schema

by SSWUG Research

(Jeff Smith) It’s easier to run things unsecured.

Continue Reading →