SQLSaturday #775 - Gothenburg 2018
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.
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?
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?
DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!
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.
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
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.
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
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.
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
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.
Natural Born Killers, Performance Issues to Avoid
Event Date: 15-09-2018 - Session time: 10:35:00 - Track: Application Database Development
Speaker: Lord Richard Douglas
Title: Natural Born Killers, Performance Issues to Avoid
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.
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
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.
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
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.
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
You might have heard "don't use cursors, they are slow!". In this presentation, you will learn what actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.
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
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.
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
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.
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
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.
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
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.
Event Date: 15-09-2018 - Session time: 15:00:00 - Track: BI Information Delivery
Speaker: Andrea Martorana Tusa
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.
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
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
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
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.
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
I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won’t change a lot of code, won’t generate weeks of testing and validation for your colleagues, and can be relatively quick to implement.
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.