Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 28
How do you go about making a program run a lot faster!  Like 100 times faster?   It’s difficult.  Microsoft tried in the Hekaton project, its in-memory tables feature of SQL 2014, and they got very close.  Inspired by that effort, this presentation looks at some recent cases where I’ve been able to achieve huge performance improvements in SQL Server code and how that happens.

When I work on SQL Server performance I emphasize that the first thing to think about is how to accomplish the task in a different way that will be much faster”.   Sometimes there’s a better algorithm.  Sometimes a different technology is more appropriate.  Sometimes it’s a combination of many changes that combine to create the desired outcome much, much faster. 

This presentation is illustrated with examples from my work and we'll look for common threads that might help us all.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Room 3

DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. "Storage is cheap" is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality.  Learn about the technical details behind this solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: Room 3

PowerShell is the hottest new Microsoft technology and you need to know it.  Assuming a basic knowledge of PowerShell, this session will focus on advanced topics like creating modules, advanced functions, creating custom PowerShell objects, creating a GUI for your scripts, application automation and  much more.  Many code examples will be examined to show you how to apply the concepts. This is the presentation to attend to step up your game.  
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Room 1

Tired of watching progress bars and waiting for servers to reboot while you follow run books on how to install SQL Server. This session teaches you how to automate the whole process of installing a Windows Server (Core Installation), Install SQL Server, setup Clustering and configure an AlwaysOn availability groups.

The whole process is presented as a life demo
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Room 1

This session is an introduction into the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Room 4

As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this vendor-free presentation will explain exactly what Big Data is and its benefits, including use cases.  We will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built.  We will talk about hybrid architectures that combine on-premise data with data in the cloud as well as relational data and non-relational (unstructured) data.  We will look at the benefits of MPP over SMP and how to integrate data from Internet of Things (IoT) devices.  You will learn what a modern data warehouse should look like and how the role of a Data Lake and Hadoop fit in.  The Big Data boom brings new challenges to those of you who define the architectures to create and consume business-critical data.  You will need guidance on the best solution for your data warehouse going forward.  This presentation will help to give you that guidance! 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: Room 2

Are you thinking about making a career change in 2016?  If so, this session is for you.  Tom will explain the three factors that are required for you to make a career change and get you hired in either a new contract or direct hire role.  

After this session, you will understand the mindset you need to make a change and be equipped to find the opportunity you want while increasing your compensation in a field you enjoy.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: December 12

Time: 3:30 PM - 4:30 PM

Room: Room 2

SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 12

Time: 10:15 AM - 11:15 AM

Room: Room 2

Power BI is quickly outpacing Excel as the one tool needed for self-service Business Intelligence. In this session we'll walk through Microsoft's exciting new Power BI SaaS offering, creating some Reports and Dashboards along the way. We'll explore some of the ready-made content packs for major SaaS providers such as Salesforce or Google Analytics, then create our own based on an Azure SQL Database. Next, we'll explore Power BI Desktop, a powerful new tool for creating advanced analytic data models and authoring reports using familiar experiences from the best of Excel's BI components.  Finally, we'll deploy the reports to Power BI, extend and share our Dashboard, and configure Automatic Data Refresh. All inside 90 minutes! Don't miss this session on the cutting edge of Microsoft's self-service Business Intelligence offering.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: December 12

Time: 1:15 PM - 2:45 PM

Room: Room 5

Access 2013 web apps are fully integrated with SQL Azure.  When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data using Access or other applications, including mobile.  In this session you will learn how to easily create an Access Web App with automatic views, view the online development environment and see a live, production web app in action.  We’ll also discuss different ways of extending web apps through the use of hybrid applications and integrating office web apps and the best ways to utilize Access Web Apps within your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: Room 4

Understanding how SQL Server stores your data can seem like a daunting task. In this session You'll learn how objects such as tables and indexes are stored in a data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map and GAM and SGAM pages. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: December 12

Time: 3:30 PM - 4:30 PM

Room: Room 5

Does only a small portion of your data change on a routine basis? Is index maintenance taking forever? Do users mostly focus only on a subset of data such as the current year, month or day? Do you want to delete or insert massive amount s of data with almost no blocking? Well, step right up because data partitioning can do all this and more! We will take a look at the different option for partitioning, the pros and cons and how to implement them in SQL.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Room 2

SQL Server Integrations Services is a robust product, with lots of different options available to the ETL developer. For someone new to SSIS, it can be daunting to be assigned a project to extract data from a source, transform it and then load it into its intended destination. What components do I use? Why pick one over another? Even if you are new to SSIS, it's good to have an understanding of what's going on under the hood when a package is run. Come to this session to learn what non-blocking, semi-blocking and fully-blocking transformations are. We'll explore how SSIS creates and manages memory buffers. You'll leave with a better understanding of how certain tasks and transformations can affect your package’s performance. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 12

Time: 3:30 PM - 4:30 PM

Room: Room 1

There is no better way to understand how TSQL is executing than through the execution plan.  We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance.  Be sure to bring your safety helmet!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Room 2

You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you're only seeing 200 MB/s?

This session will dive into how to optimise your File and Filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customer's table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include:
- Layout for OLTP
- Data Warehousing Fast Track Style
- Data Warehousing on a SAN
- Get data into your SSAS cubes faster (ProcessData)
- Hidden options and “go faster” buttons 
- How to maximise performance in enterprise edition and master read ahead
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 12

Time: 3:30 PM - 4:30 PM

Room: Room 3

SQL 2014 and 2016 have significant changes to allow seamless hybrid cloud scenarios.  This session will talk about "why cloud" as well as the options available with backup, deployment, and new development scenarios with SQL 2014, 2016, and Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Room 4

So you know the difference between a clustered and a nonclustered index.  I won't review it again - I promise.  This session will focus on expanding your understanding of indexes and what you can use them for. We will look at the internals of how they are structured, included columns, filtered indexes and indexed views. We will explore how to use indexes to enforce contraints beyond just simple uniqueness.  Earn your SQL Black belt with this fun and informative session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 12

Time: 10:15 AM - 11:15 AM

Room: Room 5

As BI professionals we are straddled with multiple issues pertaining to Copy Data. 
We will discuss what 'Copy Data' is along with various terminologies that go with it.

The common issues are:
1. Space
2. Network Bandwidth 
3. Time
4. Security
5. Obfuscation/Masking
6. Which Server does this go to?
7. Onward protection of Copy Data

In this session we will study the issues above and see how we can avoid these issues. We will examine what technologies/products are available that help us mitigate such a massive problem. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 12

Time: 3:30 PM - 4:30 PM

Room: Room 4

Microsoft just released The Power Business Intelligence Desktop Designer.  Learn how X-Velocity uses super compression to query data faster than ever.  See how Power Query can access virtually any data anywhere turning it into business information.  Discover how disparate data can be conceptualized into a single business view.  New visualization technology brings all this together to see your business like never before.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Room 5

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Room 6

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