sqlsathistory

Nr: 192

Back to Main list

SQLSaturday #192 - Tampa 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Bradley Ball	Track 8	SQL Internals , Recovery Models, and Backups! OH M
00:00:00	Benjamin Nevarez	Track 6	Top Query Optimizer Topics for Better Performance
00:00:00	Brian Flynn	Track 2	Pivoting Performance Data Pinpointing Problems
00:00:00	Brian K McDonald	Track 1	Reporting Services Deep Dive
00:00:00	Brook Ranne	Track 2	Reporting 101
00:00:00	Christopher Price	Track 3	Building a SSIS Business Rules Engine
00:00:00	David Dye	Track 3	Dealing With Errors in SSIS 2012
00:00:00	Dmitri Korotkevitch	Track 5	"It's MINE" - Intro into locking in SQL Server
00:00:00	Dmitri Korotkevitch	Track 5	"It's THEIRS" - Locking - a step further
00:00:00	Dustin Ryan	Track 3	MDXplosion! Intro To MDX
00:00:00	Ed Watson	Track 7	Backups: Getting the Most Out of Your Storage
00:00:00	Eddie Wuerch	Track 7	Join Us - Getting Started as a Technical Speaker
00:00:00	Eddie Wuerch	Track 6	Partitioning for Perf and Management
00:00:00	Guillermo Caicedo	Track 4	Power View Reporting Enhancements in SQL Server
00:00:00	Janis Griffin	Track 4	Extend Your Knowledge with Extended Events!
00:00:00	Jose Chinchilla	Track 1	PowerPivot+Powerview=Self-service BI Revolution
00:00:00	Joseph D'Antoni	Track 6	SQL 2012 -- All About HA and DR
00:00:00	Jeffrey Garbus	Track 5	Indexing for performance
00:00:00	Jeffrey Garbus	Track 6	Indexing for Join Optimization
00:00:00	Jessica Moss	Track 1	Exploring your Data with Power View
00:00:00	Jose L. Rivera	Track 4	Predictive Analytics at your fingertips
00:00:00	James McAuliffe	Track 4	Database Projects: A Walk Around SQL Server Databa
00:00:00	Jonathan Kehayias	Track 6	Performance Tuning by Digging into the Plan Cache
00:00:00	Jonathan Kehayias	Track 5	Successfully Virtualizing SQL Server in Production
00:00:00	Jonathan Kehayias	Track 5	Free Tools for the DBA
00:00:00	John Welch	Track 3	Moving Big Data - SSIS, Pig, and Sqoop
00:00:00	John Welch	Track 2	Tuning Analysis Services Processing Performance
00:00:00	Jorge Novo	Track 7	SSIS Programming Using .NET
00:00:00	Jorge Segarra	Track 1	What is a BI DBA?
00:00:00	Richie Rump	Track 8	New T-SQL features in SQL Server 2012
00:00:00	Kendal Van Dyke	Track 6	Using PowerShell To Document Your SQL Envronment
00:00:00	Yelena Pavlyuk	Track 2	Report Builder: reports made easy
00:00:00	Maximo Trinidad	Track 4	Extend your T-SQL scripting with PowerShell
00:00:00	Michael Antonovich	Track 2	Hello, My Name is DAX
00:00:00	Mitchell Pearson	Track 3	Building your first SSIS package made easy
00:00:00	Robert Biddle	Track 3	Process Automation with SSIS
00:00:00	Rob Volk	Track 7	Revenge: The SQL Part 2: The Sequel!
00:00:00	Ronald Dameron	Track 8	Sysadmin not always required...
00:00:00	Russell Fustino	Track 8	Building a Windows 8 app from scratch
00:00:00	Scott Klein	Track 8	Kung Fu Migration to Windows Azure SQL Database
00:00:00	Stacia Varga	Track 1	(Way Too Much) Fun with Reporting Services
00:00:00	Stacia Varga	Track 1	A Big Data Primer
00:00:00	Buck Woody	Track 5	Becoming a Data Professional – taking it to the ne
00:00:00	Aaron Nelson	Track 2	PowerShell for Data Professionals
00:00:00	Andy Warren	Track 8	Building Your Professional Development Plan
00:00:00	Arvin Meyer	Track 7	The Database Creation Process

SessionID: 10138

SQL Internals , Recovery Models, and Backups! OH M

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 8

Speaker: Bradley Ball

Title: SQL Internals , Recovery Models, and Backups! OH M

Abstract:

The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? What is a Peicemeal Restore? This is an introduction to these concepts using SQL 2012. In this session you will learn about the internal Structure, Recovery Models, and Backups and be better prepared to for Future Learning and Managing SQL!

