Upcoming Events: DataPlatformGeeks Webinar

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…

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:…