SQL FRIDAY #38 – Ásgeir Gunnarsson on ‘Reel in the Power BI Wild West’

Date:2021-03-05
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #38 – Ásgeir Gunnarsson on ‘Reel in the Power BI Wild West’

In this session we will hear about a method to govern your Power BI environment. This method is built upon my experience as a Power BI lead for a multinational company as well as my work with various customers of different sizes.

In my experience many organizations start thinking Power BI governance too late. Users are already working with Power BI and used to be in the Power BI Wild West. No matter if you are starting your Power BI journey or already in the Power BI Wild West this session will help you start with Power BI governance or enhance your existing one.

The method has four main pillars:

  • Process
  • Training
  • Monitoring
  • Roles

All these pillars are equally important but with different complexity. We will dive into each pillar and look at examples on documents and implementation methods. We will then bind it all together into a cohesive method and suggest how to approach the implementation.

About Ásgeir Gunnarsson

Ásgeir is a Data Platform MVP and owner of North Insights IVS. He works on Business Intelligence solutions using the whole of the MS BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.

Ásgeir speaks regularly at events both domestic and internationally and is the group leader of the Icelandic PASS Group as well as the Icelandic Power BI user group.

Ásgeir is passionate about data and loves solving problem with BI.

https://twitter.com/bidgeir
https://www.linkedin.com/in/asgeirgun/
http://blog.northinsights.com/

SQL FRIDAY #37 – Deepthi Goguri on ‘SQL Server Internals and Architecture’

Date:2021-02-26
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #37 – Deepthi Goguri on ‘SQL Server Internals and Architecture’

Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes.

Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server.

This session will cover ACID properties, key components of the Relational Engine, Storage engine, Cache and the Transaction manager. You will learn how SQL Server manages Plan cache and Buffer pool and how SQL Server optimizer chooses the plans.

We will also cover what happens under the covers during read and write operations within SQL Server.

This session also has Demos showing how components of SQL Engine works for queries.

Deepthi will show you how the SQL engine thinks – enabling you to think like it!

About Deepthi Goguri

I am a SQL Server Database Administrator with 7 years of experience in Administering SQL Servers. I did my Maters in Computer Technology at Eastern Illinois University. I am a Microsoft Certified professional with an Associate and Expert level Certification on Data Management and Analytics. I blog for DBANuggets.com.

https://twitter.com/dbanuggets
https://www.linkedin.com/in/deepthigoguri
https://dbanuggets.com/

SQL FRIDAY #36 – Manush Kumar on ‘Secure Your Data with Azure SQL Database’

Date:2021-02-19
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #36 -Manish Kumar on ‘Secure Your Data with Azure SQL Database’

The session will take you through Industry-leading security which comes built-in with Azure SQL database. In this session we will have an overview of Network security and Access Management and then dive deep into Threat Protection & Security Management and Information Protection and Encryption. A high level aim would be to give sound understanding of following features to attendees :

Network Security (Overview)

  • IP Firewall rules
  • Virtual Network Firewall RulesAccess Management (Overview)
  • Authentication
  • SQL Authentication
  • AAD Authentication
  • Authorization
  • Roles and permissions
  • Logins and Users
  • Row-Level Security

Threat Protection and Security Management (deep dive with demo’s)

  • Auditing
  • Advanced data security
  • Data Discovery and Classification
  • Advanced Threat Protection
  • Vulnerability Assessment

Information Protection and Encryption (deep dive with demo’s)

  • Transport Layer Security (Encryption in transit)
  • Transparent Data Encryption (Encryption at rest)
  • Always Encrypted (Encryption in use)
  • Dynamic data masking

About Manish Kumar

Manish Kumar is a Microsoft certified Solution Expert in ‘Data Management and Analytics’ and work as a Sr. cloud solution architect at Microsoft.

He is a thought leader in modern data platform which includes solutions involving relational and non-relational databases, data lakes, advanced analytics, MPP, big data and hybrid cloud implementations.

He has over 20 years of IT experience working as Software developer, SQL Server DBA, Solution/Data Architect, Cloud Solution Architect and extremely passionate about blogging and public speaking.

https://www.linkedin.com/in/manishk5/

SQL FRIDAY #35 – Riccardo Zamana on ‘Redis on Cloud: Red Pill or Blue Pill’

Date:2021-02-12
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #35 – Riccardo Zamana on ‘Redis on Cloud: Red Pill or Blue Pill’

