-
Workshop: Cloud Ready - Preparing Yourself for Azure SQL Databases
This full day session will bring you up to speed on Microsoft’s implementation of a cloud based database solution known as Windows Azure SQL Database and the many facets that this data tier encompasses.
-
Workshop: Big Data and NoSQL for Database and BI Pros - Intermediate
Learn new skills that are in strong demand in the BI/BA world and actually understand what you learn.
-
MDS in Practice: An Integrated Approach
This session will discuss how MDS fits in the overall EIM architecture within your organization including real-world strategies for integrating (cleansing, matching and loading) Master Data into MDS and for making it available organization-wide.
-
SQL Server Query Performance Tuning: A 12-Step Process
In this session, you will learn the 12 steps of SQL Server performance tuning.
-
O, There's My Data, OData for Data Guys
In this session Steve will explain what OData is and what tools are involved.
-
Managing SQL Server in the Enterprise
Join Chad as he shares how to achieve consistency and minimize overhead using Central Management Server.
-
Utilizing Knowledge with Data Quality Services in SQL Server 2012
In this session, we will be looking at what it takes to get DQS up and running in your environment, how to set up Knowledge Bases, and how to utilize the system with tools like SSIS and Master Data Services.
-
Troubleshoot SQL Server Performance Issues using Wait Statistics
In this session, you will learn how to use SQL Server wait statistics to troubleshoot performance problems.
-
Designing and Managing a SQL Server Replication Topology
In this session, Chad will explain everything you need to know about designing and managing SQL Server replication.
-
A Window into Your Data Using SQL Window Functions
If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions.
-
Implementing Auditing in SQL Server 2012
In this session, you'll explore the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
-
What's New in SQL Server Integration Services 2012
Join Kevin as he shows you all the new features in SQL Server Integration Services 2012.
-
Architecting a SQL Server AlwaysOn Availability Groups Topology
This session will explain how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements.
-
SQL Server 2012 Columnstore Index
In this session, you will learn about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it.
-
Column Level Encryption in SQL Server
In this session, you'll learn how to use T-SQL to natively encrypt data in a SQL Server database.
-
Performance Tuning When It Isn't Your Database
Join Don as he shares how you can safely tune performance of a database (that doesn't belong to you).
-
Fundamentals of SQL Server AlwaysOn Availability Groups
In this session, we will look at the underlying concepts behind AlwaysOn Availability Groups – how it works under-the-covers and how you can leverage this information to efficiently design a highly available database.
-
The Transaction Log and How It Affects High Availability and Disaster Recovery
In this session, you will learn everything you need to know abou the SQL Server Transaction Log and how it affects High Availability and Disaster Recovery.
-
Virtualizing SQL Server (Yes, You Can)
In this session, you will learn some tips and tricks when virtualizing SQL Server.
-
SSAS 911 -The Field Medics Guide to Performance Tuning Analysis Services
This session uses field-tested techniques to demonstrate how you can use familiar tools to dig into Analysis Services processing and query handling to identify bottlenecks, isolate issues while understanding how and why they occur and what needs to be done to resolve or fix them.
-
The Absolute Beginner's Guide to Windows Azure SQL Database
This session is for the Windows Azure SQL Database beginner. Kevin will explain how to create an Azure account and how to create/manage Azure databases.
-
Big Data 101 with HDInsight
Learn how developers with relational database skills can make the jump into this exciting and opportunity-filled area.
-
Planning and Configuring SQL and SharePoint 2013 Business Intelligence (PowerPivot and Power View)
In this session you will learn how to plan and configure SQL and SharePoint 2013 Business Intelligence.
-
Ancient Problems and Modern Solutions - Troubleshooting CPU
In this session, Pinal will show you some advanced tips/tricks for performance tuning and troubleshooting.
-
Excel: An Analytics Superhub
The ability to do serious, sophisticated analytics in Excel is here, right now - come learn more.
-
Troubleshooting and Monitoring Windows Azure SQL Databases
In this session you will learn how to troubleshoot issues and monitor query performance.
-
Implementing a Tabular Data Model with Microsoft PowerPivot and Analysis Services
In this session, you'll learn how to implement a Tabular Data Model with Microsoft PowerPivot and Analysis Services.
-
Inside the Query Optimizer
Join Bradley as he shows you how to make your queries run faster using the Query Optimizer.
-
Exploring Data with Data Explorer
In this session you will explore Data using Data Explorer.
-
Migrating to Windows Azure SQL Database
In this session you will learn when to migrate applications to Windows Azure SQL Database, the options you have available and how to troubleshoot common errors.
-
Integrating Reporting Services with SharePoint
In this session you'll learn the necessary integration/configuration steps for integrating SSRS 2008R2/SSRS 2012 with SharePoint 2010/2013, as well as deploying reports to a SharePoint location.
-
Into the Wild....Taming Unstructured Data with Semantic Search
This session will dive into the new FileTable and Statistical Semantic Search features.
-
Database Performance Tricks Every SharePoint Admin Must Know
In this session, Pinal will share some tips/tricks on how to optimize your server's performance using practically no SQL coding at all.
-
Through Gardens Overgrown: PowerPivot to Analysis Services 2012 Tabular
In this session, Bill will provide an overview of the steps required to "upgrade" an Excel PowerPivot model to a SSAS 2012 Tabular model using SQL Server Data Tools (SSDT).
-
Near Unlimited Scalability with SQL Azure Federations
In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, what developers need to know, and show you real world solutions using SQL Azure Federations to overcome difficult scenarios.
-
Using PowerShell to Quickly Deploy New SQL Server Instances
In this session, you'll learn how to automate the SQL Server install and configure/deploy standard objects using PowerShell.
-
An Overview of PowerPivot for Excel
This session will provide an overview of the primary features of PowerPivot.
-
Dealing with Errors in SSIS 2012
In this session, David will cover how you can identify errors that occur within SSIS 2012 and how to handle them dynamically and proactively.
-
SQL Server Tracing for Developers
This session explains how developers can resolve issues using tools available for tracing and information on how to access those tools.
-
"What Did I Do?" T-SQL Worst Practices
In this demo-oriented session, you will see some common T-SQL mistakes and how to avoid them.
-
DBA Task Automation: Unleash the PowerShell Hero in You!
In this session, Michael will show you how to maximize your efficiency using PowerShell for process automation.
-
Securing SSAS Data Without Tying Yourself in Knots
In this session you'll learn the different methods of securing data in your cube.
-
HSQL Server 2014 "Hekaton" (a.k.a. In-Memory OLTP) Deep Dive
In this session, Bradley will dive-deep on project "Hekaton" and explain all everything you need to know about this new technology.
-
Programming the T-SQL Enhancements in SQL Server 2012
In this session, Lenni will guide you through the T-SQL enhancements in the latest release of SQL Server.
-
Add It Up: Analysis Services Aggregations
This session explains what aggregations are and how they work.
-
The Creepy DBA, How to Stalk Your Users
Join Jason as he shows you how to use SQL Server to monitor and track user activity.
-
SQL Server 2014: A First Look at Whats New!
In this session, Bradley will guide you through the new features of SQL Server 2014.
-
Everything You Never Wanted to Know About Indexes, but Have to Know Anyway
In this session, Don explains everything you need to know about SQL Server indexes.
-
SQL Server 2012 Enterprise Features That Every Business Should Know
In this session you will learn the new features of SQL Server Enterprise and how/why you should use them.
-
Introducing SQL Server Data Tools
In this session, you will learn the how to use the new SQL Server Data Tools (SSDT).
-
Analysis Services 2012 End-to-End
This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more.
-
Workshop: SQL Server for Developers
This full-day workshop will get you up to speed on powerful new features in SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.
-
Workshop: SQL Server Maintenance and PTO Crash Course
Gain the background information you'll need to really leverage other courses at the conference!
-
Workshop: The Data Warehousing Process in a Day - Design, Build, and Deliver
This full-day session walks through the entire process of data warehousing.