sqlsathistory

Nr: 357

Back to Main list

SQLSaturday #357 - Cleveland 2015

Start Time (24h) Speaker Track Title
00:00:00 Ben Miller Training 4 PoShDBA: Practical PowerShell for the DBA
00:00:00 Julie Smith Training 1 Swimming in the Deep End with SSIS
00:00:00 Chris Schmidt Training 5 SSAS, MD.: Tuning your cubes for fast processing and faster queries
00:00:00 Colleen Morrow Training 4 Enterprise-level auditing on a Standard Edition budget
00:00:00 Craig Purnell Training 4 Hardening SQL Server
00:00:00 David Maxwell Training 4 The usual SUSPECTs: When good databases go bad.
00:00:00 Kevin Feasel Auditorium APPLY Yourself
00:00:00 Hope Foley Training 5 Spatial Data - Looking Outside the Map
00:00:00 Janis Griffin Training 2 Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
00:00:00 Jim Arko Training 3 Troubleshooting SQL Server Performance Using Wait Stats
00:00:00 Jeff Moden Training 2 Partitioning System for "WORM" Tables - Part 1 - The Theory and the Problems
00:00:00 Jeff Moden Training 2 Partitioning System for "WORM" Tables - Part 2 - Deep Dive on the Code
00:00:00 Joseph D'Antoni Training 2 Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.
00:00:00 Jeff Mlakar Training 1 Working with BimlScript to ease and automate your SSIS development
00:00:00 John Deardurff Training 5 Working with Data Types
00:00:00 Kendal Van Dyke Training 4 Transactional Replication: Tuning and Troubleshooting
00:00:00 Konstantin Melamud Training 2 Turbo Boost Performance: In Memory Tables index optimizations
00:00:00 Ravi Kumar Training 1 Think like SSIS and Build a package
00:00:00 Matt Nelson Training 1 Building dynamic SSIS packages for more flexibility
00:00:00 Tim Corey Training 3 Before You Optimize: Understanding Execution Plans
00:00:00 Michael Corey Training 3 Database Virtualization and Drinking out of the Fire Hose
00:00:00 Mindy Curnutt Training 3 The Ins and Outs of SQL Indexes
00:00:00 Michael Swart Training 5 Drawing Conclusions
00:00:00 Michael John Auditorium Handling catch all or sometimes queries
00:00:00 Matt Slocum Training 3 What Every DBA Needs To Know About Storage For SQL Server
00:00:00 William Wolf Auditorium Common Coding Mistakes and how to Mitigate them
00:00:00 Phillip Labry Training 5 Interactive Data Visualizations in Power View
00:00:00 Steve Hood Training 2 Fixing Page Life Expectancy
00:00:00 Warren Sifre Training 3 DBA Monitoring and Maintenance Fundamentals
00:00:00 Wayne Sheffield Auditorium Table Vars Temp Tables - What you NEED to Know!
00:00:00 Wendy Pastrick Training 4 SQL Server in Azure
00:00:00 Aaron King Training 1 Database Deployment with Release Management for Visual Studio
00:00:00 Aaron Bertrand Auditorium Top 5 Ways to Improve Your triggers
00:00:00 Aaron Cutshall Auditorium T-SQL Tips Tricks
00:00:00 Adam Belebczuk Training 5 XML Without Xanax: How to Handle XML in SQL Server
00:00:00 Audrey Hammonds Training 1 The Data Warehouse is Dead! Long Live the Data Warehouse!

SessionID: 10270

PoShDBA: Practical PowerShell for the DBA

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4

Speaker: Ben Miller

Title: PoShDBA: Practical PowerShell for the DBA

Abstract:

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.

SessionID: 11129

Swimming in the Deep End with SSIS

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1

Speaker: Julie Smith

Title: Swimming in the Deep End with SSIS

Abstract:

Many developers of all sorts get thrown into the deep end of the ETL pool without water wings with SSIS. While the dataflow and basic connections are easier to grok, the true complexity of SSIS often lies hidden in configurations, expressions, and parent child packages. This session is a primer on these lesser known, but frightfully important elements.

