Build Schedule

Advanced Filters:
  • Track

    clear all
















  • Speaker


  • Level


  • Session Type

Sessions Found: 38
Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.
Speaker:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 20

Time: 3:00 PM - 4:10 PM

Room: Theory Room #3

This is a deep dive into data compression in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in busy production systems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 20

Time: 1:40 PM - 2:50 PM

Room: Theory Room #2

SQL Server 2016 introduces a new feature called Always Encrypted. This feature allows data to stay encrypted 100% of the time in transit to and from the server, can keep it encrypted at rest, and offloads the encrypt/decrypt operations off the server to be handled exclusively by the client. Always Encrypted can also be used with whole database encryption (TDE). In this presentation we will talk about what Always Encrypted is, how it is different from the encryption options currently available, and how database administrators can even be prevented from seeing the data! Demos will be done in both SQL Management Studio and in Visual Studio 2015.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 20

Time: 1:40 PM - 2:50 PM

Room: Theory Room #5

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 20

Time: 3:00 PM - 4:10 PM

Room: Theory Room #2

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 20

Time: 11:10 AM - 12:20 PM

Room: Theory Room #6

Critical path SQL will focus on recursive common table expressions (and other proprietary approaches, if time permits) on problem solving in finding minimum and maximums for common business problems like minimum/maximum manufacturing costs and leadtimes in BOM's and other hierarchical data structures where a tree traversal would be needed. AdventureWorks will be the primary database for demonstration purposes.
Speaker:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 20

Time: 4:20 PM - 5:30 PM

Room: Theory Room #3

Continuous Integration & Delivery isn’t a new concept.  Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up.  Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I'll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments.   We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.  
Speaker:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 20

Time: 1:40 PM - 2:50 PM

Room: Theory Room #6

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 20

Time: 4:20 PM - 5:30 PM

Room: Theory Room #5

The EXEC statement provides plenty of flexibility, and sp_executesql offers even more benefits on top of that. But both have their drawbacks, their nuances, and their impact on performance. After this session, you will know what to expect from the query processor when using these features in your code and how to get the most performance out of them.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
DEV

Level: Beginner

Session Code:

Date: February 20

Time: 8:30 AM - 9:40 AM

Room: Theory Room #6

Follow along as we adventure through the vastness that is Availability Groups in SQL Server.  In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
Speaker:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 20

Time: 8:30 AM - 9:40 AM

Room: Theory Room #4

HDInsight is the latest evolution of Hadoop on the Windows platform.  It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server.  This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology.  You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 20

Time: 9:50 AM - 11:00 AM

Room: Theory Room #7

Are you looking to understand what IaaS or PaaS really mean? Perhaps you are not sure of virtual, high available relational or NoSQL databases. Get started with the basics of managed services and platforms for running databases on AWS. Hear how to use managed relational databases such as MS SQL Server with minimal administration. Also discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 20

Time: 4:20 PM - 5:30 PM

Room: Theory Room #4

Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 20

Time: 8:30 AM - 9:40 AM

Room: Theory Room #5

An agile project to build the data warehouse is a natural way to handle model, process and rule changes caused by a better understanding of requirements, data, and data quality during a project.  And yet designing, building, changing and documenting a data warehouse is still a laborious exercise that makes agile difficult.  By using WhereScape's flagship RED data warehouse automation software to remove to automate the mechanics of building the data warehouse you can accelerate delivery cycles and get agile.  That’s the way the business wants to work with IT – and the way that data warehouse developers want to work with the data.  Come and see a demonstration of data warehouse design and build automation – developed in WhereScape RED and implemented in SQL Server. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: February 20

Time: 12:30 PM - 1:40 PM

Room: Theory Room #6

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.  This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too.  When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 20

Time: 9:50 AM - 11:00 AM

Room: Theory Room #6

In Memory OLTP is one of the most popular features of SQL Server 2014. Many BI professionals are finding memory optimized objects make excellent tools in the quiver of the ETL developer as well.  Attend this session to see how "hekaton", memory optimized objects, native stored procedures, and schema only designs can be applied to staging and transformations to achieve  incredible performance gains over traditional models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 20

Time: 11:10 AM - 12:20 PM

Room: Theory Room #4

Azure Machine Learning [ML] is a great tool for gathering more insight with your data, but how do you know if the models you are using are providing the best results? How do you apply modules customized to analyze your data? After this session you will have the answers to these questions, as well as the knowledge necessary to implement machine learning data analysis into your data environment.
Using Azure based SQL Server, attendees will learn rules which can be used to classify the data and the type of analysis desired by Azure ML.  Building upon this information, the best methods for determining which ML models to use will be shown.
This presentation will demo how to extend the flexibility of Azure ML by implementing custom analysis from other sources. Incorporating items created in R and SQL will show the expanded capabilities available outside of the existing ML components.  Lastly we will deploy the Azure ML solution and incorporate the results into our SQL Server Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: February 20

Time: 9:50 AM - 11:00 AM

Room: Theory Room #5

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your SSIS package development productivity to the next level. Creating template packages can add productivity to your SSIS development effort. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
In this session we will walk through various examples that will inspire you to make Biml your number one SQL Server Integration Services development tool. Learn how to use Biml scripts to create both staging tables and Integration Services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
In this session, you will learn:
* How to work with Biml and BimlScript
* Metadata options that can create robust Biml solutions
* Biml design methods that can work around some so the SQL Server Integration Services pain points.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 20

Time: 3:00 PM - 4:10 PM

Room: Theory Room #5

For many engineers, interpreting disk I/O is a black art.  Yet analyzing perfmon & virtual file stats is typically straightforward. This session provides authoritative, clear guidance on collecting & interpreting disk I/O metrics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 20

Time: 1:30 PM - 2:40 PM

Room: 2

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, how to access and manipulate data, install packages, create and use variables, use control flows and some basic graphing and statistical analysis. We will finish with a very brief introduction of how R integrates in Azure ML, Power BI and SQL Server.

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 to Data Science! 
Speaker:

Session Type:
Regular Session (60 minutes) (70 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 20

Time: 11:10 AM - 12:20 PM

Room: Theory Room #2

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