Writing data to new database - collation question
Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility'
How do I make Bash my default shell on Ubuntu? Has Wonder Woman ever killed a mortal in anger? Is there a "do ... while" loop in Ruby? I'm using this code to let the user enter in names while the program stores them in an array until they enter an empty string (they must press enter after each name):  people = [] info = 'a' # must fill variable with something, otherwise loop won't execute  while not info.empty?     info = gets.chomp     people += [Person.new(info)] if not info.empty? end   This code would look much nicer in a do ... while loop:  people = []  do     info = gets.chomp     people += [Person.new(info)] if not info.empty? while not info.empty?   In this code I don't have to assign info to some random string.  Unfortunately this type of loop doesn't seem to exist in Ruby. Can anybody suggest a better way of doing this? Does the series $\sum \limits _{n=0}^{\infty} \cos(n\pi)$ converge or diverge? Does the series $\sum \limits _{n=0}^{\infty} \cos(n\pi)$ converge or diverge?   On substituting values I get alternate $1$ and $-1$.    So taking sum of infinite GP, I get $\dfrac 1 2$. So it looks like it converges. Setting the pivot point of an object I have a sword that currently rotates around a pivot point thats off of the actual object. Im new to blender and im not sure how i would go about changing it so that the sword rotates around the handle. Any help would be appreciated! I feel intimidated in learning TikZ. I was wondering if there are some nice materials (or just your replies) at different level:   for providing big picture, which is important to beginners to not lose direction during learning. for comprehensive reference.   Examples are important, but only examples are not always clear for understanding the big picture and organization. $ac\equiv bc \pmod{\!m}\!\!\iff\!\! a\equiv b \pmod{\!\!\frac{m}{(c,m)}}$ [Euclid's Lemma, congruence form] I came across this theorem:   For all integers a,b,c and m&gt;0, if d = GCD(c,m) then a*c ≡ b*c (mod m) iff a ≡ b (mod m/d).  The =&gt;proof states this:  a*c ≡ b*c (mod m) =&gt; m|(a-b)*c                    =&gt; m/d | (a-b)*c/d                   =&gt; m/d | (a-b)                   =&gt; a ≡ b (mod m/d)   I don't understand how to go from step 2 to step 3. The proof states that this is possible because m/d and c/d are coprime. To me this means GCD(m/d, c/d) = 1 but how does this cancel out the whole term? Compare nullable types in Linq to Sql I have a Category entity which has a Nullable ParentId field. When the method below is executing and the categoryId is null, the result seems null however there are categories which has null ParentId value.  What is the problem in here, what am I missing?  public IEnumerable&lt;ICategory&gt; GetSubCategories(long? categoryId) {     var subCategories = this.Repository.Categories.Where(c =&gt; c.ParentId == categoryId)         .ToList().Cast&lt;ICategory&gt;();      return subCategories; }   By the way, when I change the condition to (c.ParentId == null),  result seems normal. Can I use Beetel 450TC1 as wireless router? Canonical Isomorphism Between $\mathbf{V}$ and $(\mathbf{V}^*)^*$ For the finite-dimensional case, we have a canonical isomorphism between $\mathbf{V}$, a vector space with the usual addition and scalar multiplication, and $(\mathbf{V}^*)^*$, the "dual of the dual of $\mathbf{V}$." This canonical isomorphism means that the isomorphism is always the same, independent of additional choices.   We can define a map $I : \mathbf{V} \to (\mathbf{V}^*)^*$ by $$x \mapsto I(x) \in (\mathbf{V}^*)^* \ \text{ where } \ I(x)(f) = f(x) \ \text{for any } \  f \in \mathbf{V}^*$$  My Question: what can go wrong in the infinite-dimensional case? The notes I am studying remark that if $\mathbf{V}$ is finite-dimensional, then $I$ is an isomorphism, but in the infinite-dimensional case we can go wrong? How? Equation of a rectangle I need to graph a rectangle on the Cartesian coordinate system. Is there an equation for a rectangle? I can't find it anywhere. How do we perform transverse measurements in a two level system? In quantum mechanics any two level system can be mapped onto effective spin variables. If the system is defined by two energy levels, $|E_1\rangle$ and $|E_2\rangle$, the Hamiltonian is  $$ H = \left(\begin{array}{cc} E_1 &amp; 0 \\ 0 &amp; E_2 \end{array}\right) \, .$$  This can be recast as  $$ H = \frac{E_1+E_2}{2} 1\!\!1 + \frac{E_1-E_2}{2} \sigma_3\, .$$  $1\!\!1$ is the identity operator and $\sigma_3$ is the third pauli matrix. This is very nice because we can now apply our knowledge and intuition of spin dynamics to any two level system.  My question is the following: for a real spin I can measure expectation values of $\sigma_{1,2}$ by physically rotating my system and align its $x$ or $y$ axis with my measuring apparatus. How do I do this (in the lab!) with a pseudo-spin system? Imagine I am looking at a cold atom and I want to know if the system is in an symmetric or anti-symmetric superposition of $|E_1\rangle$ and $|E_2\rangle$, how do I do it? How do you copy the contents of an array to a std::vector in C++ without looping? BSOD: Driver State Power Failure For the past two weeks, I've been getting this BSOD error on my Lenovo laptop. I have even reset my laptop ("rest this PC"), but it's still happening.  My laptop details:     I have the latest Nvidia driver for my Nvidia Geforce MX150: 431.60 released on 23 Jul 2019.  I have the latest BIOS for my laptop: 8TCN53WW15  released on 15 Jul 2019.     I have run WhoCrashed, it says it says the problem was caused by some driver which could not be identified. If I get to know the problematic driver I will update/uninstall it.  How can I analyze my dump files, so that I can find the problematic driver?  Edit 1: If you get "Oops there was a problem with the network" on google drive page while accessing dump files, just click on download. They will be downloaded. I don't know what's causing this. Is there some way to embed LaTeX source code in a PDF file? Ubuntu 18.04 Dock mouse hover tooltips - how to disable? I need to know if it is possible and how to disable the Ubuntu 18.04 Dock tool-tips for mouse hover the pinned application. Heroku deployment failed because of sqlite3 gem error Why do we use von Neumann ordinals and not Zermelo ordinals? Why do we use von Neumann ordinals, $$ 0 = \emptyset $$ $$ n+1 = n \cup \{n\} $$  and not Zermelo ordinals? $$ 0 = \emptyset $$ $$ n+1 = \{ n \} $$ Graph editor for shape key animation I have animation where object changes his shape using shape keys, and I want to make some animation smoothing with graph editor. Is there a way to use graph editor for shape key animation? I want to appropriate line segments that share the same geometry with a particular line width and labels based on the aggregated values of one field "GIS@BUS_5_Min".  My attribute table and polyline objects look as following, see image below   "BUSLINIE" means a bus line, "Overlap" means if the line has overlaps, i.e. it's geometry repeats.  Values of the field "GIS@BUS_5_Min" for these three objects has to be aggregated as one value and represented as a label sum("GIS@BUS_5_Min").  And the width of this line (selected in yellow) will be sum("GIS@BUS_5_Min")/100 = 19.10/100 = 0.1910  How can I achieve such output?  I assume it is possible with Layer Properties &gt; Width &gt; Data defined override &gt; Edit..., but I do not know how to check the same geometry and how to sum the values of certain features with CASE WHEN condition THEN result END conditional function?  Dissolve function does not work in my case because I do not have any key-fields.    References: