This year we have 5 exciting precons covering a good variety of topics to ensure that there is something for everyone.
Database DevOps – a crash course! with Alex Yates
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.
A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
Deploying database changes, for many of us, is horrible. It’s often a manual, time-consuming and error-prone process. When it goes wrong, and it often does, the consequences can be serious. The DevOps, Continuous Delivery and Application Lifecycle Management (ALM) movements have revolutionised our ability to deliver software regularly and reliably. Unfortunately, many of us have not adopted the associated practices for our databases. There are, however, tools and techniques (technical and cultural) to implement Database DevOps/Database Lifecycle Management (DLM), allowing us to manage SQL changes efficiently and safely.
Introduction to Database DevOps/DLM and an overview of the different tools that are available
Discussion about the different approaches: model vs migration / shared dev DB vs dedicated dev DBs
- HANDS-ON LAB: Source control a database using Git, VSTS/TFS and Redgate SQL Change Automation (formerly called ReadyRoll)
HANDS-ON LAB: Working with static data
- Introduction to continuous integration
- HANDS-ON LAB: Automating builds with VSTS/TFS and Redgate SQL Change Automation
- Introduction to continuous delivery
- HANDS-ON LAB: Continuous delivery to an integration database
- HANDS-ON LAB: Production-ready automated releases (automation while keeping DBAs happy)
Protect your data – Security in SQL Server with Uwe Ricken
Uwe Ricken is working with IT-systems since early 1990's. He started with development of database applications in 1998 with a professional CRM-System based on Microsoft products (Microsoft Office and SQL Server). In May 2013 he achieved the "Microsoft Certified Master: SQL Server 2008. Since 2013 he has been awarded continuously with the MVP Award for his activities and engagement for the SQL community and was the first MCM + MVP for SQL Server in Germany.
"In which newspaper can you read that a woman throws her husband out of the apartment?
In "Better Homes and Gardens". What this sentence certainly must do in Microsoft SQL Server can be found in this one-day workshop on the individual security components of Microsoft SQL Server.
Starting with the correct security settings for the service account of Microsoft SQL Server, the same goes on in the staircase of the databases. What rights should you give to a login without endangering the security of the system or securing the data.
Once arrived in the "honourable tenement", one would of course like the nice rented apartment. But stop! - What am I allowed to do in my apartment? A lawyer is no longer required after attending the workshop. In this workshop, the following topics will be taught with examples and exercises:
- Proper configuration of the service account of Microsoft SQL Server and SQL Server Agent
- TDE and encrypted backup
- The special features of sysadmin
- Danger and Beauty from "xp_cmdshell"
- Minimal Rights principal when creating logins
- Database permissions and their consequences
- Use of certificates for the execution of stored procedures
- Schemes and objects
- Owners of objects and access via stored procedures / views / functions
- EXECUTE AS
All security aspects of Microsoft SQL Server are covered in detail in this workshop and will be tested on your own laptops with extensive demos and exercises themselves.
An Introduction to data warehousing with Steve Simon
Steve Simon is a Data Platform MVP and a Database Solutions Architect with Preventure Inc. He has been involved with database design and analysis for over 32 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQL Saturday circuit and he is a regular contributor on SQLShack.com
We live in a complex world where we accumulate more and more data with each passing year. We tend to normalize our data within our OLTP relational databases and oft times this proves problematic with regards to extract times for reporting purposes.
Properly defined and constructed data warehouses can level the playing field and enable us to provide the end user with more information within a timely manner.
This “hands on” pre-conference session will be concentrating on how to construct efficient and effective data warehouses, with the emphasis being placed upon proper design and being able to produce the reports so necessary to the success of the corporate enterprise.
Topics will include
- Why do we need a warehouse?
- Points to consider before embarking on warehouse construction.
- Case history from a recent practical implementation and the gotcha’s encountered.
- Gathering requirements (business side, existing documentation).
- Types of warehouse design (Star - Snowflake).
- Legacy Data? Existing Data?
- Creation of effective functional and technical specification.
- Why are data relationships critical to the warehouse design and functionality?
- Planning and modeling
- Multidimensional vs. Tabular warehousing
- Construction of relationship diagrams and usage of Entity/Relationship tools (e.g.Erwin)
- Creating effective dimensions
- Creating effective fact tables
- The need to denormalize our data.
- Measures / Dimensions (Keys, qualitative fields)
- Fact tables (keys, quantitative fields)
- Query / Stored procedure efficiencies against the warehouse, a barometer!
- SSRS Report efficiencies.
All the techniques that we shall be working through have been utilized on a recent major North American project in 2017/2018. As always, rest assured that you will leave this session with more questions than answers!
A Drill Down Into SQL Server Machine Learning Services with Niels Berglund , Data Platform MVP
Niels works as a Software Architect at Derivco, where he develops software as well as "dreaming" up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as a researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: "A First Look at SQL 2005 for Developers". He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, etc., and is also a Microsoft Data Platform MVP.
In this full-day workshop we look in detail at how SQL Server Machine Learning Services work and what you can do with it. We look at how it "hangs together" under the covers, and we look at how you can put together a complete machine learning pipeline with SQL Server ML Services. Some may think that SQL Server ML Services is purely for data scientists, but in this workshop, we also see how a database developer/DBA can get a lot of benefits from SQL Server ML Services.
Azure Fundamentals with Adnan Hendricks, Azure MVP
Learn the latest and greatest updates to the Azure Platform IaaS and PaaS services, bringing you all the required knowledge to start architecting and deploying Azure resources as soon as you are back in the office… with confidence!
Attendee’s desired pre-requisites/profile We assume attendees to be familiar with Azure concepts already, or have experience in using Azure Service Manager and eager to learn what Azure Resource Manager has to offer. Content is targeted to IT Pro’s, Architects, Developers, who are interested in a good combination of architect-to-architect knowledge sharing and doing hands-on labs.
All content from this workshop is created by Adnan Hendricks and the AzurePlatformExperts community itself, and will provide the most up-to-date information on the Azure platform available, closest to the conference. All slide decks and lab guides will be shared with the participants, as well as giving them access to a repo, containing additional material to use after the workshop day.
Emerging AI Developer – Hands-on labs with Azure Search, Bot Service and Cognitive Services with David Peter Hansen
In this workshop we will focus on hands-on activities that develop proficiency in AI-oriented services such as Azure Bot Services, Azure Search, and Cognitive Services. These labs assume an introductory to intermediate knowledge of these services, and if this is not the case, then you should spend the time working through the pre-requisites.
Most challenges observed by customers in these realms are in stitching multiple services together. As such, where possible, we have tried to place key concepts in the context of a broader example.
At the end of this workshop, you should be able to:
· Understand how to configure your apps to call Cognitive Services
· Build an application that calls various Cognitive Services APIs (specifically Computer Vision)
· Understand how to implement Azure Search features to provide a positive search experience inside applications
· Configure an Azure Search service to extend your data to enable full-text, language-aware search
· Build, train, and publish a LUIS model to help your bot communicate effectively
· Build an intelligent bot using Microsoft Bot Framework that leverages LUIS and Azure Search
· Effectively log chat conversations in your bot
· Perform rapid development/testing with Ngrok and test your bots with unit tests and direct bot communication
· Effectively leverage the custom vision service to create image classification services that can then be leveraged by an application
This workshop is meant for an AI Developer on Azure. Since this is only a short workshop, there are certain things you need before you arrive.
Firstly, you should have some previous exposure to Visual Studio. We will be using it for everything we are building in the workshop, so you should be familiar with how to use it to create applications. Additionally, this is not a class where we teach you how to code or develop applications. We assume you have some familiarity with C# (intermediate level - you can learn at https://mva.microsoft.com/en-us/training-courses/c-fundamentals-for-absolute-beginners-16169?l=Lvld4EQIC_2706218949), but you do not know how to implement solutions with Cognitive Services.
Secondly, you should have some experience developing bots with Microsoft’s Bot Framework. We won’t spend a lot of time discussing how to design them or how dialogs work. If you are not familiar with the Bot Framework, you should take the Microsoft Virtual Academy course at https://mva.microsoft.com/en-us/training-courses/creating-bots-in-the-microsoft-bot-framework-using-c-17590#! prior to attending the workshop.
Thirdly, you should have experience with the portal and be able to create resources (and spend money) on Azure. We will not be providing Azure passes for this workshop.
Finally, before arriving at the workshop, we expect you to have completed a setup process. The setup process will be sent to you before the workshop. You also need to bring your own laptop to the workshop.
Please note: This is a rough agenda, and the schedule is subject to change pending class activities and interaction.
· 8-9 (optional): Setup assistance
· 9-10: Introduction and context for Cognitive Services and Bots
· 10-12: Lab 1: Simplifying Cognitive Services App Development using Portable Class Libraries
· 12-13: Lunch
· 13:00-14:00: Lab 2: Developing Intelligent Applications with LUIS
· 14:00-15:00: Lab 3: Developing Intelligent Applications with Azure Search
· 15:00-16:30: Lab 4: Building Intelligent Bots
· 16:30-17:30: Q&A
· Optional Lab 5: Log Chat Conversations in your Bot
· Optional Lab 6: Testing your Bot