sqlsathistory

Nr: 187

Back to Main list

SQLSaturday #187 - Richmond 2013

Start Time (24h) Speaker Track Title
00:00:00 Brandon Leach DBA A DBAs Guide to HIPAA
00:00:00 Tim Chapman Dev Writing faster queries
00:00:00 Tim Chapman DBA SQL Server Index Internals
00:00:00 Nimble Storage Professional Development / Misc How Flash-Optimized Storage Accelerate Performance and Simplify Storage For Virtualized Environments
00:00:00 Geoff Johnson DBA Intro to Common Table Expressions
00:00:00 Grant Fritchey Professional Development / Misc Query Tuning in the Clouds
00:00:00 Grant Fritchey DBA Database Backups for the Accidental DBA
00:00:00 Joseph D'Antoni DBA SQL 2012 -- All About HA and DR
00:00:00 Jessica Moss BI Getting Reports on Your Schedule
00:00:00 Jessica Moss Mixed Women in Technology: Breaking the Glass Ceiling
00:00:00 Jessica Moss Dev Implementing CapTech's Data Management Framework
00:00:00 Jason Hall Dev 5 Common SQL Server Performance Issues
00:00:00 Jason Hall Professional Development / Misc Recipe for a happy DBA
00:00:00 John Welch BI2 Moving Big Data - SSIS, Pig, and Sqoop
00:00:00 John Welch BI2 Unit Testing SSIS Packages
00:00:00 Karen Lopez Mixed Database Design Contentious Issues
00:00:00 Kevin Kline Mixed Team Leadership Fundamentals
00:00:00 Kevin Kline Mixed Top 10 Admininistrator Mistakes on SQL Server
00:00:00 Matt Velic Professional Development / Misc Build your own Virtual Lab
00:00:00 Michael Corey Professional Development / Misc Virtualizing SQL Server 2012: Doing IT Right
00:00:00 Mike Hillwig DBA How Not to Be a Cranky DBA
00:00:00 Paul Oster Dev SQL Server and XML Imports and Exports
00:00:00 Paul Rizza BI Upgrading to SSIS 2012
00:00:00 Philip Noakes BI Realizing the Power of Microsoft Reporting
00:00:00 Rafael Salas BI Waiter, There's a Fly In My Data
00:00:00 Rob Volk Professional Development / Misc Revenge: The SQL Part 2: The Sequel!
00:00:00 Steve Jones Mixed Branding Yourself for a Dream Job
00:00:00 Steve Jones Dev The Encryption Primer
00:00:00 Shannon Lowder Professional Development / Misc OnPremise to Azure
00:00:00 Stacia Varga BI (Way Too Much) Fun with Reporting Services
00:00:00 Melissa Coates BI Dashboards...How To Choose Which MSBI Tool
00:00:00 Melissa Coates BI2 So You Want To Be A Rockstar Report Developer?
00:00:00 Thomas LaRock Mixed Choose Your Own Adventure: Performance Tuning
00:00:00 Kevin Boles Dev Common TSQL Mistakes
00:00:00 Kevin Boles Dev Windowing Functions: THE Reason to Upgrade to 2012
00:00:00 Kevin Hazzard BI2 Creating an Extensible Data Quality Foundation
00:00:00 A.J. Mee BI2 SQL Server 2012's Net-New BI Capabilities
00:00:00 Andy Leonard BI2 “I See a Control Flow Tab. Now What?” (Level 100)
00:00:00 Andy Leonard Mixed Using BIML as an SSIS Design Patterns Engine

SessionID: 10660

A DBAs Guide to HIPAA

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Brandon Leach

Title: A DBAs Guide to HIPAA

Abstract:

In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve.

We'll also dive into several features in SQL Server that can help in this endeavor.

SessionID: 11399

Writing faster queries

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Tim Chapman

Title: Writing faster queries

Abstract:

Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.

SessionID: 11400

SQL Server Index Internals

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Tim Chapman

Title: SQL Server Index Internals

Abstract:

Have you ever wondered what an index actually looks like and performs under the covers? In this talk I'll discuss Index Internals, and how SQL Server creates, maintains, and uses indexes internally for normal operations. I’ll be discussing topics such as index data structures, query optimization (briefly) and maintaining indexes and statistics.

SessionID: 12044

How Flash-Optimized Storage Accelerate Performance and Simplify Storage For Virtualized Environments

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Nimble Storage

Title: How Flash-Optimized Storage Accelerate Performance and Simplify Storage For Virtualized Environments

Abstract:

This presentation will explore the evolution of storage architectures, reviewing the technology inflection points and core business drivers that have propelled the transitions from direct attached to monolithic to modular storage solutions. We are at the beginning of the next major technology inflection driving enterprise storage. Solid state drives (SSDs) promise to solve the performance challenges inherent in spinning disks, rendering traditional storage architectures obsolete. But SSDs by themselves are not the solution. The next decade will be dominated by storage architectures designed from the ground up to leverage the best characteristics of flash and disk. Will these new solutions be able to simultaneously deliver high performance and high capacity primary storage? And can they improve data protection, improving recovery point and recovery time objectives with far less cost and complexity? Learn the answer and examine real-world case studies in this informative session.