SessionID: 11677

SSAS, MD.: Tuning your cubes for fast processing and faster queries

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5

Speaker: Chris Schmidt

Title: SSAS, MD.: Tuning your cubes for fast processing and faster queries

Abstract:

Do you have an Analysis Services Multidimensional cube that isn't working right? Is it slow and non-performing? Does it take a REALLY long time to process? In this session, we'll review some of the best practices that you can put against your SSAS cube to get it running at peak efficiency. We'll discuss how to optimize dimension processing and why attribute relationships are so important, and what makes distinct count measure groups special. We'll also discuss why SSAS has 2 engines under the covers, and how you can use this knowledge to performance tune your cube to address the right bottleneck.

SessionID: 11782

Enterprise-level auditing on a Standard Edition budget

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4

Speaker: Colleen Morrow

Title: Enterprise-level auditing on a Standard Edition budget

Abstract:

In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases. Unfortunately, that's an Enterprise Edition feature. What about those of us running Standard Edition? In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, and extended events.

SessionID: 12041

Hardening SQL Server

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4

Speaker: Craig Purnell

Title: Hardening SQL Server

Abstract:

Need to build a more secure SQL Server? Attend this session and learn 10 things you can do today to make your SQL Server more secure. Options like encrypting client connections, renaming SA, and configuring a SPN so SQL Server uses Kerberos. You learn how to combine multiple layers to truly build “defense in depth” for a more secure database platform.

SessionID: 13340

The usual SUSPECTs: When good databases go bad.

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4

Speaker: David Maxwell

Title: The usual SUSPECTs: When good databases go bad.

Abstract:

You just restarted SQL Server, but some of your databases aren't coming online. Maybe

you see a database marked SUSPECT, or RECOVERY PENDING. What do you do? In this session we'll cover the various states that a database can be in, how they get into those states, and learn the proper techniques to bring your data safely back online.

SessionID: 14199

APPLY Yourself

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 15002

Spatial Data - Looking Outside the Map

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5

Speaker: Hope Foley

Title: Spatial Data - Looking Outside the Map

Abstract:

I've said it before and I'll say it again, spatial data doesn't get much love in SQL Server. It is a feature worthy of much appreciation and will become more vital as more location data is collected. In this session we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.

SessionID: 15744

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2

Speaker: Janis Griffin

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract:

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.

SessionID: 15774

Troubleshooting SQL Server Performance Using Wait Stats

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3

Speaker: Jim Arko

Title: Troubleshooting SQL Server Performance Using Wait Stats

Abstract:

Sometimes the hardest part of diagnosing performance issues is determining where to start. Wouldn’t it be nice if you could just ask SQL Server what’s slowing it down? Good news: you can! Every single time SQL Server has to wait on a resource it keeps track of it in its Wait Stats. That valuable data can be used to narrow down your troubleshooting efforts and help you get to the root cause quicker. This session will provide an introduction to Wait Stats and explain how they can be leveraged to improve your performance tuning skills.

SessionID: 16065

Partitioning System for "WORM" Tables - Part 1 - The Theory and the Problems

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2

Speaker: Jeff Moden

Title: Partitioning System for "WORM" Tables - Part 1 - The Theory and the Problems

Abstract:

This isn't your typical talk on "partitioning". This is a deep dive into all the problems that you'll run into when partitioning new or existing "Write Once, Read Many" tables, such as large Audit Tables, and how to code around them. You'll also learn the methods to support three of the best reasons for partitioning such monster tables... MUCH shorter nightly index maintenance, MUCH shorter and smaller backups, and MUCH shorter "Get back in business" piecemeal restores. We'll also learn how to do the "impossible"... compact a File Group (one per partition) so that there's virtually no unused space in the underlying file. After all, we don't want to set any "free" disk-space to "Read Only". Don't let the "Advanced" rating of this session scare you away. Anyone with a decent handle on T-SQL (or wants one) will be able to understand this session because "all will be explained" and there will be oodles of well-documented code to back up the explanations.

SessionID: 16066

