SQL Server: calculating memory requirements for Full db backups

In 2018, we inherited a production SQL Server 2012 FCI running on Windows 2012 with 32 GB RAM. SQL Server max server memory was set at 23.6 GB, and things were running fine.

However, in 2019, we migrated these databases to a SQL Server 2016 FCI. After this migration, our Full backups began intermittently failing due SQL Server restarts. The log seemed to indicate these restarts were due to low memory.

I noticed all of these SQL Server restarts only happened when a full backup was running for our biggest (~80 GB) db. (Incidentally, in case this matters, this db is set to simple recovery model. I have 4 other dbs in full recovery model on this instance: 10 GB, 110 MB, 100 MB, and 50 MB.)

Each time these “low memory restarts” occur, I have been incrementally increasing RAM and max memory. Currently, I’m at 56 GB RAM and max memory is at 45 GB.

From your experience, does it seem unusual for an 80 GB database to require 45 GB max memory during full backups? Can you please share any ideas how I can better identify how much memory my full backup truly needs? Unfortunately, I don’t have a non-production system with similar specs as this one.

Has anyone satisfied the UK fiancee/spouse visa financial requirements by working their foreign job remotely as someone self-employed in the UK?

I’m a UK citizen with a Japanese fiancee. We plan to get married in the UK, so we want to apply for his entry under the fiancee visa. However, we don’t meet the financial requirements yet — I’m searching for, but haven’t yet secured, a UK-based job. That said, I have a Japanese job that meets the income requirement and would be willing for me to work remotely.

I spoke to a Japanese visa firm who suggested it would be possible to count J-income if

  1. I paid tax on the income in the UK.
  2. I became self-employed in the UK and submitted that documentation.

However, it seems like the forms for the self-employed look to a past year of s.e. income, which I don’t have.

Tldr; Has anyone satisfied the UK fiancee/spouse visa financial requirements by working their foreign job remotely as someone self-employed in the UK?

dnd 5e – Does the Thief rogue’s Use Magic Device feature let them ignore class, race, and level requirements on attuning to magic items?

The Artificer’s Magic Item Savant feature states (E:RftLW p. 58, WGtE p. 180; emphasis mine):

(…) You ignore all class, race, spell, and level requirements on attuning to or using magic items.

In contrast, the Thief rogue’s Use Magic Device feature merely states:

(…) You ignore all class, race, and level requirements on the use of magic items.

The Use Magic Device feature doesn’t mention ignoring requirements on attuning to magic items, only on using them. It seems like that would mean a Thief rogue can not attune to a magic item if it has a specific requirement on who can attune to it (e.g. the holy avenger).

Does the Use Magic Device feature let a Thief rogue ignore class, race, and level requirements on attuning to magic items?

Help with Schengen entry requirements

I try to get clear information about which category I fall into when entering the Schengen area because the immigration authorities I called were not very helpful.

I am a Brazilian national (Brazilian passport), married to an Italian and live in Great Britain. I have a British residence card with the words "Family member – EU residence" on the front and the comments on the back "EU right of residence".

Last year I traveled to the EU pretty much on my own for personal reasons (mainly the Netherlands). I show my passport at the border control, answer a few questions and get the entry stamp. I recently noticed that I might be breaking the 90-day rule limit and I don't want to risk overstay.

So my questions are:

  • Does the 90-day rule apply to me (if I travel alone) because the two documents I have are a Brazilian passport and a British residence card?

  • How exactly is the rule applied? In my understanding of the rule, the calculator at https://ec.europa.eu/assets/home/visa-calculator/calculator.htm is wrong because it only takes into account the last 90 days.

How do I find out which version and derivative of Ubuntu is suitable for my hardware in terms of minimal system requirements?

Preliminary remarks


First of all, there is no point in installing versions of Ubuntu that are no longer supported with updates. The reasoning is discussed at the end of this answer.

This answer focuses on currently supported versions of Ubuntu and its official derivatives.

