Re enable Windows Authetication in SQL Server My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.  I tried logging in using single user mode as Remus described but I get the following error:     Login failed for user 'SERVER\Administrator'.    Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
How do you reset the sa password? I lost the sa password on a machine, and when I log in to the machine directly using an account in the admin group, SQL Server Management Studio will not allow me to log in using Windows authentication.  My plan was to simply log into the server, connect via Windows Authentication, and reset sa to use a new password. Since I cant' connect via Windows Authentication, this won't work.  How else can I reset the sa password?
What is the emergency phone number in different countries? How do you prove that a harmonic planar mapping $f(x,y) = u(x,y) + i v(x,y)$ for real $u,v$ can be written as $f(x,y) = \phi(x,y) + \overline{\psi}(x,y)$ where $\phi$ is a holomorphic function, and $\overline{\psi}$ is an anti-holomorphic function (conjugate of a holomorphic function)? If you have a java.io.InputStream object, how should you process that object and produce a String?    Suppose I have an InputStream that contains text data, and I want to convert it to a String, so for example I can write that to a log file.  What is the easiest way to take the InputStream and convert it to a String?  public String convertStreamToString(InputStream is) {     // ??? } Django: manage.py does not print stack trace for errors When functions commute under composition Today I was thinking about composition of functions.  It has nice properties, its always associative, there is an identity, and if we restrict to bijective functions then we have an inverse.  But then I thought about commutativity.  My first intuition was that bijective self maps of a space should commute but then I saw some counter-examples. The symmetric group is only abelian if $n \le 2$ so clearly there need to be more restrictions on functions than bijectivity for them to commute.  The only examples I could think of were boring things like multiplying by a constant or maximal tori of groups like $O(n)$ (maybe less boring).  My question: In a euclidean space, what are (edit) some nice characterizations of sets of functions that commute? What about in a more general space?   Bonus: Is this notion of commutativity important anywhere in analysis? I want to writing the matrix on the arrow from X to Y 3x3 type, from Z to Y 3x2 type ; Can a mathematically sound prediction interval have a negative lower bound? I have used R to form a 95% prediction interval for the number of endemic species on an island. My lower bound is negative – is that mathematically sound?  In the linear model used in the prediction interval, the data used are:  Area Surface area of island, hectares DiscSC Distance from Santa Cruz, kilometres Elevation Elevation of higher point in metres and it is coded as such:   selected.model &lt;- lm(ES ~ Area + Elevation + DistSC + I(Elevation^2)                      + (Elevation:DistSC) + (A‌​rea:Elevation))    and stepwise regression was performed to find this "best" model   I'm not exactly sure how a prediction interval works. I just want to make sure it is OK. Obviously a negative number of species is incorrect, but I know it takes into account the uncertainty of the mean as well as data scatter. Armature keeps spinning around root bone in pose mode when I try to move anything I was following a tutorial on rigging (was pretty much done) and now my entire model keeps spinning around the main root bone if I try to move any bone at all. (first picture is where it originally was and still is while in Rest Position, second image is of how it changes when in Pose Position while in Pose Mode or Object mode, Edit Mode seems fine)    I tried clearing All Transforms or hitting the ALT+g, s, r while all were selected and that just caused it to spin in the same direction like everything else does as shown in this picture:   I was nearly finished with this video tutorial here,     and near the last part my issue began. 2:28:07 was the last time I was in edit mode and the pose was fine. Right after the little turrets he then went and parented 3 more bones and then he switches back to pose mode with no problem, I suspect somewhere in there is where the problem occurred on my end. I could have sworn I followed it correctly but maybe I went wrong somewhere I have no idea.   I couldn't find another issue like mine exactly so sorry if this question has been asked before, I'm still very new.  Edit: I checked in the video comments to see if it had happened to anyone else but I did not see any mention of it unfortunately.  Edit2: Picture for more detail on the yellow lines. This comes up every time I login, how do I remove this or fix it.  Thanks. I created a presentation using the beamer class with texmaker. Right now it looks like this:    Now I would like to include a jpg where the red circle is located, so basically inside a palette. Can anybody help me how to do that?  The code:  \documentclass[t,compress,10pt,xcolor=dvipsnames]{beamer}  \usepackage{lmodern} \usepackage[labelformat=empty,labelsep=none]{subfig} \usepackage{caption} \usepackage{float} \usepackage{wrapfig}  \newcommand*\oldmacro{}% \let\oldmacro\insertshorttitle%  \renewcommand*\insertshorttitle{%   \oldmacro\hfill%  \insertframenumber\,/\,\inserttotalframenumber}  \definecolor{UniDunkel}{RGB}{73,142,137} \definecolor{UniHell}{RGB}{142,184,182}  \setbeamertemplate{blocks}[rounded][shadow=true] \setbeamercolor{structure}{fg=UniDunkel}  \setbeamercolor{block body}{parent=normal text,use=block title, bg=block title.bg!10!bg} \setbeamercolor{block body alerted}{parent=normal text,use=block title  alerted,bg=block title alerted.bg!10!bg} \setbeamercolor{block body example}{parent=normal text,use=block title  example,bg=block title example.bg!10!bg}  \setbeamercolor*{palette primary}{use=structure,fg=white,bg=UniDunkel!115} \setbeamercolor*{palette secondary}{use=structure, fg=UniHell,  bg=UniHell} \setbeamercolor*{palette tertiary}{use=structure,fg=white,bg=UniDunkel!115} \setbeamercolor*{palette quaternary}{fg=Orange}  \setbeamercolor*{sidebar}{use=structure,bg=structure.fg} \setbeamercolor*{palette sidebar primary}{use=structure,fg=structure.fg!10} \setbeamercolor*{palette sidebar secondary}{fg=white} \setbeamercolor*{palette sidebar quaternary}{fg=white} \setbeamercolor*{titlelike}{parent=palette primary}  \setbeamercolor*{fine separation line}{}  \setbeamercolor{block title}{use=structure,fg=white,bg=structure.fg!0!red} \setbeamercolor{block title alerted}{use=alerted text,fg=white,bg=alerted text.fg!0!white} \setbeamercolor{block title example}{use=example text,fg=white,bg=example text.fg!0!white}  \useoutertheme{miniframes} \useinnertheme{circles} \setbeamertemplate{footline}[frame number]  \beamertemplatenavigationsymbolsempty  \begin{document}  \section{Section1} \subsection{Subsection1} \frame { \frametitle{Frame1} }  \section{Section2} \subsection{Subsection2} \frame { \frametitle{Frame2} }   \end{document} How can one obtain an adamantine weapon? I recently re-watched Contact for the first time since my childhood, and while I thoroughly enjoyed it, I realized that there was something I'd never understood: why couldn't they corroborate Ellie's account of her journey?  As far as I could tell, the pod fell harmlessly through the machine.  That is, it didn't break anything, and the machine wasn't destroyed.  I don't recall any dialogue about circuits being fried or the system shutting down, so presumably it wouldn't be hard to simply hoist the pod up and go again.  I imagine the energy draw was substantial on the local Japanese power grid, but given the amount of effort and money already invested in the machine, surely "Round 2" wasn't out of the question?  I mean, they almost certainly expected that this machine would get more than one good use out of it, anyway!  So given Ellie's vehement insistence that the machine had worked, the public nature of the controversy surrounding her testimony, and the government's (secret) findings that her device had recorded 18 hours of static, why wasn't it the obvious choice to have someone else suiting up the next day, ready to drop through the machine and corroborate her story? 2 GROUP BY WITH DISTINCT , SUM , COUNT : PHP MYQL Ref :   I got answer (thanks coytech ) but i need one more column in its :  as per :  id | mid | pid | owgh | nwgh | 1    3      12    1.5    0.6 2    3      12    1.5    0.3 3    3      14    0.6    0.4 4    3      15    1.2    1.1 5    4      16    1.5    1.0 6    4      17    2.4    1.2  7    3      19    3.0    1.4   i got answer      Select mid ,          COUNT(distinct pid) as cpid  ,          SUM(nwgh) as totalnwgh  from test  GROUP BY mid   sqlfiddle :   mid  cpid       totalnwgh 3      4          3.8 4      2          2.2    But above i need one more column that's as below : totowgh  mid cpid        totalnwgh  totowgh 3      4          3.8        6.3 (DISTINCT value as per pid column) 4      2          2.2        3.9   where totowgh = 6.3 come by DISTINCT value of owgh column  as per distinct pid column  mid = 3 has count 5 but distinct pid  = 4 for mid=3 same way "distinct" owgh = 6.3 for mid=3 and distinct pid.  As pid=12 , column owgh value 1.5 is twice ...hence its is count 1 time hence,  1.5 + 0.6 + 1.2 + 3 = 6.3 ( please not this is as per DISTINCT value of pid )  Please note : i need distinct owgh value as per distinct pid or group by pid .. because if i replace value of owgh 0.6 with 1.5 then it will be 5.7 instead of 7.2 but value of owgh 0.6 belong to pid = 14 and not pid = 12 hence totalcount of owgh change ...but i need is 7.2  SEE WHAT I MEANS   : Deleted object would be re-saved by cascade (remove deleted object from associations) I was rewatching the Breaking Bad episode S04E08 (Hermanos) and I didn't quite understand why exactly Don Eladio killed Gus's partner, but he let Gus live. He says:     The only reason you're alive and he's not, is because I know who you are.   But I still have yet to fully understand. Limits of sequences of sets I am starting to learn about the liminf and limsup of a sequence of sets. However, I do not understand the very basics, such as why $\lim\sup A_n=\bigcap_{n\in N}\bigcup_{k&gt;n} A_k,$ and why $\lim\sup A_n=\bigcup_{n\in N}\bigcap_{k&gt;n}A_k.$ Can someone break these definitions down for me?  Also, why is $\lim\inf\subseteq\lim\sup$? crossfade between 2 videos using ffmpeg I've been trying to achieve a crossfade transition between 2 video clips using ffmpeg but have failed so far. I'm new to ffmpeg and am mostly relying on tweaking what I can find in the documentation and existing examples online. From what I read so far, using either the blend or overlay filter should help in achieving what I'm after but I can't figure out the command line details to get it to work.  The fade and concat filters are great for fade-out of video 1, fade-in to video 2 and concat the 2 into 1 clip type transitions but I'd appreciate help in getting a command to transition from video 1 to video 2 without any going to black in between. I couldn't find any examples for exactly this problem anywhere, maybe I'm looking for the wrong keywords...?  More speficially, my videos are mp4s (h264 video, no sound, in case that matters), each is 5 seconds long and I'm after a transition from approx. 4.5s of video 1 to 0.5s of video 2.  Similar to what this tutorial does using MLT and frames (see 2:25 for an example fade), though I'm looking for a way to do this just in ffmpeg without calling any other progs.   Any pointers or maybe a command line to get a fade like this would be much appreciated, thanks very much! How can I get CSS comments with jQuery? I am wondering how I can read CSS comments out of a linked stylesheet.  I have this sample CSS loaded via:  &lt;link rel="stylesheet" type="text/css" media="all" href="test.css" /&gt;   &nbsp;  #test1{ border:1px solid #000; } #test2{ border:1px solid #000; } #test3{/* sample comment text I'm trying to read */}   I'm testing this in FF3. The following javascript reads the rules but doesn't read the comments in#test3.  window.onload = function(){     s=document.styleSheets;     for(i=0;i &lt; s[0].cssRules.length;i++){         alert(s[0].cssRules[i].cssText);     } } Hello,   I create an app using the Promoted Links in Sharepoint 2013. I chose to do this because the feature has the awesome hover effect and is easy to customize the image.  The issue is that I have been trying to figure out how to change the tile sizes. They are awesome the way they are, however I just need them smaller. I still want the hover effect as well and for the text to match the same ratio as the tile. I have tried web zones, I have done each ID but with no luck. I have attached a sample image of the tiles I'm referring to. Please help. Parallel option performing worse on cluster I'm trying out oracles parallel option on a cluster and surprisingly I am getting worse results with the parallel option. I was expecting some improvement with the parallel option but certainly not worse results. I am wondering why this is the case, and if there is anything wrong with the way I am using the parallel option on my cluster.   I am using a degree of 4 when the number of CPU's I have is 8. I have tried adding parallel to the cluster directly ALTER CLUSTER cluster PARALLEL 4 as well as at the statement on both the index /*+ PARALLEL_INDEX(clust_index, 4) */and tables /*+ PARALLEL(4) */,   Here is my trace from the parallel:    Without parallel: