Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 33
Machine Learning is certainly a hot topic these days.  For example, Microsoft is all-in in its company transformation from "a PC on every desktop" to "deep learning in every software".  There are tons of product offerings in and out of the Microsoft stack and cloud and it can be a bit daunting to separate all of the noise from the signal.  In this session, we are going to look at the fundamentals of machine learning - the building blocks of Deep Learning, Artificial Intelligence, and Cognitive Apps.

Some familiarity of computing programming, statistics, and manipulating tabular data will help you get the most out of this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: March 11

Time: 9:45 AM - 10:45 AM

Room: 116

Are you a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you're considering AlwaysOn Availability Groups? This session is for you! I'll cover the pros and cons of four typical configurations of AlwaysOn Availability Groups: stand-alone instances, fail-over cluster instances, multi-subnet configurations, and disaster-recovery-on-the-cheap. I'll also discuss read-only routing, and implications and limitations of the Availability Group Listener. In addition, you'll learn why you should be using Windows Server 2012 R2 or above for your Windows clusters. Join me to learn which configuration options you should choose for your Availability Group.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 11

Time: 11:00 AM - 12:00 PM

Room: 114

SharePoint Server uses SQL databases but not like a convention relational database.  This session looks at some of the differences between SharePoint databases and default settings.   What kinds of maintenance jobs to run and why its not a good idea to tweak the indexes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 9:45 AM - 10:45 AM

Room: 114

We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 11

Time: 11:00 AM - 12:00 PM

Room: 222

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 11

Time: 11:00 AM - 12:00 PM

Room: 220

Azure Machine Learning enables far more than supervised 2-class classifications and continuous value predictions. Azure ML clusters unsupervised data. Azure ML analyzes free form text for entity recognition, sentiment analysis, or topic detection. Azure ML even provides Jupyter Notebooks with fully functional R and Python environments. This sessions demonstrates some of these capabilities to help you solve some of your business problem.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: March 11

Time: 2:30 PM - 3:30 PM

Room: 222

Join us for a discussion of strategies and architecture options for implementing a modern data warehousing environment.  We will explore advantages of augmenting an existing data warehouse investment with a data lake, and ideas for organizing the data lake for optimal data retrieval. We will also look at situations when federated queries are appropriate for employing data virtualization, and how federated queries work with SQL Server, Azure SQL DW, Azure Data Lake, and/or Azure Blob Storage. This is an intermediate session suitable for attendees who are familiar with data warehousing fundamentals.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 11

Time: 1:15 PM - 2:15 PM

Room: 217

Embed power BI reports in asp .net and JavaScript based apps using Portal and embedded Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 11

Time: 8:30 AM - 9:30 AM

Room: 217

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: March 11

Time: 8:30 AM - 9:30 AM

Room: 222

If you do not have enough harddisk space and do not want buy more space, one way to get more space is compress the tables and also do some house keeping.

I am going use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles.
And in the final I will defragment the indexes and update the statistics, since shrink datafile is not fragmentation aware task.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 3:45 PM - 4:45 PM

Room: 222

You are a data analyst by trade. Your SQL skills are likely used to write research queries, do quality control for the query results, and churning out reports. However, you're now concerned with loading and manipulating data in the database. You're now asked to write statements that don't start with SELECT. In short, you're becoming a SQL developer.

This session will provide you with some high-level essential resources, from additional T-SQL query operators to SQL Server Data Tools and data modeling knowledge to warehousing basics, to help you navigate this uncharted territory...coming from a speaker who has been in the same position. You will come out of the session eager to use these resources to moonlight as or transition to a developer in the SQL Server space, ideally blending this developing skill set with your analyst skill set to create a well-rounded data professional!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 11

Time: 11:00 AM - 12:00 PM

Room: 111

You've decided to start using Biml to make your integration services packages. Congratulations! 

Now, you're looking at data sources other than SQL Server. How do you automate package development for these flat files, Excel Files, and other databases?  In this session, I'll share some of the techniques I've used to deal with these second-class sources. I'll be walking you through C# code.  Don't worry, I'm not a real programmer, so the code isn't the most complex, but it does solve the need.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: March 11

Time: 2:30 PM - 3:30 PM

Room: 220

Azure SQL DB has had Row Level Security and Dynamic Data Masking for a while now, SQL Server 2016 brings that on-premises. But just how can you use it, what changes do you need to make to your model to get the most from it?

These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.

In this session we will look at how you can get the most out of these features and retain the performance of your system.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 11

Time: 9:45 AM - 10:45 AM

Room: 111

Often enough we need to grant higher-level than ideal permissions to a Login or Role that are necessary to perform a task. For example, someone needs to start a SQL Agent job without being able to edit any jobs. Or, a task needs data from one of the DMVs that requires the "VIEW SERVER STATE" permission, but you don't want the user to see everything that is made available by that permission. When ownership-chaining doesn't work, the common solution is to use EXECUTE AS (i.e. Impersonation). Sometimes this works, but cross-DB tasks often require enabling cross-DB ownership chaining and/or TRUSTWORTHY, which are security risks.

Module Signing is more flexible and more secure, but requires a Certificate or Asymmetric Key. Those can be confusing to work with, and the security mechanism isn't intuitive.

Come learn how to have more secure, granular control over permissions that covers cross-DB tasks and Dynamic SQL. See what signing can do, understand how certificates work, and rejoice.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 11

Time: 2:30 PM - 3:30 PM

Room: 111

So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups.  We will discuss what metrics to look at, what they mean, and what you need to alert on.  You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.  This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 2:30 PM - 3:30 PM

Room: 114

With the release of SQL Server 2016, Temporal tables are a new way to track changes within your tables.  This  session will walk you through moving from Change Tracking/Change Data Capture to Temporal tables and what advantages Temporal Tables has for your database and application.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 11

Time: 3:45 PM - 4:45 PM

Room: 114

PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro's use to automate their database activities and beyond, for both DBA's and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with with clicks can be automated.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 11

Time: 8:30 AM - 9:30 AM

Room: 114

SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 1:15 PM - 2:15 PM

Room: 222

Power BI is the latest and greatest BI delivery service from Microsoft. This session will help you understand the concepts and DAX functions needed to create dynamic models for either internal use for your own company, or for a multi-tenant deployment. Power BI Desktop models and Tabular models will be discusses as we look at some common business scenarios for securing you Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 11

Time: 11:00 AM - 12:00 PM

Room: 217

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 11

Time: 1:15 PM - 2:15 PM

Room: 220

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