SessionID: 10335

Top Query Optimizer Topics for Better Performance

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Benjamin Nevarez

Title: Top Query Optimizer Topics for Better Performance

Abstract:

This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.

SessionID: 10401

Pivoting Performance Data Pinpointing Problems

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 2

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: 10528

Reporting Services Deep Dive

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Brian K McDonald

Title: Reporting Services Deep Dive

Abstract:

SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - Features added in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it **

SessionID: 10899

Reporting 101

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Brook Ranne

Title: Reporting 101

Abstract:

This session will be basic reporting of the different microsoft products excel, access, ssrs. In excel we will connect it to database and create simple report. In access we are going to connect to word and make basic report. In visual studio we are going to make simple ssrs report. This will be simple overview of different ways to create reports. Let's get creative and start creating some reports.

SessionID: 11961

Building a SSIS Business Rules Engine

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Christopher Price

Title: Building a SSIS Business Rules Engine

Abstract:

While DQS in SQL Server 2012 is a powerful tool for enforcing data quality through business rules, often times the time and complexity it takes to set-up is overkill for more mundane common problems. This session will focus on implementing a business rules engine in a SSIS custom component. A flexible, metadata-driven solution will be discussed including considerations for implementation as a custom SSIS component.

SessionID: 12925

Dealing With Errors in SSIS 2012

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: David Dye

Title: Dealing With Errors in SSIS 2012

Abstract:

This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.

SessionID: 13268

"It's MINE" - Intro into locking in SQL Server

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Dmitri Korotkevitch

Title: "It's MINE" - Intro into locking in SQL Server

Abstract:

In this session Dmitri talks about locking in Microsoft SQL Server. He covers various lock types that exist in the product and explains how transaction isolation levels affect locking behavior. Dmitri also discusses why we have blocking in the systems and how to troubleshoot blocking problems and deadlocks.

This is PowerPoint-free session. Only Management Studio, T-SQL Code and bag of candies are in use.

SessionID: 13269

"It's THEIRS" - Locking - a step further

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Dmitri Korotkevitch

Title: "It's THEIRS" - Locking - a step further

Abstract:

In this session Dmitri continues to talk about locking in Microsoft SQL Server. He covers more advanced concepts related to locking such as Schema Locks, Application Locks, Lock Escalation and Optimistic Isolation Levels and discusses how to choose the right transaction strategy for the system.

This is PowerPoint-free session. Only Management Studio, T-SQL Code and bag of candies are in use. Assuming there are still some candies left :)

SessionID: 13500

MDXplosion! Intro To MDX

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Dustin Ryan

Title: MDXplosion! Intro To MDX

Abstract:

The MDX query language is a powerful tool for extracting data from your cube but can often seem confusing and overwhelming to the untrained eye. But have no fear! It's easier than you might think. In this session, attendees will learn the basic MDX query syntax, how to navigate a hierarchy, how to create dynamic time calculations, and how to add calculations to your cube.

SessionID: 13692

Backups: Getting the Most Out of Your Storage

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 7

Speaker: Ed Watson

Title: Backups: Getting the Most Out of Your Storage

Abstract:

In this session we will compare SQL Server's native backups with the compressed backups available in SQL Server 2008 Enterprise, Red Gate's SQL Backup Pro v7, and the various configurations of Red Gate's SQL HyperBac tools. We will compare them with real world scenarios so that you can decide which tool is the best for your scenarios.

SessionID: 14069

Join Us - Getting Started as a Technical Speaker

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 7

Speaker: Eddie Wuerch

Title: Join Us - Getting Started as a Technical Speaker

Abstract:

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session

SessionID: 14070

Partitioning for Perf and Management

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Eddie Wuerch

Title: Partitioning for Perf and Management

Abstract:

Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.

SessionID: 14859

Power View Reporting Enhancements in SQL Server

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Guillermo Caicedo

Title: Power View Reporting Enhancements in SQL Server

Abstract:

Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on Power Pivot workbooks or tabular models deployed to SSAS instances. In this session will dive in to what is needed to create Power View reports and an overview of the reporting enhancements in the new version of SQL Server.

SessionID: 15664

Extend Your Knowledge with Extended Events!

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 4

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: 16118

PowerPivot+Powerview=Self-service BI Revolution

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jose Chinchilla

Title: PowerPivot+Powerview=Self-service BI Revolution

Abstract:

SQL Server 2012 introduced several new features and tools that have sparked the self-service BI revolution. Learn how PowerPivot and the new ad-hoc dashboarding tool called PowerView are revolutionizing the way Business Intelligence is being delivered and consumed by the end users themselves. In this session you will also understand what is the role of IT in this new self-service paradox.

