Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 26
Big Data has moved beyond the hype and entered the mainstream as a tool for managing large and unstructured data sets, giving data architects more options for managing data. The Hadoop ecosystem has become the tool of choice and Microsoft has entered this arena with HDInsight in the cloud. For DBAs this means having a place to store data that can be accessed using a highly parallel framework. In this session you’ll see how to use the numerous tools available to store data in Hadoop, process it, manage it, and retrieve it. We’ll explore Sqoop and how its many options can be configured to import data by taking advantage of Hadoop’s massive parallelism. We will develop and run Map\Reduce code, with an emphasis on understanding what belongs in a mapper function versus what belongs in a reducer function, while demonstrating Hadoop Streaming with languages such as R and C#.  Finally, Hive will be shown to exhibit the use of a high-level query language in Hadoop for those who prefer SQL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
NoSQL

Level: Beginner

Session Code:

Date: June 06

Time: 2:20 PM - 3:20 PM

Room: Room5

As a DBA yourself, I’m sure you’ve encountered instances where the SQL Server has been running fine, there’ve been no changes for ages, everything is stable, there’s no exposure to the outside world, and the last time anyone updated or applied a patch to the server was in February 2004… …and then the world intruded, and all of a sudden you’ve been given a directive to “bring that system up to date!” Now what? You’re faced with upgrading not only the SQL Server, but the Windows server as well (and a bunch of other applications), because Microsoft has announced that ALL support for Windows Server 2003 will be going away (far away!) this summer! And some clever person upstairs decided that it would be A GOOD THING to have this SQL Server exposed to the outside…and has commissioned the web dev team to build a whole suite of apps that WILL MAKE THE COMPANY MILLIONS! Where to start…
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: June 06

Time: 1:00 PM - 2:00 PM

Room: Room3

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency? 

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Architecture

Level: Intermedia

Session Code:

Date: June 06

Time: 2:20 PM - 3:20 PM

Room: Room3

Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical).  Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 06

Time: 3:40 PM - 4:40 PM

Room: Room1

Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West.  We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task.  We will  go over some different modeling techniques around Normalized, Dimensional and Data Vault options.   And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast.  Yee-Haw!

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Architecture

Level: Beginner

Session Code:

Date: June 06

Time: 3:40 PM - 4:40 PM

Room: Room2

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: June 06

Time: 1:00 PM - 2:00 PM

Room: Room4

Most of the training we receive as SQL Server professionals has code developed for the purpose of demoing or providing training for a specific feature. I’ve developed my share of demo code and it serves it purpose. This session is different. I’ll quickly demo my company’s application (so you can get a sense of what it does), and then walk through many key portions of the actual T-SQL code showing you how the techniques I’ve used to make it production worthy with a focus on robustness, security, and performance. note: this session includes a LOT of dynamic SQL. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Advanced

Session Code:

Date: June 06

Time: 9:10 AM - 10:10 AM

Room: Room2

ETL may not be dead, there will always be use cases for it.  But if we can get sub-second query response time over petabytes of data, why do you need all that other stuff?  Come to this session to see a modern data pipeline.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: June 06

Time: 10:30 AM - 11:30 AM

Room: Room1

Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we've all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 06

Time: 10:30 AM - 11:30 AM

Room: Room4

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events.  Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years.  Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them.  Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more.  We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way.  You may never go back to Profiler again!
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 06

Time: 9:10 AM - 10:10 AM

Room: Room4

No question about it, Hadoop is here and enterprises large and small are starting to embrace it. The adoption rate of Hadoop is making some EDW professionals anxious about this technology replacing their tried and true relational data warehouse.  This is a worry that need not be had.

In this session, we'll go through several design patterns that show how Hadoop can augment an existing relational data warehoue, and show WHY we need both technologies to cover the broad spectrum of reporting an analytics.

This session is largely conceptual, although we will cover a few code examples to show how some of the Hadoop technologies work in conjunction with SQL Server as a data warehousing platform.
Speaker:

Session Type:
Regular Session

Track:
NoSQL

Level: Beginner

Session Code:

Date: June 06

Time: 9:10 AM - 10:10 AM

Room: Room5

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

Track:
BI

Level: Beginner

Session Code:

Date: June 06

Time: 2:20 PM - 3:20 PM

Room: Room1

Disk I/O can be a significant performance bottleneck for SQL Server. And when physical I/O is the suspected culprit, the first thought is to purchase more storage. But expensive hardware upgrades don’t necessarily ensure a faster database. So how do you determine how much I/O is contributing to poor performance? How can you assess the performance of a specific workload on different types of storage? And how do you decide which infrastructure is best for a specific storage solution?  

This presentation will cover :
The difference between latency, throughput, IOPS, and how they relate.
Performance characteristics of several storage solutions.
Techniques for analyzing storage subsystem performance.
How database design and infrastructure interact and impact performance and scalability.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: June 06

Time: 3:40 PM - 4:40 PM

Room: Room4

What is the state of SQL Server?  When is the next version coming?  What are the big success features in SQL Server 2014?  
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: June 06

Time: 12:00 AM - 1:00 AM

Room:

In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS.  This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration.  You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 06

Time: 2:20 PM - 3:20 PM

Room: Room4

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

Track:
Architecture

Level: Intermedia

Session Code:

Date: June 06

Time: 1:00 PM - 2:00 PM

Room: Room2

It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data?  In this session we'll investigate a real-world solution to this common BI problem.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: June 06

Time: 9:10 AM - 10:10 AM

Room: Room1

People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
NoSQL

Level: Intermedia

Session Code:

Date: June 06

Time: 10:30 AM - 11:30 AM

Room: Room5

Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do?  If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options. 
The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 06

Time: 10:30 AM - 11:30 AM

Room: Room3

Most DBA’s know you need to be doing some form of maintenance on your databases: Backups, index rebuilding\reorganization, update statistics, integrity checks, and system cleanup.  SQL Server offers some basic tasks to complete this needed maintenance. The session will cover setting up a maintenance plan including the tasks, schedules, and logging. From there, we will dive deeper into the basic task, find out what is going on behind the scene, and discuss when it is OK to use them and when you should create your own.  At the end of the session you will know how to create a maintenance plan, how to log results and keep a history of success or failures, when you should use what SQL Server has provided and when you should create your own plan.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 06

Time: 3:40 PM - 4:40 PM

Room: Room3

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