In this new world we're all developers! Whether we're writing application code or describing our infrastructure using bicep or terraform we need to keep it safe. Git and source control is our best option for developing on our own and as part of a team… but git is scary! In this 20 min session we'll go through just enough to git you comfortable with source control.
The video is not available to view online.
Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you? Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work!
The video is not available to view online.
Introduction to AutomatedLab PowerShell module that enables you to set up test and lab environments on Hyper-v or Azure in seconds.
The video is not available to view online.
How can we test potential weaknesses in SQL Server? In this session we will explore the concept of Chaos Engineering, its core concepts, and the methodologies behind it.
The video is not available to view online.
Learn some of the root causes of high cloud bills and what you can do to solve them.
The video is not available to view online.
Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.
The video is not available to view online.
Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.
The video is not available to view online.
From a development perspective Power BI gives you some challenges you can't overcome easily. When you and your team are continuously working on Power BI files, you need a central location, to keep track of changes, find differences between versions, check out files and deploy in an easy way. In this sessions we will see how Azure DevOps helps you with versioning, CI/CD-pipelines and tracking changes in datamodels.
The video is not available to view online.
This session will demonstrate PowerShell's abilities to validate and load data to fill potential gaps in data acquisition process.
The video is not available to view online.
A deep dive into cleaning and wrangling raw data (text or non-text) in PowerShell with regular expression (regex) matching. This session will cover essential syntax and theoretical approaches to building effective regex, as well as providing detailed examples of when regex in PowerShell 'saved the day'.
The video is not available to view online.
Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.
The video is not available to view online.
In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.
The video is not available to view online.
Both Minecraft and Devops are phenomena from the early 2010s that have stood the test of time. But what can we learn from the sandbox-based video game Minecraft that can be applied to a set of practices for software development? By the end of this session I hope you have an appreciation of both DevOps and Mincraft!
The video is not available to view online.
Does your organisation need to manage the deployment of Power BI better? Join this session to learn how to shorten the time to deploy new features to your users while ensuring you maintain a standard for high quality using tools such as Azure DevOps and Power BI deployment Pipelines.
How to build a data platform in Azure
The video is not available to view online.
Automate checking your database security model
Reality Check on Microsofts Enterprise Scale Analytics Framework
Improve the quality of your T-SQL code with the free tool ScriptDom
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.
In this Session MVP Frank Geisler and first time speaker Timur Dudhasch will give an introduction to Bicep for the Cloud DBA. As more and more systems are migrated to the cloud and as the sheer number of systems rises continuously Frank and Timur will demonstrate how to ease the process of creating and maintaining resources in the cloud via bicep
Everything you need to get started with PowerShell.
Quickly and easily migrate databases and associated logins using dbatools.
On this session I'll show the most useful and powerful development features on Power BI Desktop and external tools
Learn how to deploy Power BI at scale within a large Enterprise. The mantra behind this is “discipline at the core, flexibility at the edge” - we will cover deploying appropriate guardrails/controls whilst still retaining the notion of “self-service” within the organization.
There is a time and a place for everything. John and Rob, being consultants, often say "Well, it depends" Lets talk about some of the times when the "rules" may not fit
A short introduction of the cool tools you need as a DBA today.
The video is not available to view online.
Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.
dbatools is an open source PowerShell module. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.
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
In this short session we will set up an Azure Function using PowerShell and Visual Studio Code. This function will respond to HTTP requests, and securely return the results of a database query.
The video is not available to view online.
The dbatools module now has over 400 commands you can work with. How do you know where to start and which ones you can use in your day-to-day work?
The video is not available to view online.
PowerShell loves Power BI. In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!
The video is not available to view online.
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
Join me for this session as I demo how disaster recovery can be greatly simplified using PowerShell.
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
The video is not available to view online.
Learn how to make Azure do the work for you by developing smart responses for Azure SQL DB alerts using Automation and Logic Apps.
Learn how you can validate your SQL Server estate with ease using dbachecks
Automate SSRS management using Microsoft's PowerShell module
Provision dev databases quickly and easily using containers and clones
Introduction on how to use the Powershell library Lability to create complex SQL Server based test labs.
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function
Combining Always ON Availability Groups and Powershell will make your life easier
The video is not available to view online.
Row Level Security based on related tables
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
This session will explore the Tabular Model Scripting Language (TMSL); how TMSL can be used with PowerShell to automate the creation and deployment of an Analysis Services Tabular Model.
We will take a look into my favourite Powershell scripts
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
The video is not available to view online.
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
The video is not available to view online.
System-versioned temporal tables provide information about data at any point in time rather than just the current moment, and are a must have feature for any DBA. Collect vast amounts of operational data using OSS based on PowerShell technology and Azure. Add PowerBI to the mix and get mind blowing insights, the future will never be the same.
The video is not available to view online.
<<12>>