In this full-day seminar, you will gain core knowledge about how SQL Server works, along with a host of information covering memory usage, the optimizer, indexes, statistics, and table design.
Most importantly, you will be exposed to an elaborate and detailed tour of T-SQL patterns and anti-patterns, many of which will enlighten or surprise you. You will also learn about default settings to override, trace flags that can help query analysis, optimizing tempdb, and how to avoid “it worked on my machine” syndrome.
Packed with sample code, live demos, and even pop quizzes, you will leave the room armed with many new insights into making your design phase more robust, your queries more efficient, and making life easier for your DBAs, fellow developers, and end users.
Advanced data analytics does not live only in the realm of data scientists. The necessary tools now exist in SQL Server 2016 to perform advanced analytical analysis with R and Power BI. Starting with SQL Server 2017, Python can also be part of a SQL Server deployment solution, so we will review that as well. Attendees will see how to apply these techniques to analyze a database server.
- Learn how to code applications in R to provide data insight and data visualizations for use within SQL Server.
- Discover some of the new functionality of SQL Server 2017 by acquiring the knowledge of how to incorporate Python code
- Develop and understanding of some of the algorithms used in data science and how to apply them.
- Extend the functionality of SQL Server by integrating R code to provide insight into the performance of SQL Server.
- Understand different ways to visualize the results, including storing within SQL Server, creating SSRS reports and visualizing in Power BI.
- Introduction to Data Science concepts.
- Application of Data Science algorithms in R.
- SQL Server R Internals and Integration.
- Modifying SQL Server to optimally perform and monitor R Code.
The availability and storage landscape for SQL Server has changed in the past few years. Not only are the options and combinations for deploying SQL Server instances greater than in the past, but we are also moving towards a software defined world. There are many new capabilities both in SQL Server itself as well as in the underlying platform which can help you increase not only availability of your instances and databases, but some will also increase performance and give you more flexibility.
These features can be cornerstones of advanced SQL Server architectures which need to be planned and deployed correctly. If you want to stay ahead of the curve and take advantage of what is available – or get a glimpse of what is coming – you need to attend this full day session to learn about things like:
- Distributed Availability Groups
- Domain Independent Availability Groups
- In-place WSFC upgrades
- Scale Out File Server
- Storage Spaces Direct
- Storage Replica
- SQL Server v.Next on Linux and its availability story
- Quorum configuration for multi-site AGs and FCIs
- Tips, tricks, and gotchas not only for on premises, but also for virtualization and public cloud deployments
Outside of anything in v.Next, everything taught and demonstrated can be used right now. Register to take advantage of these new paradigms and incorporate them into your mission critical SQL Server architectures today. Note that this session assumes you know the basics of Windows Server Failover Clusters, Availability Groups, and Failover Cluster Instances and will not cover fundamentals of availability or storage.Allan Hirt Precon
If you have wanted your head to hurt with Power BI, this session is for you! You will learn parts of Power BI to help you take full advantage of the reports and usage in the service. From creating reports to deployment and maintaining fresh data. The debugger will also make an appearance!
During the pre-con, we will look at the following areas.
- M Syntax within Excel and Power BI Desktop
- Modeling and DAX
- How Power BI Premium fits in
- Data Refresh and Gateway usage
- Implementing Row-Level Security
- Embedded, Custom Visuals, and the APIs
What's a full day without time for your questions also!Adam Saxton Precon 400
You've heard a lot about PowerShell recently because a lot has changed. Now, you don't need to be a coder to get things done; you can lean on hundreds of community-created commands that solve many of the problems we all share.
In development and need a nightly refresh? Architecting and need to find duplicate indexes fast and easy? Putting on your BI hat and need quick importing and exporting of data? Join us and we'll supply a hands-on lab for your laptop where you can experience PowerShell’s realized potential, crafted by both Microsoft and the SQL community.
Whether you need a prepackaged solution or the building blocks to roll your own fix, you will leave with awesome tools to manage your most annoying problems. And maybe - hopefully - you'll even be confident enough to contribute your own solutions to share with the community.Chrissy Lemaire Klaas Vandenberghe Rob Sewell Precon