Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type






Sessions Found: 28
This session will provide an introduction to understanding and configuring  SQL Server backups. It will explain Data files, Transaction Log files, Recover Models, Backup Types as well as show multiple examples of Full, Differential and Transaction Log backups and restores. We will also cover the easiest way to schedule backups and to remove the old backup files.

You will also be shown answers to the following questions?
    What are the different types of Backups?
    What does the Recovery Model setting do?
    Are there conflicting backups happening? 
    Why are the log (ldf) files so big?
    How do I clear space from the log files? 
    How do I shrink the log files?

This is a good introduction, if you need to learn how to backup SQL, want to know more about backups or occasionally need to troubleshoot backup issues.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 2:40 PM - 3:40 PM

Room: Room 374

SQL Server has many build in T-SQL functions. This session will introduce you to 42 (or more) of them and explain how they can make your life easier. To name just a few TRANSLATE(REVERSE(DIFFERENCE(STATS_TIME(STRING_SPLIT(…)))).
Speaker:

Session Type:
Half Day Session (240 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 10

Time: 8:00 AM - 12:00 PM

Room: Room 114

Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper. 

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures or KPIs in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Advanced

Session Code:

Date: August 10

Time: 1:15 PM - 2:15 PM

Room: Room 374

Do you think of SQL Agent as a simple scheduling tool? I used to but over the years have learned how to get more out of SQL Agent than I once did. In this session I will show you how to use SQL Agent for notifications, how to create jobs that can re-run steps, jobs to restart jobs, jobs that start jobs on other servers along with a few other tricks. To close the session, I will demonstrate a SQL Agent job that can even clean up after itself.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 2:40 PM - 3:40 PM

Room: Room 373

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include:
-Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase
-Unique advantage of SQL Server Big Data Clusters
-Data Virtualization, Scale-out Data Marts, and Data Hub concepts
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 9:25 AM - 10:25 AM

Room: Room 373

R isn't well known for enterprise Web Applications.  However, recent advancements in the R ecosystem aim to change that.  In this presentation, I will introduce what you need to know for building a production-ready web-app in R.

Here are a few topics we'll address:
* Building and Managing Database Connections
* Error Handling & Input Validation
* Load Testing
* Performance Tuning and Optimization
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 10

Time: 2:40 PM - 3:40 PM

Room: Room 114

Every wonder if you could predict the outcome of the Superbowl? Or know the score of any game? The NFL is perfect for predictive analytics: it has a fixed time frame, large playing field, and rigorous rules.  These are characteristics we can only envy in the business world. With the power of machine learning Services in SQL Server 2017, we have the strength of statistical languages like R and Python right within the database engine. In this session, John will demonstrate the steps for successfully preparing the data, then run a regression model to predict the scores for a current week’s scheduled NFL games.  Want to know if your team is likely to win against the spread?  Wanna bet?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: August 10

Time: 9:25 AM - 10:25 AM

Room: Room 116

Companies everywhere are racing to implement AI and data science (a $169 billion industry by 2025). At the same time, companies are making a huge push toward the cloud. Microsoft Azure is leading the way in cloud data science. That is why, in early 2019, Microsoft released new certifications aimed at that skillset. This full day training will leave you knowledgeable about the data science and AI offerings on Azure. Plus, it will leave you prepared to apply data science techniques to your own projects. Finally,it will give you a jump start on preparing for the Azure Data Scientist Associate Exam.

Things to bring with you (besides a smile)
• A Microsoft account (Hotmail, live.com, outlook.com), a free account will suffice
• A laptop
• Some previous experience with programming or scripting (Any necessary math or machine learning background will be covered)

REGISTER HERE:
https://www.eventbrite.com/e/precons-sqlsaturday-sioux-falls-tickets-63432355884
Speaker:

Accompanying Materials:

No material found.

Session Type:
PreCon2 (240 minutes)

Track:
PreCon2

Level: Beginner

Session Code:

Date: August 09

Time: 9:00 AM - 1:00 PM

Room: Room 373

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 10

Time: 4:05 PM - 5:05 PM

Room: Room 114

Extended Events was introduced in SQL Server 2008. Every release since then, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 1:15 PM - 2:15 PM

Room: Room 373

This session will cover the basics for SQL server native tools to provide high availability to your databases.   Overview of AlwaysOn, Failover Cluster Instances, Mirroring, and Log Shipping.  Pros and cons for each will be covered and direct comparisons of the technologies.  After attending this session attendees should be able to know the questions to answer to select the proper HA solution for their environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 1:15 PM - 2:15 PM

Room: Room 116

Service Broker is a robust asynchronous programming model that provides reliable messaging between SQL Server instances. Making life easier for developers creating sophisticated applications to communicate between databases and servers. 

With focusing on your basic database to database asynchronous messaging to more advance messaging across multiple servers, we are positive you will walk away with new knowledge about Service Broker. And just as positive we will learn something new with you. As some of you may know, Service Broker never ceases to surprise.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 10

Time: 4:05 PM - 5:05 PM

Room: Room 373

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks.  This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.  We will also spend some time on how to properly read execution plans.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 8:00 AM - 9:00 AM

Room: Room 373

Power BI provides numerous features to enabling data interactivity. This session combines the more advanced interactive features to demonstrate a truly dynamic viewing experience. Together we will explore the use of specialized report pages, bookmarks, advanced DAX and more, to dynamically change chart axes and even visualization measures with a selection from a slicer. We will even see how to completely change the presentation on a Power BI tab with the single click of a button. Come see how to take your dashboards and reports from interactive to hyper-interactivity.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Advanced

Session Code:

Date: August 10

Time: 10:50 AM - 11:50 AM

Room: Room 374

There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature. Discover this highly auditable modeling technique used in international banking, manufacturing, insurance and many more industries.  Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy.  Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 10

Time: 1:15 PM - 2:15 PM

Room: Room 114

Session in the SQLStarter beginner track to introduce the business intelligence career.  Will discuss aspects of what this job entails and what day to day could look like in this career path.  We'll go over important skills and where to find training information.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 10

Time: 8:00 AM - 9:00 AM

Room: Room 116

Do you love Power Query?  Are you ready to take your skills to the next level?  Learning to write M code is easier than you think!  Writing M code can reduce maintenance and create a more dynamic solution for you and your users.  

In this session you will learn:
1.  Where you can write M code in PowerQuery.
2. The different types of objects you can use as variables in your code.
3. Different ways you can leverage variables to create a dynamic solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: August 10

Time: 8:00 AM - 9:00 AM

Room: Room 374

Are you a developer or analyst, creating Power BI reports that will be shared across teams or even your entire organization? Moving from "quick and dirty" deployments to production ready solutions intended for larger audiences means that you should already be thinking about performance, standardization and (most importantly) your end users.  Bring your laptop to follow along as well!

In this pre-con we will take a deep dive into the considerations and best practices when developing Power BI models, reports and dashboards to help you bridge the gap and make your solutions enterprise ready. Some of the topics we will cover are:
·        Power BI Desktop Configuration
·        Connection Reuse
·        Entity/Table Design
·        Cross Filters
·        Date Entities
·        Aggregates & Measures
Prerequisites
Beginner or intermediate Power BI development experience is required

REGISTER HERE:
https://www.eventbrite.com/e/precons-sqlsaturday-sioux-falls-tickets-63432355884
Speaker:

Accompanying Materials:

No material found.

Session Type:
PreCon1 (240 minutes)

Track:
PreCon1

Level: Beginner

Session Code:

Date: August 09

Time: 9:00 AM - 1:00 PM

Room: Room 374

How are my systems performing RIGHT NOW! That's the problem we had to solve for a client's real-time messaging solution. In this talk we'll discuss the problem domain, the important metrics we needed to collect, how we could collect them, serve them and display them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: August 10

Time: 9:25 AM - 10:25 AM

Room: Room 374

If you're like me, you've attended PowerShell sessions before. However, much of the *practical* usage of PS comes with rolling back your sleeves and digging into the nuances of syntax and how to get things done. We are going to focus specifically on using PowerShell within the SQL Server Agent to build out everyday jobs.

In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with the SQL Agent's flavor of PowerShell.

And then we'll spend the balance of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 10

Time: 10:50 AM - 11:50 AM

Room: Room 116

Sessions Found: 28
Back to Top cage-aids
cage-aids
cage-aids
cage-aids