Hot potato – Administering SQL Server for the experienced sysadmin

Goals:

Explore what a database is and what makes it tick
Describe key differences between systems and database management
Ensure continued database availability even in the absence of the DBA

Did the DBA just quit? Have you suddenly inherited some SQL Server databases, though you are a career systems administrator? Do you find yourself trying to keep a database afloat with no previous experience? If so, this session is your lifeline.

Administering a database is surprisingly different from administering a server, despite what management sometimes think. In this session Alexander, a trainer and consultant with 20 years experience, will help you understand why a database is not just another file.

We will begin with an overview of what a database is and what makes it different from anything else a sysadmin has seen before. We will discuss necessary do’s and don’ts for keeping the database running, what pieces goes where, and where to find help.
An hour won’t make you a seasoned database administrator, but I can ensure that you will learn enough to confidently support your databases and avoid making a mistake that might prompt the need for a good résumé.
When you leave, you will have a firm grasp on what a database is, you will be able to describe key differences between systems and database management, and have enough knowledge to ensure continued database availability even in the absence of a dedicated DBA.

Heck freezes over – SQL Server for the Oracle admin

Goals:

Explore the key differences between Oracle and SQL Server
Gain basic knowledge for administering a SQL Server database
Develop a plan for continued learning

Have you found yourself suddenly caring for a SQL Server database after a career of administering Oracle? If so, this is the session for you!

This session will walk you through the key differences between Oracle and SQL Server and give you the confidence to manage a SQL Server database without inadvertently breaking it. It follows with key tips for getting to know your new database and how to avoid mistakes due to incorrectly assuming that SQL Server behaves in the same way as Oracle does. Join a fast-paced session filled with lessons from the field, all led by a 20-year veteran of Oracle and SQL Server.

If you need to quickly get up to speed on SQL Server, gain a basic knowledge for administering SQL Server and develop a plan for continued learning, then this session will provide the tools you need to put you on the right track to become a SQL Server DBA.

The Force Awakens – Azure SQL Server for the on-prem DBA

Goals:

Explore the database offerings available in Azure
Gain a basic understanding of which SQL Server solution to use when
Develop a plan for harnessing the power of the cloud

Have you ever been asked what the cloud means for your database environment or wondered if Azure is a viable platform for a new system? If so, look no further!
This session begins with an overview of Azure and where SQL Server fits in among the other services of the cloud. It follows with key differences between SQL Server on-prem, SQL Server on a VM, Azure SQL Server and Azure SQL Server Managed Instance, as well as discuss some of the pros, cons, challenges and benefits of putting a database in the cloud in the first place.
If you are eager to explore the database offerings in Azure, gain a basic understanding of which toys to use when and develop a plan for harnessing the power of the cloud, then this session will provide the tools you need to step into a new world.

SQL Server hates you(?) – what the DBAs never told the developers

Goals:

Explore different default settings and their consequences for developers
Investigate why some harmless SQL can come with a hefty performance pricetag
Explain how different isolation levels affect function and performance

Have you had performance tank despite the code working fine in another environment? Maybe heard that some SQL is bad but not why? If so, this is the session for you!
This session will start with a walkthrough of some of the basic settings in SQL Server and how they affect you as a developer. It follows with key tips on what settings to change, why some code will wreak havoc on your performance and how isolation levels matter (and why NOLOCK can be an exceptionally bad idea!) The session is led by a 20-year DBA veteran who decided to try to help developers understand performance issues by seeing things from his perspective.
If you want to explore how default settings kill your performance, investigate why harmless SQL might not be quite so harmless and gain insight into how isolation levels affect function and performance, then this session will provide you with the tools to think outside the box and incorporate database engine knowledge into your developer prowess!

Boring is stable, stable is good – best practices in practice

Goals:

Explore my set of best practices
Understand the reasoning behind every best practice
Inspire the creation of your own best practices

Have you ever wondered why there are so many, sometimes contradictory, best practices for SQL Server on the internet? Have you considered creating your own but didn’t know where to begin? Then this is the session for you.
Everybody is talking about best practices, and like standards, most everybody has them. But why do they look like they do, and why would you use a specific set of “best practices” that someone has put together? This session goes through my set of best practices that I’ve accumulated over 20 years of DBA work, disassembles each and every one of them to see how they came about and discuss why I still use them – or don’t.
There are no such things as the “ultimate” best practices, but I aim to provide the attendee with as much food for thought as possible in order to let each and everyone decide on their own path forward. The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.

A brave new world – the SQL Server DBAs primer on Linux

Goals:

Explore what sets Linux and Windows apart and how this impacts the DBA
Gain a basic understanding of how to work with the Linux OS
Instill confidence to take on the challenge of running SQL Server on Linux

Have you started to wonder what Linux is and how it works, now that your favorite database can be run in it? Do you find the lack of GUIs daunting, and would like to gain an understanding of Linux from the relative safety of a session? Look no further!

With SQL Server suddenly available on Linux, the need for the DBA to have a basic grasp of that OS equally suddenly spiked. At the very least the SQL Server DBA will need to know what Linux is and why one would run SQL Server on it. This session will walk you through what Linux is and how it is different from windows from the perspective of a DBA. It follows with tips, tricks and demos to make the most of your shiny new toy and help you ensure that you can both talk the talk and walk the walk.

Stepping over to the other side is way easier said than done. This session will explore what set Linux and Windows apart and how this impacts you, the DBA, help you gain a basic understanding of the OS and how to work with it as well as instill confidence to take on the challenge of running SQL Server on Linux.

Azure machine learning for the absolute beginner

Goals:

Machine learning is one of the hottest trends on the market. According to the popular belief, machine learning will help you do everything from water your plants to running your multi-million dollar company. Some of the hype is true, much of it is false. But what IS machine learning – really? How can it be used? What questions can it answer? Har hard is it to get started?
Join Alexander for a session that will give you a thorough overview of what machine learning tools is available in Azure, how to actually find any use for machine learning, what preconceptions are wrong and how to get started on your first machine learning project.

Talk tech to me – improving your technical presentation skills

Goals:


Become a better speaker by improving your body language, learn to make better use of technical resources and make clearer demos.
Learn about body language, Learn how to better use technical resources, Learn how to better structure and deliver demos

Technical speakers are most often very good at the “technical” part of speaking but sometimes leave the “speaking” part with something to be desired. The body language may be stilted (or in some cases nonexistent), the voice can be a dull monotone or the font size can make the demos unreadable from more than five feet away. We have all been there – the technical content is great but the presenter just won’t cut it. This session is for anyone who either is or aspires to become a technical speaker, and I will go through tips and techniques for better understanding and using body language, how to use your voice for maximum benefit and finally give some pointers, ideas and software tips to make sure your demos are as clear and readable as possible.