Presentations
Passwords: they just seem to work. You connect to your PostgreSQL database and you are prompted for your password. But what if I told you there was a better way to authenticate with passwords in PostgreSQL?
Let's learn how SCRAM (Salted Challenge Response Authentication Mechanism) in PostgreSQL securely authenticates passwords. At the end of this talk, you will understand how SCRAM works, how to ensure your PostgreSQL drivers supports it, how to upgrade your passwords to using SCRAM-SHA-256, and why you want to tell other PostgreSQL password mechanisms to SCRAM!
How do you go from IDK to FTW? Need to get started monitoring a custom data set? Want to make big money as a security use case detection engineer? Then you need to get to know your data.
Let me show you how I, for the past 10 years, have been analyzing, normalizing, and working with security data for some of the biggest names in entertainment. I'll show you how to learn about your data so you can build with confidence, knowing that your dashboards, reports, and alerts will return expected results.
Continuous Delivery (CD) concepts are increasingly adopted by many technology organizations and teams. CD enables teams to establish processes that increase velocity, collaboration and quality of their codebase. Continuous Integration and Continuous Deployment (CI/CD) enables developer & operations teams to break down unnecessary silos and gain a deeper knowledge of their respective arenas.
Misconfigurations in your Kubernetes deployments can create unforeseen security vulnerabilities that can give bad actors leverage to exploit containers, nodes or even the entire control plane of your cluster. In this talk I'll show how easy it can be to break into a cluster and why using tools to find issues and enforce governance around them can make your clusters a less attractive target.
This talk will be focused on summarizing all new and improved features introduced in PostgreSQL 14, the current major supported version of Postgres released in autumn 2021.
Though we have in the past depended on traditional data warehouses to drive business intelligence from data, they were generally based on databases and structured data formats and proved insufficient for the challenges that the current data-driven world faces. Enter data lakes, which are optimized for unstructured and semistructured data, can scale to petabytes easily, and allow better integration of a wide range of tools to help businesses get the most out of their data.
"If you have a hammer, all you see is nails." also known as the Law of the Instrument describes the cognitive bias that involves over-reliance on a familiar tool. To protect MySQL data, a DBA must have a toolbox full of the proper utensils. To know only one approach is not enough.
In this talk, we will discuss the different backup methods: cold, warm, and hot. And the multiple tools available to perform each of these types of backup.
We'll be looking at PostgreSQL configuration options (postgresql.conf) for logging and basic tuning parameters, how to monitor which queries are taking the most time using pg_stat_statements, going over EXPLAIN and EXPLAIN ANALYZE output for select queries (and the auto_explain module), what the EXPLAIN output means in terms of how the query is being executed, and then going over ways to improve the queries, including index creation, rewriting the query to allow PG to use a different plan, and how to tune parameters for specific queries.
With the growing popularity of 3D printing, there are a flood of new people wanting to learn how to not only print objects but also design their own. Learning 3D modelling can be daunting and much of the software around the hobby is proprietary and/or expensive. In this talk, you will learn about parametric modelling with OpenSCAD (GPL 2.0) and how you can use your pre-existing coding skills to jump start learning.
Learn about Apache Druid and how it integrates with streaming data from Apache Kafka at any scale. We will walk through the microservice architecture and how it scales to deal with any streaming throughput. You will also learn about the columnar data structure it uses and how its storage and compute efficient design delivers fast query response times and deals with high concurrency.