There has been a remarkable shift introduced in the new features of SQL Server--programming languages have been embedded into the database. This has led to a few "What are you thinking" questions from myself and others. It also opens new opportunities for those working with SQL Server and in this episode, I chat with Andy Roberts and Chris Hyde and discuss the new features of R and Python--why they are included, how data teams are changing, and what this means for the rest of us. As someone who does not and has not ever considered themselves a programmer, I don’t try to tackle any of the technical challenges of the language. We stay safe on the side of ideas, process, with a sprinkle of installation and setup.
One of the most compelling ideas from this conversation is the democratizing of data. Sure, this is not a new concept; however, now with a programming language in the database it will force a thinking realignment for those that traditionally called themselves gatekeepers. Where CLR couldn’t quite do the trick, I think the introduction of these languages is going to require increased collaboration with teams and force administrators to up their game as they tackle challenges of data distribution and data consumption.
I am interested to see what lies ahead and how consumers will use these new features. We already have some insights into R and while I won’t call it a smashing success—it is certainly useful to those who know how to take advantage of it and those numbers appear to be growing. With Python, I think we are increasing the breadth of those who can take advantage of analytics in the database, which I think only bodes well for those who enjoy working with SQL Server.
What about you? Is your team trying to implement R or Python? What new skills have you had to learn because of these changes? Hit me up on social media.
The show notes for today's episode can be found at http://sqldatapartners.com/2018/03/15/episode-127-developing-in-the-database. Have fun on the SQL Trail!
Episode 116: Are people still using PSSDiag?
Episode 115: The Companero Conference Retrospective
Episode 114: How do you start consulting?
Episode 113: Standing on the shoulders of giants
Episode 112: Keeping up with patching
Episode 111: How do you prepare for conferences?
Episode 110 How do I build trust with my team
Episode 109: To certify or not to certify?
Episode 108: The Future of the Relational Database
Episode 107 BI for the Little Guy
Episode 106 Temporal Tables
Episode 105 When is enough, enough?
Episode 104: Keeping up with technology
Episode 103 Plan Reuse
Episode 102 Monitoring Availability Groups
Episode 101 Inspecting a new Database
Episode 100 Role Reversal
Episode 99 Imposter Syndrome
Episode 98: The first change you make
Episode 97 Transactional Replication
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast