We are thrilled to welcome five (5) distinguished industry experts delivering four (4)Pre-Cons this year!!
Thomas LeBlanc and Kevin Hill, who will each be hosting FULL DAY pre-cons this year
Sean & Jennifer McCown and Rick Lowe, who will each be presenting HALF DAY pre-cons.
Come attend an amazing in-depth day of training, the day before SQL Saturday!
- If you register for a pre-con: you must still register to attend SQL Saturday.
- If you register for a pre-con and are on the SQL Saturday wait-list: please e-mail a copy of your pre-con registration receipt to firstname.lastname@example.org.
Thomas LeBlanc presents: Power BI On-Premise in a Day
This day long session will concentrate on what currently can be done On-Premise with Power BI. Time will be spent on connecting to various data sources. Data modeling will include inside on Power BI and using a Tabular Model for enterprise modeling. Measures will be created to show the power of the DAX language/functions and expanded with Time Intelligence for impressing data consumers in an organization. Data modeling will show attendees why a majority of time is spent on data structure, importing and cleansing data. The visuals are the cool stuff, but not a lot of time has to be spent here if the data is well structured. But, we will still show canned visuals, filters, custom visuals in addition to R Scripts. The formatting and interaction between visuals and filters will complete the dashboard look to the Power BI report. The last function is to show how to use in the new Power BI Report Server. We might even see a dashboard with the Mobile Report tool (DataZen).
Kevin Hill Presents: DBA Fundamentals - give yourself a solid SQL Foundation!
This class is designed for New or Non-DBAs struggling with SQL admin tasks, and having to Google things daily. I will teach you SQL Server fundamentals so that you will have confidence in:
- What makes up a SQL Server
- How a database is structured
- How to install and what to look out for
- Finding what you need in Management Studio
- SQL Security Basics
- How to create and manage backups
- How to create a database
- Basic performance troubleshooting
- Picking a Disaster Recovery option for your environment
These are taught from a foundational standpoint, in simple to understand terms so that you can build on them with confidence. My teaching is heavy on interaction, with examples from years of experience/mistakes. There will be a mix of slides and demos. I'll skip many advanced features that are out of scope of a beginner class, as I don't want your head to explode! Join me for the day and you will walk out with a strong grasp of SQL Admin basics!
Sean & Jennifer McCown Present: Beginning Programming with Powershell (Half-Day)
Have you ever wanted to learn how to code, but you don’t think you have enough knowledge to jump into a class? In this half-day class we’re going to start from scratch and teach you the basics you need to know to begin your coding career. By the time we’re finished, you’ll be able to understand the basic concepts, and do a lot more in code than you would expect.
This course is for those who are completely new to coding and want to get started. It is not necessarily for those with coding experience, and just want to learn PowerShell. If you have experience, you’re welcome to come because you will learn the basics of PowerShell, but some of the beginning concepts may leave you answering work email. So whether you’re strictly an admin, or a business person, manager, or any other field, if you’ve got no experience coding, then this course is for you. Your coding career starts today.
Rick Lowe presents: What to Do Instead of ... Query Hints and Entity Framework (Half-Day)
Most database developers have been told at some point that using the NOLOCK hint is dangerous ... and yet many source control repositories are stuffed to the gills with NOLOCK. Why? Most likely because blocking is a real problem and NOLOCK does often help reduce blocking. If we accept that NOLOCK is bad then what strategies should be used instead to reduce blocking? It can be extremely difficult (impossible?) to find a DBA that is excited about supporting LINQ to Entities (or other object relational mapper) workloads. And yet LINQ is still pretty frequently used. Why? Most likely because non-ORM alternatives such as ADO.Net are a lot more work for the developers. Is this a hopeless conflict, or can deloper teams do things to make DBA lives less painful when using LINQ? If you’ve ever been frustrated by the feeling you’re told what not to do, without positive guidance on alternatives, this half day session may be for you.