We run stand alone instances all virtual. SQL 2012 - SQL 2017 Backups are performed by a third party tool so the server has no need to access anything on the network.   Agent jobs are all run via proxy accounts.   I've started to use virtual service accounts since i don't see the need to setup AD accounts and also Microsoft indicates to use a VSA or MSA (if network access is needed).  I just noticed today that, in my sp_Blitz results, the lowest priority issue indicates AD accounts are preferred.  Now of course it is the lowest priority, which to me is a non issue, but I'd really like to know why there is a preference (at least from Brent) to use AD accounts.
My question is, if you create a new domain user account for each of the SQL Server processes, what permissions should be set for each account? Or does the SQL configuration manager actually take care of this, and I just had an unforeseen issue?  I quite often have to setup Microsoft SQL Server and wondered if anyone can provide advice on configuring the accounts the services should run as. IMO this has been vaguely documented by Microsoft, while they point you in the right direction I have never been able to find any concrete examples.  To summarize what I've seen so far:  For simple deployments\development environments it is OK to use the virtual account defaults the installer uses: e.g. NT SERVICE\MSSQLSERVER  Avoid using the SYSTEM account, this is not secure.  For production and in domain environments it's recommended to use either a Managed Service Account, or create a domain user account (not an admin) for each service. Allegedly if you use a domain account at installation time the installer will set any required permissions for you.  If changing the service account on an existing install from a virtual account to a domain account the recommendation is to use the SQL Server configuration manager to set the new service accounts. Allegedly this will set any required permissions for you.  I just tried changing the service account in an existing install to a domain account and it would give me a logon failure until I granted the account log on as service permission, which contradicts the part where the SQL Server configuration manager will set any required permissions. (Although I'm not sure if a GPO may have interfered with setting this local security policy)  Microsoft does provide a list of the permissions that the SQL Server Setup grants .  But it's not clear to me if that is something I should be doing manually for the user I create to run the service as, or whether using the SQL config manager should automatically set these permissions.  SQL Server 2014, Domain Controller is on Windows Server 2008 R2.
The repository 'http://ppa.launchpad.net/mdeguzis/libregeek/ubuntu focal Release' does not have a Release file I can't remember the gender of the main character.  I remember bits and pieces from different books, but I think they're all part of the same series. The pieces may not be in order or from multiple books.   Boy somehow ends up in a mirror universe that's darker and seems to have no people. He has to travel to a certain office(?) building and steal a book. I think this is towards the end of the book (I can't remember the events leading up to it). I think he finds the portal in a forest or something behind his school. He goes into the ocean with mermaids or something and has to save the ocean from pollution. Aliens exist and are observing Earth, because they think it's undeveloped and are waiting for them to be advanced enough. His mother ends up in hospital and he does something to save her. He goes to Ireland(?) and enters a mountain or something to find a race of people. I can't remember who showed him how, but I'm pretty sure she used magic. He goes to Mars and saves a race from war with themselves(?). This place was hidden inside an illusion. He's also grouped with a linguist that learned their language. He travels to another world where there's a prince. I can't remember, but I think it might've been part of a tournament. His sister goes to a robot planet through a portal. I think the actual planet was a robot/AI and had lots of little robots on it. Can't remember what happens here, but he goes there and saves her from something.   It was set a few years ago, when computers weren't common (his family got one early in the first book, I think).  Thanks in advance if someone finds it. When do we still need the table and figure environments when we don't want the enclosed objects to float? The LaTeX Wikibook :     Please understand: you do not have to use floating tables. It only   looks more professional. If you want to place your tables where they   lie in your source code, do not use table at all! This is a very   common misunderstanding among newcomers.   LaTeX works with an intricate , but I often prefer immediate placement with the H placement specifier (enabled by the float package).  My understanding is that captions and table/figure numbering require the table/figure environments. Is this really so, or are there ways around that? What other reasons are there for using table/figure if we know that we don't want a particular object to float? My current employer has given me the opportunity to design my own GIS workstation. The problem is I have no idea what is important when it comes to hardware! I have been given a datasheet from Fujitsu which includes the latest CELSIUS M720 series workstations but the configuration includes about 30 different processors, graphics cards, and hard drives.  I will be working a lot with the ESRI desktop suite (spatial analyst and 3D analyst) and doing a fair amount of raster processing (DEMs, visibility analysis, etc.), but I also use the GDAL library, SAGA-GIS, Quantum GIS and others.  Does ArcGIS 10 actually use multiple cores?  I have the choice from 4 cores with 8 threads up to 8 cores with 8 threads - 16 threads?  Is SSD SATA III better than HDD SATA III?  The Celsius R920 supports up to 512 GB RAM. But what do I need?  It will probably be the last time I get a new workstation for the next 5 years, so I am curious what others have ordered or feel will be necessary for the coming years. Obviously the cloud isn't taking over as quick as they say! I'm one of those exceptions that deviates from the norm: I run CyanogenMod without any Google apps.   Is it possible to download the Stack Exchange Android app .apk directly? Is there a continuous function such that $\int_0^{\infty} f(x)dx$ converges, yet $\lim_{x\rightarrow \infty}f(x) \ne 0$? Is there a continuous function such that $\int_0^{\infty} f(x)dx$ converges, yet $\lim_{x\rightarrow \infty}f(x) \ne 0$?  I know there are such functions, but I just can't think of any example. Disappointed to see that the 18.04 installer no longer offers the option to encrypt the home directory. According to  bug report referenced in the installer, the recommended method for encryption these days is full-disk with LUKS, or fscrypt for directories. Full-disk encryption seems a bit overkill for my needs, and all the bugs and caveats mentioned on the  don't make it a very attractive option. All I really want is to protect my home directory from someone accessing my documents, photos, etc. if my laptop were to get stolen, making fscrypt the option for me.  The  has some examples on how to set it up, but I can't find any documentation aimed at encrypting the home directory on Ubuntu. The old ecryptfs tool is still available, but after setting it up Ubuntu would sometimes freeze at the login screen.  So my question is: How do I setup fscrypt to encrypt my /home directory and decrypt when I log in? I also liked how ecryptfs allowed decrypting the folder manually (eg. from disk images).  (A similar question was posted  and was unfortunately closed for being an "off-topic" bug report. To clarify, this is not a bug report. The fact that the encrypt home directory option was removed from the installer was intentional. All I'm asking here is how to setup fscrypt.) Correct usage of suspended hyphens I have seen some people using them while others not. Should I still use a suspended hyphen in the following snippet?     I have used upper- and lowercase in my script. All Faces to Individual Objects I am looking for a way to take all the faces of an object and make each face it's own object.   In the image above, you'll see a basic representation of what I'm trying to accomplish. On the left is a shape with faces, all attached. On the right is the result I want, an object for each face. The project I'm working on is much more complicated than this example, so I can't select each face and separate by selection. I have over 3,000 faces to work on. How to count derangements? I was going through .Suppose that there are n persons who are numbered 1, 2, ..., n. Let there be n hats also numbered 1, 2, ..., n. We have to find the number of ways in which no one gets the hat having same number as his/her number. Let us assume that the first person takes hat i. There are n − 1 ways for the first person to make such a choice. There are now two possibilities, depending on whether or not person i takes hat 1 in return:  A) Person i does not take the hat 1. This case is equivalent to solving the problem with n − 1 persons and n − 1 hats: each of the remaining n − 1 people has precisely 1 forbidden choice from among the remaining n − 1 hats (i's forbidden choice is hat 1).  B) Person i takes the hat 1. Now the problem reduces to n − 2 persons and n − 2 hats.  From this, the following relation is derived: !n = (n - 1) (!(n-1) + !(n-2))  I have a hard time understanding point B and the equation derived. I was trying to understand with an example of 4 people named A, B, C and D and the corresponding hats A, B, C and D. Everyone of them are supposed to wear any hat except their own matching hat i.e. A can wear B, C or D.  If suppose A wears B hat so we will be left with only 3 people and 3 hats. So I can understand "(n-1)!(n-1)" part but what i didn't understand is part B(marked above). Can anyone help? I have an older iPod touch which which supports up to iOS 6.1.6 and nothing newer.  This device is equipped with a Linea Pro barcode scanner and previously had an application called "" installed.  Recently I was attempting to do some work on a web application I wrote and realized that I needed to update to a newer version of Web Barcode - but unfortunately the Apple ID saved on my device was deactivated a few years ago.  So I went to settings and updated it with my current Apple ID.  Then again tried to update the App from the Apple store.  Still no dice - it was asking me for the password on the old account.  So then I figured I'd just remove it and reinstall from scratch.  Deleted the app and went to the store but now I am met with a message that the new version requires at least iOS 8.0.  I feel I followed a very logical series of steps to update this application and while I can understand that I won't be able to install the newest version, how can I get the old version back?  The device is completely useless without the barcode scanning application and the Apple store is now refusing to install any version at all on my device.  What can I do to get the original version of this application reinstalled? Paging using ldapsearch I am searching an LDAP directory that has a much larger number of results than the sizelimit currently set,500, by slapd.conf that for all intents and purposes cannot be changed)  My idea was to keep running ldapsearch but from a different offset each time (501, 1001, etc.) until all results have been obtained.  I have seen the , and it appears that this is handled for you using the -E options:  -E [!]&lt;ext&gt;[=&lt;extparam&gt;] search extensions (! indicates criticality)          [!]domainScope              (domain scope)          [!]mv=&lt;filter&gt;              (matched values filter)          [!]pr=&lt;size&gt;[/prompt|noprompt]   (paged results/prompt)          [!]subentries[=true|false]  (subentries)          [!]sync=ro[/&lt;cookie&gt;]            (LDAP Sync refreshOnly)                  rp[/&lt;cookie&gt;][/&lt;slimit&gt;] (LDAP Sync refreshAndPersist)   So i tried: ldapsearch -h $HOST -p $PORT -x -L -b "$BASE" '*' '+' -E pr=$SIZE  However when the results (even paged results with size = 50 for example) hit 500, I get the same error as if the results were not paged:  Size limit exceeded (4)  I have seen in the man pages there is another option for virtuallistview but have been unable to find examples for it, and as well I dont think my version of ldapsearch has this option.  The goal here is to create a backup using ldapsearch and the -L option to create an ldif file that is suitable for restoring the database.  A few google searches show up with the same problem I'm having, but none have an applicable solution.. How can I use variables in the LHS and RHS of a sed substitution? Do trees really get a large share of their mass from the carbon in the air? I remember hearing that trees and other plants actually obtain a large amount of their mass from the carbon floating in the air, not the ground beneath them. Does the makeup of air actually contain enough carbon to support this theory, and is a tree's surface area actually large enough to obtain the amount of carbon it needs directly from the air? How should I act when I see tiny "Have you tried this..?" type of answers? SQL query to convert columns into rows How do I install Ubuntu? Context: I was looking at . I didn't know the result referred to in Brian M. Scott's answer is hard enough to require a separate proof   ― .  ― .  (1)  ― What's the intuition? Is Bezout Identity supposed to be intuitive?  (2) — Why doesn't this try work? Let $c$ be any common divisor of $a, b$. Therefore $c\mid a, c\mid b \iff cj_1 = a, cj_2 = b$ for some integers $j_1, j_2$.     Call $g = \gcd$. By definition $\gcd(a,b)\mid a$ and $\gcd(a,b)\mid b$ and $c \le \gcd(a,b)$. Therefore $g\mid a, g\mid b \iff gk_1 = a, gk_2 = b$ for some integers $k_1, k_2$.   The two paragraphs together precipitate $cj_1 = a = gk_1,  cj_2 = b = gk_2$ but this only proves $c\mid gk_1, c\mid gk_2$?    Origin - Elementary Number Theory, Jones,  p9, Exercise 1.8 How to change default window background color in Windows 10? What's the application extension? (aka .exe, .app, etc.) I'm new to Ubuntu. What's the application extension for development reasons? I know Windows is mainly .exe and Mac is .dmg or .app. Does Linux have an unique one?