sqlsathistory

Nr: 731

Back to Main list

SQLSaturday #731 - Athens 2018

Start Time (24h) Speaker Track Title
09:40:00 Cláudio Silva Enterprise Database Administration Deployment Administrate SSRS/PBIRS with PowerShell
09:40:00 Sergio Govoni Professional Development SQL Server 2017 Graph Database
10:50:00 Mikael Wedham Application Database Development A Masters view on Query plans and indexing
10:50:00 Mihail Mateev Strategy and Architecture Choosing the Right Database for Microservices Solutions
12:00:00 André Melancia Enterprise Database Administration Deployment SQL Curiosities: η περιέργεια σκότωσε τη γάτα
12:00:00 Christian Cote BI Platform Architecture, Development Administration The modern data warehouse
13:45:00 Bent Pedersen BI Platform Architecture, Development Administration Boost your Tabular Productivity
13:45:00 Arnie Rowland Application Database Development Magical Memory Moments
14:55:00 Rudi Bruchez Enterprise Database Administration Deployment What can you do with SQL Server on Linux?
14:55:00 Christian Cote BI Platform Architecture, Development Administration Azure Data Factory V2 /SSIS in Azure
16:05:00 Kevin Boles Application Database Development Know What Your Code is Doing to SQL Server!

SessionID: 71728

Administrate SSRS/PBIRS with PowerShell

Back to calendar

Event Date: 16-06-2018 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Cláudio Silva

Title: Administrate SSRS/PBIRS with PowerShell

Abstract:

Once in a while I need to deploy dozens of reports, data sources, permissions and subscriptions across multiple Reporting Services folders.

Some time ago, I accomplished this by hand, wasting hours of my life. Nowadays it takes me a couple of minutes and I'm done.

In this session I will share how you can leverage on ReportingServicesTools PowerShell module to deploy your reports, manage permissions and subscriptions and stop waste your time with some of those trivial tasks.

We will see examples for both Reporting Services and PowerBI Report Server.

SessionID: 72318

SQL Server 2017 Graph Database

Back to calendar

Event Date: 16-06-2018 - Session time: 09:40:00 - Track: Professional Development

Speaker: Sergio Govoni

Title: SQL Server 2017 Graph Database

Abstract:

SessionID: 73734

A Masters view on Query plans and indexing

Back to calendar

Event Date: 16-06-2018 - Session time: 10:50:00 - Track: Application Database Development

Speaker: Mikael Wedham

Title: A Masters view on Query plans and indexing

Abstract:

Do you find query optimization a mystery? This session will straighten out your question marks.

You will se how queries are run, how indexes are used and get an insight into what query plans tell you. Further on you'll be introduced to In-Memory and Column Store indexing to get a fair chance of selecting appropriate indexing for your query load.

SessionID: 73868

Choosing the Right Database for Microservices Solutions

Back to calendar

Event Date: 16-06-2018 - Session time: 10:50:00 - Track: Strategy and Architecture

Speaker: Mihail Mateev

Title: Choosing the Right Database for Microservices Solutions

Abstract:

The past years have seen the explosive growth of large-scale distributed systems. This trend has changed the database world that is arguably without precedent in the history of the software industry. The result is a ompetitive database marketplace with a huge variety of platforms for us to choose from. But how do we go about making the right choices?

In this talk we will discuss how we can go about choosing the right database models for your application. We will also look at how the choice of data models can help determine which technologies to include in your data tier.

SessionID: 71476

SQL Curiosities: η περιέργεια σκότωσε τη γάτα

Back to calendar

Event Date: 16-06-2018 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: André Melancia

Title: SQL Curiosities: η περιέργεια σκότωσε τη γάτα

Abstract:

There are weird things in life. Even weirder for developers... "It should work!"... What you see is NOT what you get... There's a bug, a feature, a workaround...

Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Ελληνική Φιλοζωική Εταιρεία...

SessionID: 82434

The modern data warehouse

Back to calendar

Event Date: 16-06-2018 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Christian Cote

Title: The modern data warehouse

Abstract:

SessionID: 74711

Boost your Tabular Productivity

Back to calendar

Event Date: 16-06-2018 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bent Pedersen

Title: Boost your Tabular Productivity

Abstract:

Tabular Editor is an open source alternative that relies only on the Model.bim JSON metadata and the Tabular Object Model (TOM), thus providing an offline developer experience for Azure and on-premises tabular models.

Making changes to measures, calculated columns, display folders, etc. is lightning fast, and the UI provides a "what-you-see-is-what-you-get" model tree allowing you to maintain Display Folders, Perspectives and Translations. The perfect tool for your tabular models.

Combined with scripting functionality, a Best Practice Analyzer, command-line build and deployment, and much more, Tabular Editor is a must for every SSAS Tabular developer. The tool is completely free.

Demoing the capabilities of the tool is what is in focus for this session and therefore do not expect many slides. Attendees are assumed to be familiar with Tabular Model development.

SessionID: 77166

Magical Memory Moments

Back to calendar

Event Date: 16-06-2018 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Arnie Rowland

Title: Magical Memory Moments

Abstract:

OR, How In-Memory Objects Can Supercharge Your Data And Bring About World Peace

OK, so you’ve been reading about, perhaps even testing out some of the ‘in-memory’ objects now available in SQL Server. Some of the claims are exciting, and some seem overly optimistic. And Yet, you want to know, experience more … Perhaps your situation doesn’t really call out for in-memory tables. But you should consider memory-optimized #Temp tables, memory-optimized table variables, and natively compiled stored procedures.It’s true. Using memory-optimized tables requires a little more fore-thought, a bit more care, even a few configuration tweaks. • But what are the real advantages of memory-optimized objects? • What are the memory-optimized objects you can use? • How can you best use memory-optimized objects? In this demo packed session, we will discuss the pros and cons of using memory-optimized objects in ways that will supercharge your SQL Server.

SessionID: 71412

What can you do with SQL Server on Linux?

Back to calendar

Event Date: 16-06-2018 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Rudi Bruchez

Title: What can you do with SQL Server on Linux?

Abstract:

The best RDBMS meets the best Operating System. But can you leverage all the power of SQL Server on Linux? Can you create AlwaysOn Availability Groups on Linux? Can you use Integration Service (SSIS) to exchange data ? Is Change Data Capture (CDC) available? Can you use Active Directory Authentication? You will need to attend this session to get the answers!

SessionID: 73559

Azure Data Factory V2 /SSIS in Azure

Back to calendar

Event Date: 16-06-2018 - Session time: 14:55:00 - Track: BI Platform Architecture, Development Administration

Speaker: Christian Cote

Title: Azure Data Factory V2 /SSIS in Azure

Abstract:

Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is now able to integrate SSIS packages. In this session, you will learn how to deploy and execute SSIS packages from Azure Data Factory V2.

SessionID: 72325

Know What Your Code is Doing to SQL Server!

Back to calendar

Event Date: 16-06-2018 - Session time: 16:05:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Know What Your Code is Doing to SQL Server!

Abstract:

ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and concurrency you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.