SessionID: 16169

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Joseph D'Antoni

Title: SQL 2012 -- All About HA and DR

Abstract:

Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, the HA and DR options within SQL Server, and finally a demonstration of the new Availability Groups feature in SQL Server 2012 and see them in practice.

SessionID: 16293

Indexing for performance

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Jeffrey Garbus

Title: Indexing for performance

Abstract:

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 16294

Indexing for Join Optimization

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Jeffrey Garbus

Title: Indexing for Join Optimization

Abstract:

Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.

SessionID: 16653

Exploring your Data with Power View

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jessica Moss

Title: Exploring your Data with Power View

Abstract:

Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and how to use each one.

SessionID: 16957

Predictive Analytics at your fingertips

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Jose L. Rivera

Title: Predictive Analytics at your fingertips

Abstract:

The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.

SessionID: 16975

Database Projects: A Walk Around SQL Server Databa

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: James McAuliffe

Title: Database Projects: A Walk Around SQL Server Databa

Abstract:

SQL Server Database Tools (SSDT) provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. SSDT contains visual tools to enable Database Developers or DBAs to:

• Develop tables, views, stored procedures, functions, etc., both live and offline. • Develop and manage partitions, compression, and other advanced features. • Refactor and Rename objects • Maintain database in source control • Perform schema comparisons • Easily deploy database schema updates without having to write complex alter scripts.

SessionID: 17063

Performance Tuning by Digging into the Plan Cache

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Jonathan Kehayias

Title: Performance Tuning by Digging into the Plan Cache

Abstract:

The plan cache in SQL Server 2005 and 2008 has a wealth of information available to assist DBA's in performance tuning. This session will show how to query the plan cache to find plan information and then how to parse the XML plans contained in the cache to identify missing indexes by query, high cost parallel queries with high usage counts, implicit column conversions caused by data type mismatches, and other interesting information about how queries have executed in the system.

SessionID: 17065

Successfully Virtualizing SQL Server in Production

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Jonathan Kehayias

Title: Successfully Virtualizing SQL Server in Production

Abstract:

Virtualization has been growing in popularity for years and changes in Windows Server 2012 and ESX 5 make it so that even high end workloads that demand large amounts of memory, significant I/O, and lots of processing power can be virtualized. With over 8 years of experience virtualizing SQL Server in production, SQL Server MVP Jonathan Kehayias knows what it takes to successfully virtualize SQL Server for production workloads. This session will explain the features that make virtualizing SQL Server possible using both VMware and Hyper-V, and will explain the most common problems businesses encounter trying to virtualize SQL Server.

SessionID: 17068

Free Tools for the DBA

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Jonathan Kehayias

Title: Free Tools for the DBA

Abstract:

Many DBAs don't realize it, but a plethora of free tools are available that make managing SQL Server easier and less time consuming. This session will take a look at a number of these tools and how they can simplify your life as a DBA. Whether you want to analyze trace data, query plans, or performance counter, or maybe just reduce the possibility of having one of those dreaded "Oops, that was production" moments as a DBA, this session will show you how, and the best part is it's all free.

SessionID: 17181

Moving Big Data - SSIS, Pig, and Sqoop

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: John Welch

Title: Moving Big Data - SSIS, Pig, and Sqoop

Abstract:

Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.

SessionID: 17183

Tuning Analysis Services Processing Performance

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: John Welch

Title: Tuning Analysis Services Processing Performance

Abstract:

You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.

SessionID: 17377

SSIS Programming Using .NET

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 7

Speaker: Jorge Novo

Title: SSIS Programming Using .NET

Abstract:

Learn how to create metadata driven ssis using the .net libraries.

Learn how to traverse and extract ssis metadata information across servers. Build ssis packages dynamically for generic ETL solutions.

SessionID: 17380

What is a BI DBA?

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jorge Segarra

Title: What is a BI DBA?

Abstract:

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!

SessionID: 17453

New T-SQL features in SQL Server 2012

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 8

Speaker: Richie Rump

Title: New T-SQL features in SQL Server 2012

Abstract:

With the introduction of SQL Server 2012 data developers have new ways to interact with their databases. This session will review the powerful new analytic windows functions, new ways to generate numeric sequences and new ways to page the results of our queries. Other features that will be discussed are improvements in error handling and new parsing and concatenating features.

SessionID: 18052

Using PowerShell To Document Your SQL Envronment

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Kendal Van Dyke

Title: Using PowerShell To Document Your SQL Envronment

Abstract:

We've all been here before:

• You're the DBA and it seems like every day someone is telling you about some other server you never knew existed but you're responsible for
• You're the consultant and you want to know what SQL Servers your new client has but they can't tell you
• You're the IT Manager and your CTO asks you for an inventory of every SQL Server running in production