If your hardware never connects to the internet and if you like Never use software that is newer than the installation mediaOnly then may it be advisable to use outdated versions. But who can be sure of it for all eternity?

You don't have to install Ubuntu to see if it works on your hardware. It's always a good idea Boot from Live-DVD / USB and check if the system runs fine (albeit slowly) on the specified hardware.

Even if it doesn't seem to work, you may be just a boot option from a working system. See My computer starts on a black screen. What options do I need to fix? For example the nomodeset Option could help.


Currently supported versions and their minimum requirements

The community wiki usually offers a current list of the currently supported versions. Minimum system requirements for Ubuntu can be found there in the technical data. The Ubuntu certified hardware lists may also be useful to you.

Information about the derivatives is scarce, but their requirements are less than those listed here. In general, 32-bit versions use less memory and tend to be faster than their 64-bit counterparts on older systems. Nowadays, every software requires a 64-bit architecture. If you are unsure, install the 64-bit versions.

Supported versions of Ubuntu

  • 16.04 System requirements recommended by the desktop

    To run Unity, the system needs a more powerful graphics adapter.

    • 2 GHz dual core processor or better

    • 2 GB RAM

    • 25 GB storage space

    • Graphics processor and display with a size of at least 1024 x 768

    • Either a DVD drive or a USB port for the installation medium

    • Internet access is helpful

  • 04/16 Desktop minimal

    To run Unity, the system needs a more powerful graphics adapter.

  • 17.10 and later System requirements recommended by Desktop

    • 64-bit 2 GHz dual-core processor or better

    • 4 GB RAM

    • 25 GB storage space

    • Graphics processor and display with a size of at least 1024 x 768

    • Either a DVD drive or a USB port for the installation medium

    • Internet access is helpful

  • 17.10, 18.04, 18.10, 19.04, 19.10 and 20.04 desktop minimal

    • 64-bit processor for ISO, Intel Pentium 4 processor or better for installation with the Ubuntu minimal CD. The Ubuntu Minimal CD supports the installation of Ubuntu on computers with a 32-bit processor.

    • 1 GB RAM

    • Graphics processor and display with a size of at least 1024 x 768

    • 10 GB storage space

    Ubuntu 18.04 updates will be available for 5 years through April 2023. Updates for Ubuntu 19.10 will be available for 3 months until July 2020.

  • 04/16 and 04/18 server installation standard

    • Ubuntu Server supports three main architectures: Intel x86, AMD64 and ARM.
    • 1 GHz processor
    • 512 MB system memory (RAM)
    • 1 GB storage space (basic system)
    • 1.75 GB storage space (all tasks installed)
    • Graphics card and monitor with a size of 640 x 480
  • 04/16/20/04 Server installation minimal

    • Ubuntu Server supports three main architectures: Intel x86, AMD64 and ARM.
    • 300 MHz processor
    • 256 MB system memory (RAM) 64-bit, 192 MB RAM 32-bit
    • 700 MB storage space (basic system)
    • 1.4 GB storage (all tasks installed)
    • Graphics card and monitor with a size of 640 x 480

    Security and maintenance updates are available for Ubuntu Server 16.04 through April 2021 and for Ubuntu Server 20.04 through April 2025.

Supported versions of Xubuntu

See the Xubuntu help page.

  • 16.04-18.10

    Minimum system requirements
    To install or test Xubuntu on the desktop / live CD, you need 512 MB
    Memory, 700 MHz processor and 7.5 GB of free space on your hard drive.

    Recommended system requirements
    It is recommended to use at least 1 GB of memory to ensure that multiple applications run smoothly on the desktop at the same time. It is recommended to have at least 20 GB of free space. This enables new application installations and the storage of your personal data on the hard disk in addition to the core system.

    Security and maintenance updates will be provided for Xubuntu 16.04 for 3 years until April 2019 and for Xubuntu 20.04 for 3 years until April 2023. Security and maintenance updates will be provided for Xubuntu 19.10 for 9 months through July 2020.

  • April 19 and later

    Minimum system requirements
    To install or test Xubuntu on the desktop / live CD, you need 512 MB
    Memory, 64-bit 700 MHz processor and 7.5 GB of free space on your hard drive.

    Recommended system requirements
    It is recommended to use at least 1 GB of memory to ensure that multiple applications run smoothly on the desktop at the same time. It is recommended to have at least 20 GB of free space. This enables new application installations and the storage of your personal data on the hard disk in addition to the core system.

