Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 41
Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need.
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 21

Time: 2:30 PM - 3:30 PM

Room: 203

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success.  Often times we focus on showing how smart we are instead of showing what a good team member we can be.  We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills?  We will explore innovative and fun ways in which to do just that!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 21

Time: 9:30 AM - 10:30 AM

Room: 202

This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to most any ETL/ETL scenarios.
The components used during this session:
- Biml
- BimlExpress
- BimlSnap On-line
are all available at no charge. In addition, attendees will receive:
- A complete 'SQL Server Metadata Manager' solution (front and back end)
- A fully functional SSIS Framework

Attend to see how Biml can revolutionize your SSIS development!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 21

Time: 12:00 PM - 1:00 PM

Room: 204

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft's Tim Chapman as he helps guide you while YOU make the choices in this interactive performance tuning adventure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: July 21

Time: 10:45 AM - 11:45 AM

Room: 205

So you've done traditional BI for some time, but now you and your company know it's time to dig into advanced analytics. The big question is, with so many data science platform options available, which one is the right one for us?

In this session we dive into the available platforms listed below and provide a brief summary, strengths and weaknesses, scale capabilities, and last but not least, pricing/licensing.
•	Microsoft R Open
•	Microsoft R Server
•	R and Python Services for SQL Server 2017
•	Azure Machine Learning Workbench
•	HDInsight (with Spark)
•	Microsoft Data Science VM

If you're looking to maximize and optimize your data science platform of choice, be sure to attend.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: July 21

Time: 1:15 PM - 2:15 PM

Room: 202

There are a lot of options for cloud databases out there from Microsoft and other vendors. In this session, you will learn about the various options that run SQL Server Amazon RDS, Azure SQL DB, and Azure Managed Instances, as well as a bit about other platforms like SQL Data Warehouse, Azure Data Lake, and Cosmos DB. You will learn how to decide which platform (or combination) is the best for your application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 21

Time: 8:15 AM - 9:15 AM

Room: 203

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - how to Access and Manipulate Data 
  - install and Manage Packages 
  - create and Use Variables 
  - control Flows 
  - functions 
  - basic Graphing and Statistical Analysis. 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 21

Time: 8:15 AM - 9:15 AM

Room: 201

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 21

Time: 12:00 PM - 1:00 PM

Room: 202

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: July 21

Time: 12:00 PM - 1:00 PM

Room: 203

Protecting our data from unauthorized access becomes more and more important all the time, however it has been difficult to ensure sensitive data is encrypted in SQL Server. The new Always Encrypted feature in SQL Server 2016 makes this much simpler for developers and DBAs with a framework for protecting data from the client, across networks, and inside of the database. This new feature allows for limiting access to the data, even from the DBAs and sysadmins that may control the database instance itself. Learn how to implement and use Always Encrypted in your applications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 21

Time: 8:15 AM - 9:15 AM

Room: 205

Extended Events were introduced in SQL Server 2008. With SQL 2014, 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: July 21

Time: 1:15 PM - 2:15 PM

Room: 201

Power BI is a powerful self-service analysis tool and is being adopted by organizations across the globe to quickly gain meaningful business insights. 
This session will cover the basics on creating compelling dashboards and guide you through the process of managing your company’s Power BI service, Power BI desktop, and mobile apps.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 21

Time: 10:45 AM - 11:45 AM

Room: 206

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 21

Time: 1:15 PM - 2:15 PM

Room: 203

Do you have large amounts of data which you want to leverage to predict the answers to difficult questions?  The seemingly new field of Machine Learning (ML) has been around for almost 60 years, with this exact goal in mind. 

In this session, you will be introduced to the fundamentals of ML, to get you started without requiring a mathematics background.  We will look at how to “frame” your data questions, as well as understanding the type of outputs ML can provide in responding with predictions.   Focus will be placed on the high-level overview of the ML process, and spend time on the simple steps of determining the “right” algorithm to use.  Tools used include Weka and Azure ML Studio, but the focus of the session is on fundamentals and the ML process, not specific toolsets.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 21

Time: 2:30 PM - 3:30 PM

Room: 202

You log into your email first thing in the morning and the rumors are confirmed; your company is expanding with branch offices in three new cities. As you read, the Big Boss drops by your cubicle and says that she needs an analysis of the real estate situation in all three cities. The analysis needs to include summaries of prices based on factors such as number bedrooms, number of bathrooms, and number of square feet. It should include lots of visualizations, be clear and easy to understand, and point out any interesting relationships that you've uncovered. And you need to have it done by 11:30 a.m.

We'll show you how to do this with real, publically available data from Redfin, using JMP statistical analysis and visualization software. We'll start with concatenation and subsetting, move on to data integrity, then to visualization, exploratory data analysis, and simple linear regression. We'll make plenty of charts and graphs with some summary statistics thrown in for good measure.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: July 21

Time: 1:15 PM - 2:15 PM

Room: 205

DevOps has revolutionised our ability to deliver customer value.

Updates aren’t held up in 6-month release cycles. We’ve automated tests and deployments collaboratively so we know updates work. A virtuous cycle of innovation and testing allows us to build better, more reliable products faster and cheaper.

However, while that’s great in theory, I’ve seen people screw up spectacularly when applying DevOps to relational databases.

In this cheerful session I’ll review the 16 most popular ways to screw up your ability to deliver database updates, resulting in painful, fragile deployments and expensive legacy databases that no-one likes to maintain.

A session for developers *and* DBAs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: July 21

Time: 9:30 AM - 10:30 AM

Room: 206

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 21

Time: 9:30 AM - 10:30 AM

Room: 205

Are you having a hard time enforcing or updating processes? Are you having trouble getting the business to see your vision of the future? Do you want to improvement process or tasks as your office? Your answer to these challenges may be to improve relationships with key departments like Development and Quality Assurance.

In this session, I will go over steps I took to improve relationships with other members of the IT department. I will also discuss how improving my relationships helped me accomplish my long-term goals.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 21

Time: 1:15 PM - 2:15 PM

Room: 206

Since the early days of SQL Server, it has been possible to use basic security measures to allow (and disallow) user access to any object in a database, and even limit access to a given column. A more difficult task has been to limit access to the individual rows in a table. This has made application development more complex because whereas most every user may have access to a table like HR.Employee, not every employee will have access to every employee's data. In this session I will cover several techniques to limit access to rows, from methods that have existed since early versions of SQL Server, to the new Row Level Security feature in SQL Server 2016. If time permits, an overview of Dynamic Data Masking will be included, since it is a related technology.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 21

Time: 2:30 PM - 3:30 PM

Room: 201

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities.  Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 21

Time: 2:30 PM - 3:30 PM

Room: 204

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