Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 52
You’re just getting started as a SQL Server Database Administrator -- or you’re trying to get there. You’re confused about exactly what you need to learn to master the basics of the job. Kendra Little has been there, and she can help! In this session she’ll explain three critical skills that every Junior DBA must master. You’ll leave this session with free scripts and an itemized, online training plan to achieve your goals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 02

Time: 8:30 AM - 9:30 AM

Room: Health Sci. 131

You have all probably heard about this "NoSQL" thing and wondered what is about, how does it differ from SQL Server and how will this affect me.  You might want to just stick your head in the sand and ignore it, but as database professionals it is always good to know about what other technologies might be out there to compliment your existing solutions.  We will not be going deep into any one solution, but by the end of this session, the goal will be that you understand the following:

1. The different types of NoSQL databases
2. Some use cases where they might be applicable
3. Some of the major solutions out there for each one
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 02

Time: 8:30 AM - 9:30 AM

Room: Health Sci. 117

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:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 02

Time: 9:45 AM - 10:45 AM

Room: Health Sci. 131

Have you wanted to start giving back to our amazing SQL Community through writing, but are not sure how to start? Do you want to start blogging, but are anxious about criticisms? Are you unsure what to write about? I’ll walk through how to find topics to start writing about. I’ll go over tools to help you blog, and websites that you can start blogging about. We’ll discuss why it’s import to be a woman blogger, and I’ll share with you my experience over the last three years as a woman blogger in our community. Role models are needed for women in tech. They need to know that they are wanted in the community and that they have a voice. Be that role model through blogging.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 02

Time: 2:45 PM - 3:45 PM

Room: Health Sci. 120

Are you already using Reporting Services (SSRS) but just not loving it?  Has it become clumsy, hard to manage or just plain not great?  In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts.  An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance.   Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication.  Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 02

Time: 2:45 PM - 3:45 PM

Room: Humanities 206

Demonstrate the steps to import raw data from text file, Access database and Excel file into Excel 2013, and then build a BI dashboard using PowerPivot and Power Map. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 02

Time: 11:00 AM - 12:00 PM

Room: Humanities 208

Test Data Builders. Ever heard of them? That's ok. Neither did I before I went looking for a convenient way to set up test data in SQL Server. I will show you what they are and how they work. More importantly, you will learn an easy way to get started and what you can do with them that could make your professional value grow and earn more money. I will also cover some of the design decisions you need to make so that they'll fit your needs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 02

Time: 1:30 PM - 2:30 PM

Room: Humanities 303

SQLHA founder Allan Hirt is a Microsoft Cluster MVP, consultant, and trainer who specializes in all things related to mission critical SQL Server - high availability, disaster recovery, consolidation, virtualization, administration, and more. Based in the Boston, MA area, he travels all over the world to work with and train clients. Allan is currently working on the book Mission Critical SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 02

Time: 12:30 PM - 1:30 PM

Room: Health Sci. 117

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 02

Time: 1:30 PM - 2:30 PM

Room: Humanities 305

We will focus on important concepts, methodologies and do some demos if there is time at the end. If you would like to have an advanced sessions, please send me an email.

Agenda

1. Infrastructure - What do you need to get started with SSIS?
2. Methodology, Concepts, Best Practices
3. If we have time, we may jump to some SSIS demos and share some tips.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: April 02

Time: 9:45 AM - 10:45 AM

Room: Humanities 307

Join us to explore how emerging data modeling methods and model notations help us define, and easily communicate, robust integration points between NOSQL data stores and emerging RDBMS 'Lean Data Warehouse' models that would otherwise be challenging to map across due to radical differences in normalization.   Did you buy the pitch about how 'BigData and RDBMS  Data Warehouses can remain in isolation'.      Me neither!      You will leave this sessions not only free from some rigid E/R modeling assumptions and diagramming standards, but also armed with an introduction to a practical method of logical data modeling in the new world of polyglot data storage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 02

Time: 9:45 AM - 10:45 AM

Room: Health Sci. 117

If you're like the rest of us, don't miss the chance to learn how to forget about snapshots and consistency groups forever with Reduxio's database time machine at SQL Saturday. 

Never lose more than 1 second of transactions ever again. Reduxio will showcase their breakthrough Backdating technology that obsoletes existing database backup technologies by providing the ability to instantly recover and clone from any second in the past with no upfront planning or data copy. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 02

Time: 12:30 PM - 1:30 PM

Room: Humanities 206

Let's take the new, free backup tool out for a spin. We can hop through a quick installation, glance at the multi-install PowerShell script, and dance around the table-based schedules, for a start. Afterward we'll have a long, leisurely walk through some of the best things you can do with MB: backup ordering, pre- and postcode, live insight, striping and mirroring, and of course so much more. Feel free to download MB and follow along on your own laptop! 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 02

Time: 11:00 AM - 12:00 PM

Room: Humanities 305

NAND flash storage is the new wave of technology hitting data centers and solutions design.  With a new technology comes a new set of pros versus cons, new economics and changes in solutions architecture that highlight what it has to offer.  This session will give an overview of how the technology works, what to look out for, how to properly POC/test each vendor’s solution and how to modernize your database architecture with this new technology.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 02

Time: 12:30 PM - 1:30 PM

Room: Health Sci. 120

t its most fun, software development is a team sport. Think of an NFL team. Does the quarterback know where the running back or tight-end will be? Does he do his job in a vacuum or with coordination and support from his teammates?

However, if the teammate isn't doing what they're supposed to do, the play dissolves and leads not only to losing a game, but also individual dissatisfaction. Come to this session to learn how to coordinate and communicate as a team, improving individual and overall developer effectiveness.  Learn how to overcome  particular obstacles unique to SQL Developers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 02

Time: 8:30 AM - 9:30 AM

Room: Humanities 305

Sometimes bad execution plans happen to good queries. You may have heard that it's better to rewrite complex TSQL-- but is using a temporary table better than using query hints? In this session you'll learn the pros and cons of using hints, plan guides, and the new Query Store feature in SQL Server 2016 to manipulate your execution plans. You'll take away a checklist of things to do every time you decide to bully an execution plan.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 02

Time: 11:00 AM - 12:00 PM

Room: Health Sci. 131

How to interact with your corporate data right from within the Cortana experience including voice integration for querying your data. How Q&A can resolve our day today question from organization. How to Use natural language queries to find answers in your own data. Start with a question, and have fun traveling through your data refining or expanding your question, uncovering trust-worthy new information, zeroing in on details and zooming out for a broader view
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 02

Time: 4:00 PM - 5:00 PM

Room: Humanities 206

Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. 
Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about  performance, scale, availability and support for what is usually considered their most critical applications.  In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience  and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the same person writing the official SQL on VMware best practices guides.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 02

Time: 9:45 AM - 10:45 AM

Room: Humanities 303

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it.  This session includes demonstration and use case scenarios.  The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: April 02

Time: 1:30 PM - 2:30 PM

Room: Health Sci. 117

This session will cover what is Streaming Analytics and the various use cases.  We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review.  The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 02

Time: 9:45 AM - 10:45 AM

Room: Humanities 208

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