Session Schedule

Here are the content details for this event's available sessions.
All times are adjusted to your local timezone. Printable Schedule || Times, presenters and sessions are subject to change.

Time
Title
Speaker
Room

     All Sessions   |   Saguaro Room   |   Ocotillo Room   |   Microsoft Session Room
  • 4/2/2015 9:00 AM
    -to-
    10:15 AM
    Opening Comments and Keynote - SQL Server 2014 Overview
    Saguaro Room

  • 4/2/2015 10:15 AM
    -to-
    11:30 AM
    Performance Improvements in SQL Server 2014
    Saguaro Room
    SQL Server 2014 provides a lot of new and interesting features to build cost effective, high-performance, mission-critical enterprise applications that can be deployed on premises, in the cloud or in a hybrid environment. The features to be discussed include:

    In-memory OLTP Engine
    Transactional performance gains
    Support for memory-Optimized Tables
    Support for Natively Compiled SPs
    Buffer Pool Extensions
    Clustered ColumnStore Indexes
    Delayed Transactions
    Support for Cardinality Estimation


    Sponsored by:
  • 4/2/2015 10:15 AM
    -to-
    11:30 AM
    The SSIS Catalog and Project Model Deployment
    Ocotillo Room
    Microsoft gave SSIS a complete makeover with the SQL Server 2012 release. Most of the changes are cosmetic in nature. The exception to this is deployment. Starting with 2012, you have a brand new way to deploy and manage SSIS via the SSIS Catalog and the Project Model. Attend this session to learn how this new model can simplify deployment and configuration of your SSIS packages.
  • 4/2/2015 10:15 AM
    -to-
    11:30 AM
    In-Memory OLTP Overview
    Microsoft Session Room
    In-Memory OLTP is a key feature in the In-Memory offerings of SQL Server 2014. We discuss the key user scenarios and the hardware trends that prompted the development of In-Memory OLTP. We will also introduce the new memory-optimized tables and natively compiled stored procedures, as well as the key memory and storage management concepts, and we will show how In-Memory OLTP can be used to improve the performance of a sample application.

    Sponsored by:
  • 4/2/2015 11:30 AM
    -to-
    12:45 PM
    Using Peer-to-Peer Replication
    Saguaro Room
    From reporting to high availability, Peer-to-Peer replication offers a way to create an environment with multiple master copies of your data. This allows you to spread load across servers and even seamlessly update systems with no apparent down time to the end user. In this session, we will look at how to configure Peer-to-Peer replication and run it though it's paces so you can integrate the technology into your environment.
  • 4/2/2015 11:30 AM
    -to-
    12:45 PM
    SQL Server Cryptology Primer
    Ocotillo Room
    So, you were told you need to encrypt "the database." Now what?
    Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies. After attending the session, you will be able to identify the right technology to use in your specific use case and you will have the basic knowledge to start implementing it immediately.
     
    After attending this session, you will be able to
    • ·       explain the difference between symmetric and asymmetric encryption.
    • ·       select the right cryptographic technology for your special security requirement.
    • ·       identify when to use one-way hashing instead of encryption.
  • 4/2/2015 11:30 AM
    -to-
    12:45 PM
    In-Memory OLTP for DBA Management
    Microsoft Session Room
    Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this DBA focused session we will take a deep dive into how in-memory tables and indexes are managed in memory and on storage. You will also learn how to provision and control memory usage, how durability and high availability is achieved and how these constructs and operations are integrated together with disk-based tables to provide you a seamless experience.

    Sponsored by:
  • 4/2/2015 12:45 PM
    -to-
    2:00 PM
    Build Services over Data Quickly with Azure Mobile Services
    Saguaro Room

    In today's rapidly-moving world, it's not enough to know how to build great on-premises databases. The rapid pace of development sometimes demands fast solutions that make data available via services, across platforms, and for all kinds of devices.

    In this session, consultant G. Andrew Duthie will show you how Azure Mobile Services provides the ability to quickly build services to store and access data in the cloud, and easily provide client apps for the web, iOS, Android, and Windows/Windows Phone.

  • 4/2/2015 2:00 PM
    -to-
    3:15 PM
    PowerShell for the DBA – Getting Started
    Saguaro Room
    This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour.
  • 4/2/2015 2:00 PM
    -to-
    3:15 PM
    Setting up SQL Server on Windows Azure
    Ocotillo Room

    Best of SSWUG Webcasts:

    In this webinar, we'll explore the options, pros and cons of each and how-to information about setting up databases with Microsoft's Azure systems. This will include a look at both Database Services and Virtual-Machine-oriented solutions, along with different considerations and things to understand about each.

    Here's a look at the different topics to be addresses:

    - Setting up your Windows Azure SQL Database
    - Setting up a VM
    - Setting up a SQL Server on a VM
    - Understanding some of the differences between VM and WASD implementations
    - Making the choice, questions to ask
    - Best Practices
    - Disaster Recovery considerations in the environments

  • 4/2/2015 2:00 PM
    -to-
    3:15 PM
    In-Memory OLTP Migration
    Microsoft Session Room
    SQL Server In-Memory OLTP is a key new feature included in SQL Server 2014. It has been proven to dramatically increase OLTP performance without hardware changes. However, numerous nuances in In-Memory OLTP mean that not all workloads can derive benefits from it. For the workloads that can benefit, care must be taken so that the migration process will enable the workload to take maximum advantage of In-Memory OLTP while keeping efforts down to the minimum. This session will use a sample workload to demonstrate how to plan to migrate to In-Memory OLTP.

    Sponsored by:
  • 4/2/2015 3:15 PM
    -to-
    4:30 PM
    What’s Simple About Simple Recovery?
    Saguaro Room
    There is a common misconception that SIMPLE Recovery means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in SIMPLE Recovery, but some (not all) operations are minimally logged.

    In this session, Kalen will discuss what exactly minimal logging means and what the benefits and dangers of the SIMPLE Recovery Model are.


    Sponsored by:
  • 4/2/2015 3:15 PM
    -to-
    4:30 PM
    How to be a Great Production DBA
    Ocotillo Room

    Do you want to be a DBA? Have you been appointed DBA-by-default? Are you responsible for up time? Operational aspects of your server? Performance? 
    This presentation, which encompasses over 100 years of combined DBA experience, covers everything you need to consider in order to be a great DBA, including: 
    ·         the right way to manage preventive maintenance (including what is important to do, and what is important not to do);
    ·         planning for disaster recovery;
    ·         interacting with developers and management;
    ·         personal characteristics of the great DBA;
    ·         how to be perceived as a great DBA, as well as being one in fact

  • 4/2/2015 3:15 PM
    -to-
    4:30 PM
    In-Memory OLTP Common Design Patterns
    Microsoft Session Room
     
  • 4/2/2015 4:30 PM
    -to-
    5:45 PM
    Lessons Learned with Amazon AWS Infrastructure and SSWUG.ORG
    Saguaro Room
    This session will review the infrastructure items that have been learned from deploying, then re-deploying, SSWUG.ORG to the Amazon cloud.  From load balancers to content distribution to security and managing development cycles, several lessons have been discovered and addressed along the way, some painful.  Join in this session for a look at the considerations and things you can take away from the implementation projects completed.  

    Sponsored by:
  • 4/2/2015 4:30 PM
    -to-
    5:45 PM
    Care and Feeding of Your System Databases
    Ocotillo Room
    Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to keep your backup history from growing indefinitely. You'll leave with a better understanding of these shared resources and how they affect your database applications.
  • 4/2/2015 4:30 PM
    -to-
    5:45 PM
    In-Memory OLTP for Database Developers
    Microsoft Session Room
    SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this session we focus on the new concepts for database developers. We discuss the new memory-optimized tables and the new memory-optimized hash and nonclustered indexes. You will also learn how to access memory-optimized tables using interpreted Transact-SQL, and how to optimize data access using the new natively compiled stored procedures. Finally, you will learn how to work with the new lock-free transaction semantics for in-memory OLTP.

    Sponsored by:
  • 4/2/2015 5:46 PM
    -to-
    6:01 PM
    Ending Comments and Giveaway
    Saguaro Room
    As thanks for participating in our conference and hashtag contests, we're giving away swag from Microsoft at the end of the day. Participate in the conference survey (found in the Help Center) to win tomorrow's big price - an XBOX ONE!
  • 4/3/2015 9:00 AM
    -to-
    10:15 AM
    Security - Ignorance is No Longer Bliss
    Saguaro Room
    This session will take a look at security requirements, evaluating your systems and some of the recent happenings with information security.  We'll look at the different things you need to know about for SQL Server security and for working through a re-examination of your systems to look for weaker spots and opportunities to tighten up controls.  We'll also go over changing legal and moral ideals that pertain to security and responsibilities for information protection. 

    Sponsored by:
  • 4/3/2015 9:00 AM
    -to-
    10:15 AM
    Understanding and Monitoring Tempdb
    Ocotillo Room
    Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.

    Sponsored by:
  • 4/3/2015 9:00 AM
    -to-
    10:15 AM
    In-Memory Columnstore Overview
    Microsoft Session Room
    The updateable clustered columnstore in SQL Server 14 offers a leading solution for your Data Warehouse workload with order of magnitude better data compression and query performance over traditional btree based schemas. This session describes columnstore index internals with deep insight into data compression methodology and achieving high query performance.

    Sponsored by:
  • 4/3/2015 10:15 AM
    -to-
    11:30 AM
    Are You Optimistic About Concurrency?
    Saguaro Room
    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!
  • 4/3/2015 10:15 AM
    -to-
    11:30 AM
    Indexing for Performance
    Ocotillo Room

    While the industry studies uniformly blame 70-80% of performance issues on bad code, there’s a presumption that database physical design supports the queries. Proper indexing has a dramatic positive effect on query and server performance (sometimes taking multi-day queries down to seconds). 
    There is a great deal of misinformation and uniquely inappropriate information being presented in white papers and documentation on the web. 
    This presentation discusses:

    • ·         Physical index structures;

    • ·         How physical structures affects optimizer decisions;

    • ·         How the optimizer may or may not use indexes;

    • ·         Index design and selection for performance

  • 4/3/2015 10:15 AM
    -to-
    11:30 AM
    SQL Server in Azure Virtual Machine
    Microsoft Session Room
    Learn about all the cool features available to make running SQL Server in a VM a breeze on Azure. From setting up Always on to leveraging automatic backup to Azure this session we will give an overview of everything to get you started with SQL Server in a VM on Azure and how it can benefit and enhance your on-premise SQL Server at the same time.

    Sponsored by:
  • 4/3/2015 11:30 AM
    -to-
    12:45 PM
    SMO Internals for High Performance Automation
    Saguaro Room
    Ever wanted to know what happens behind the scenes in SQL Server when automating your maintenance work? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come to learn about the knobs available to tune your SMO automations. PowerShell will be used as the vehicle that leverages SMO. Come see this demo-heavy session, you'll be glad you did.
  • 4/3/2015 11:30 AM
    -to-
    12:45 PM
    Sensors and Data, and the IoT
    Ocotillo Room

    The term IoT, short for the Internet of Things, has become quite the buzzword recently. But what are the implications of the IoT in terms of data? Many internet-connected devices feature sensors, and in order for those sensors to be useful, the data from them needs to be transported, stored, and made available for review and analysis. 

    In this session, consultant G. Andrew Duthie will show some of the techniques and technologies that you can use to collect, transport, and store data from IoT devices and sensors, including ASP.NET Web API and SQL Server, as well as Azure services specifically designed to support IoT. He'll also discuss architectural considerations, such as local caching, to optimize performance when dealing with small bits of data from many devices.

  • 4/3/2015 11:30 AM
    -to-
    12:45 PM
    SQL Server Hybrid Features
    Microsoft Session Room
     

    Sponsored by:
  • 4/3/2015 2:00 PM
    -to-
    3:15 PM
    Upgrading SQL Server Done Right
    Saguaro Room
    With SQL Server 2005 approaching its end of support, a lot of businesses are struggling on how to upgrade their existing environments to SQL Server 2012 or SQL Server 2014. Well this session is targeted at those! Learn how to successfully implement different upgrade scenarios, including advanced upgrade scenarios such as rolling upgrades. By the end of the session you will have a clear understanding of which tools to use, which upgrade strategies to implement, and how to successfully upgrading your SQL Server installations with minimal downtime.
  • 4/3/2015 2:00 PM
    -to-
    3:15 PM
    Securing Multi-Database Applications
    Ocotillo Room
    It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable. In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
  • 4/3/2015 2:00 PM
    -to-
    3:15 PM
    SQL Server Buffer Pool Extension & Resource Governor
    Microsoft Session Room
     

    Sponsored by:
  • 4/3/2015 3:15 PM
    -to-
    4:30 PM
    New features in ASP.NET 5
    Saguaro Room
    ASP.NET 5 provides an optimized development framework for apps that are either deployed to the cloud or run on-premises. The new features in ASP.NET 5 to be discussed include the following:
     
    New flexible and cross-platform runtime
    New modular HTTP request pipeline
    Cloud-ready environment configuration
    Unified programming model that combines MVC, Web API, and Web Pages
    Ability to see changes without re-building the project
    Side-by-side versioning of the .NET Framework
    Ability to self-host or host on IIS
    New tools in Visual Studio 2015
  • 4/3/2015 3:15 PM
    -to-
    4:30 PM
    SSIS Execution, Logging, and Troubleshooting
    Ocotillo Room
    In the past, you had to answer a lot of questions about SSIS logging. How much is too much? What is really useful? Files or tables? Do I have to build my own reports?

    Starting with SSIS 2012, you can take advantage of automatic SSIS logging when you use the Project Deployment Model and the SSIS Catalog. You also get built-in reports and a new way to execute the packages.

    Attend this session to learn all you need to know about SSIS logging. As a bonus, you will learn about the best kept secret in SSIS: Data Taps.
  • 4/3/2015 4:31 PM
    -to-
    4:46 PM
    Ending Comments and Giveaway
    Saguaro Room
    As thanks for participating in our conference and hashtag contests, we're giving away swag from Microsoft at the end of the day. Participate in the conference survey (found in the Help Center) to win the big prize - an XBOX ONE!
Panel Bottom