SessionID: 14473

Intro to Common Table Expressions

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Geoff Johnson

Title: Intro to Common Table Expressions

Abstract:

Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.

SessionID: 14764

Query Tuning in the Clouds

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Grant Fritchey

Title: Query Tuning in the Clouds

Abstract:

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud.

SessionID: 14765

Database Backups for the Accidental DBA

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Grant Fritchey

Title: Database Backups for the Accidental DBA

Abstract:

You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.

SessionID: 16172

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: DBA

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 presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.

SessionID: 16650

Getting Reports on Your Schedule

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Jessica Moss

Title: Getting Reports on Your Schedule

Abstract:

Too often reports sent on a daily basis end up in a mail filter. Only a small percentage of the reports are actually necessary for someone to take action. How happy would your users be if you could only provide the report when they actually needed to look at it? You can, by using subscriptions and alerts in Reporting Services 2012. This session will provide a comparison of regular subscriptions, data-driven subscriptions, and data-driven alerts in Reporting Services 2012 in SharePoint Integrated mode. Attend this session to learn how to provide reports that will be read rather than filtered.

SessionID: 16651

Women in Technology: Breaking the Glass Ceiling

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Jessica Moss

Title: Women in Technology: Breaking the Glass Ceiling

Abstract:

Join us for this Women in Technology (WIT) panel to discuss career tips, promotion opportunities, and moving your profession forward. Each member will share their background and then will answer questions in an interactive QA session. Both men and women are welcome to attend this informative event!

SessionID: 16652

Implementing CapTech's Data Management Framework

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Jessica Moss

Title: Implementing CapTech's Data Management Framework

Abstract:

It can quickly become overwhelming to track all of your SQL Server Integration Services (SSIS) packages for loading data. Trying to figure out ‘what ran when’ and ‘who did what’ are tasks we've all had to face. CapTech Consulting has successfully solved these common data management problems by implementing a data management framework for multiple organizations. Come to this lunchtime session to learn how to implement your own SSIS framework and to never worry about your SSIS packages again!

SessionID: 16762

5 Common SQL Server Performance Issues

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Jason Hall

Title: 5 Common SQL Server Performance Issues

Abstract:

I spend a large portion of each day looking through performance reports and dashboards from various organizations around the world. I've identified some very common performance problems and/or misunderstandings that tend to have easy, though not always obvious, solutions.

I intend to share the whys and hows of these issues with anyone who would like to attend during a SQL Saturday session.

SessionID: 16763

Recipe for a happy DBA

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Jason Hall

Title: Recipe for a happy DBA

Abstract:

In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid and beginning execution plan analysis.

SessionID: 17184

Moving Big Data - SSIS, Pig, and Sqoop

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI2

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

Unit Testing SSIS Packages

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI2

Speaker: John Welch

Title: Unit Testing SSIS Packages

Abstract:

Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. You will also see how to automate the testing of SSIS packages, using the open source ssisUnit framework. The session will cover several of the common questions about automated unit testing, including how to handle test data , how to set up the environment for multiple developers, and how to make tests flexible.

SessionID: 17904

Database Design Contentious Issues

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.

SessionID: 18185

Team Leadership Fundamentals

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Kevin Kline

Title: Team Leadership Fundamentals

Abstract:

Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn:

  1. What are the fundamental ways that a new leader can build credibility and trust with their team?
  2. What are the unique ways in which IT people are motivated?
  3. How can a leader effectively communicate with their IT team using a variety of communication channels?
  4. How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?

SessionID: 18186

Top 10 Admininistrator Mistakes on SQL Server

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Kevin Kline

Title: Top 10 Admininistrator Mistakes on SQL Server

Abstract:

SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

SessionID: 19873

Build your own Virtual Lab

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Matt Velic

Title: Build your own Virtual Lab

Abstract:

If you don't have the chance to work on different kinds of projects, it can be tough to grow all the necessary skills to further your career. Take control of the situation by building a virtual lab at home.

We'll begin the session by talking about why you might want to build a lab, and what you'll need to complete the task - nothing more than your home computer and free software. We'll review the basics of virtualization as it relates to VirtualBox. Finally, we'll dive into an example of building a Windows Server 2012 cluster, and talk about how you can use these networking and server skills to advance your SQL Server education.

SessionID: 20230

Virtualizing SQL Server 2012: Doing IT Right

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Michael Corey

Title: Virtualizing SQL Server 2012: Doing IT Right

Abstract:

A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA how to virtualize a business critical application like SQL server 2012. It will be based upon experience learned using VMWare as the virtualization platform. But many of the lessons taught will carry over to any virtualized platform.

