Yesterday, we looked at ways to connect R to SQL Server using RODBC. Today, we're going to take a look at how SQL Server 2016 is going to make R processing a little bit easier. Warning: Time-Sensitive Material Hey, so this blog post is written for SQL Server 2016 CTP 3. If you’re a time…
November’s TriPASS Meeting
This month's TriPASS meeting will feature Mark Gordon, covering database backups on Tuesday, November 17th at 6:30 PM. It's an introductory-level session, but Mark gave it at SQL Saturday Raleigh to great effect. TriPASS meetings are always free. Sign up through the Meetup page. If you're in the RTP area, come check it out.
Using RODBC To Connect R To SQL Server
So far in my series on R, I've only looked at reading data from flat files. Flat files are very useful constructs and are nice ways to get data sets to people with arbitrary end systems, but there's this awesome thing called a database which allows you to store data, and I want to get on…
Installing SQL Server R Services With CTP 3
I'm excited that CTP 3 of SQL Server 2016 is publicly available, in no small part because it is our first look at SQL Server R Services. In this post, I'm going to walk through installing Don't-Call-It-SSRS on a machine. Warning: Time-Sensitive Material Hey, so this blog post is written for SQL Server 2016 CTP…
Miata Paid Off
Yesterday marked the last payment on my new Miata. My original plan was to pay upfront with a cashier's check, but the check arrived a few days too late, so I ended up doing a payment plan. Strangely, the loan provider's website limited my payments to 3x the monthly payment, and only allowed me to make two…
Pluralsight Reviews: Play By Play: Website Security Review
I had the pleasure of watching Troy Hunt go through a website security review with Lars Klint. This video definitely gets a 5-star rating from me because Troy walks through a step-by-step process, explaining to a developer with a relatively limited security background what the problems are, how you can trigger these problems, and---most importantly---how…
A tale of three games
What with the dissertation and other various and sundry responsibilities, I've dialed back my gaming somewhat. There have been three games that I have been playing, so here are some quick notes on them: -- The Witcher Enhanced Edition (PC). The Witcher is an RPG, but it's an action RPG like Skyrim or Fallout. The publisher…
Front Office Football 7, A Review
I love Out Of The Park. I was looking forward to Beyond The Sideline but it sounds like that project has been delayed indefinitely. I also didn't want to get a new console so I could play Madden (that's my co-blogger's bag, anyhow), so I went searching for games and landed on Front Office Football 7. Now…
R And The Housing Market
Last month, at SQL Saturday Charlotte, I had the opportunity to meet Kiran Math, who gave a great talk introducing R to SQL developers. His talk was the basis for my blog post on dplyr and TidyR, and I want to walk through his housing market example in some detail here. A lot of this…
Visual Studio Database Test Extensions
I introduced a new project last night: Visual Studio Database Test Extensions, or VSDBTestExtensions. You can get the code from Github. What Is This? The short version of this project is that it makes Visual Studio database test projects a little bit better, making it easier to compare result sets. This is very helpful when refactoring code, testing…
36 Chambers - The Legendary Journeys: Execution to the max! 