Key Details What: Data Platform Geeks webinarWhere: On the Internet, next to all the other webinars.When: Thursday, April 18th at 11:30 AM Eastern time, which happens to be 9 PM India Standard Time.Admission is free. Sign up at the DataPlatformGeeks website. What I’m Presenting 11:30 AM — 12:30 PM — Applying Forensic Accounting Techniques Using…
Course Review: Getting Started with Spark 2
This is a review of Janani Ravi's Pluralsight course entitled Getting Started with Spark 2. I think this course was a good length and includes a lot of quality content. Janani presents everything in Python but I was able to follow along and do similar examples in Scala. The entire course length is just over…
Upcoming Events: Southern Fried F#
Key Details What: Southern Fried F#Where: Red Hat, 100 East Davie Street, Raleigh, NC 27601When: Saturday, April 13th, all dayAdmission is free. Sign up on Eventbrite. The tastiest conference logo What I’m Presenting Nothing at all! I'm one of the organizers for the inaugural edition of Southern Fried F#. Our goal is to expand functional…
Azure Data Studio Notebooks: GitHub Issues
There are a couple of Azure Data Studio GitHub issues near and dear to my heart that I'd like to point out in the hopes that it'll raise their profile and give the Azure Data Studio product team more reason to make my life easier. Command Mode The first issue I'd love to see addressed…
Forensic Accounting: Generating Sketchy (But Not Too Sketchy) Data
This is part two in a series on applying forensic accounting techniques to SQL and R. Start with a Data Model My plan here is to create a model which is a simple version of the Wake County transportation fraud case. To do so, I've created the simple data model which we see below: The…
Forensic Accounting: Introduction and Case Study
This is part one in a series on applying forensic accounting techniques to SQL and R. Necessary Disclaimers Before I get started, I have some disclaimers I need to get out of the way. I am not a CPA. My wife is a CPA but I'm the one writing this so you get my interpretation,…
Upcoming Events: SQL Saturday Madison
Key Details What: SQL Saturday MadisonWhere: 1000 Edgewood College Drive, MadisonWhen: Saturday, April 6th, all dayAdmission is free. Sign up at the SQL Saturday website. What I’m Presenting 11:00 AM — 12:00 PM — APPLY Yourself02:45 PM — 03:45 PM — Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques SQL Saturday Madison is in…
PolyBase Revealed: the DW Databases
Today is a fairly short post covering a trio of databases you might not even know you have: DWConfiguration, DWDiagnostics, and DWQueue. The PolyBase installer drops all three of these on your instance. Let's go in ascending order of the number of useful tables. DWQueue The DWQueue database has two tables, neither of which I've…
WhoIsActive In SSMS
Several years ago now, I put together a post on helpful wrapper procedures for calling sp_WhoIsActive. Since then, I've taken to three sp_whoisactive calls as SSMS keyboard shortcuts. Ctrl + F1: What's Going On? Here is my bread and butter query in a format you can easily copy and paste: EXEC sp_whoisactive @get_full_inner_text = 1,…
Upcoming Events: DataPlatformGeeks Webinar
Key Details What: Data Platform Geeks webinarWhere: The police said the webinar was coming from...inside the house!When: Thursday, April 4th at 11:30 AM Eastern time or 9 PM India Standard Time. You choose.Admission is free. Sign up at the DataPlatformGeeks website. What I’m Presenting 11:30 AM — 12:30 PM — Launching a Data Science Project:…