sqlsathistory

Nr: 167

Back to Main list

SQLSaturday #167 - Columbus GA 2012

Start Time (24h) Speaker Track Title
00:00:00 Brian K McDonald Track 2 Reporting Services Deep Dive
00:00:00 Julie Smith Track 2 Data Quality Services--Finally!
00:00:00 Christopher Price Track 3 Integrating DQS, MDS and Your Data Warehouse
00:00:00 Christopher Price Track 2 Introduction to Master Data Services 2012
00:00:00 Erik Monchen Track 2 End users have a short attention span
00:00:00 Geoff Hiten Track 4 Bad SQL
00:00:00 Geoff Hiten Track 1 SQL 2012 AlwaysOn
00:00:00 Jon Boulineau Track 3 T-SQL: Beyond the Basics
00:00:00 Jim Wooley Track 4 Managing Schema Changes - Visual Studio and SSDT
00:00:00 Devin Knight Track 4 Adapting your ETL Solutions to use SSIS 2012
00:00:00 Devin Knight Track 1 Designing Your First Power View Report
00:00:00 Mark Swofford Track 1 I Shoulda Taken That Left Turn at Albuquerque...
00:00:00 Michael French Track 1 Independent Contracting 101
00:00:00 Pam Shaw Track 2 Tips Tricks for dynamic SSRS Reports
00:00:00 Chad Churchwell Track 3 Designing An Efficient Replication Topology
00:00:00 Stuart Ainsworth Track 4 The Agile DBA: Managing your To-Do List
00:00:00 Kevin Boles Track 2 SQL Server 2012 Column Store Index
00:00:00 Tim Radney Track 3 Reducing Your Storage Footprint
00:00:00 Thomas Norman Track 3 Production is all Virtualized, Is Yours?
00:00:00 Thomas Norman Track 1 PBM and You!
00:00:00 Andy Thiru Track 1 Windows Azure SQL Database Intro and what’s New
00:00:00 William E Pearson III Track 4 Getting Started with MDX: The (Very) Basics
00:00:00 Aaron Nelson Track 4 PowerShell for Data Professionals
00:00:00 Robert Cain Track 3 The Decoder Ring for Data Warehousing / BI

SessionID: 10529

Reporting Services Deep Dive

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2

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? - New Features included 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: 11109

Data Quality Services--Finally!

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Julie Smith

Title: Data Quality Services--Finally!

Abstract:

Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create a Knowledge Base, how to create Data Cleansing Projects to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Projects can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together.

SessionID: 11940

Integrating DQS, MDS and Your Data Warehouse

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Christopher Price

Title: Integrating DQS, MDS and Your Data Warehouse

Abstract:

With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.

SessionID: 11941

Introduction to Master Data Services 2012

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Christopher Price

Title: Introduction to Master Data Services 2012

Abstract:

Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.

SessionID: 13924

End users have a short attention span

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Erik Monchen

Title: End users have a short attention span

Abstract:

As a BI Administrator or report designer, you've probably been asked many times by the business to create a dashboard to present some data. What makes a good dashboard though? The more information, the better? The more colors, the better? In this session you will get tips about designing dashboards, graphs, tables, gauges and maps with the goal of how you can impress your end user with the most efficient designed reports. This session is less technical than others, since it covers aspects and tips that you can take into consideration to create your reports as clear, understandable and usable as possible. The session consists of some general tips and tricks, followed by examples of designs and how to optimize these.

SessionID: 14484

Bad SQL

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Geoff Hiten

Title: Bad SQL

Abstract:

Good Code, Bad Code. It can be the difference between a server running smoothly and an unresponsive piece of junk. This session digs into what makes some SQL code perform faster and scale better. Session is almost all interactive demo.

SessionID: 14485

SQL 2012 AlwaysOn

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Geoff Hiten

Title: SQL 2012 AlwaysOn

Abstract:

AlwaysOn is the new High Availability technology suite for Microsoft SQL Server 2012 that allows for multiple HA and DR solutions along with hardware reuse and reporting scale-out. Learn what AlwaysOn can do and how it works.

