Stamford BIT: Business Intelligence and Technologies Meetup
You want to learn Python but don't know where to start? You already know SQL, and data wrangling is one of the most critical use cases for Python. Why not start with that? Good news! Python provides many ways to use good old SQL as a first-class query and data manipulation language. In this session, we'll show you how easy it is to use SQL with Python to query non-relational and relational database data, to load data from SQL Server, and write it back. It's so easy, you'll feel like a Python pro before you know it!
Over time SQL Server has accumulated a lot of different options to deal with temporary data. This session will take a look at all of them and compares them in over ten different ways to show which one to use in which case and more importantly which ones to avoid. We will look at tempdb as well as in-memory OLTP. Explore performance, scope, durability, and how to overcome some of the limitations with a particular focus on staging tables.
Special Guest: Thomas Grohser has spent most of the past 27+ years exploring the deeper inner workings of SQL Server and its features while working in the entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage.
As the value of data assets surpasses that of even oil in the Age of Information, a patchwork of local and national regulations governing data consent, collection, access, and use is emerging to protect data subjects. Brandon Keaveny, founder and principal consultant of Data Ethics (dataethics.net), will provide an introduction and overview of key elements of evolving data privacy and security regulations. He will focus on the EU's GDPR and California's CCPA regulations as primary examples. This overview is intended for anyone responsible for their organization's data assets, from strategy and policy management to stewardship, architecture, design, data flow, reporting and visualization, marketing, communications, and compliance. You don't want to miss this!