Nr: 775
SQLSaturday #775 - Gothenburg 2018
SessionID: 78501
Let the Cognitive Services to help you to find your favourite cocktail.
Event Date: 15-09-2018 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Speaker: Alexander Klein
Title: Let the Cognitive Services to help you to find your favourite cocktail.
Abstract:
Who does not know the problem, you sit in the bar and just don't know which cocktail to order?
The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?
SessionID: 78503
DevOPS for DBAs - Where is your magic wand?
Event Date: 15-09-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Satya Jayanty
Title: DevOPS for DBAs - Where is your magic wand?
Abstract:
Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer .
In this session let us overview where exactly DBAs can make miracles with their magic wand, let's talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices.
Take away best practices associated in DEVOPS and DBA world.
SessionID: 78530
Scaling Out Workload Processing Using SQL Server Running Inside Containers
Event Date: 15-09-2018 - Session time: 09:15:00 - Track: Application Database Development
Speaker: Christopher Adkin
Title: Scaling Out Workload Processing Using SQL Server Running Inside Containers
Abstract:
Scaling out workloads such OLTP using the traditional database engine always leads to certain bottlenecks being encountered, namely around spinlocks and the logging infrastructure. This session will cover these bottlenecks and present ways and means for overcoming these using SQL Server running inside containers. Use cases for these solutions include ingesting the massive amounts of data encountered in IoT and micro services style applications.
SessionID: 78962
The Road to The Autonomous Databases
Event Date: 15-09-2018 - Session time: 10:35:00 - Track: Strategy and Architecture
Speaker: Janusz Rokicki
Title: The Road to The Autonomous Databases
Abstract:
Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.
SessionID: 80611
SQL Server, Next station Azure
Event Date: 15-09-2018 - Session time: 10:35:00 - Track: Cloud Application Development Deployment
Speaker: Jose Manuel Jurado Diaz
Title: SQL Server, Next station Azure
Abstract:
This session will cover the main aspects to start or migrate from an OnPremise model to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment for our requirements.
We will cover:
- Red pill or blue pill
SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
- Always available.
High availability in Azure
- Now what ...
Best practices and configuration connectivity.
SessionID: 83920
Event Date: 15-09-2018 - Session time: 10:35:00 - Track: Application Database Development
Speaker: Lord Richard Douglas
Abstract:
Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code. As an attendee you will gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.
Ever thought that you were adhering to best practices but still seeing performance problems? You might well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn’t always use the best plan.
You will leave this session with a list of things that you can check for in your environment to improve performance for your users.
SessionID: 80848
How to build solution for High Availability/Disaster Recovery
Event Date: 15-09-2018 - Session time: 11:45:00 - Track: Strategy and Architecture
Speaker: Marcelo Fernandes
Title: How to build solution for High Availability/Disaster Recovery
Abstract:
How does your SQL Server environment meet the RPO and RTO service levels?
In this session, we will cover all aspects of HA / DR. We will cover all technology options and compare the benefits between them. We will also talk about processes to maintain your RPO and RTO level.
SessionID: 82885
SQL Server GDPR
Event Date: 15-09-2018 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Francisco Racionero
Title: SQL Server GDPR
Abstract:
GDPR is coming and only a few companies are ready to apply. In this session we will see how SQL Server can help us to be compliance with regulation.
Discover
Manage
Protect
Report
Monitoring
SessionID: 83714
Don't Use Cursors or Why You Maybe Should Use a Cursor After All
Event Date: 15-09-2018 - Session time: 11:45:00 - Track: Application Database Development
Speaker: Erland Sommarskog
Title: Don't Use Cursors or Why You Maybe Should Use a Cursor After All
Abstract:
SessionID: 80821
Encryption in SQL Server
Event Date: 15-09-2018 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Michal Sadowski
Title: Encryption in SQL Server
Abstract:
An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how to approach this issue? What type of encryption should you use in your environment? On the session I will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats, and countermeasure them by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc. After this session, you will know a set of best practices that you can apply in your environment.
SessionID: 83635
Data Wrangling as the key to success with Data Lake
Event Date: 15-09-2018 - Session time: 13:45:00 - Track: BI Information Delivery
Speaker: Sergiy Lunyakin
Title: Data Wrangling as the key to success with Data Lake
Abstract:
Self-Service Data Preparation aka Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. Traditional approach doesn't work here, data analysts and data scientists have to wait until IT guys gather requirements and prepare a right dataset for them. Time from raw data to insights is too long. In this session, I invite you together look closer at Self-Service Data Prep and show how it would help to get insights and make decisions faster, onboard new data sources without IT, and increase efficiency for data analysts and data scientists.
SessionID: 83732
Azure Stream Analytics Machine learning: better together
Event Date: 15-09-2018 - Session time: 13:45:00 - Track: Advanced Analysis Techniques
Speaker: Nico Jacobs
Title: Azure Stream Analytics Machine learning: better together
Abstract:
In the current just-in-time world we want to analyze what is happening now, not what happened yesterday. Companies start to embrace Azure Stream Analytics, which makes it easy to analyze streams of incoming events without going into advanced coding. But for advanced analytics we need machine learning to learn patterns in your data. Azure Machine learning can do this for you. But the real beauty is that both products can easily work together.
So if you want to see how within 60 minutes we can learn patterns in streams of data and apply them on live data, be sure to attend this demo-oriented session.
SessionID: 78873
Headless chicken - calming the sysadmin that turned DBA
Event Date: 15-09-2018 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Alexander Arvidsson
Title: Headless chicken - calming the sysadmin that turned DBA
Abstract:
Last night you went to bed as a sysadmin, but today you are realizing with a rising dread that you have woken up as a DBA. It sounds like a bad dream, but it doesn't seem to go away. Maybe the previous DBA won a million bucks and quit on the spot or was hit by a bus and will spend the next couple of months in the hospital; the fact remains that you're now THE DBA. It really doesn't matter if you have a single database on-prem or thirty in the cloud - you've pulled the short straw and you quickly need to get up to speed. This session is a fast-paced, exciting and fun database primer for sysadmins. You will learn how to best feed and care for your new toy, where to scratch, where to kick and most importantly - what never to do. Bring me your fear and despair and I will give you the confidence needed to continue your new DBA journey.
SessionID: 82570
Event Date: 15-09-2018 - Session time: 15:00:00 - Track: BI Information Delivery
Speaker: Andrea Martorana Tusa
Abstract:
Reporting Services is used by years as the main tool to create and delivery reports for SQL Server data platform users.
But although we are accostumed to use it, there are many tips and tricks that can help us to significantly improve the output we produce. For example:
- writing custom function to perform non-standard actions or to create personalized charts
- export multiple sheets in Excel
- dealing with merge cells when exporting in Excel
- using interactive and dynamics filters inside a report
- creating alternate rows backgrounds in tables or matrix
The release of SQL Server 2016 introduced support for R, the most common and powerful analytical and statistical language.
With R inside SQL Server it’s possible to embed R charts straight into Reporting Services, exploiting countless opportunities offered by the powerful graphic libraries shipped into the language.
SessionID: 80698
My 10 favorite PowerShell commands
Event Date: 15-09-2018 - Session time: 16:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Marcos Freccia
Title: My 10 favorite PowerShell commands
Abstract:
As a DBA I am always trying to automate the tasks that I have to do. In this session I want to show you 10 Powershell commands that will make your life easier and increase your productivity.
I promise that at least one new thing you will learn it
SessionID: 83151
Automate your work processes with Microsoft Flow and Power BI
Event Date: 15-09-2018 - Session time: 16:10:00 - Track: Analytics and Visualization
Speaker: Hylke Peek
Title: Automate your work processes with Microsoft Flow and Power BI
Abstract:
You use different apps to organize your work. Outlook, Onedrive, Onenote, Sharepoint, Power BI and so on. All for different tasks. Microsoft introduced Flow to let these apps talk to each other. This allows us to create new automated workflows in an easy way. And the beauty is, you don’t need to be a developer!
In these workflows Power BI can play an important role. Power BI generates data alerts which can be used to create emails, work tasks or even start a new flow. Also, you can automatically publish data to Power BI from apps like Outlook and SharePoint to analyze your email and documents.
In this session we’ll introduce Flow and look at use cases to integrate apps with Power BI. By using different demo’s, you will get a good understanding how to use Power BI and Flow to automate new work processes.
SessionID: 84027
Not just polish – How good code also runs faster
Event Date: 15-09-2018 - Session time: 16:10:00 - Track: Application Database Development
Speaker: Daniel Hutmacher
Title: Not just polish – How good code also runs faster
Abstract:
But most of all, they’ll make the code prettier and easier to understand for the next person.
We’ll look at common ways that null values, implicit datatype conversions and foreign key constraints can radically affect the performance of your queries. Inspired by an actual client case, where I tuned a 20 hour query down to a few minutes, with only a minor code change.
This presentation is all-code, some execution plans, and no-powerpoint.