SessionID: 20556

How Not to Be a Cranky DBA

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Mike Hillwig

Title: How Not to Be a Cranky DBA

Abstract:

Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.

SessionID: 21779

SQL Server and XML Imports and Exports

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Paul Oster

Title: SQL Server and XML Imports and Exports

Abstract:

The discussion will cover beginner and intermediate SQL Server based XML for data export. The discussion will start by covering basic XML generation via SQL Server and XML schema validation, moving on to intermediate XML export. It will then go into a more advanced topic of utilizing XSLT to create robust data import scripts via xlst and xquery/xpath.

SessionID: 21781

Upgrading to SSIS 2012

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Paul Rizza

Title: Upgrading to SSIS 2012

Abstract:

As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort!

SessionID: 22215

Realizing the Power of Microsoft Reporting

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Philip Noakes

Title: Realizing the Power of Microsoft Reporting

Abstract:

Once you’ve loaded your data into a star schema and built an Analysis Services 2008 R2 cube around it, you are ready to harness the power of multi-dimensional analysis. Then, what are your next steps? You need to decide how to create and display reports. Should you go with Reporting Services, PowerView or another reporting tool? This session will explore and demonstrate the different reporting options for deriving business intelligence.

(Co-presented with Jessica Moss)

SessionID: 22952

Waiter, There's a Fly In My Data

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Rafael Salas

Title: Waiter, There's a Fly In My Data

Abstract:

Dealing with bad data is a painful and expensive experience.  In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with  SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals.  You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.

SessionID: 23308

Revenge: The SQL Part 2: The Sequel!

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Rob Volk

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

Abstract:

SessionID: 24466

Branding Yourself for a Dream Job

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 24468

The Encryption Primer

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Steve Jones

Title: The Encryption Primer

Abstract:

Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.

SessionID: 24624

OnPremise to Azure

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Professional Development / Misc

Speaker: Shannon Lowder

Title: OnPremise to Azure

Abstract:

During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.

SessionID: 24715

(Way Too Much) Fun with Reporting Services

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI

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

Dashboards...How To Choose Which MSBI Tool

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Melissa Coates

Title: Dashboards...How To Choose Which MSBI Tool

Abstract:

Compare and contrast how each Microsoft BI tool satisfies requirements for visualization, interactivity, data sources, formatting, printing, and exporting. We'll explore the strengths and limitations of each tool for creating dashboards scorecards with PerformancePoint, Reporting Services, Excel, and Power View. This session will help you with things to consider when selecting one tool in the Microsoft BI stack versus another.

SessionID: 24936

So You Want To Be A Rockstar Report Developer?

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI2

Speaker: Melissa Coates

Title: So You Want To Be A Rockstar Report Developer?

Abstract:

You don't want to settle for being an average Report Developer, right? In this highly interactive session we'll discuss various development, standardization, deployment, and documentation practices that will make your SSRS development life easier, your output of higher quality, increase maintainability, and ultimately save you time. Audience participation and sharing of experiences is encouraged as we cover choices you have for datasets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session focuses primarily on SQL Server Reporting Services 2012, although some concepts may apply to other BI tools as well.  Join us for this this session and take your reporting skills to the next level!

SessionID: 25126

Choose Your Own Adventure: Performance Tuning

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Thomas LaRock

Title: Choose Your Own Adventure: Performance Tuning

Abstract:

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join SQL Server MCM and MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.

SessionID: 26225

Common TSQL Mistakes

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated!

SessionID: 26226

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Dev

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 28232

Creating an Extensible Data Quality Foundation

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI2

Speaker: Kevin Hazzard

Title: Creating an Extensible Data Quality Foundation

Abstract:

Data Quality (DQ) tools are typically expensive and difficult to integrate into your ETL and governance plans but it doesn't have to be that way. During this fun, highly-interactive session, Kevin Hazzard (Microsoft Windows Azure MVP and author of the book Metaprogramming in .NET), will show you how to implement a modular, highly resilient DQ foundation from the tools you already own, no matter which version of SQL Server you're using today. At the end of this discussion, Kevin will give you a copy of his schema and his standard DQ function library that you can use in your own databases.

SessionID: 9104

SQL Server 2012's Net-New BI Capabilities

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI2

Speaker: A.J. Mee

Title: SQL Server 2012's Net-New BI Capabilities

Abstract:

Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including: · Power View · BI Semantic Model (BISM) · Data Quality Services · Master Data Management · Columnstore Index

SessionID: 9522

“I See a Control Flow Tab. Now What?” (Level 100)

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: BI2

Speaker: Andy Leonard

Title: “I See a Control Flow Tab. Now What?” (Level 100)

Abstract:

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

SessionID: 9523

Using BIML as an SSIS Design Patterns Engine

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Mixed

Speaker: Andy Leonard

Title: Using BIML as an SSIS Design Patterns Engine

Abstract:

Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.

This site is open source. Improve this page.