SSWUG.ORG - SQL Server, Azure SQL Database, Oracle and IBM DB2 Help

Editorials

Can Entity Framework Performance Compete With a Custom ORM Implementation?
August 18, 2017
I’m having a hard time realizing what I am going to write today. It goes against what I have experienced for years. And it explains [...]
Optimizing Data Transformations
August 17, 2017
AutoMap is a Dot Net library used to transform data model objects to and from data transfer objects. It uses a fluent syntax, helping you [...]
SqLite and Dot net
August 16, 2017
Today I was working with an application where I create a SqLite database for an embedded device. I’ve been using the System.Data.SqLite package [...]

More in this category »

SQL Server

Troubleshooting SQL Server 2016 Snapshot Replication
August 16, 2017
Troubleshooting SQL Server 2016 Snapshot Replication If you have problems with SQL Server 2016 snapshot replication, review this troubleshooting [...]
Distributed Databases with Client Server Architectures Part – 4
August 14, 2017
Data Duplication and Allocation Duplication is beneficial in refining the obtainability of data. The maximum extreme case is replication of the full [...]
Troubleshooting SQL Server 2016 Merge Replication
August 9, 2017
Troubleshooting SQL Server 2016 Merge Replication If you have problems with SQL Server 2016 merge replication, review this troubleshooting checklist [...]

More in this category »

From the Community

In-Memory ASP.NET Core Integration Tests with TestServer
August 18, 2017
(Jason Roberts) Test, test and test again. You can automate those tests with a TestServer-based Web app that doesn’t even touch the Web [...]
Create the Oracle database objects
August 18, 2017
(Dimitri Gielis) This post is part of a series of posts: From idea to app or how I do an Oracle APEX project anno [...]
Extended Engagement
August 18, 2017
(David Fitzjarrell) Oracle offers, in release 12.1.0.2, the option of increasing the maximum string length from the standard 4000 to a whopping [...]
OBI formatting grand totals – without XML!
August 18, 2017
Recently I needed to have some conditionally formated grand total rows in OBI. I remember years ago hacking around with the XML which is far [...]
MySQL 8.0: When to use utf8mb3 over utf8mb4?
August 18, 2017
(Morgan Tocker) Long time MySQL users will recognize that there are two varieties of utf8 support in MySQL; utf8mb3 and utf8mb4. Let me dig a [...]
Maximize your business value with 5 universal use cases
August 18, 2017
(Sam Weeks and Martin Westphal) This series of articles introduces the Representational State Transfer (REST) application programming interface (API) [...]
Accessing XML Data From XML Document In C# Console Application
August 18, 2017
(Saravanan Ponnusamy) In this article, I am going to give you the best way to access XML data from an XML document and also how [...]
New SQL Server 2017 features give good reasons for fast upgrades
August 18, 2017
(Michael Otey) SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database [...]
Performance is bad. Did you change anything recently? No. Are you sure?
August 18, 2017
(Kenneth Fisher) Ever have this [...]
Migrating complex JavaScript applications
August 18, 2017
(Jack Franklin) This blog post is a write up of a talk I’ve gave at Front Trends in Poland, May 2017. You can find the [...]
Implementing SQL Server Failover Clustering in Azure
August 18, 2017
(Marcin Policht) Deploying Infrastructure as a Service (IaaS) solutions in Microsoft Azure offers a number of benefits that leverage agility, [...]

More in this category »

Other News

Migrating complex JavaScript applications

by SSWUG Research

(Jack Franklin) This blog post is a write up of a talk I’ve gave at Front Trends in Poland, May 2017. You can find the […]

Continue Reading →

Can Entrepreneurship Be Taught? (Part 2)

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of […]

Continue Reading →

Ten HTML Tags Developers Should No Longer be Using in Web Apps

by SSWUG Research

(Nathan Segal) In any conversation about HTML5, one needs to consider what’s changed and how to adapt to those changes. Although many tags are now […]

Continue Reading →

In-Memory ASP.NET Core Integration Tests with TestServer

by SSWUG Research

(Jason Roberts) Test, test and test again. You can automate those tests with a TestServer-based Web app that doesn’t even touch the Web server.

Continue Reading →

Can Entity Framework Performance Compete With a Custom ORM Implementation?

I’m having a hard time realizing what I am going to write today. It goes against what I have experienced for years. And it explains […]

Continue Reading →

New SQL Server 2017 features give good reasons for fast upgrades

by SSWUG Research

(Michael Otey) SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, […]

Continue Reading →

SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet

by SSWUG Research

(Pinal Dave) There are many rules in SQL Server setup which are checked to make sure that the user is not seeing failure at the […]

Continue Reading →

Accessing XML Data From XML Document In C# Console Application

by SSWUG Research

(Saravanan Ponnusamy) In this article, I am going to give you the best way to access XML data from an XML document and also how […]

Continue Reading →

QA for Big Data Applications – Part 1

by SSWUG Research

(Lockwood Lyon) Big data applications promise the ability to analyze huge volumes of transactional data for actionable (i.e., profitable) intelligence.

Continue Reading →

Implementing SQL Server Failover Clustering in Azure

by SSWUG Research

(Marcin Policht) Deploying Infrastructure as a Service (IaaS) solutions in Microsoft Azure offers a number of benefits that leverage agility, resiliency, and scalability built into […]

Continue Reading →