Archive | Microsoft SQL Server RSS feed for this section
How to Harvest Facebook updates with Python, MySQL or SQL Server
![](http://ryrobes.com/wp-content/themes/therapy/functions/thumb.php?src=wp-content/uploads/2012/07/fbdata-thumb.jpg&w=150&h=150&zc=1&q=90)
Data Party! Most people focus on search.twitter.com (or automated pulls from their API) for data collection regarding the “pulse” on a particular topic or brand – they often overlook the fact that the public Facebook timeline can be a useful source of data as well. I’ll show you how to harvest it and store it in a database of your choosing for later analysis.
Rare Shit: Scoring Songs on a Setlist by Historical Context (Frequency, Rank, Ntile)
![](http://ryrobes.com/wp-content/themes/therapy/functions/thumb.php?src=wp-content/uploads/2012/02/setlist-icon.png&w=150&h=150&zc=1&q=90)
It’s interesting, the types of data conversations you have with people when discussing a unique project like MetallicAnalysis. You’re trying to show things in a different way and get as deep as possible, BUT never want to get too lame or “tech-y”, else it loses contact with the actual subject matter and begins to make less sense. Numbers are cool, but numbers that ACTUALLY FUCKING MEAN SOMETHING to the average fan / person are way cooler…
Mortgage Software Hack: Importing Contacts automatically into Encompass WITHOUT the SDK (just with SQL)
![](http://ryrobes.com/wp-content/themes/therapy/functions/thumb.php?src=wp-content/uploads/2010/08/mort-icon.jpg&w=150&h=150&zc=1&q=90)
Anyone who has ever dealt with the mortgage software package “Encompass” from Ellie Mae – from any kind of support / IT standpoint knows the pain. It just… well, doesn’t behave as you would assume. Seemingly simple things (from an integration / workflow standpoint) just don’t play nice, help in the web forums is laughable, […]
Business Intelligence, Tools, Dirty Caveman Sex, Open-Source – Part 1
![](http://ryrobes.com/wp-content/themes/therapy/functions/thumb.php?src=wp-content/uploads/2010/08/geico-caveman-relaxing.jpg&w=150&h=150&zc=1&q=90)
Business Intelligence. I hate the term as an IT buzzword. So sick of hearing Business Intelligence-this, Business Intelligence-that, Business Intelligence-expert-my-ass. But, hate it or not “Business Intelligence” shiz isn’t going anywhere – in fact, its been here in one way, shape, or form since the first caveman traded a sharp rock for some unsanctioned cave-nookie.
Cut-N-Paste Corner: Microsoft SQL Server 2000, 2005, 2008 Simple Loop Template
![](http://ryrobes.com/wp-content/themes/therapy/functions/thumb.php?src=http://thumbs/sql_screen_image.jpg&w=150&h=150&zc=1&q=90)
I think that ‘data wrangling’ takes a special kind of problem solving mentality. Keeping data current, cleaning it, merging it, aggregating it, and creating summary (or data warehouse) tables for reporting purposes… For MANY years I used Express installations of SQL Server 2000 as my ultimate data Swiss Army knife. It was like a secret […]