Supported versions of Lubuntu

  • 16.04-17.10

    Processor (CPU)
    The minimum specification for the CPU is Pentium 4 or Pentium M or AMD K8. Older processors are too slow and AMD K7 has problems with flash video.

    Memory (RAM)
    Your computer requires at least 1 GB RAM for advanced Internet services such as Google+, YouTube, Google Docs and Facebook.

    For local programs such as LibreOffice and simple surfing habits, your computer needs at least 512 MB RAM.

  • April 18 and April 18

    Processor (CPU)
    The minimum specification for the CPU is Pentium 4 or Pentium M or AMD K8. Older processors are too slow and AMD K7 has problems with flash video.

    Memory (RAM)
    Your computer requires at least 2 GB of RAM for advanced Internet services such as Google+, YouTube, Google Docs and Facebook.

    For local programs such as LibreOffice and simple surfing habits, your computer needs at least 1 GB RAM.

  • April 19 and later

    Processor (CPU)
    64-bit processor

    Memory (RAM)
    Your computer requires at least 2 GB of RAM for advanced Internet services such as Google+, YouTube, Google Docs and Facebook.

    For local programs such as LibreOffice and simple surfing habits, your computer needs at least 1 GB RAM.

    Alternative ISOs from Lubuntu are intended for PCs with low RAM memory. Computers with less than 700 MB RAM are considered computers with low RAM. Instructions can be found here.

    Updates will be provided for Lubuntu 4/20 for 3 years through April 2023. Updates will be provided for Lubuntu October 19 for 9 months through April 2020.

Supported versions of Ubuntu Core

With an image size of 260 MB, Ubuntu Core is the smallest Ubuntu version to date. This makes it ideal for both IoT devices and cloud containers. A new version of Ubuntu Core is released every 2 years in even years (2016, 2018, 2020, etc.).

Processor – 600 MHz processor (ARMv7 or higher or x86)
System memory – 128 MB RAM or more
Memory – 4 GB flash / memory for factory reset and system rollback

  • Ubuntu Core 16 and 18

    Ubuntu Core 16 is based on Ubuntu 16.04 and is supported for 5 years.

    Ubuntu Core 18 is based on Ubuntu 18.04 and has been supported for 10 years.


Enter the image description here
RAM use of different flavors from 18.04. Under basic conditions (Click on the image to enlarge it)


Why you shouldn't use versions when their support has ended

  • Security risks: At some point there will be an exploit that threatens the security or system integrity of old versions of Ubuntu
  • Software incompatibilities: Versions that are no longer supported have increasing problems with this. Due to missing updates, the latest LibreOffice documents can no longer be opened or programs compiled that need newer libraries. Hardware drivers of newer devices are not included in older kernels.
  • Reduce repository availability: It can be very difficult to download software that did not ship with the outdated version. Hosting repositories for very old versions is no longer economical at some point.

PHP – Your requirements could not be resolved into an installable set of packages

Tengo un problema cuando trato de instalar la libreria de fpdf, ya vi que el .json estuviera bien, eso es lo que me muestra, ayuda por favor
Error
The requested package phpmailer / phpmailer (locked in version 6.1.5, required as dev master) can be fulfilled by phpmailer / phpmailer (version 6.1.5), but these conflict with your requirements or the minimum stability

