Associative Qualities in Relational and Dimensional Databases

Aside from how these structures differ in application (what they do), is it accurate to state that Dimensional Models represent composite entities (collection of primary keys) embodied by a fact table interconnected with its dimensions (foreign keys) and attributes – a “star” schema of relations?

Hoping for general conversation to define the interrelated concepts.

Is back-end only working on DataBases? [on hold]

I have a problem to exactly understand what is the back-end developer meaning? What do exactly back-end developers do? Is their job only working on DataBases?

When I see front-end developers, they design and make the UI, then they even write the codes of buttons, Menus, drawers, progressbars, tabs, etc to make them working.

So the question comes to my mind, what really back-end developers do and is their job only working on Databases or they do have more jobs that I didn’t mention in my above example?

Or maybe better to ask: What part of a project/software is called back-end?

2013 to 2016: Upgrade all DB’s? Or just Content Databases?

I am in the process of completing a Farm Upgrade from 2013 to 2016. I have the new 2016 Farm built and configured, and am ready to transfer the databases.

I know that I don’t need to move the following: (Already created on new 2016 farm). Sharepoint_Config, Sharepoint_AdminContent.

I know that I do need to move the following: WSS_Content_xxxxxxxxxxxxxx, WSS_Content_MySites, WSS_Logging, Search_Service_Application, Secure_Store.

However: Should I also move the following?

SbGatewayDatabase, SbManagementDB, SBMessageContainer01, SocialDB, ProfileDB, WFInstanceManegment, WFResourceManagement.

Multiple db.crypt12 databases in the whatsApp Databases folder

I’m trying to reduce space eaten by the whats-app application on my phone & PC
I see Multiple db.crypt12 databases in the whats-app Databases folder
This is probably due to me copying the app folders to my PC over the years for backup..
Is it possible to remove the least used once?
is it correct that whats-app is using only one of the databases?

whats-app databases

How do I remove apache2 without losing lampp and databases?

I installed lampp (7.3) on ubuntu (18.4). Then I started lampp (sudo /opt/lampp/lampp start) and created my projects and databases with mysql. I could see my projects and databases with visiting (localhost) and (localhost/phpmyadmin). After that, I installed apache2 (2.4.29) to just test it. Now, when I want to start lampp with this command “sudo /opt/lampp/lampp start”, it starts apache2 instead of lampp and I can’t access my projects and tables with (localhost or localhost/phpmyadmin).

  1. Can I access my “lampp tables” in apache2?
  2. If I want to keep my lampp, is it necessary to remove apache2?
  3. Which command can start lampp instead of apache2?
  4. How can I remove apache2 without removing lampp?

Process for building a single ClickOnce application to distribute to multiple clients with separate databases

I’m working on an application that is used by multiple clients. Each client currently has their own database, and the application code is in a client-specific repository.

My team is bringing the code together into one repository to make changes, upgrades and maintenance easier, but I’d like some advice on building and distributing the application from this single source. We currently have 5 different clients, and each has 3 environments (dev, uat, prod).

Currently, each client’s application is built and published manually via Visual Studio IDE, so the database, publish location, and other config are stored in the solution file and app.config. I want to move away from doing the build and publish manually via the IDE and towards a scripted process as I will eventually perform this as part of a larger release management process.

One suggestion from the team was to be able to build the application once and publish to a local server, then as each client was ready to receive the update, we would update/modify the database connection string and app.config settings to their client-specific values, and copy to their download location.

I’ve done some searching, and haven’t found any concrete examples of this being done.

Another option was to build the application for each client, using their client-specific settings, rather than just once – e.g. run a batch script to build and publish for all clients. There was some good advice in this question and this blog post which I have looked at, however I’m wondering if there is a better or different approach now that is recommended?

I’m not sure which would be the best way to go and would appreciate some advice. Are there other options I should consider?

Service Oriented Architecture (SOA): One Database or Multiple Databases?

In Service Oriented Architecture (SOA), should there be One Single Database “with the share as much as possible philosophy” or Multiple Databases by Service/functional area?

I know in Microservices, the hard rule is to apply one database per area.

Just curious if the hard rule applies to SOA?

This is not opinion based: Just curious if there is a hard rule to SOA Architecture principles, if multiple databases allowed or not. Similar to SOLID Principles.

SharePoint 2013 Site Collection Databases Swelling too big over night

I upgraded SharePoint 2010 Farm using database attach method to SharePoint 2013. I have many site collections with their own databases. Overnight randomly one site collection database becomes huge from few MB to 70 GB or more on the sql Server. It is giving warning disk space is too low. I see one of the database and its log file have swelled very big more than 70 GB. If I go to the site collection corresponding to that database I don’t see any content there all list and document libraries have same content. I don’t know where to look for. I am not very good in sql Server. Any help will be appreciated. Thanks.