Trying to wrap my head around what's going on under the hood when integration services is installed, and how that relates to SQL instances on the same machine.  Currently we are aiming to have a full BI stack with each component (SQL Server containing DW, SSAS and SSIS) on separate VMs so resource requirements can be siloed. We want to use the project deployment model for SSIS so are targetting SSISDB rather than MSDB, but the server with SSIS installed doesn't have a SQL instance to host SSISDB, so currently it's installed on the SQL box.  My question is, is it necessary to install a SQL instance on the SSIS box in order to host SSISDB or can it reside just within the integration services instance somehow? If so, does that mean that connecting to the SSIS instance through SSMS is just a legacy feature to manage MSDB or file system packages?   This isn't a question about licensing, it's about infrastructure.
Not sure this is something which people will know on here are not.    We currently have a BI setup where we have Integration services on one SQL instance and the data warehouse database on a separate SQL Instance.    My question is, as no users physically connect to the Integration services SQL instance and it is purely used to execute package from the integrations service catalog via SQL agent, do we need to License every user i.e. Cal's for that SQL instance.  Basically i'm wanting to know if I could utilize SQL 2016 for an integration services instance and use features like Json manipulation etc and then load this data into the 2014 version instance...but what level of licensing will I need?
This is relating to the movie. Frodo finally relinquishes his desire for the ring, and it melts in the fires of Mount Doom. The next scene shows the eruption of Mount Doom and the destruction of Barad Dur. Gandalf looks up with tears in his eyes.  I have read the books, and can't seem to remember this being explained or described. I'm just wondering why they depicted Gandalf as being so emotional about the event, when throughout the story it depicts Gandalf as having unparalleled wisdom, faith and knowledge. Out of all the Ainur he listened to Eru's song the longest and contemplated it's meaning.   It strikes me that Tolkien portrayed Gandalf as all knowing, and has ultimate faith that Frodo would carry out the task at hand. So why was he so emotionally surprised that it happened? Especially when he had seen far more surprising things happening throughout the War of the Ring and in the movies he was depicted as emotionally immovable, an almost cold hearted awareness of the evil that lurks within the world.   I understand this is probably going to be down-voted as it has alot of opinion based statements. The TL:DR is: Was Gandalf described in the book as being so emotional at Sauron's fall? Or was this simply for effect in the screenplay? What is the difference between a desktop environment and a window manager? I'm having a really hard time trying to understand what the differences between a desktop environment and a window manager are?  EDIT: From this :  There are basically three layers that can be included in the Linux desktop: X Windows – This is the foundation that allows for graphic elements to be drawn on the display.  builds the primitive framework that allows moving of windows, interactions with keyboard and mouse, and draws windows. This is required for any graphical desktop. Window Manager – The Window Manager is the piece of the puzzle that controls the placement and appearance of windows. Window Managers include: , , , , , etc. Requires X Windows but not a desktop environment. Desktop Environment – This is where it begins to get a little fuzzy for some. A Desktop Environment includes a Window Manager but builds upon it. The Desktop Environment typically is a far more fully integrated system than a Window Manager. Requires both X Windows and a Window Manager.  Examples of desktop environments are , , ,  among others) Which computer science / programming Stack Exchange sites do I post on? There seems to be more than a few computer science/programming Stack Exchange networks (is that the correct term?). Stack Overflow, being the first, has by far the most users, questions, and answers.  What is the reasoning for creating the others, and are there clear guidelines for which kinds of questions should be posted? I can see a large amount of potential overflow, many cases of people not getting a good answer to their question, because the person who has the answer isn't browsing that particular network at the moment.  I understand that they were probably created for organizational purposes, but wouldn't it almost make more sense to just have them as categories under Stack Overflow, keep them separated but still connected, instead of making people have to create multiple 'account's, one for each network?  I am sure there was a very good reason to break them up, but as someone that is new to SE, it can be somewhat intimidating to decide which one to post in to ensure you get a good answer. For example, if I am a computer science student, my first instinct might to be to post in the computer science network, until I see that it literally has 1% of the users as the Stack Overflow network, which still seems to be for programming/computer science related questions.  So my second instinct would then to be to post it into the Stack&nbsp;Overflow site on the basis that I have a significantly higher chance of my question being seen and getting a good answer. Then I notice that there is also a 'programmers' network, and I don't even begin to know where that fits in. I, and I am assuming most people, will probably just post on Stack&nbsp;Overflow to be safe.  My question is, other than the short little description blurb of each one, is there a clear cut set of guidelines which what each network is intended for, what kinds of questions should go to each one, and is anything being done to encourage people to post in these newer, smaller (more specialized?) networks as opposed to just posting in big daddy Stack Overflow?  Now again, this is for computer science/programming/"why isn't this code doing what I want?" related questions, I am not saying that if I had a question about Linux or WordPress or something I would have the same confusion. Mail.app crashes constantly, even after deleting mail profile and cache I'm looking for the antonym of -cide (as in suicide, pesticide, etc.). Essentially the ending to words that would mean "to create or embrace". Can anyone come up with an explicit example of two functions $f$ and $g$ such that: $f\circ g$ is bijective, but neither $f$ nor $g$ is bijective?  I tried the following: $$f:\mathbb{R}\rightarrow \mathbb{R^{+}} $$ $$f(x)=x^{2}$$  and  $$g:\mathbb{R^{+}}\rightarrow \mathbb{R}$$ $$g(x)=\sqrt{x}$$  $f$ is not injective, and $g$ is not surjective, but $f\circ g$ is bijective  Any other examples? How can I tell Ubuntu to do nothing when I close my laptop lid? Password protecting a page I'm trying to password protect a page but it doesn't seem to be working. I've set the password for the page but when you navigate to it it just loads up like normal and doesn't ask for any passwords.  This is the loop I have on my page:  &lt;?php /**  * @package WordPress  * @subpackage Default_Theme  * Template Name: Page  */  get_header(); ?&gt;  &lt;?php global $post; if ( post_password_required( $post ) ) { ?&gt;  &lt;?php $fields = get_acf(); ?&gt;  &lt;script type="text/javascript"&gt;  (function() {   window.onload = function() {   ...  }} )  &lt;/script&gt;  &lt;div id="map"&gt;&lt;/div&gt;  &lt;?php } else { ?&gt;     Not passworded        &lt;?php if (have_posts()) : ?&gt;         &lt;?php while (have_posts()) : the_post(); ?&gt;          &lt;?php endwhile; ?&gt;     &lt;?php endif; ?&gt;         &lt;?      } // Page isn't password-protected     ?&gt; &lt;?php get_footer(); ?&gt;   I want to password protect everything within the page.  UPDATE:  I have custom content on the page so if possible I need to be able to wrap some code around it all.  Update: I am doing some arcpy -functions and afterwards I'm trying to add the calculated results from one table to another table. I'm using the arcpy.AddJoin_management() function.   As input table I'm using a table which is stored in a personal geodatabase. The personal geodatabase is not the workspace environment! As "JoinTable" a Table of a file geodatabase is used. This file geodatabase is the workspace geodatabase environment.  The initialized function looks like this:  (%self.getWorkspaceEnvironment => "W:/a18fb/data/mypersonalgeodatabase.mdb" and tFactsheetHochwasser => table in the personal geodatabase)  arcpy.AddJoin_management("%s/tFactsheetHochwasser"%self.getWorkspaceEnvironment(),"KPG", "GebaeudeKtn_BWVred1Stat","KPG","KEEP_ALL")  If the code is executed the following error-message appears:  Failed to execute.Parameters are not valid. The value cannot be a table     ERROR 000840: The value is not a Raster Layer.      ERROR 000840: The value is not a Raster Catalog Layer.      ERROR 000840: The value is not a Mosaic Layer.      Failed to execute (AddJoin)`. What is the most elegant proof of the Pythagorean theorem? Simple programs with tutorials for beginners in graphic design? I was going through the fundamental theorem in Number Theory where any non zero integer n can be represented as a product of distinct primes. A related problem with this theorem is to prove that for every such number, there exists a prime $p$ such that $p&lt; \sqrt n$. I was wondering if there is any mathematical proof that no prime $p$ exists for the number $n$ such that $p&gt; \sqrt n$. How to design the attack class in an RPG game? What does **Ens** stand for? Earlier someone was asking about the category "Ens" described in Categories for the Working Mathematician. My question is more basic: What does Ens stand for?  Most of the categories have names that are self explanatory, and maybe this one does too.  But for the life of me I can't think of it, and a Google search was no help. How to extract this format in xslt Prove QM-AM inequality $$\dfrac{x_1^2+ x_2^2 + \cdots + x_n^2}n \geq \left(\dfrac{x_1+x_2+\cdots+x_n}n\right)^2$$   I don't think AM, GM can be used here. And simple expansion doesn't help too. What should I do? On my Toshiba Encore 8 Tablet I noticed that the CPU usage is very high. In Taskmgr / ProcessExplorer, I can see that OneDriveSetup.exe is hogging 1 CPU cores heavily for hours.    How an I solve this hang and finish the OneDrive Update? I have a question regarding transaction log (let’s just call it LDF for short) contents. I am assuming a database with full recovery model.  I have read that LDF file contains (logs) each and every operation to the database (that is in full recovery mode). How is it different from logging during BEGIN TRAN; COMMAND(s); COMMIT? I am asking because apparently you can roll back transactions, but you cannot roll back standard commands (in full recovery mode).  I guess that during transaction the contents being logged into the LDF file are different than in regular full recovery logging. Is that right? How is it different? Is it only the inclusion of “undo” operations for each action?  On a related note, I have heard that there are commercial tools to "rollback/undo" standard queries using full recovery LDF file. How do they do it? Do they analyze the LDF contents and try to come-up with inverse/undo operations? Re-mounting an un-mounted USB stick Is there a way to mount back a USB stick that is once ejected, without physically detaching it and then plugging it in?  It was a live-usb of Linux Mint 14 in it, if it helps. Finding basis of $\mathbb{Q}(\sqrt{2},\sqrt{3},\sqrt{5})$ over $\mathbb{Q}$