sqlsathistory

Nr: 191

SQLSaturday #191 - Kansas City 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Brian Flynn	Mixed use	Pivoting Performance Data Pinpointing Problems
00:00:00	Bill Fellows	Developer 2	Type More, Click Less: Programmatically build SSI
00:00:00	Bill Graziano	Developer 2	Designing for Concurrency and Asynchronous Processing
00:00:00	David Valentine	Developer 2	T-SQL: Simple Changes That Go a Long Way
00:00:00	David Klee	DBA 1	Squeezing Performance from Virtualized SQL Server
00:00:00	Doug Lane	BI 1	From Minutes to Milliseconds: High-Performance SSRS Tuning
00:00:00	Nathan Heaivilin	DBA 2	Introduction to Execution Plans
00:00:00	Ira Warren	Developer 1	(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
00:00:00	Janis Griffin	DBA 1	Extend Your Knowledge with Extended Events!
00:00:00	Jason Horner	BI 1	Dimension Modeling Design Patterns: Beyond Basics
00:00:00	Jason Strate	DBA 1	What Are You Waiting For?
00:00:00	Jason Strate	DBA 2	XQuery Basics for the DBA
00:00:00	JD Wade	Mixed use	What SQL DBAs need to know about SharePoint
00:00:00	Jason Kassay	DBA 2	Getting Started with Execution Plans
00:00:00	Karen Lopez	Mixed use	$#*! Your Database Says About Me
00:00:00	Kathi Kellenberger	DBA 1	Women in Tech Panel
00:00:00	Kathi Kellenberger	Developer 2	T-SQL 2012 Analytic Functions
00:00:00	Larry Toothman	Mixed use	Yesterday I Couldn’t Even Spell ‘DBA’.
00:00:00	Meagan Longoria	BI 1	Don’t Miss Out on Excel Cube Functions
00:00:00	Levi Syck	BI 1	Something Fishy With Power Query
00:00:00	Leslie Weed	BI 1	Pyramid Analytics - making your cube look good
00:00:00	Marc Beacom	Developer 1	New T-SQL features in SQL Server 2012
00:00:00	Mark Marinovic	DBA 2	Proactively+Automagically Manage your SQL footprin
00:00:00	Andre DuBois	Developer 2	What secrets does your database schema hold?
00:00:00	Jeff Renz	BI 1	Data Vault Data Warehouse Architecture
00:00:00	Russel Loski	Developer 1	Introduction to BIML and BIMLScript
00:00:00	Sean McCown	DBA 2	Beginning Powershell for DBAs 1.0
00:00:00	Scott Shaw	DBA 2	Dimensional Modeling for the Everyday DBA
00:00:00	Steve Wake	Developer 1	Capture Change and Apply it With Change Data Capture SSIS
00:00:00	Tristan Wilson	DBA 1	Sql Server: Now 25% Faster
00:00:00	Travis Whitley	Mixed use	SSRS Development and Administration Basics
00:00:00	Wendy Pastrick	DBA 1	Navigating the Options for Data Redundancy
00:00:00	Michael Fal	DBA 1	The Hierarchy of Monitoring Needs: A Methodology
00:00:00	Allen Smith	Developer 1	SSIS Configurations Vs. Parameters
00:00:00	Allen Smith	Developer 2	Sharing SQL Data in SharePoint
00:00:00	Andy Thiru	Developer 1	Loading the Windows Azure Cloud

SessionID: 10402

Pivoting Performance Data Pinpointing Problems

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Mixed use

Speaker: Brian Flynn

Title: Pivoting Performance Data Pinpointing Problems

Abstract:

Have you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers? After being bit by this many times, I developed my own eye in the sky to monitor CPU Physical IO at the database, user and application levels. This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel. No need to requisition funds for 3rd party tools. You can do this with the tools you have and I’ll give you the scripts to get started. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels.

SessionID: 10428

Type More, Click Less: Programmatically build SSI

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 2

Speaker: Bill Fellows

Title: Type More, Click Less: Programmatically build SSI

Abstract:

Developing repetitive strain injury (RSI) from all those mouse clicks in Business Intelligence Development Studio/SQL Server Data Tools? Longing to automate the tedium in SQL Server Integration Services package creation? In this session, we’ll explore the Integration Services object model and learn how to create rich packages without ever clicking our mouse. You’ll learn about the basic object model, the EzAPI wrapper for it, as well as using BIMLScript to build moderately complex packages.

SessionID: 10466

Designing for Concurrency and Asynchronous Processing

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 2

Speaker: Bill Graziano

Title: Designing for Concurrency and Asynchronous Processing

Abstract:

In modern applications supporting hundreds or thousands of users (or devices), concurrency or code that doesn’t block is more important than raw, blazing speed. This presentation will start with approaches to write more concurrent transactions. It will cover strategies to process data asynchronously and methods to maintain read-only reporting databases. Technologies covered will include T-SQL, isolation levels, Change Tracking and Change Data Capture, Service Broker, replication, database mirroring and Availability Groups.

SessionID: 12364

T-SQL: Simple Changes That Go a Long Way

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 2

Speaker: David Valentine

Title: T-SQL: Simple Changes That Go a Long Way

Abstract:

Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance of your queries. Learn about indexing techniques and reading execution plans to see if the optimizer is using the index. Performance isn't everything though. There are small things you can do to make your TSQL more maintainable too. We will dive into a few TSQL tricks with Common Table Expressions, Table-Valued Parameters, and COALESCE.

SessionID: 12588

Squeezing Performance from Virtualized SQL Server

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: David Klee

Title: Squeezing Performance from Virtualized SQL Server

Abstract:

Sure, your SQL Server is up and running. Anyone can click through a SQL Server install nowadays. But... is it running at its peak potential? Do you have your virtualization environment configured properly? Have you measured the performance lately? Your business-critical SQL Server performance does not have to suffer just because it was virtualized. Very specific virtualization and SQL Server tuning tips and tricks from David Klee (@kleegeek) will be presented in this session.

SessionID: 13389

From Minutes to Milliseconds: High-Performance SSRS Tuning

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 1

Speaker: Doug Lane

Title: From Minutes to Milliseconds: High-Performance SSRS Tuning

Abstract:

Even though you're an experienced report developer or administrator, performance tuning for SQL Server Reporting Services still feels as bewildering and hopeless as folding a fitted bed sheet. You've made your data sets smaller and timeouts longer, but it's not enough to remove the slowness dragging down your reporting environment.

In this session, you'll learn how design and configuration choices put pressure on your report server and techniques to relieve that pressure. You’ll see how to configure your Reporting Services databases for speed, houseclean your subscription schedules, and use caching for high-demand reports. You'll also learn some design strategies to lighten your report processing load. If you want to maximize the speed of your Reporting Services environment and minimize the pain of performance tuning, this session is for you.

SessionID: 14950

Introduction to Execution Plans

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 2

Speaker: Nathan Heaivilin

Title: Introduction to Execution Plans

Abstract:

Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.

SessionID: 15490

(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 1

Speaker: Ira Warren

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Abstract:

SessionID: 15662

Extend Your Knowledge with Extended Events!

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: Janis Griffin

Title: Extend Your Knowledge with Extended Events!

Abstract:

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

SessionID: 15849

Dimension Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 1

Speaker: Jason Horner

Title: Dimension Modeling Design Patterns: Beyond Basics

Abstract:

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

SessionID: 15921

What Are You Waiting For?

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: Jason Strate

Title: What Are You Waiting For?

Abstract:

You’ve spent the afternoon sweating over your T-SQL query. You’ve wrung out all of the wrinkles. It’s deployed, it’s running… now its waiting. In SQL Server the most performant query can become a problem query if there aren’t any resources in the SQL Server for it to use. In this session, we’ll look at wait statistics and what they are. We’ll look into how they are accumulated and how they can be monitored. By the end of the session, you’ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them.

SessionID: 15923

XQuery Basics for the DBA

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 2

Speaker: Jason Strate

Title: XQuery Basics for the DBA

Abstract:

For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery.

SessionID: 16146

What SQL DBAs need to know about SharePoint

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Mixed use

Speaker: JD Wade

Title: What SQL DBAs need to know about SharePoint

Abstract:

With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, supported methods for providing high availability and disaster recovery, and the part SharePoint and SQL each play in the Microsoft Business Intelligence story.

SessionID: 16888

Getting Started with Execution Plans

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 2

Speaker: Jason Kassay

Title: Getting Started with Execution Plans

Abstract:

You just received a phone call from your boss telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, the first thing you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points

SessionID: 17902

$#*! Your Database Says About Me

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Mixed use

Speaker: Karen Lopez

Title: $#*! Your Database Says About Me

Abstract:

Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems.

SessionID: 18400

Women in Tech Panel

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: Kathi Kellenberger

Title: Women in Tech Panel

Abstract:

This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women -- and men -- in tech. Everyone welcome to this very interactive session.

SessionID: 18402

T-SQL 2012 Analytic Functions

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 2

Speaker: Kathi Kellenberger

Title: T-SQL 2012 Analytic Functions

Abstract:

Learn how the new analytic functions introduced with SQL Server 2012 can take your T-SQL skills to the next level! Solve complicated requirements with better performing and easier to write queries.

SessionID: 18960

Yesterday I Couldn’t Even Spell ‘DBA’.

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Mixed use

Speaker: Larry Toothman

Title: Yesterday I Couldn’t Even Spell ‘DBA’.

Abstract:

Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator. Once the initial shock passes they realize that they need help. The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help.

SessionID: 19197

Don’t Miss Out on Excel Cube Functions

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 1

Speaker: Meagan Longoria

Title: Don’t Miss Out on Excel Cube Functions

Abstract:

Cube functions have existed since Excel 2007, but they’re not as well known nor as well publicized as other methods to obtain data from Analysis Services/PowerPivot sources. Business Analysts may feel confined to tabular (symmetrical) reports with pivot tables. BI Developers may avoid Excel because they want the ability to write calculations in MDX and the extensive formatting capabilities of Reporting Services. And Power View limits you to the sets, calculations, and captions available in the data source and doesn’t provide drillthrough detail. We’ll start with the basics of how to write and use cube functions, then employ them to build a nicely formatted, asymmetrical, parameter-driven report that overcomes the previously noted limitation

SessionID: 19246

Something Fishy With Power Query

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 1

Speaker: Levi Syck

Title: Something Fishy With Power Query

Abstract:

The public preview of Power Query and the Power BI suite is in full swing. This session will introduce the basics of Power Query

and explore how it can help solve a problem common to many organizations.

SessionID: 19313

Pyramid Analytics - making your cube look good

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 1

Speaker: Leslie Weed

Title: Pyramid Analytics - making your cube look good

Abstract:

Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. Pyramid Analytics is another option for helping create and customize the look and feel of how you look at your data. Join us as we step through this tool and look at advantages it might bring to your enviornment. We will demo the dashboard and customizable UI in this slick tool.

SessionID: 19428

New T-SQL features in SQL Server 2012

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 1

Speaker: Marc Beacom

Title: New T-SQL features in SQL Server 2012

Abstract:

SQL Server 2012 has many new T-SQL features and enhancements that will simplify your code and life. We’ll roll up our sleeves and dive in head first to take a look at some of the new features such as the Sequence object, Date and Time functions, Analytic functions, etc.

SessionID: 19677

Proactively+Automagically Manage your SQL footprin

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 2

Speaker: Mark Marinovic

Title: Proactively+Automagically Manage your SQL footprin

Abstract:

As a DBA I think it's essential to stay proactive and ahead of the game. Using SSIS, SSRS, and a little bit of creativity I cut down the amount of time spent firefighting and come to meetings with quantitative answers for questions like:

How can we do Capacity Planning based on actual data growth trends?
How many databases out there have missing indexes, and what are the indexes?
Are you 100% certain your databases are backed up, even if you haven't seen any failure alerts come through?
Developers' application logs report that SQL sessions were timing out a couple days ago. What was going on in SQL at that time?
What databases are set to Autogrow in too small of increments (and/or growing too frequently)?

SessionID: 21161

What secrets does your database schema hold?

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 2

Speaker: Andre DuBois

Title: What secrets does your database schema hold?

Abstract:

Flaws in database design can hurt you in many ways. This session will look into one of the most basic building blocks, using the correct data type when designing a table. We will look at different databases with best practices in mind to uncover any underlying design flaws in their design. Having a solid foundation can help eliminate data integrity and performance issues that could be lurking. Inconsistent field lengths and data types are examples of secrets that will be unveiled.

SessionID: 22892

Data Vault Data Warehouse Architecture

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 1

Speaker: Jeff Renz

Title: Data Vault Data Warehouse Architecture

Abstract:

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.

SessionID: 23630

Introduction to BIML and BIMLScript

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 1

Speaker: Russel Loski

Title: Introduction to BIML and BIMLScript

Abstract:

Microsoft has provided some great tools for creating and editing SSIS packages. First Business Intelligence Development Studio (BIDS) then SQL Server Data Tools (SSDT). However, when creating an SSIS package you frequently repeat the same steps over and over. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package.In this session we will use BIDS Helper to create a simple SSIS package using BIML. We will handle a couple SSIS scenarios with BIML and BIML Script.

SessionID: 24252

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 2

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 25193

Dimensional Modeling for the Everyday DBA

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 2

Speaker: Scott Shaw

Title: Dimensional Modeling for the Everyday DBA

Abstract:

This session will work to relieve the skepticism and mysticism around dimensional modeling. If, like me, you've grown up in IT with normalization hammered into your head we'll walk through why in large data warehouses and cubes you need to think differently. You'll learn the basic terminology of dimensional modeling and you'll learn where it all started and where it is going. By the end of the session you'll learn to accept denormalization as the solution to some very specific problems.

SessionID: 25685

Capture Change and Apply it With Change Data Capture SSIS

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 1

Speaker: Steve Wake

Title: Capture Change and Apply it With Change Data Capture SSIS

Abstract:

Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.

SessionID: 27115

Sql Server: Now 25% Faster

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: Tristan Wilson

Title: Sql Server: Now 25% Faster

Abstract:

Are you getting the most performance out of your hardware configuration? This session will cover the best tips and tricks that you’ve never heard of to improve performance. We'll cover server configuration, disk layout, and Sql Server settings. If you aren't following these best practices, I'll guarantee a 25% increase in performance, or your money back!

SessionID: 27171

SSRS Development and Administration Basics

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Mixed use

Speaker: Travis Whitley

Title: SSRS Development and Administration Basics

Abstract:

Many SQL Server people may support Reporting Services administratively, but may not know how a report is actually developed - or vice versa. This session will outline some fundamentals of SQL Server Reporting Services, as well as walk through the development of a parameterized report from end to end.

SessionID: 27805

Navigating the Options for Data Redundancy

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: Wendy Pastrick

Title: Navigating the Options for Data Redundancy

Abstract:

SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.

SessionID: 34800

The Hierarchy of Monitoring Needs: A Methodology

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA 1

Speaker: Michael Fal

Title: The Hierarchy of Monitoring Needs: A Methodology

Abstract:

When it comes to the servers in your environment, do you feel alone, afraid, and in the dark ? If we want to know if our servers are healthy, where do we start? It's very easy to feel lost or overwhelmed when you have hundreds, if not thousands, of metrics you can monitor in SQL Server. The Hierarchy of Monitoring Needs provides a clear roadmap for designing your monitoring strategy. This session will review monitoring from a high level, helping you develop a plan from the ground up by addressing critical metrics, business needs, and your overall strategic goals.

SessionID: 9927

SSIS Configurations Vs. Parameters

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 1

Speaker: Allen Smith

Title: SSIS Configurations Vs. Parameters

Abstract:

In this session, we review configurations in SQL 2008R2 and 2012. The 2008R2 options allowed dynamic configuration across environments. SSIS 2012 adds new dynamic options, including Parameters, Expressions and Variables. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so anyone with basic SSIS experience can follow along.

SessionID: 9928

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 2

Speaker: Allen Smith

Abstract:

SessionID: 9954

Loading the Windows Azure Cloud

Back to calendar

Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Developer 1

Speaker: Andy Thiru

Title: Loading the Windows Azure Cloud

Abstract:

Windows Azure provides many options for storing data. SQL Azure is one of Windows Azure’s solutions for working with relational data. If you are familiar with SQL Server, SQL Azure will be a natural extension of your knowledge and skills.

In this session, we will look at the different options for loading data to the Cloud from an on premise SQL server and vice versa. Topics we will cover include:

SQL Azure Data Sync - Migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers.
BACPAC – Importing and Exporting the BACPAC
CDC - loading the Data to cloud by capturing the incremental Changes at ON-Premise (SSIS)
Finally, we will query the System Views for the data movement. What you will learn: • Overview of SQL Azure • SQL Azure Data Sync • BACPAC • Incremental Load to Cloud

This site is open source. Improve this page.