Every developer knows Redis, but only uses 10% of its real capabilities.
During the session we will see how to use this multimodel datastore in various use cases and architectures, as a universal component to manage time series & data analysis, real time streams, Json data store.

Many examples of using Redis on Azure will be reported (such as Paas, such as Iaas cluster, such as Temporary DataBase with docker, etc.), as well as various tools found to make it as easy to use and maintain as any database.

About Riccardo Zamana

I’m an accomplished, result driven management professional with 20 years of experience in both IT and business functions.

Proven history of managing complex IT operations and strategy for the development and delivery of high technological product and services.

I’m highly skilled in proposal development and delivering business results by creating tailor made Cloud and IOT based solutions around the specific customer needs. My passions are to architect and build up teams of qualified professionals, redesign and streamline of software processes integrating more departments, delivering perfectly governed eco-systems. Decisional trees based on microservices plots, especially in OSS sauce, represent my greatest fun.

Even if I’m historically voted to OSS / Java / Spring Platform, I learned (and I’m still learning) the wonders of the Azure platform every day.

twitter.com/riccardozamana
linkedin.com/in/riccardozamana/
www.theazurefield.com

SQL FRIDAY #34 – Kevin Chant and Sander Stad on ‘Github Devops Duet – SQL Friday Edition’

Date:2021-02-05
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #34 – Kevin Chant and Sander Stad on ‘Github Devops Duet – SQL Friday Edition’

Welcome to GitHub DevOps Duet, a scenario where two teams (dev and ops) are going to start using GitHub Actions for Data Platform deployments.

They need to figure out how to implement their processes within GitHub and make it work for all parties.

We will discuss:

  • the challenges of implementing DevOps
  • setting up a database solution project
  • testing your database releases using tSQLt
  • setting up your GitHub Actions workflows
  • deploy database artifacts to multiple Data Platform solutions

As part of the session we will cover the GitHub services you get including:

  • Actions
  • Projects
  • Security

The session will cover how to setup projects for your tasks, set up workflows in Github Actions, security and so much more.

If you want to find out more about how Github can be implemented for your DevOps process than come to our session

About Kevin Chant

Senior Database Architect originally from the UK and now living in the Netherlands.

Many years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.

In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications, and was probably the last ever person in the world to gain the MCSD Azure Architect certification.

Real life experience with SQL Server and Azure Devops. Currently SQL Server product Owner of around 1,900 instances. In addition, done various things for the Data Platform Community. With the last being one of the organizers of the online DataWeekender conference.

https://twitter.com/kevchant
https://linkedin.com/in/kevin-chant
https://kevinrchant.com

About Sander Stad

Sander is a SQL Server DBA with over 15 years of experience in IT. He has worked with SQL Server since version 2000 and is a Cloud and Datacenter Management (CDM) MVP.
He is a huge PowerShell enthusiast and will try to automate processes as much as he can.

https://twitter.com/SQLStad
https://linkedin.com/in/sanderstad
https://www.sqlstad.nl

SQL FRIDAY #33 – Geovanny Hernandez on ‘First Steps to Go Ahead with Sql Server on Linux’

Date:2021-01-29
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #33 – Geovanny Hernandez on ‘First Steps to Go Ahead with SQL Server on Linux’

The Every beginning is difficult, but adopting the right strategy can mark the difference. In this session, I am going to share some of the most valuable lessons learned in my journey through the use of Linux as a platform together with MS SQL Server.

In this session, I will be explaining some fundamentals about Linux and subjects ranging from permissions to basic bash shell scripting and how we can use to maximize some routines and tasks on MS SQL Server, including the installation and configuration and practical examples and good practices for own mental health.

About Geovanny Hernandez

Geovanny Hernandez is a Senior Database Engineer and Microsoft Certified Trainer (MCT) and MCSE with more than fourteen years of experience in software development, passionate for performance tuning in MS SQL Server, Unit Testing, Python and Databases technologies.

In addition, Geovanny collaborates with MS SQL Server community as a speaker on different sessions for PASS Malaga (Spain chapter) and virtual events for students and professionals in Universities from Nicaragua (Central America) and international events as SQLBits and SQLSaturdays.

https://www.linkedin.com/in/geovannyhernandez/
https://twitter.com/datawithgeo
https://geohernandez.net/

SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’

