I have some list of databases with different owners.   Among them [NT SERVICE\SQLSERVERAGENT] is the owner of one database (let's say db_name ='Test_db_repli').  Can we change the owner of that particular database to [sa]?  If changed, will there be any problems in the future?
Today while troubleshooting a service broker problem, I discovered that the database owner was the Windows login of an employee who had left the company. His login had been removed and thus the query notifications were failing.   Supposedly the best practice for dealing with this is to make 'sa' the database owner. We changed it and that cleared out the queue.   My (very elementary) question: what is the database owner and what is its purpose?
How do I kill background processes / jobs when my shell script exits? I am looking for a way to clean up the mess when my top-level script exits.  Especially if I want to use set -e, I wish the background process would die when the script exits. "really not" vs "not really" If someone says "David is not really a leader", it means something like: the speaker believes that David isn't the kind of person you would think of as a without-doubt a real leader; but the speaker isn't necessarily saying that David is definitely a very poor leader.  If someone says "David is really not a leader", it means that the speaker thinks that David is definitely a very poor leader.  What analysis (grammatical, dictionary, etc?) can help me understand how this difference in meaning is created? How do I call the parent function from a derived class using C++? For example, I have a class called parent, and a class called child which is derived from parent. Within  each class there is a print function.  In the definition of the child's print function I would like to make a call to the parents print function.  How would I go about doing this? How to Sort a 2D array? How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file? I have an Excel file that want to update and save automatically with out having to open it or manually interact with.  Manually, I open the file up and hit data refresh which goes and does a SQL query and then hit F9 for the formulas to update and then I just close/save.    (I then would mail the file out to people using a perl script or use SAS JMP to run some numbers/charts and also mail them out.  Basically I need to script some things which require the XLS file to be updated.) Colored borders around windows after update After some gorgeous updates I witness this: Parametric vs non-parametric machine learning methods I looked-up many references and websites and researched on how to determine if a method is between parametric or non-parametric. I came up with below definitions,     A parametric algorithm has a fixed number of parameters. In contrast, a non-parametric algorithm uses a flexible number of parameters, and the number of parameters often grows as it learns from more data.   From .  Moreover, I found,     A parametric model, we have a finite number of parameters, and in nonparametric models, the number of parameters is (potentially) infinite.    From .  And many other methods of determination, though the problem is none of them can helo ones to determine if a certain hypothetical method is parametric or not. (For instance, why k-means' number of parameters are constant but KNN is variable or basically what do we call a parameter and what we do not?) Identify a book with a social engineering theme I originally read this book in the mid- to late '70s.   The premise was a bureaucracy whose job it was to manipulate events in human history by making the smallest possible change that would effect the desired outcome. Not time cops in the sense of going after law breakers.  The intent was to maintain a policy of non-interference as much as possible but when interference was warranted then to make the least possible change and to do so invisibly.  For example, they might take someone's keys off the dresser and put them just out of sight underneath the dresser where they plausibly might have fallen.  The subject would never know of the manipulation but would then be delayed getting out of the house and the ripples grew from there to avert a war or otherwise affect events on a large scale.  After reading that, whenever I would lose something - especially in an improbable way such as dropping a screw at my feet and then finding it on the other side of the room half an hour later - I would take some consolation in the thought that I had just averted some global catastrophe.  I was pretty scatterbrained as a kid (we call that ADHD nowadays) so I experienced this a lot.  Given that I've spent so much time pondering the ideas from the book, I'd love to re-read it. 6-digit password - a special decoding method How do I set a default host for nginx? I'm trying to figure out how to set a default host for my nginx installation. I found this article in the nginx Wiki:    Unfortunately, this doesn’t work. After restarting I get this:  Restarting nginx: nginx: [emerg] unknown directive "http" in /etc/nginx/sites-enabled/catchall:1 nginx: configuration file /etc/nginx/nginx.conf test failed   After removing the http directive I get this:  Restarting nginx: nginx: [emerg] unknown log format "main" in /etc/nginx/sites-enabled/catchall:7 nginx: configuration file /etc/nginx/nginx.conf test failed   I’m on Ubuntu 10.04.3 where I’m using the official nginx PPA. Version 1.0.9 of nginx is running. Fastest Gun in the West Problem I feel like there's a problem with Stack Overflow, as the number of people prowling it increases.  Each question's answers are sorted by descending score and then by descending time of posting. This means that if a person sits down and answers a question in a long, thorough way, going through every nook and cranny, once they post their answer, it will already be one of about seven different ones, some of which have already been upvoted. This wouldn't be a problem if those answers were as thorough as the one this guy's posting, but they usually aren't. Some of them are downright wrong, some aren't even answers to the question asked because their poster didn't bother to read the question all the way through.  This causes a problem I like to call Stack Overflow's Fastest Gun in the West Problem. I've come to a point where I'd rather just send a short, simple, correct explanation, than to go and do some proper research, write a whole blog post about it or even make sure the code I post even compiles, just so it will be noticed, as opposed to the incorrect ones.  I'm sure I'm not the only one doing this and that it despairs many people from even trying to answer questions.  I've long ago learned to try to always raise a problem with a solution in hand, rather than just say "This is a problem, handle it," so my question, after this long tirade, is:     How do you think this can be changed? What would you change in Stack Overflow to make this problem go away without hurting the site?   I promise to vote on answers I like, even if it takes you a long while to post them. :) Why does Jack let Walt go? In Breaking Bad S5 E14, Jack not only lets Walt go, but also leaves a barrel of money to him after killing Hank. I don't understand why he would do this. Jack says that, with 7 barrels of money, he doesn't need to cook meth any more, so there is no reason to keep Walt (the witness of the killing) alive, let alone to give him so much money. What's the rationale behind this? Or it's just mercy or respect? I am looking to identify a story that I read around 2001 (it is probably much older).  Someone showed me the story on pages printed from the internet, and it was attributed to Isaac Asimov (although I cannot state that is the true author).    The story is told in glimpses at different points of time in the future.  In each glimpse, humans are asking a more and more "intelligent" computer how to prevent the universe from collapsing into a singularity in the future, and the computer states it needs more computational power and resources to solve this problem.  At some point, man becomes one with the computer, and the computer exists in hyperspace (or subspace?).    In the final glimpse, it is the end of time and the universe is collapsing into a singularity.  At the instant the universe reaches the singularity, the computer figures out how to prevent it and says "Let there be light" and the universe begins to expand again.  Is anyone familiar with this story? I have an issue with my website: Google isn’t using my meta description, instead it’s using the content of the web page and I’m really confused.  Reason I’m confused is because I have checked and I don’t have duplicate page titles, description nor keywords, neither do I have any robots.txt for my website. My page title, description and keyword is unique, and page description is about 150 characters.  I have my site in Google Webmaster Tools and I checked for errors, but found none.  So I really don’t know why Google Search isn’t using my meta description. We are using Nginx to serve static files on a development platform. As it is a development platform, we'd like to disable caching so that each change is propagated to the server. The configuration of the VHost is quite simple:  server {   server_name  static.server.local;   root /var/www/static;    ## Default location   location / {     access_log        off;     expires           0;     add_header        Cache-Control private;   }  }   When we access an HTML file (http://static.server.local/test.html), we have no issue: the server returns a code 304 Not Modified as long as the file is not changed, and a 200 OK response with the modified file when the file is changed. However, it seems to behave differently with a Javascript or a CSS file. Once the file is changed, we get a 200 OK response as expected, but with the old text. Is there an internal cache mechanism in Nginx that could explain this behaviour? Or some configuration that we should add?    As a side note, here is the header returned by Nginx when the file has been modified (it seems correct):  Accept-Ranges:bytes Cache-Control:max-age=0 private Connection:keep-alive Content-Length:309 Content-Type:text/css Date:Fri, 13 May 2011 14:13:13 GMT Expires:Fri, 13 May 2011 14:13:13 GMT Last-Modified:Fri, 13 May 2011 14:13:05 GMT Server:nginx/0.8.54   Edit After trying different settings with the expires directive and Cache-Controlheader, I made some further investigations. In fact, the server is installed on a VirtualBox guest Ubuntu, and data are read from a shared folder that is on the Mac OSX host. If the file is edited from an IDE (NetBeans) on the host, it seems that changes do not appear whereas if I edit it directly on the guest (using VIM), it is refreshed. The strange thing is it does not behave similarly with HTML files. Quite puzzling.  Edit 2 (ANSWER) Indeed, the origin of the issue was more on the VirtualBox side. Or rather a conflict between VirtualBox and the "sendfile" option of the server. This link  gave me the solution: switch the sendfile flag in the server configuration to off:  sendfile  off;   Hope this could also help other person using VirtualBox for development. :) There are some additional information on the . Did Darth Sidious and Vader ever discover how to cheat death? In Episode 3 Revenge of the Sith Palpatine/Sidious strings Anakin along to the dark side with the promise that together the two of them will be able to re-discover Darth Plagueis' secret to cheating death.      "To cheat death is a power only one has achieved, but if we work together, I know we can discover the secret."   From the end of Revenge of the Sith to their deaths in Return of the Jedi did Darth Sidious and Darth Vader ever manage to re-discover this secret? I've got a bunch of files named with a the pattern 99 - DescriptiveName.txt and I'd like to remove the number from the front so I just have DescriptiveName.txt.  How can I do this? Can I do it from the command line or is there a utility that can do this? Has the concept of non-integer $(n+m)$-dimensional spacetime ever been investigated by theoretical physicists? The following image serves to aid the reader in understanding the "privileged character" of $3+1$-spacetime.    The wikipedia article on , and the  "The priveleged character of $3+1$-dimensional spacetime" in particular, made me think a bit about the possibility that we might live in a non-integer amount of spatial and/or time dimensions.   The notion of attaching a non-negative real number to a metric space has at least mathematically already been described by such concepts as "" and "".   This may sound silly/ignorant/absurd to professional practicing theoretical physicists. To me (a layman), however, it doesn't sound much stranger than the idea of wrapping up six extra dimensions (which is, from what I understand, considered to be a serious possibility by those who study $10$-dimensional String Theory) into intricate shapes called "Calabi-Yau Manifolds".   Has any research on $(a +b)$-dimensional spacetime (where $a,b \in \mathbb{R}_{\geq 0} $) ever been done? If so, what where the findings? If not, why not? Extension of degree 2 with characteristic not 2 I am told that $K \leq L$ is a field extension of degree 2 and that $K$ has characteristic not 2. I am then asked to show that $\exists \: \alpha \in L$ such that $L = K(\alpha), \; \alpha^2\in K $  So far I have that:  $\exists \; \alpha_1, \alpha_2 \in L$ such that $L = K( \alpha_1, \alpha_2)$  $\Rightarrow |L:K| = |L:K(\alpha_1)| |K(\alpha):K| $ so $|K(\alpha):K| = 1$ or $2$  $|K(\alpha_1):K| = 2 \Rightarrow L = K(\alpha_1)$ and $deg(f_{\alpha_1}(t)) = 2  $ where $f_{\alpha_1}(t)$ is the minimal polynomial of $\alpha_1$ over $K$   So $f_{\alpha_1}(t) = t^2 + at + b$ for some $a,b \in K$  Also, $|K(\alpha_1):K|=1 \Rightarrow K(\alpha_1) = K$ and $L = K(\alpha_2)$ which means $degf_{\alpha_2}(t) = 2$ where $f_{\alpha_2}(t)$ is the minimal polynomial of $\alpha_2$ over $K$.   So $f_{\alpha_2}(t) = t^2 + at + b$ for some $a,b \in K$  Given that we consider the same polynomial each time, relabel to consider:   $f_{\alpha}(t) = t^2 + at+ b $ for some $a,b \in K$  We have already demonstrated that $L=K(\alpha)$ for some $\alpha \in L$ so now we much show that $\alpha^2 \in K$  $\alpha^2 \in K \Leftrightarrow a = 0_K$  I now have no idea how to show that this coefficient of $f_{\alpha}(t)$ is necessarily $0$.   I know that $f_{\alpha}(t)$ has two roots in $L$ and that because $K$ and thus $L$ has characteristic not 2, they cannot be the same root, but I don't know how to then conclude that they must sum to $0$  Any help would be greatly appreciated. Start Bounty has a different colour This may be me being silly, but has the start a bounty text colour changed?  I distinctly remember it being the same colour as the add comment text?