SQLBits 2024

Streamlining Power BI with PowerShell

Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks.

Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone.
This session explores how PowerShell automation simplifies and streamlines these tasks.

Attendees will join us on a journey exploring the fundamentals of PowerShell scripting, tailored specifically towards PowerBI administrators and users. We will cover the setup and configuration of the PowerBI PowerShell module, PSPowerBITools, illustrating its installation, and diving into the authentication methods to securely connect to your PowerBI environment.

The session will have live demonstrations, showcasing real-world scenarios where PowerShell scripts significantly reduce manual efforts and enhance efficiency in managing PowerBI resources. Attendees will witness firsthand the power of automating tasks that are typically time-consuming and error-prone when done manually

Examples of covering automating workspace management
- Check user access
- Activity Events
- Lineage of reports and data sources

Sander Stad's previous sessions

Streamlining Power BI with PowerShell

Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks.

Saying no is OK

In the high-demand IT field, professionals often struggle with overcommitment and work-life balance. This presentation, "Saying No is OK," offers practical insights and strategies for IT professionals to assertively manage their workload and protect their well-being. Learn the art of saying no, how to prioritize, and maintain professionalism while achieving a healthier work-life balance. Join us for a transformative session that will empower you to succeed while setting necessary boundaries.

Unveiling the magic of CI/CD for SQL Server using GitHub Actions

In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.

Github and Azure DevOps Duet - SQLBits edition

A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.

Battle tested project planning with Azure Devops boards

Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?

Start to See With tSQLt

Unit testing with databases is fairly new and is not yet embraced within database development. We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt

Solving the dev DB problem with Docker and dbaclone

Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.

Linda Torrång's previous sessions

Streamlining Power BI with PowerShell

Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks.

Nose-Dive Narratives: Slide Karaoke 2024

Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!

Anyone can be an alphabet soup ally

Folks that belong to the queer community are often referred to as LGBTQ+, Jess and Linda represent a small portion of the letters within this alphabet soup and they will guide you through some common situations where you can be a good ally. There is no one right answer, but there are ways for you to prepare for certain situations so you know what your best move might be to provide support and allyship. This session will provide tips for people who are new to being an ally and for existing allies who want to add skills to their toolbelt.

+5 Wisdom - Learn to Ask Better Questions to Solve the Right Problems

By asking the right questions we can solve the actual problem - not only the problem we think we are facing. Take a step back, look further, and ask better questions. We'll show you how.

Multitasking for Mortals - How to Stop Multitasking and Start Getting Things Done

Humans were never meant to multitask - fact is, the human brain is not even capable of true multitasking. Despite this we keep trying to achieve more in less time, and in the end we achieve less and suffer from more stress. There are ways to stop trying to multitask and instead embrace structure and methods for actually getting things done. Let me show you.

How to avoid the most common junior mistakes

Junior makes mistakes. That's part of being junior. But we don't have to make the SAME mistakes over and over again - let's talk about how to make starting life in the tech lane a bit easier.

Learning to Listen - Making the Most of Mentoring

Being a mentor or a mentee offer amazing opportunities but come with their own sets of challenges. We'll help you make the most of mentoring!