Rank #1: *Deep Dive* SSIS, Data Integration Life-cycle Management
In this Deep Dive, Frank and Andy delve into the depths of Data Integration and SQL Server Integration Service.
Rank #2: Micheleen Harris on R, Bioinformatics, and Mountaineering
In this episode of Data Driven, Frank and Andy talk with Micheleen Harris, an R developer who loves Python. Yes, it is possible. Show notes coming soon!
Rank #3: *DeepDive* Data Science vs. Data Engineering
Frank and Andy talked about doing a Deep Dive show where they take a deep look into a particular data science technology, term, or methodology. And now, they deliver! In this very first Deep Dive, Frank and Andy discuss the differences between Data Science and Data Engineering, where they overlap, where they differ, and why so many C-level execs can't seem to figure out the deltas. Links Sponsor: Audible.com - Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics Notable Quotes Frank's new courses are up at WintellectNow (01:30) David Goggins (03:00) Dive! Dive! Dive! It's a deep dive on Data Science vs. Data Engineering (06:00) "Clean data" means different things to different people. (09:30) "Shaping the data." (11:00) Our conversation with Buck Woody (12:30) Andy's screed on managing NULLs (14:00) Andy's screed on managing dupes (17:00) Frank, on aggregation and schema changes... (21:21) Attempted NoSQL definition (23:45) On MySQL... (25:00) Maybe "No" stands for "Not only" (26:45) "What sorcery is this?!" (28:30) Kevin Hazzard's article on Database Design if we started today (29:15) Andy's opinion: We're not using the SSD-ness of SSD's (31:30) "I don't know how much simpler you can get." - Andy (33:00) Denny Cherry's company: Denny Cherry and Associates (34:45) "... somewhere between useless and lying..." (35:45) Frank on HDFS (38:00) ClearDB wiped out 13 years of Frank's blog data, and we're still bothered by that. (40:30) sklearn (42:50) Correlation is not causation. (45:30) How to Lie with Statistics (45:45) Movie/TV Reference: Star Trek TNG (46:15) CNTK (Microsoft Cognitive Toolkit) (48:00) Frank, on selling ice cream... (49:25) On over-fitting (55:30) Training the model (56:30) Request for feedback! (57:30)
Rank #4: Melissa Coates on Data Lakes, BI, and Dogs
In this show, Frank and Andy chat with Melissa Coates about Googling her name, Data Lakes, and CBIG.
Rank #5: Frank and Andy on Reinforcement Learning, Audiobooks, and Keto
Frank and Andy sync up before a big internal conference and some goodies that Andy's working on.
Rank #6: Brad Llewellyn on Statistics, Data Science, R, CBIG, Gaming, and Vanilla Ice
Frank and Andy speak with a real, live unicorn (data scientist), Brad Llewellyn. Links: Sponsor: Audible.com - Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics Brad Llewellyn: @BreakingBI Notable Quotes: Movie Quote - Star Wars: A New Hope (1:55) Bruce Lee (2:20) Book reference: Unicorns Among Us (3:00) CBIG - the Charlotte BI Group (6:45) Azure Machine Learning (7:45) Is Data Science only for super-nerds? (12:50) H2O's Driverless AI (13:40) On Automation... (14:25) On Predicsis.ai... (15:12) On Amazon Machine Learning... (15:45) "Why is the 'why' important to you?" (17:00) Game reference: The Incredible Machine (17:30) Statistical terms (19:15) Microsoft SQL Server R Services (21:12) Movie reference: The Blues Brothers (22:25) "Python started around 1991." - Frank (24:17) Video: Trapping a self-driving car (26:20) Vanilla Ice reference (27:50) Movie paraphrase: I, Robot (28:10)
Rank #7: Frank and Andy Go Fishing in the Data Stream of Consciousness
Frank and Andy ponder the meaning of data in the Data Age, treadmill desks, health data, and re-tooling your skills for AI and Machine Learning. Links: Sponsor: Audible.com - Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics Notable Quotes Frank is working out (0:45) Book: Brain Rules (5:15) Frank spoke at his first SQL Saturday! (9:30) Cathrine Wilhelmsen interviewed Buck Woody at MSIgnite (16:30) GPUs (17:30) SQL Server 2017 GA released (22:00) SSIS as a Service (not "Sassafras" but close) (24:45) Azure DataFest - Reston, Virginia - 12-13 Oct 2017 (26:50) Some triskaidekaphobia (28:15) Frank has a new MSDN Magazine column! (32:15) Talking with the Farmville local podiatrist... (34:15) "Which exit?" (24:22) On becoming a data scientist... (35:00) Brittany Wegner taught herself data . (36:00) www.FranksWorld.com (38:00) Ask Siraj Raval, YouTube star to join us on Data Driven! Teachable Machine - it's magic. (41:00) Crazy talk... (47:00) It's been about a year... (48:20)
Rank #8: Reza Rad on Training, PowerBI, and the Physics of Data
Links: Sponsor: Audible.com http://audibletrial.com/DataDriven Sponsor: Enterprise Data & Analytics http://entdna.com Reza's website: http://radacad.com Reza's free e-book: Power BI from Rookie to Rock Star http://radacad.com/edition-3-of-free-book-power-bi-from-rookie-to-rock-star-1075-pages Notable Quotes: The future is chilly... in the southern hemisphere. (5:15) The State of Training. (7:20) "The physics of data still apply." (10:00) How do developers react to the data side of things? (15:35) The epic Power BI update cycle (18:00) What's the future of Data Science? (20:35) Did Reza find data (or did data find Reza)? (24:15) On dogs... (27:30)
Rank #9: William McKnight on Data Strategy and Leadership
Links Sponsor: Audible.com - Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics McKnight Consulting Group Notable Quotes On strategy and leadership... (7:00) "Business strategy is really about data strategy" (7:45) It takes a team (10:30) On AI: "We're only barely tapping into the possibilities..." (12:00) Interviewing at IBM (12:45) "...data as its own discipline, it's not a drag-along to applications." (14:45) William is active! (16:00) AI is the coolest thing (17:30) Growing meat, prescription errors (19:00) On McKnight Consulting Group (21:20) @WilliamMcKnight "Be a leader." (25:50)
Rank #10: Audrey Hammonds on Women in Tech, COBOL, and the #SQLFamily
In this episode, Frank and Andy catch up with Audrey Hammonds, the other half of the Data Chix duo. Links Sponsor: Audible.com - Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics Notable Quotes Frank's cold/allergies (1:00) Andy is now Enterprise Data & Analytics' Chief Data Engineer (2:00) Frank wants to be more like Buck Woody (3:00) Innovative Architects (3:50) Hurricane Irma disrupted Data Driven! (5:00) Data Chix (5:20) Palm Beach Tech Association (5:45) Audrey lives at the beach (8:00) Audrey escaped COBOL... (9:50) ... and learned Oracle in the Air Force (12:00) On COBOL... (13:00) Audrey studied Bio-Medical Engineering in college (14:30) On building toys for children with prosthetics... (15:15) "I'm right here!" - Andy (17:20) On Andy's phone calls... (17:35) "I've been trapped in here with me for decades, and I am not impressed." (21:45) On Women if Tech... (23:00) Being a woman in IT... "It's a double-edged sword" (25:20) Microsoft Flow (27:00) "If you don't like learning, this is a terrible field..." - Frank (28:15) We are constantly learning... (29:00) Weaponized hacking (30:00) Shoutout to the Frank and Andy show about Elon Musk (32:40) Data is the new oil (33:30) Audrey is putting PowerBI in SPACE! (36:00) Movie reference: Hackers (39:30) Book Reference: Wheel of Time (40:30) Book Reference: Paradox Bound (41:15) Book Reference: Ready Player One (42:00) Sci-fi television reference: Stargate (44:00) Sci-fi television reference: Battlestar Gallactica (44:30) Back to school for Audrey! (45:30) Randy Dyess' first sci-fi book: First Contact: Spider Wars: Book 1 (49:00) Mark Russinovich's book: Zero Day (50:00) "I don't always know what I'm doing." (53:00) "Be ready to fail many, many, many, many times before you get it right." (54:00) #SqlFamily shoutout (56:45)