Our database structure utilizes two roles in the Window Failover Cluster Manager.  One is for FCI - switching between the active/passive node in the Primary Data center. One is for SQL Availability Group setup to copy data from the primary data center to the DR data center.  This also use for manual failover in the case of disaster scenario occurs.  Our IT team wants to perform OS patching on these servers regularly on a scheduled down time, the application will be offline when this happens.  This helps us out a bit because we don't have to worry about failover to a node while patching another, but instead we can assume we can bring the database offline completely during patching period. My question is what is the best way to do this since IT team probably does not know much about FCI or Database.  I don't want our databases to failover unexpectedly because during this process one of the active SQL node may needs reboot.  I'm thinking of giving them the following instruction.  RDP into the node active Cluster Group, you can find this by running the powershell command: Get-ClusterGroup and find the OwnerNodeValue of the &quot;Cluster Group&quot;.    Open up Failover Cluster Manager Expands to Roles, there are two    roles one for AG and one for FCI. Right click on each and select &quot;Stop Role&quot; Perform patch, restart ect.. Once done, RDP back in and &quot;Start Role&quot; on the two roles to resume.  Would this work and is it considered good practice?  I am hoping to force the failover service to stop so that the SQL nodes don't fail-over to another node during a server reboot.
Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary Availability Replica on node 3 (no votes). Async commit, manual failover, readable secondary. Node 3 is used to run reports on these 2 databases (out of 8 databases running outside AG on node 1 and 2).   Problem: Looking to patch these from SQL 2014 to SP1 and latest CU. Not my build and no experience with AG or FC so far. My "test" environment is also used for development, so no room for mistakes.   Questions:  What's the best order to patch the 3 nodes ?   Do I first have to remove the databases from AG on the node I'm patching ?  Do I need to take the Secondary out when patching it ?  No experience on this, and I can't find clear answers for my scenario (maybe not supported?) in the docs:
Evaluation of Differentiation and Integration I was having some thought about what would be the syntax to make the end point evaluation of derivatives or integrals. Such as making the | with the two end points of evaluation on the top an bottom of the line. Any suggestions would be wonderful. Input field added through javascript not in PHP $_POST variable. How to fix this? Do I need to change my ESTA address when visiting the US? Canonical vs. non-canonical terminal input I am studying for an exam and I am confused as to how canonical vs. non-canonical input/output works in Unix (e.g., curses).  I understand that there is a buffer to which "line disciplines" are applied for canonical input.  Does this mean that the buffer is bypassed for non-canonical input, or does it simply mean that no line disciplines are applied?  How does this process differ for input and output operations?  In the curses programs I have worked with that demonstrate canonical input, the input typed by a user is automatically entered either after a certain number of characters have been typed or a certain amount of time has passed.  Are either of these things considered "line disciplines" or is this something else entirely? Butterknife appears twice in the OSS attribution list of the Android app (v1.0.85). Based on the links, the second one should be JMustache. By integration by parts and the substitution $x = \sin t$ we can easily calculate the integral $\int_{0}^{1} \ln (x+ \sqrt{1-x^2})dx$ which equals to $\sqrt{2} \ln (\sqrt{2} +1) -1.$ I’ve tried to use the same substitution $x = \sin t$ to calculate the integral $ \int_{0}^{1} \frac {\ln (x+ \sqrt{1-x^2})}{x}dx,$ which becomes $$ \int_{0}^{\frac {\pi}{2}} \frac {\ln \sin (t+ \frac {\pi}{4})}{\sin t}dt$$ It seems difficult to solve the particular integral. Any help? Footnote in tabular environment Einstein-Hilbert action as an effective field theory I have read the following statement:      "The Einstein-Hilbert action can be seen as an effective field theory: setting $g_{\mu\nu}= \eta_{\mu\nu}+h_{\mu\nu}$, one gets a free Lagrangian for the field $h_{\mu\nu}$ plus interactions."   Now, how is it possible to define all the interaction terms?  EDIT: I ask apologize if my statement was appeared unclear: I have created a  which is more precise; please don't continue to consider seriously this one. What torque for caliper brakes onto carbon-alloy forks? I've recently got a new bike with a . This comes with deep-drop calliper brakes (Shimano R451 Dual Pivot). The first time out I bumped one of the brakes and it twisted around the single attachment bolt and rubbed on the rim.  I managed to easily twist it back by hand and carry on, however I thought the bolt probably needs tightening. The question is: How tight can it be?  As the fork is part carbon I've so far only dared to take it up to 4Nm, but it still seems possible to twist the whole calliper around with a bump of the hand. Maybe that's normal? Perhaps it's easier to bump around because of the longer deep-drop lever. Should I be aiming to get it really secure?    I'm not sure whether the brake mount in the fork is all carbon, or some of it is alloy underneath, but either way I'd like to know what a sensible torque is. As far as I can see from the  there is no such specification. How can I find this out? Ambiguity of the word 'any'? LaTeX package for syntax highlighting of code in various languages I am looking for a LaTeX package that does syntax highlighting on code. For example, right now I use the verbatim block to write code:  \begin{verbatim}     &lt;html&gt;        &lt;head&gt;            &lt;title&gt;Hello&lt;/title&gt;        &lt;/head&gt;        &lt;body&gt;Hello&lt;/body&gt;     &lt;/html&gt; \end{verbatim}   And this works fine to display the code on my document. But, suppose I wanted to highlight the HTML markup the way an IDE would in the output document? Is there a package that could help?  I would like to do the same for various languages such as Java, C#, HTML, CSS and so on. Populate an entire pre-configured workspace in i3wm Is it possible with I3Wm to populate an entire workspace with determined size, position and commands for each window?  I know I can do i3-msg "exec xterm -e 'ls; bash'" to create a new window, but I can't specify his position and size.  Maybe there is also an alternative by declaring via JSON the layout or something like that? Let $G$ be  a group and $H$ be a subgroup of $G$ of index $2$ .Then show that if $a,b\notin H$ then $ab\in H$.   $a,b\notin H\implies aH,bH\neq H\implies $ $aH=bH$  since $H$ has only two distinct left cosets in $G$.  $\implies a^{-1}b\in H$  How to show that $ab\in H$ from here? We have 10 PC with some version of Ubuntu and only remote access. While doing some upgrades to custom software I did not notice that the line endings in some scripts were Windows version (CR+LF) and not the Unix version (LF). So now when I want to launch the script it gives an error:   bash: /usr/local/bin/portsee: /usr/bin/python^M: bad interpreter: No such file or directory   Is there a way to change all line endings in a script from terminal. The thing is that I can not install any new software to this group of PC-s. How to derive $E=mc^{2}$? Is there some way to derive ? I can understand that energy in something is proportional to its mass, but the $c^{2}$ part. I have no idea. It seems like the way the units are going it would end up as $kg*(m/s)^{2}$, which I think is the unit for Newtons, not energy. And why is there no constant of proportionality $k$? Did Einstein just set it up perfectly so that there wouldn't be one? At what port did Lorance Effler born about 1787 in Germany come to the US? Your communities list is not visible in mobile web on site where you don’t have an account If you don’t have an account for some site, you can still see a list of your communities via top bar menu of this site, e.g. on 3D Printing:        But this works only for full web, in mobile web «sign up or log in» is shown:        When you have an account then the list of your communities is shown even for mobile web: How to match all occurrences of a regex Does magic jack work on Ubuntu? Does magic jack work with Ubuntu? I originally had my magic jack on a computer with windows XP and I decided to switch to Ubuntu but I still want Magic jack. Is $\frac{1}{\sqrt{2}}$ a fraction or not?