Partitioning System for "WORM" Tables - Part 2 - Deep Dive on the Code

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2

Speaker: Jeff Moden

Title: Partitioning System for "WORM" Tables - Part 2 - Deep Dive on the Code

Abstract:

SessionID: 16234

Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2

Speaker: Joseph D'Antoni

Title: Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.

Abstract:

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.

SessionID: 16279

Working with BimlScript to ease and automate your SSIS development

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1

Speaker: Jeff Mlakar

Title: Working with BimlScript to ease and automate your SSIS development

Abstract:

Business Intelligence Markup Language (Biml) is a great way to simplify your SSIS development to an easy-to-read XML format. BimlScript expands this even further to allow you to embed .NET code in your Biml to have new Biml dynamically generated with schema changes at your source. In this session, we’ll talk about what BimlScript can do and give you multiple examples of how it makes SSIS package creation easier and more dynamic.

SessionID: 17238

Working with Data Types

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5

Speaker: John Deardurff

Title: Working with Data Types

Abstract:

This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.

SessionID: 18080

Transactional Replication: Tuning and Troubleshooting

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4

Speaker: Kendal Van Dyke

Title: Transactional Replication: Tuning and Troubleshooting

Abstract:

At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.

Session Goals: • Learn how to baseline performance metrics by gleaning information from the distribution database • Show how to tune replication agent performance with agent profiles • Demonstrate advanced troubleshooting techniques to apply when problems occur

SessionID: 18580

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 18875

Think like SSIS and Build a package

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1

Speaker: Ravi Kumar

Title: Think like SSIS and Build a package

Abstract:

You wouldn't drive to a new place without directions? Then why build a SSIS package without having a road map on how to build it. Learn how to think like SSIS, make your ETL life easy, and convert a Process into an SSIS Package. If time allows, we will also cover SSIS Package Configurations, security and deployment. Expect to participate actively in the class.

SessionID: 19849

Building dynamic SSIS packages for more flexibility

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1

Speaker: Matt Nelson

Title: Building dynamic SSIS packages for more flexibility

Abstract:

After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today's date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.

SessionID: 20047

Before You Optimize: Understanding Execution Plans

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3

Speaker: Tim Corey

Title: Before You Optimize: Understanding Execution Plans

Abstract:

You know what your query does, but do you know how it does it? Do you know what type of resources your query uses? Come to this session to find the answers to these questions and more as we walk through reading execution plans. We will see how SQL breaks down the execution of your query and what each step tells us about the overall query. If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.

SessionID: 20236

Database Virtualization and Drinking out of the Fire Hose

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3

Speaker: Michael Corey

Title: Database Virtualization and Drinking out of the Fire Hose

Abstract:

A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.

SessionID: 20779

The Ins and Outs of SQL Indexes

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3

Speaker: Mindy Curnutt

Title: The Ins and Outs of SQL Indexes

Abstract:

This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

SessionID: 20841

Drawing Conclusions

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5

Speaker: Michael Swart

Title: Drawing Conclusions

Abstract:

A fun and sometimes irreverent look a the SQL Server and Data world through illustrations.

I often blog about my DB Developer life in a very visual way. I explore a subset of useful topics such as Normal Form, Deadlocks, the Query Optimizer.

SessionID: 20966

Handling catch all or sometimes queries

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium

Speaker: Michael John

Title: Handling catch all or sometimes queries

Abstract:

We have all had requirements for a procedure based upon many parameters that may or may not contain a value. These are typically seen as the code behind a search screen. The end users need to do this regularly, and they can be real performance killers.

This session will provide a number of different ways to handle "sometimes" queries, and provide techniques to make these perform faster.

Michael John is a Senior DBA with almost 20 years experience working and solving problems for both Fortune 100 companies and smaller firms. As a frequent contributor to many of the community newsgroups, and expert at answering the 2:00 AM problem phone calls, Michael has seen nearly every issue as a DBA in his career.

SessionID: 21145

What Every DBA Needs To Know About Storage For SQL Server

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3

Speaker: Matt Slocum

Title: What Every DBA Needs To Know About Storage For SQL Server

Abstract:

