Thanks for posting this! I love to see applications of R in SQL. A couple of notes: You might want to think about adding in a step for Principal Component...

If only half the people I deal with made that statement, my day would be half as difficult. 🙂 You have the most important points in mind!

Not a problem at all. In fact, maybe I'll blog it - but not in the way you think. 🙂

Do keep asking questions - it helps us in our...

Not sure I have enough info to answer this, but I have a cheat-sheet referenced on this page that might help, along with some ideas: https://buckwoody.wordpress.com/2015/12/02/knowing-which-statistical-formula-to-use/

Then tell me your thoughts on this: http://blogs.msdn.com/buckwoody/archive/2009/11/30/aren-t-dba-s-just-system-admins-for-databases.aspx

Actually, when I broached this very subject with that product team, they told me "This isn't for DBA's. they just do admin work." sigh.

Same here. I've ensured that the code pasted correctly, there are no bad characters and so on. But I'm also getting a divide by zero error - I'm assuming this...

No problem at all Phil - the only reason I even responded is that I respect this site's writing so much, and I think others do as well.

I agree with...

Well, as a Microsoft employee who wrote some of the manageability tools, I always find these articles humorous. We wrote (and write) a wide array of tools - graphical, command-line,...

Licensing for a VM is the same as a physcial machine. If you have 5 VM's installed, you have to license SQL Server 5 times.

Most often the problems people...

This is a good treatment of a complex subject in a short space. Thanks for putting this together!

It might be useful to compare VMware and Hyper-V from Microsoft, rather than...

Hi -I'm the Program Manager in charge of this feature for SQL Server. This is coded in, but I wouldn’t recommend changing it even in the registry. I’m looking...

I've found Virtual Machines (VM's) are perfect for just this situation. Microsoft's desktop version is now free.

Buck - MSFT

Ah - my mistake - you're referring to the REFERENCES, not REFERENCES TO! My bad.

Actually Oracle doesn't have those bragging rights. Microsoft has unlimited references per table. From the BOL note (not the page this article has referenced, but the REAL Books Online):

^{http://msdn2.microsoft.com/en-us/library/ms143432.aspx}

⁴Although...