Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 26
Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014.  Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud.  Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 160

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

I recently took over a new database that I needed to query and report from but I didn't know what was there and how it all connected.  Join me on my journey of tips and tricks to decode your next new database.  There will be some T-SQL, some Interface work and a little bit of Sherlocking while avoiding locking. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 180

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases.  The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, define processes, share ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion.
Speaker:

Session Type:
Regular Session

Track:
Room 3170

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Follow along as we adventure through the vastness that is Availability Groups in SQL Server.  In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
Speaker:

Session Type:
Regular Session

Track:
Room 170

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 170

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

We always keep versions of our code in a source control system, but how about the database? How can we reduce the pain of updating the database model when working on a team, or even knowing when do we need to update it? What can we do if we want to rollback to a previous version of the database?  Liquibase is a pretty awesome library that will help you update, maintain and control your database model, as any other asset in your project.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 110

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA!  Feeling overwhelmed, not sure where to begin.  I know I have data and maybe lots of it.  I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends.   For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends.  Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 180

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. 

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
Speaker:

Session Type:
Regular Session

Track:
Room 160

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Our company built a system mixing Big Data technologies (hadoop/ElasticSearch) along with SQL Server to make a system that is both highly scalable and cost effective.  In this session I’ll walk you through the ETL process of pulling data through sqoop, transforming data in hive and presenting a denormalized table in hive.  If you are looking to understand how to get data from SQL Server into hadoop and leveraging parallel architecture this is the session for you.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 5180

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

You touch SQL Server Management Studio almost every day.  Do you use it to its fullest or are you wasting time? This session will cover 15 aspects of SSMS that will make you more efficient as a professional. You will learn how to customize your toolbars, leverage templates, and work with multiple environments.  You will be introduced to  drag/drop shortcuts, secret hotkey combinations, and copy/paste behaviors most users do not know about. You will leave with a full understanding of the debugger, breakpoints, data tips, and setting up RPC to debug remotely.  Finally, for those looking for the ultimate in flexibility you will learn how to build your own ad-ins from scratch.  This session is for SQL Server professionals across BI, development
Speaker:

Session Type:
Regular Session

Track:
Room 3160

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1170

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Session Type:
Regular Session

Track:
Room 5180

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

As a DBA in the modern era, you may be required from time to time to do something outside of your comfort zone.  One of these things may be to become quickly acquainted with SSRS.  Even better is that you may be required to do things you have not considered in a standard report.  In this session, you will learn how to implement a framework to help provide a common ground for your reports.  This session will delve into fun topics such as dynamic grouping and dynamic sorting.  We are not talking about the interactive sorting that your accountant may use.  Attendees will also be introduced to a few quick methods of exporting Reports from the report server - this is from a DBA perspective after-all!
Speaker:

Session Type:
Regular Session

Track:
Room 3160

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

On occasion as DBAs we have need to disable the foreign keys and constraints on one or more tables. Guess what, SQL Server no longer trusts those constraints when you re-enable them. What does that mean? In this discussion, we’ll talk about what the impact is to your queries when you have non-trusted constraints, how to find the non-trusted constraints, and how to soothe SQL Servers mistrusting heart so that it will trust your constraints again! How about your foreign keys? Are you using implicit conversions? Are your stats 'stale'? All of these things effect how the query optimizer works and can negatively affect you query performance. 
Speaker:

Session Type:
Regular Session

Track:
Room 170

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events were introduced in SQL Server 2008.  With each edition through SQL 2014, we have seen a significant upgrade to this feature.  Join me for a little adventure into Extended Events.  We will discuss how to use extended events to aid in performance tuning and in day to day administration.  We will also explore some background and the architecture of extended events.  
Speaker:

Session Type:
Regular Session

Track:
Room 3160

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Explore proven methods to rapidly identify and fix inefficient SQL. This course will include but is not limited to the following: 
1. Sight recognition of inefficient or troublesome SQL.
2. Understanding how to use STATISTICS IO and TIME. 
3. Basic understanding of an execution plan to evaluate indexes and sheer amount of data at each stage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 160

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
Speaker:

Session Type:
Regular Session

Track:
Room 1170

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Every database professional knows the database design ideal and we have all seen that ideal on numerous occasions -  databases in perfect third normal form;  constraints and relational integrity rigorously enforced; elegant error handling in every SQL statement;  data so clean you can eat off it.

Unfortunately we’ve only seen this ideal in textbooks and sample databases designed by vendors.  

The databases we see in the real world are… less than ideal shall we say.  Of course, we use other phrases for what we see but human resources frowns on such terms and this is, after all, a family friendly presentation.  
Database professionals in Greece circa 600 BCE may have access to the Alpheus and Peneus rivers to cleanse their particular stables but we modern folks need to rely on the tools on our own computers such as SQL and SSIS.  Mike will review various techniques and tools for data cleansing that will help you wash away the muck to get to the data gold standard.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 3160

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.
Speaker:

Session Type:
Regular Session

Track:
Room 1180

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Session Summary:   
Microsoft IT's Cloud strategy involves migrating hundreds of applications to Azure.  The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important—& painful—ones.
Session Abstract: 

As part of the team leading the migration effort from Microsoft IT's on-prem servers to The Cloud, I've collected a number of best practices that can save your organization weeks or months of effort & untold dollars in development & implementation costs.  Those who think the only tool required to move SQL instances from the datacenter to IaaS VMs is a forklift have a hard lesson to learn.  In fact, it's much, much more challenging than that.  This session will introduce the Top 10 Lessons Learned in the MSIT migration effort & provide actionable guidance that customers can begin using immediately. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 160

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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