How do you go about figuring out where the SQL Servers are, how they're set up, and what they're doing?

This session will give you the answer by demonstrating how to use PowerShell and SQL Server Management Objects (SMO) to discover and document all of your instances - no PowerShell experience required!

SessionID: 19119

Report Builder: reports made easy

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Yelena Pavlyuk

Title: Report Builder: reports made easy

Abstract:

Report Builder is a free and a powerful tool providing familiar Microsoft Office environment and targeted by Microsoft to business users.

See for yourself if you as a developer would like to use this product or convince your power users to give it a try. In this session we'll look at differences between BIDS Report Designer and Report Builder. Then we'll walk through creating some reports to highlight Report Builder features and make a general overview of Report Builder benefits. Also we'll touch a bit on Report Manager that provides a user interface to a report server.

SessionID: 19897

Extend your T-SQL scripting with PowerShell

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Maximo Trinidad

Title: Extend your T-SQL scripting with PowerShell

Abstract:

I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques.

SessionID: 20674

Hello, My Name is DAX

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Michael Antonovich

Title: Hello, My Name is DAX

Abstract:

For anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by just connecting to a custom view. However, for most other data sources (and for those users without development access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. DAX is also used to join tables on multiple columns and to create calculated measures. This session will explore DAX functions and expressions and how they differ from Excel expressions. We will even show how to use DAX expressions to create new measures.

SessionID: 20839

Building your first SSIS package made easy

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Mitchell Pearson

Title: Building your first SSIS package made easy

Abstract:

In this session I will walk you through a complete SSIS package from scratch to finish. The package will hit some of the key SSIS components in the control and data flow and along the way I will emphasize best practices that should always be followed. We will also cover variables and setting expressions on the variables to make the package the dynamic.

SessionID: 23141

Process Automation with SSIS

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Robert Biddle

Title: Process Automation with SSIS

Abstract:

In this session we'll use SSIS in a real-world example to automate processes. We'll look at using Variables and Expressions. We'll look at several items in the Control Flow that can be used to automate a lot of integration processes. We'll import data from MS Excel, save it to a database, export aggregated data into a different format, archive the data source, zip the data source, encrypt the exported file, and submit it via SFTP or email.

SessionID: 23312

Revenge: The SQL Part 2: The Sequel!

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 7

Speaker: Rob Volk

Title: Revenge: The SQL Part 2: The Sequel!

Abstract:

In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!

SessionID: 23437

Sysadmin not always required...

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 8

Speaker: Ronald Dameron

Title: Sysadmin not always required...

Abstract:

I'll describe how I've used the Separation of Duties Framework and a Privileged Identity Management suite to minimize the permissions needed by DBAs to do routine work. I'll review the Separation of Duties Framework and the process I took to arrive at a workable solution that will give DBAs the access they need to maintain the server but not be able to view user data.

SessionID: 23606

Building a Windows 8 app from scratch

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 8

Speaker: Russell Fustino

Title: Building a Windows 8 app from scratch

Abstract:

See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps. You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including:

• A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls.

• Get data locally or from azu

SessionID: 24142

Kung Fu Migration to Windows Azure SQL Database

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 8

Speaker: Scott Klein

Title: Kung Fu Migration to Windows Azure SQL Database

Abstract:

As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master.

SessionID: 24712

(Way Too Much) Fun with Reporting Services

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Stacia Varga

Title: (Way Too Much) Fun with Reporting Services

Abstract:

Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?

SessionID: 24713

A Big Data Primer

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Stacia Varga

Title: A Big Data Primer

Abstract:

The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.

SessionID: 28269

Becoming a Data Professional – taking it to the ne

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Buck Woody

Title: Becoming a Data Professional – taking it to the ne

Abstract:

“What does a “Data Scientist” or a data professional that works in larger sets of data need to know? Buck Woody, a Senior Technical Professional at Microsoft, will explain a few of the major topics you need to be familiar with to enter this new level of working with data. Buck also assisted in the design of the Data Science program at the University of Washington, and teaches a database certification course there.

You’ll learn which areas to study, the types of problem areas this knowledge solves, and how to develop a study plan, along with resources to learn more.

SessionID: 8855

PowerShell for Data Professionals

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

SessionID: 9572

Building Your Professional Development Plan

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 8

Speaker: Andy Warren

Title: Building Your Professional Development Plan

Abstract:

Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.

SessionID: 9876

The Database Creation Process

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Track 7

Speaker: Arvin Meyer

Title: The Database Creation Process

Abstract:

What happens before the flowchart

This site is open source. Improve this page.