Archive | SQL RSS feed for this section
I’m always looking for data from unlikely sources, especially sources that are close to my own bizarre interests. Anyone who played guitar at one point or another has probably used tablature.
What if we scripted out a way to crunch through an old school tab text file, split it up in a logical way, and insert it all into a database for display / analysis…
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.
Twitter. It’s everywhere. It’s Data. Realtime, Social, Contextual Data. But, if you want to do any real trending, data mining, post-processing, or even simple analysis on it – you really need to be making a historical record of what you’re looking for and store it in a usable way. I will show you how to create SQL Server tables and use a simple Python script to pull out tweets and save them for future analysis.
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)
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. 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.