.JSON
{
"Name": "Laravel / Laravel",
"Type": "Project",
"description": "The Laravel Framework.",
"Keywords": (
"Frame",
"Laravel"
),
"License": "MIT",
"need": {
"php": "^ 7.2",
"fideloper / proxy": "^ 4.0",
"guzzlehttp / guzzle": "^ 6.3",
"Laravel / Framework": "^ 6.0",
"Laravel / Helfer": "^ 1.2",
"laravel / tinker": "^ 1.0",
"phpmailer / phpmailer": "^ 6.1",
"uxweb / sweet-alert": "^ 2.0"
},
"require-dev": {
"Facade / ignition": "^ 1.4",
"fzaninotto / faker": "^ 1.4",
"laravel / ui": "^ 1.0",
"Ridicule / ridicule": "^ 1.0",
"Nunomaduro / collision": "^ 3.0",
"phpunit / phpunit": "^ 8.0",
"phpmailer / phpmailer": "dev-master"
},
"config": {
"Optimize Autoloader": true,
"Preferred Install": "dist",
"sort-packages": true
},
"extra": {
"Laravel": {
"Do not discover": ()
}}
},
"Autoload": {
"psr-4": {
"App": "App /"
},
"Class ticket": (
"Database / seeds",
"Database / factories"
)
},
"autoload-dev": {
"psr-4": {
"Tests": "tests /"
}}
},
"minimal stability": "dev",
"preferably stable": true,
"Scripts": {
"post-autoload-dump": (
"Illuminate Foundation ComposerScripts :: postAutoloadDump",
"@php craftsman package: discover –ansi"
),
"post-root-package-install": (
"@php -r " file_exists (& # 39 ;. env & # 39;) || copy (& # 39 ;. env.example & # 39 ;, & # 39; .env & # 39;); ""
),
"post-create-project-cmd": (
"@php artisan key: generate –ansi"
)
}}
}}

E-commerce with specific functions or requirements

I have a few customers asking about ecommerce websites and everyone has their own needs:

1. A customer has over 1,000 products in approximately 10 categories. You need a platform with a unique search filter for each category. Category A searches for 4 fields, while Category B searches for 4 different fields.

2. A customer sells several different products, but each product can be available in different sizes. I want to find an e-commerce platform that I can use to create a page for each product. I want to have a table somewhere on the page. In each row it would be the different sizes of this product. The columns would have a few fields, and then I would like there to be a text box for the amount the user wants to order and a button to add to the cart. This button for adding to the shopping cart can either be the last column or the end of the table.

Basically, I want to allow a user to order multiple sizes of a particular product on one page.

I know that this is definitely possible, but I just need to know which platforms I can do this on. I've been looking for an example of this, but can't find one that is exactly what I want (but that's probably because I don't know the right industry or website to look for).

3. A customer wants to enable users to register for conferences or training online. The date and time as well as the number of available seats are available for each session.

4. A customer already has a website, but now wants to sell some products (less than 5), but wants a simple shopping cart and not just individual links to PayPal or the like.
SEMrush

I know I ask a lot in one post, but I thought it would be better to do it in one thread than to start 4 different ones.

I appreciate advice and recommendations that you have in these situations.

juju – Add authentication requirements for Snapcraft applications

I installed Ubuntu Server version 20.04. On my computers and enchanted Kubernetes provided with Snap / Juju. However, not only does Juju not require superuser permissions, it also fails when I use sudo:

ERROR cannot acquire lock file to read all the controllers: unable to open /tmp/juju-store-lock-X: permission denied

Since the Juju command is very powerful, there is a recommended way to restrict access to it, e.g. through additional authentication?

native support for magento2 – m2 or recommended extensions for location requirements in wholesale

We have just switched to m2. In m1 we had to hire a programmer to customize our site. We have a wholesale and retail website that runs the same data, multistore.

We are looking for the cheapest way to implement the following for wholesale.

1-size matrix per product for ordering configurable variants in quantity per size

2-way to order items that are currently out of stock

Show 3-SKU in the catalog view

Hide 4 prices for unregistered users, show "Log in to view prices" instead of "Add to cart" for all items in the category and detail view including out of stock products.

5-Remove the "Out of Stock" display in the category and detail view

6-Multi-Store, hide items not in stock in one store, show them on the other