SessionID: 16081

T-SQL: Beyond the Basics

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Jon Boulineau

Title: T-SQL: Beyond the Basics

Abstract:

If you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.

SessionID: 16863

Managing Schema Changes - Visual Studio and SSDT

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Jim Wooley

Title: Managing Schema Changes - Visual Studio and SSDT

Abstract:

As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio and SSDT to help manage these changes better.

SessionID: 18635

Adapting your ETL Solutions to use SSIS 2012

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Devin Knight

Title: Adapting your ETL Solutions to use SSIS 2012

Abstract:

With all the great new features added to SSIS in SQL Server 2012 it is important to understand how they can make your development life easier. This session will not only highlight what is new in SSIS but also show how your existing solutions can be adapted to utilize the latest features. Topics will include changes to usability, deployment, configuration and management.

SessionID: 18636

Designing Your First Power View Report

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Devin Knight

Title: Designing Your First Power View Report

Abstract:

Power View has the capability of creating eye-popping visualizations within SharePoint 2010. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. In this session you will learn how to design your own dazzling reports using Power View.

SessionID: 19613

I Shoulda Taken That Left Turn at Albuquerque...

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Mark Swofford

Title: I Shoulda Taken That Left Turn at Albuquerque...

Abstract:

The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role. To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals.

Organization, planning, and having a roadmap to where you are going will be crucial to your success. This session will bring these topics together so you can set your GPS to success avenue.

SessionID: 20243

Independent Contracting 101

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Michael French

Title: Independent Contracting 101

Abstract:

WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology.

SessionID: 22355

Tips Tricks for dynamic SSRS Reports

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Pam Shaw

Title: Tips Tricks for dynamic SSRS Reports

Abstract:

In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

SessionID: 24911

Designing An Efficient Replication Topology

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Chad Churchwell

Title: Designing An Efficient Replication Topology

Abstract:

This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve specific business needs will also be covered.

SessionID: 25831

The Agile DBA: Managing your To-Do List

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Stuart Ainsworth

Title: The Agile DBA: Managing your To-Do List

Abstract:

SessionID: 26248

SQL Server 2012 Column Store Index

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Boles

Title: SQL Server 2012 Column Store Index

Abstract:

Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

SessionID: 26702

Reducing Your Storage Footprint

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Tim Radney

Title: Reducing Your Storage Footprint

Abstract:

In this session I will discuss and show the benefits of utilizing compression. I will be demonstrating native SQL Compression as well as a third party tool. I will show examples of my real world testing and share the numerous benefits of SQL Compression.

SessionID: 26926

Production is all Virtualized, Is Yours?

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Thomas Norman

Title: Production is all Virtualized, Is Yours?

Abstract:

I don't know how the Sql Server will perform! You can't do that! Yes, we can! Yes, we did! It runs better than our physical server. Need to add a CPU in less than 5 minutes, no problem. Need more memory, sure. Give me 5 minutes. Thin provisioning, thick provisioning? Can I put as many Sql Servers as I want on the Host? What is a Host and a Guest? What is causing my Sql Server to run slow, is it the virtual, operating system or Sql Server? How do I know? What is the licensing for Sql Server? How do you monitor it? How is it working? Let’s find all of these answers.

SessionID: 26927

PBM and You!

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Thomas Norman

Title: PBM and You!

Abstract:

Peanut Butter and Mayonnaise? No, Policy Based Management What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? Who is that masked man you got into my database. You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers.

SessionID: 27333

Windows Azure SQL Database Intro and what’s New

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Andy Thiru

Title: Windows Azure SQL Database Intro and what’s New

Abstract:

In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure

SessionID: 28034

Getting Started with MDX: The (Very) Basics

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: William E Pearson III

Title: Getting Started with MDX: The (Very) Basics

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

SessionID: 8849

PowerShell for Data Professionals

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4

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

The Decoder Ring for Data Warehousing / BI

Back to calendar

Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Robert Cain

Title: The Decoder Ring for Data Warehousing / BI

Abstract:

Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean.

This site is open source. Improve this page.