Do you have issues communicating your needs to your Storage/SAN Administrator? Do they seem to speak a different language when it comes to determining and providing your SQL Server storage needs? In this session we'll review storage technologies so that you can communicate effectively with your Storage/SAN Administrator as well as methods of monitoring your storage to ensure that your needs are met.

In this session we will discuss RAID types, Local/Direct Attached Storage vs SAN Storage, and Flash Storage (including how it fits into multiple storage models). We'll also review methods for monitoring and testing your storage performance. With the information gathered in this session, you'll be able to have thorough, informed discussions with your Storage Administrator as well as being able to provide solid metrics to confirm storage performance.

SessionID: 22082

Common Coding Mistakes and how to Mitigate them

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium

Speaker: William Wolf

Title: Common Coding Mistakes and how to Mitigate them

Abstract:

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

SessionID: 22122

Interactive Data Visualizations in Power View

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5

Speaker: Phillip Labry

Title: Interactive Data Visualizations in Power View

Abstract:

Power View is an interactive data exploration, reporting and presentation tool that is a pleasure for business people to use. It the one of the core building blocks of Power BI. In this session we will cover slicing, filtering, custom drill hierarchies, animated scatter plots, maps and more. You don't have to be a visualization expert to create beautiful and compelling visualizations.

SessionID: 25727

Fixing Page Life Expectancy

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2

Speaker: Steve Hood

Title: Fixing Page Life Expectancy

Abstract:

Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.

SessionID: 27566

DBA Monitoring and Maintenance Fundamentals

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3

Speaker: Warren Sifre

Title: DBA Monitoring and Maintenance Fundamentals

Abstract:

The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.

SessionID: 27740

Table Vars Temp Tables - What you NEED to Know!

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium

Speaker: Wayne Sheffield

Title: Table Vars Temp Tables - What you NEED to Know!

Abstract:

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?"

SessionID: 27826

SQL Server in Azure

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4

Speaker: Wendy Pastrick

Title: SQL Server in Azure

Abstract:

Walk through on creating SQL Server solutions in the cloud! Learn about the options for data storage in Azure, plus how to (very easily) configure and deploy a SQL Server. We will go over pricing, storage options, security and other details on using either Infrastructure as a Service (Iaas) or Database as a Service with Microsoft cloud solutions.

SessionID: 8833

Database Deployment with Release Management for Visual Studio

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1

Speaker: Aaron King

Title: Database Deployment with Release Management for Visual Studio

Abstract:

Database deployments while trying to implement continuous integration can be tricky. Microsoft has some great tools available to make things easier. Aaron will show how to use Release Management and Visual Studio to make your development life easier.

SessionID: 8927

Top 5 Ways to Improve Your triggers

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium

Speaker: Aaron Bertrand

Title: Top 5 Ways to Improve Your triggers

Abstract:

You've got a piece of code that you want to implement as a trigger, but you've read that triggers can grind your performance to a halt. Developers everywhere write triggers to implement business logic, to enforce certain types of constraints, or to avoid changing database schema or external code. Many triggers are inefficient and violate best practices -- but it doesn't have to be this way. Come learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.

SessionID: 8950

T-SQL Tips Tricks

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium

Speaker: Aaron Cutshall

Title: T-SQL Tips Tricks

Abstract:

Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you'll learn about various features such as CTE, ROW_NUMBER, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.

SessionID: 9003

XML Without Xanax: How to Handle XML in SQL Server

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5

Speaker: Adam Belebczuk

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract:

Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.

SessionID: 9968

The Data Warehouse is Dead! Long Live the Data Warehouse!

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1

Speaker: Audrey Hammonds

Title: The Data Warehouse is Dead! Long Live the Data Warehouse!

Abstract:

Okay, the Data Warehouse isn't really dead. But, it's time to think past your favorite textbook and begin looking at practical solutions that fit the schedule, budget, and team you're working with. In this session, we'll discuss design options, implementation considerations, and lessons gained from the many mistakes the presenter has made over the years. This is a highly interactive session, so bring your ideas, opinions, and experiences.