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 #29: Uwe Ricken on “Simplify Data Management with Partitioning”

Date:2020-12-18
Time:12:00 CEST
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 #29: Uwe Ricken on “Simplify Data Management with Partitioning”

The days of small database systems are now over. Even “small” systems already provide databases with a data volume of several 100 GB. It can be a real challenge for the DBA to do the daily maintenance tasks, data backup, consistency checks, … within a reasonable time frame.

With the help of partitioning (also a feature of the Standard Edition since SQL 2016), considerable advantages can be achieved in ETL processes, maintenance and backup / recovery.

The main area of application for partitioning is the optimization of loading paths for complex DWH solutions and the maintenance of large databases (statistics, indices, backups, restores). The very strongly demo-based session shows partitioning scenarios that allow the DBA to do alternative things again and encourage ETL developers to dance with joy.

About Uwe

Uwe Ricken is working with IT systems since the 90’s. The start of experiences with Microsoft SQL Server came with the assignment for development of membership administration software for the American Chamber of Commerce in Germany. The software has been distributed to five additional European countries.

The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification.

The year 2013 finished with the first MVP award for his support to the Microsoft SQL Server community in Germany and Europe.

Twitter: @dbberater

LinkedIn: https://www.linkedin.com/in/uwericken

SQL Friday #28: Jayakumar Balasubramaniam on “Implement Security in Azure SQL with Azure Key Vault and AlwaysEncrypted”

Date:2020-12-11
Time:12:00 CEST
How to attend:Already finished
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 #28: Jayakumar Balasubramaniam on “Implement Security in Azure SQL with Azure Key Vault and AlwaysEncrypted”

n this session let’s learn how always Encrypted technology allows client applications to encrypt sensitive data and never reveal the data or the encryption keys to SQL Server or Azure SQL Database.

About Jayakumar

(MCT) Microsoft Certified Trainer | (MCSD) Microsoft Certified Professional in Azure and Dot Net.

A technology evangelist working on Microsoft 365, SharePoint & Azure.

Gets my hands dirty with latest and greatest of SharePoint, Azure & front-end frameworks.

Currently working with “Hubfly – A unified digital workplace” as a Product Engineer.

Getting in to the depth of the domain & technology, with my eyes for perfection, ensures that the product releases go right every time.

Recognized as C# Corner MVP.

SQL Friday #27: Matt Gordon on “Dialogue with Your Data – Interactive AI with Cognitive Services”

Date:2020-12-04
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download at https://www.sqlatspeed.com
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 #27: Matt Gordon on “Dialogue with Your Data – Interactive AI with Cognitive Services”

Customers and users increasingly demand personal and prompt communication from companies and brands with which they interact.

How can data professionals help fill that need? The incredible power and instant accessibility of the Azure Cognitive Services Language and Speech APIs, alongside other Azure services, put the power in our hands. From translating between languages for better communication to analyzing the quality of customer support communications,

Azure Cognitive Services allows data professionals to enhance a company’s ability to communicate and understand. This demo-heavy session walks through practical applications of these APIs that you can apply anywhere immediately after the session.

About Matt

Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker.

He’s an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm.

He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.

Matt can be found on Twitter @sqlatspeed.