Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 36
Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: February 04

Time: 1:30 PM - 2:30 PM

Room: Training 3

In SQL Server, the transaction log is the most important file in any database.  All changes to the data and schema are tracked in the transaction log.  Join me to learn how to read the transaction log, how to follow a transaction as is processes, and how SQL Server handles a transaction rollback.  You will also learn how to identify the resources and objects SQL Server accesses during the course of the transaction.  Finally, you will see how SQL Server processes transactions for In-Memory tables.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 04

Time: 9:45 AM - 10:45 AM

Room: Training 3

This session is all about hands-on experience and information sharing of SQL 2016 MultiD vs Tabular differences that are not articulated in common Internet blogs and MSDN comparison charts.  You will be seeing  VS examples of many-to-many, date calculation strategies, role playing dimensions, hierarchies and we'll be talking a lot about available properties.  We'll be covering storage and query engines, performance tuning and extended events.  If you are evaluating either of these SSAS tools for your BI project, come spend an hour digging into the detail which will help you make a more informed project decision.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: February 04

Time: 9:45 AM - 10:45 AM

Room: Training 5

The breadth of options available to data professionals today is staggering:  between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools.  This talk will walk you through data platform, data analysis, and data processing options.  We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies.  By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: February 04

Time: 8:30 AM - 9:30 AM

Room: Training 3

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 04

Time: 8:30 AM - 9:30 AM

Room: Auditorium

Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips, You will learn all latest and greatest features of Power BI.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 04

Time: 9:45 AM - 10:45 AM

Room: Training 2

Azure SQL Database provides an environment to quickly build SQL Server databases.  This allows for testing of new versions and functionality with minimal effort.  PowerShell provides cmdlets that create, configure and deploy an Azure SQL Database quickly and easily.  Additionally, cmdlets exist to tear the environment down once you are done with it,  Join me to learn more about the options available for scripting and automating the build of an Azure SQL Database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 04

Time: 2:45 PM - 3:45 PM

Room: Training 5

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:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 04

Time: 11:00 AM - 12:00 PM

Room: Training 1

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression. 

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 04

Time: 4:15 PM - 5:15 PM

Room: Training 5

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

 1. Quickly fine tune a SQL statement
 2.  Identify performance inhibitors to help avoid future performance issues
 3.  Recognize and understand how new SQL Server features can help improve query    
      performance
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 04

Time: 11:00 AM - 12:00 PM

Room: Auditorium

It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 04

Time: 11:00 AM - 12:15 PM

Room: Training 2

SQL Server 2016 introduced Query Store, a new feature which tracks query metrics and can be used for troubleshooting, testing, and proactively monitoring a workload.  Query Store also provides the ability to force a plan for particular query, which means you may no longer need to use those tricky plan guides.

In this session, we'll start with a quick review of how Query Store works.  Then we'll examine plan forcing in depth, including why a forced plan will fail and how plan forcing compares to using plan guides.  Expect a lot of demos as we investigate how Query Store can help you do more than just troubleshoot issues, but also manage query performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 04

Time: 2:45 PM - 3:45 PM

Room: Training 1

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 04

Time: 2:45 PM - 3:45 PM

Room: Auditorium

Since Extended Events are replacing Profiler, every DBA should know what they are and how to use them.  This session will cover the basics of Extended events as well as an introduction to the system_health session.  This session will give someone who has never used Extended events before the skills to start using them!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 04

Time: 9:45 AM - 10:45 AM

Room: Auditorium

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the various ways that we can apply advanced analytics by using the R programming language on top of SQL Server. We'll consider the advantages and capabilities of SQL Server R Services and look at how to set up a development environment. Along the way, we will discuss the data science workflow and consider some examples of advanced analytics that are commonly used.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 04

Time: 4:15 PM - 5:15 PM

Room: Auditorium

We hear it in every session and every webinar “…test…” regardless of it being upgrades, new code, performance tuning or any of a thousand changes.  Once we confirm nothing breaks., we don’t need to check anything else, nothing could possibly change the results, right?  What about load on the database(s) in question or the server as a whole?  In this session four readily available tools, distributed replay, Hammer DB, SQL Query Stress and oStress will be introduced.  The session will cover how to use the tools as well as which situations they shine in.  Once introductions are made, we will spend a little time with two of my favorites, HammerDB and SQL Query Stress.  Join me as we apply a little heat to our SQL Servers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 04

Time: 4:15 PM - 5:15 PM

Room: Training 4

The best defense is a good offense. Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be demonstrating how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 04

Time: 1:30 PM - 2:45 PM

Room: Auditorium

Most people don't like to speak in public and technical folks are certainly no exception.  Yet, you've got some ideas for a great presentation but just don't know how to go about putting it all together.  On top of that, how do you go about giving the presentation itself?  This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you want to relay.  We'll also discuss how to deal with issues that cause presenters stress to help you to make the process enjoyable and rewarding for all.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 04

Time: 1:30 PM - 2:45 PM

Room: Training 5

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 04

Time: 8:30 AM - 9:30 AM

Room: Training 1

With the significant improvements made to in-memory OLTP in SQL Server 2016, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors?  

In this session, we are going to take a look at in-memory tables, their best use cases as well as development best practices. We will also look at the changes to the indexing design for inMemory-based objects and how it differs from existing disk-based table indexing. Finally, we are going to cover how to build fast, scalable applications which utilize inMemory objects, as well as choosing the appropriate indexes for your inMemory objects to give you the performance boost that you have been expecting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 04

Time: 11:00 AM - 12:15 PM

Room: Training 4

Sessions Found: 36
SQLSaturday