| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 00:00:00 | Bradley Ball | SIOS Sound Stage | Inside the Query Optimizer |
| 00:00:00 | Brandon Leach | SIOS Sound Stage | Treating Tables Like Legos, Partitioning Basics |
| 00:00:00 | Cherie Sheriff | Dell Hall of Fame | The Science of Data Forensics |
| 00:00:00 | Daniel Glenn | the Profisee Experience | Tuning SQL Server for SharePoint |
| 00:00:00 | Dave Mattingly | Dell Hall of Fame | Database: The Motion Picture |
| 00:00:00 | David Maxwell | Amazon Arena | DBA 911 - Database Corruption |
| 00:00:00 | Dan Evans | Microsoft Music Magic | Self-Service BI with Big Data |
| 00:00:00 | Ed Watson | Cisco Solid Gold | Backup Strategies are for Losers! |
| 00:00:00 | Eric Nichols | Microsoft Music Magic | Data Warehouse Architectures |
| 00:00:00 | Eddie Wuerch | Microsoft Music Magic | What is a Latch, and Why Should I Care? |
| 00:00:00 | Frank Cicalese | Cisco Solid Gold | What Happens When SQL Server 2014 Meets Cisco UCS? Better Business Intelligence. |
| 00:00:00 | Gene Webb | the Profisee Experience | Learn How To Build A Golden Record for Any Subject Over Lunch! |
| 00:00:00 | Geoff Hiten | the Profisee Experience | Cloudy with a Chance of Data |
| 00:00:00 | Hope Foley | the Profisee Experience | Spatial Data - Looking Outside the Map |
| 00:00:00 | Janis Griffin | the Ryman | Introduction to Wait Types and Response Time Analysis |
| 00:00:00 | JD Wade | the Ryman | What SQL DBAs need to know about SharePoint |
| 00:00:00 | Joseph D'Antoni | Dell Hall of Fame | Building Perfect SQL Servers, Every Time |
| 00:00:00 | Joseph D'Antoni | the Ryman | Who Moved My Tuple--Columnstore Indexes in SQL Server 2014. |
| 00:00:00 | Jeff Smith | Amazon Arena | Oracle Tools in a SQL Server World? |
| 00:00:00 | Joe Webb | the Ryman | The Top Ten Mistakes that New Leaders Make |
| 00:00:00 | Jon Boulineau | Amazon Arena | Continuous Integration with SQL Server Data Tools |
| 00:00:00 | Richie Rump | Amazon Arena | The Quest to Find Bad Data With Data Profiling |
| 00:00:00 | Josh Luedeman | Pyramid Cafe | GET UP AND GO: BIG DATA AUTOMATION USING HDINSIGHT |
| 00:00:00 | Kevin Kline | the Ryman | Convince Me – Persuasion Techniques That Get Things Done |
| 00:00:00 | Kathi Kellenberger | Dell Hall of Fame | T-SQL Window Function Performance |
| 00:00:00 | Kevin Kline | Microsoft Music Magic | Ten Things Every SQL Developer Should Know |
| 00:00:00 | Gareth Swanepoel | the Profisee Experience | A practical guide to Windows Azure SQL Database for the DBA |
| 00:00:00 | miguel Cebollero | Amazon Arena | SQL Server 2014 In-Memory Programming |
| 00:00:00 | Mike Lawell | Cisco Solid Gold | Execution Plans for Mere Mortals |
| 00:00:00 | Denny Cherry | SIOS Sound Stage | Table Indexing for the .NET Developer |
| 00:00:00 | Michael Reed | Cisco Solid Gold | Data Mining with Excel 2013 |
| 00:00:00 | Dr. Arisoa Randrianasolo and Dr. Eddy Borera | the Profisee Experience | How to Write Awful SQL Queries (And Drive Your DBA Insane) |
| 00:00:00 | Paco Gonzalez | Pyramid Cafe | Big Data Mining with SSAS, Azure Machine Learning Mahout |
| 00:00:00 | Randy Knight | Cisco Solid Gold | Understanding the SQL Server Transaction Log |
| 00:00:00 | Brian Davis | SIOS Sound Stage | Getting Started with Hekaton (In-Memory OLTP) |
| 00:00:00 | Robert Verell | Microsoft Music Magic | Getting Started With SQL Server Replication |
| 00:00:00 | Rob Volk | Dell Hall of Fame | Revenge: The SQL! - Director's Cut |
| 00:00:00 | Russel Loski | Cisco Solid Gold | Introduction to BIML and BIMLScript |
| 00:00:00 | Bonnie Donovan | Amazon Arena | Running SQL Server in the AWS Cloud |
| 00:00:00 | Stacia Varga | Microsoft Music Magic | Building a BI Solution in the Cloud |
| 00:00:00 | Stacia Varga | SIOS Sound Stage | Understanding BI Security Best Practices |
| 00:00:00 | Andy Yun | Cisco Solid Gold | Every Byte Counts: Why Your Data Type Choices Matter |
| 00:00:00 | Stuart Ainsworth | the Ryman | The Agile DBA: Managing your To-Do List |
| 00:00:00 | Tim Radney | Amazon Arena | Know Backups and Know Recovery |
| 00:00:00 | Wendy Pastrick | the Ryman | Women of Tech talk Trends, Passions, and Goals |
| 00:00:00 | Wendy Pastrick | Pyramid Cafe | SQL Server in Azure |
| 00:00:00 | Naomi Williams | Pyramid Cafe | SQL Server Internals |
| 00:00:00 | Mark Tabladillo | Pyramid Cafe | Primer on Power BI |
| 00:00:00 | Adam Belebczuk | SIOS Sound Stage | Introduction to AlwaysOn Availability Groups |
| 00:00:00 | Robert Cain | Pyramid Cafe | So you think MDX is hard? |
| 00:00:00 | Audrey Hammonds | Microsoft Music Magic | The Data Warehouse is Dead! Long Live the Data Warehouse! |
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: SIOS Sound Stage
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: SIOS Sound Stage
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Dell Hall of Fame
This session will go over auditing concerns and how to develop your Business Intelligence and database systems to enable accurate regulatory and internal auditing. It will cover some of the basics in auditing concerns on your databases and what one can do to ensure that they meet all of those concerns. It will also cover ways to protect your databases and data warehouses on SQL Server, though these practices can be adapted for other database systems as well.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Profisee Experience
Some of the topics covered will include: the configuration steps and settings needed for SQL Server to properly host SharePoint databases, database size considerations, the SQL permissions your SharePoint administrators REALLY need, and why SharePoint databases have a GUID in their name (and how to avoid them!).
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Dell Hall of Fame
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Profisee Experience
• Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? • Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? • Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting • Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Profisee Experience
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Profisee Experience
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Dell Hall of Fame
By default, SQL Server does not install with best practices for every environment. In this session, we will discuss the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. We will talk about lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers.
You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Data Warehouse workloads can be very large and taxing on your database server. With the modern demands of real-time analytics against growing volumes of data this challenge continues. When columnstore indexes and batch mode query processing were introduced in SQL Server 2012 were a performance game changer. In the 2012 implementation of columnstore, direct updating and inserting of data was not supported and other restrictions, such as data types limited the use of the feature. SQL 2014 removes those limitations—you can use a columnstore index as a clustered index, and more importantly directly perform DML against the index. Also, more query operators support batch mode, which means more of your queries can see performance benefits. You will understand the changes for 2014—and how having updateable columnstore indexes may cause changes to your process design. You will see the power of columnstore indexes in analytics, their limits, and how to include them into your system design.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
Oracle SQL Developer Data Modeler is a design tool that supports SQL Server. Oracle SQL Developer is a database IDE that allows for JDBC connections to SQL Server. It also has a T-SQL to Oracle SQL PLSQL translator.
In this session, Oracle SQL Developer Product Manager Jeff Smith will give an overview of both tools and show a few use cases for the SQL Server professional.
By the way, all of this stuff is free. This may be your only chance to see a session with no sales pitch from your favorite vendor.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
The legendary adventurer is on the quest of a lifetime. He's found a database that holds the locations of the world's greatest relics, but there's a problem. No, it's not snakes. The database was written using an ancient format and it may hold incorrect data. Our data archaeologist must find a way move the correct data into SQL Server or risk losing our most important treasures, forever. Luckily, he has an powerful tool, data profiling. Data profiling is a way that you can identify bad data, measure inaccurate data, and know for sure that your queries are right. There are many different ways our adventurer can use data profiling. This session will show you what data profiling is and how it can help lead you to fortune and glory.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Pyramid Cafe
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Ever wanted to convince the boss try something new, but didn't know where to start? Ever tried to lead your peers only to fail to achieve your goals? This session teaches you the eight techniques of influencing IT professionals, so that you can innovate and achieve change in your organization.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Dell Hall of Fame
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic
There are a short list of mistakes that, if you know of them in advance, will make your life much easier. These mistakes are the “low hanging fruit” of application design, development, and administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Profisee Experience
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: SIOS Sound Stage
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Profisee Experience
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Pyramid Cafe
Mahout is a machine learning library, supported in HDinsight. HDInsight is the Microsoft service that brings Apache Hadoop to the cloud, and Mahout is a powerful tool for processing models within HDFS and MapReduce. This session will cover how data mining is implemented in the context of big data and the cloud. This session will cover the full data mining cycle: ETL,building, testing, and training data models to visualization, testing, and real-time querying. You will see how to discover patterns and make predictions, classifications, and recommendations to get all the insights from your structured and non-structured big data.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: SIOS Sound Stage
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Dell Hall of Fame
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic
In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: SIOS Sound Stage
In this session, you'll also learn about the relationship across the security settings in the BI tools, backend databases, and the Windows operating system. Building on this foundation, you'll learn what steps are necessary to apply security best practices in each component of the Microsoft BI stack.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Cisco Solid Gold
Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!
When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Amazon Arena
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: the Ryman
Time permitting, we will also be taking questions from the audience. You will hear from SQL and local WIT heroes Hope Foley, Eliza, Britni Larchinese and Naomi Williams
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Pyramid Cafe
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Pyramid Cafe
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Pyramid Cafe
◾What makes Power BI different from the Microsoft Office I have known for years?
◾What are the major Power BI features in Excel 2013 and 2010?
◾What are the major features for Power BI for Office 365?
◾How can our team license Power BI?
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: SIOS Sound Stage
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Pyramid Cafe
Event Date: 17-01-2015 - Session time: 00:00:00 - Track: Microsoft Music Magic