Date:2021-01-22
Time:12:00 Central European Time (11:00AM UTC)
Accompanying material:https://prodata.ie/2020/10/02/financial-modelling-in-powerbi-downloads/
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’

Bob has been involved in taking Financial Models from paper based to highly dynamic analytics models in Microsoft BI for many large enterprises in Ireland.

Building Successful Financial Models based of a Chart of Accounts and General Ledger can be difficult for a number of reasons:
– Dynamic/Growing Chart of Accounts
– Many to Many Structure
– Parent Child
– Ragged Hierarchies on financial reports
– Unary Operators such as running sums
– Entity Attribute Value structures
– Forecasting and Budgeting
– Overhead Allocation
– Modelling Profit Variations like EDBITA

Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.

About Bob Duffy

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and now Analysis Services “Maestro” certified.

Bob used to work for Microsoft Consulting Services a Senior Consult and subject matter expert for BI/data. He now works at the Prodata SQL Centre off Excellence in Dublin, Ireland where he helps enterprise customers with cloud architecture, design, performance tuning, benchmarking and pretty much anything to do with SQL Server or Business Intelligence.

https://twitter.com/bob_duffy
https://www.linkedin.com/in/duffybob
http://blogs.prodata.ie/

SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’

Date:2021-01-15
Time:12:00 Central European Time (11:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’

Azure Synapse SQL serverless pool is a new pay-per-usage Transact-SQL query service that enables you to analyze large amount of data stored on Azure Blob Storage, Azure Data Lake, and Azure CosmosDB. Synapse SQL is connector to Azure data for the application and tools that can use T-SQL. It is a platform where you can create Logical DataWarehouse on top of your Azure data sources. If you ever wanted to use something like a fully-managed standalone Polybase service to query PARQUET, CSV, and JSON data in Azure using standard T-SQL without pre-provisioning resources, this might be the perfect solution for you. Learn about the service that might be a future of big data analytics in Azure cloud.

About Jovan Popovic

Jovan Popovic is Senior Program Manager working on Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. He is working in Microsoft Development Center Serbia as Program Manager on several developer-facing SQL Server/Azure SQL features such as T-SQL language enhancements, JSON/temporal support, columnstore/in-memory technologies, and built-in intelligence. He has more than 15 years of experience in various Microsoft technologies with a focus on SQL Server, Azure, ASP.NET, C#, and JavaScript. He has been working in various Microsoft Data Platform teams since 2012. He is a former Microsoft MVP for ASP.NET and has a PhD degree in software engineering from the University of Belgrade. He is a public speaker at top Microsoft conferences, and is author of several books and open-source projects. He enjoys exploring technologies (especially SQL Server capabilities) and finding the best ways to implement the most efficient solutions using them.

https://www.linkedin.com/in/jovan-popovic/
https://twitter.com/JovanPop_MSFT

SQL Friday 2021 Schedule Announced

Finally, the schedule for SQL Friday 2021 is done. Speakers have created session abstracts, sessions were selected, speakers have confirmed their participation and sessions were scheduled. I’m happy to announce that we have 25 top notch sessions schedules for January – June 2021.

A big Thank You goes out to all speakers – selected and not selected – for your contributions to the Data Platform community!

Check out the schedule now

SESSIONDATERegister to attendSpeaker and title
2021-01-08https://www.meetup.com/SQL-Friday/events/275338413/SQL FRIDAY #30 – M A Nakib on ‘Azure Synapse Analytics’
2021-01-15https://www.meetup.com/SQL-Friday/events/275338429/SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’
2021-01-22https://www.meetup.com/SQL-Friday/events/275338749/SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’
2021-01-29https://www.meetup.com/SQL-Friday/events/275338804/SQL FRIDAY #33 – Geovanny Hernandez on ‘First steps to go ahead with MS SQL Server on Linux’
2021-02-05https://www.meetup.com/SQL-Friday/events/275338837/SQL FRIDAY #34 – Kevin Chant and Sander Stad on ‘GitHub DevOps Duet – SQL Friday Edition’
2021-02-12https://www.meetup.com/SQL-Friday/events/275338850/SQL FRIDAY #35 – Riccardo Zamana on ‘Redis on Cloud: red pill or blue pill?’
2021-02-19https://www.meetup.com/SQL-Friday/events/275338869/SQL FRIDAY #36 – Manish Kumar on ‘Secure your data with Azure SQL DB’
2021-02-26https://www.meetup.com/SQL-Friday/events/275338880/SQL FRIDAY #37 – Deepthi Goguri on ‘SQL Server Internals and Architecture’
2021-03-05https://www.meetup.com/SQL-Friday/events/275338894/SQL FRIDAY #38 – Ásgeir Gunnarsson on ‘Reel in the Power BI Wild West’
2021-03-12https://www.meetup.com/SQL-Friday/events/275338920/SQL FRIDAY #39 – Cédric Charlier on ‘Azure databricks: brick by brick for the data engineer’
2021-03-19https://www.meetup.com/SQL-Friday/events/275338937/SQL FRIDAY #40 – Gonzalo Bissio on ‘Azure SQL DB Serverless, a new autonomous database?’
2021-03-26https://www.meetup.com/SQL-Friday/events/275339143/SQL FRIDAY #41 – Dennes Torres on ‘Data Virtualization and Data Lake using SQL Big Data Cluster’
2021-04-02CancelledSQL FRIDAY #42 – SANDEEP PAWAR on ‘Power Up Power BI with Jupyter Notebook – Use Cases’
2021-04-09https://www.meetup.com/SQL-Friday/events/277276842/SQL FRIDAY #43 – Ronen Ariely on ‘SQL Internals – Physical Table Structure under the hood, and implementation on real case scenarios’
2021-04-16https://www.meetup.com/SQL-Friday/events/277277421/SQL FRIDAY #44 – Damir Matešić on ‘Historical data with MS SQL System-Versioned (Temporal) Tables’
2021-04-23https://www.meetup.com/SQL-Friday/events/277277444/SQL FRIDAY #45 – Lou Segers on ‘🚂 Turn your slow steam locomotive into a streamlined high-speed train 🚄’
2021-04-30https://www.meetup.com/SQL-Friday/events/277277460/SQL FRIDAY #46 – Benjamin Kettner on ‘Straight from the Dojo: T-SQL string manipulations with the T-SQL Ninja’
2021-05-07https://www.meetup.com/SQL-Friday/events/277277489/SQL FRIDAY #47 – Thimantha Vidanagamage on ‘Power BI: Utilizing Large Scale Semantic Models in Service’
2021-05-14https://www.meetup.com/SQL-Friday/events/277277550/SQL FRIDAY #48 – Martin Guth on ‘Relaxed Releases with DB-Workload-Tests’
2021-05-21https://www.meetup.com/SQL-Friday/events/277277677/SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’
2021-05-28https://www.meetup.com/SQL-Friday/events/277277786/SQL FRIDAY #50 – Markus Ehrenmüller-Jensen on ‘From SQL to R – Leverage Your T-SQL Knowledge to Learn R’
2021-06-04SQL FRIDAY #51 – Mark Hayes on ‘Migrating a Data Capture solution with Event Hubs and Stream Analytics’
2021-06-11SQL FRIDAY #52 – Torsten Strauß on ‘Parallelism in Microsoft SQL Server’
2021-06-18SQL FRIDAY #53 – Jean-Pierre Voogt on ‘Data Migration to Azure SQL DB using Polybase’
2021-06-25SQL FRIDAY #54 – Manpreet Singh on ‘Let’s Develop Power Apps & Power Automate/Flows on Office 365 from scratch’

Thank you!

SQL Friday 2020 is done.

I want to thank everyone that has been involved since I started SQL Friday in the beginning of the pandemic. Huge thank you to all the speakers. Without you, SQL Friday wouldn’t have been much. Thank you to everyone that attended presentations at SQL Friday. There are hundreds of you and the SQL Friday community is growing.

Did you miss a presentation? Just head on over to the Past Sessions page. All 29 SQL Friday presentations from 2020 are there for you to watch.

You may or may not have seen that the Call for Speakers for SQL Friday 2021 was open (and then closed). I have spent the days after the last SQL Friday 2020 finalising session seletion and scheduling. And I’m happy to say that the schedule for January – June 2021 is filled with another 25 great presentations by truly awesome speakers. Check out the Schedule page or head straight over to the SQL Friday Meetup group to check out the sessions and register to attend next year’s fun! (Schedule will be updated as soon as I get confirmation from last few speakers and immediately after that I will create the Meetup events).

Again, thanks for all the Friday fun you’ll let me have in 2020 and I’m really looking forward to 2021. See you!