Armando Lacerda
Cloud Data Platform Architect & Engineer
Fairfield, California, United States
Actions
Awards
Area of Expertise
Topics
Where is SQL Server in Microsoft Fabric?
Microsoft Fabric is the most recent cloud data platform offering from Redmond's based software giant. SQL Server is one of the most successful and long running data engine from Microsoft. Of course it would be embedded inside Fabric. The question is: where can I find SQL and how can I use my SQL skills in Fabric? Let's dive into this with lots of demos and Q&A.
Data with Gusto
Meet Azure Data Explorer, and its powerful query language: Kusto. In this session we will investigate this obscure data engine in Microsoft Fabric that most people have never heard of. It is not even in the Microsoft learning curriculum. But is capable of amazing things.
MS Fabric crash session
The new Microsoft offering for cloud data computing is ready for production projects. It’s time to check an end-to-end implementation. Demos and time for asking the presenter anything are included.
This is not your daddy's backup routine
Microsoft introduced a new backup support back in SQL 2016 when the data files are in Azure Storage Accounts. It was yet another cloud native feature in SQL. After 6 years it has finally made its way to on-prem storage. In this session we will deep dive in the snapshot backup option, target to large volume data bases.
Shining data models - from OLTP to star dimensional model
Many projects struggle on getting from OLTP model to OLAP/dimensional model, and from there building up the semantic layer for all DW needs. In this session we will go over a multidimensional implementation of the StackOverflow database with live demos using delta lake and Microsoft Fabric.
From Zero to Hero on Synapse Spark pool
The "no-code" approach of SQL server SSIS can find a close parallel in Synapse Transformation Pipelines. There are cases, though, when we do need to code some complex, out of the curve, very specific data transformations. In this session you will learn the foundations of Synapse Spark Pools and how to benefit from it through many demos.
Azure Synapse Analytics in a day
So you want to learn Azure Synapse Analytics from ground up in a day? This is your session. Armando Lacerda will conduct a four-parts, all-day workshop with hands-on exercises to help you getting started on the data engineering field using this Microsoft service.
Azure PaaS SQL - Performance foundations
You are a master on-prem SQL DBA and you can fine tune it to the best performance level possible. Now you have to do the same in Azure using VMs, containers in Kubernetes or even PaaS offerings. In this session Armando Lacerda will go over the foundations of how these offerings work and what are the tuning knobs available to you.
Synapse Pipelines for the SSIS DBA
You've just been promoted from developer DBA in SSIS to data engineer in Azure Synapse cloud. Will your SSIS packages be promoted as well? In this session, Armando Lacerda will go through the foundations of Synapse Pipeline design and engineering and why you don't need to bring SSIS to your new cloud scale solutions.
Storage Options for SQL Server in an Azure VM
Everything in the cloud is throttled. IOPS and throughput are relative to services and service levels. When it comes to SQL Server and it's data files, there are a couple options to fit either budget or performance. In this session we will deep dive in how the connections in between the VM and the storage options work and evaluate both performance and price.
SQL Server 2022 cloud integrated authentication
Keeping accounts for external users in Windows Active Directory is hard enough. Integrating with Azure Active Directory adds extra work. But having external business partner / consultant accounts hosted in Azure Active Directory authenticating in a on-premises SQL Server is just impossible. Until SQL Server 2022. In this session we will understand how that can be done and demo the process from back-to-back.
Let's keep it private - Azure networking cases
Some companies freak out about moving to the cloud on the perspective the network traffic will be public all the time. But there are ways to keep it private and hybrid. In this session Armando will demo common cloud network setups to connect application layers and keep your CTO at peace.
Hybrid Disaster Recovery with SQL Server 2022
Having a backup site for your disaster recovery strategy can be expensive, time consuming and hard to maintain. SQL Server 2022 offers the ability to setup an Azure environment to serve as your backup disaster recovery site. In this session we will discuss the options and demo how to create one in minutes.
Power BI Dataset Tuning
Most Power BI reports rely on a small dataset. And due to a lighting fast data engine most data model mistakes are shadowed by the speed of the service. When the dataset gets bigger then better data modeling practices are required. The trick here is Power BI data engine is not relational and therefore most data modeling techniques either don’t apply or don’t deliver. In this session we will go over how to model and measure performance for larger Power BI datasets.
Power BI, Data Lake and Lake House in a nutshell
Data Lake technologies are becoming the standard for very large data storage. For Power BI to work with very large data volumes, it needs help from other data engines. In this session you will learn how the Serverless SQL pool, which is part of Synapse Analytics, can be used with Power BI to implement data exploration on top of a data lake, making a simple implementation of the Lake House concept.
Hyperscaling cloud-based databases
Azure SQL DB Hyperscale introduces a redesigned architecture under the hood not comparable to the other SQL DB PaaS options.
In this session you will learn and see how it works and how real time analytics and BI can be implemented using this PaaS offering.
Encrypting and securing your data in Azure SQL DB with no code impact
Always encrypted is a feature in Azure SQL DB and brings the next level of data protection in the engine. In this session full of demos you will learn how to benefit from it and compare with other options as TDE (Transparent Data Encryption) and Masking.
Azure SQL Server flavors, which one is right for my scenario?
Choosing the right Azure SQL Server offering could be daunting. With over 50 individual deployment options it is not uncommon to see DBAs migrating to Azure getting dizzy. In this session you will learn the basis of each offering and when to apply them through demos.
Your Power BI can handle way more data with Fabric
Power BI was first released as an end user, cloud born data visualization tool. Now it is a powerful, scalable enterprise level BI ecosystem, part of the Microsoft Fabric SaaS offering. This integration with Fabric has increased its ability to deal with large volume of data.
In this session I will demo how to design and implement reports and dashboards on massive amount of data available to data analysts and business decision makers.
From Zero to Hero on Microsoft Fabric Spark Compute
The "no-code" approach of SQL server SSIS can find a close parallel in Microsoft Fabric Pipelines and Data Flows. There are cases, though, when we do need to code some complex, out of the curve, very specific data transformations. In this session you will learn the foundations of Fabric Spark Compute and how to benefit from it through many demos.
Data Platform Downunder Virtual Meetup 2024 User group Sessionize Event
2023 Data.SQL.Saturday.LA Sessionize Event
SQL Saturday South FL 2023 Sessionize Event
Ohio North SQL Saturday 2023 Sessionize Event
SQL Saturday New York City 2023 Sessionize Event
SQL Saturday Austin 2023 Sessionize Event
Data Toboggan 2023 Sessionize Event
Microsoft Data Professionals' Forum User group Sessionize Event
SQLSaturday Orlando 2021 Sessionize Event
Data ANZ Sessionize Event
Virtual 2021 Data.SQL.Saturday.LA Sessionize Event
Virtual Symposium - SQL Server & Azure SQL Sessionize Event
Malta Data Saturday 2021 Sessionize Event
Certification Saturday 2021 Sessionize Event
IT Pro|Dev Connections 2020 Sessionize Event
Virtual Azure Community Day Sessionize Event
CFS - Global 2020 Summer Azure DataFest Sessionize Event
Orlando Codecamp & Tech Conference 2020 Sessionize Event
Global Azure Bootcamp 2019 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top