SQLSaturday #131 - Phoenix 2012

Event Date: 04/28/2012 00:00:00

Event Location:

Chandler-Gilbert Community College Pecos Campus
2626 East Pecos Road
Chandler, Arizona

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Mobile BI with SSRS and SharePoint

Abstract: Today’s executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let’s help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let’s discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We’ll look at iPad and other mobile devices, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices.

Speaker(s):

Angel Abundez

Track and Room: BI Delivery - N/A

Title: SQL Server 2012 Memory Manager Changes

Abstract: The SQLOS component is an internal user mode OS enrichment layer for SQL Server that delivers necessary system level services such as co-operative user mode scheduling, memory management, deadlock detection and exception handling to SQL Server components. One of the investments we made for SQL Server 2012 is to refactor the Memory Manager subcomponent in SQLOS to allow users to predictably size the SQL Server memory consumption in addition to performance scalability improvements. Come learn about what this change means for sizing memory for workloads in SQL Server 2012. You will also hear about related DMV and performance counter changes for this improvement.

Speaker(s):

Gus Apostol

Track and Room: Microsoft - N/A

Title: Real-time Data Warehouse and Reporting

Abstract: This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Carlos Bossy will show you how to use SQL Server features such as Replication, Change Data Capture, SSIS and other techniques to extract, transform and load data fast and dependably and view a real demonstration of the system in action. Finally, Carlos will show how to use Reporting Services to present data with a minimum amount of latency.

Speaker(s):

Carlos Bossy

Track and Room: BI Architecture - N/A

Title: BISM Partitions, Security and Hierarchies

Abstract: PowerPivot took end users a long way towards creating some amazing self-service data models that we are starting to find are very valuable to the business. Now how do we take these models to the next level and truly allow enterprise access to something that may have just lived in a team site previously? This is where the new features of Business Intelligence Semantic Models (BISM) come into play. We will take a BISM model from its baseline roots of a PowerPivot and drive it to the enterprise level showcasing partitioning, security, and hierarchies while explaining how these will come into play in a real world business scenario.

Speaker(s):

Tom Marek

Track and Room: BI Architecture - N/A

Title: SQL Considerations for SharePoint 2010 Farms

Abstract:

SharePoint is to be hosted on your SQL farm… Now what?

In this session, we will cover the basic need to know for SQL administrators who are now responsible for SharePoint’s DBs.
In our journey, topics we will cover will be, Farm sizing’s architecture to considerations for Enterprise Search and considerations for crawling the dreaded G:\, H:\ Z:\ drives, To the myriad of SharePoint Databases and which to watch out for. And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU RAM.

Speaker(s):

Andrew Thornton-Smith

Track and Room: BI Delivery - N/A

Title: Documenting Your Integrated Microsoft BI Solution

Abstract: Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”

Speaker(s):

William E Pearson III

Track and Room: Professional Development / Azure - N/A

Title: Fast-track to BI Analytics with SQL Server 2012

Abstract: SQL Server 2012 has made it easier to make the move to Business Intelligence and in this session Carlos Bossy will present three new features you can (and should) implement immediately. The new Analytics functions in T-SQL, Columnstore indexes, and the Tabular model are powerful features that will give your users the ability to analyze data in a faster, more effective manner. Each of these features was targeted at casual or beginning BI developers and DBAs who more familiar with traditional relational database models. You will leave this session with a good understanding of the next steps to take to get on the fast-track to BI.

Speaker(s):

Carlos Bossy

Track and Room: BI Architecture - N/A

Title: T-SQL Utilities for Serious DBAs

Abstract: Don’t miss this useful six pack of production-quality, system-level stored procedures. Source code is fully documented, and contains many valuable tips for querying SQL Server system views. The author will demonstrate each utility, and offer suggestions for extending it.

Speaker(s):

Tom Kallal

Track and Room: App Dev / DBA - N/A

Title: Data Cleansing Using the “Scrubbing Bubbles” of SS

Abstract: Got data that is a mess that you have been asked to clean up before loading into your data warehouse? Come learn from this demo packed session the various components and techniques in SSIS for cleaning messy data including removing duplicates, removing unwanted characters and words. Become less “fuzzy” about the cleansing powers of fuzzy grouping and fuzzy lookups.

Speaker(s):

Amy Lewis

Track and Room: SSIS - N/A

Title: Beyond Plateaux: Optimize SSAS with Best Practices

Abstract: Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.

Speaker(s):

William E Pearson III

Track and Room: BI Architecture - N/A

Title: “Ad Hoc Analytics – Can my customer do that?”

Abstract: In a customer service based business world the newest feature being offered to clients in many industries is access to their data for ad hoc analytics. Agile players in many industries are stealing away market share because of this additional feature they can offer and in turn is forcing big players in every industry to just keep up to hold their ground. SQL Server 2012 will be in the middle of this battle and will give us the ability to deliver this feature without building the entire system from scratch. This feature is brought to us by using the new Power View and Business Intelligence Semantic Model all surfaced using SharePoint 2010.

** This session will be co-presented by Jacob Wilson who is a SharePoint MCM **

Speaker(s):

Tom Marek

Track and Room: BI Delivery - N/A

Title: Transact-SQL does Windows

Abstract: According to Itzik Ben-Gan: “Windowing functions are the best thing to happen since sliced bread”. In SQL Server 2005, Microsoft introduced SQL Windowing into Transact-SQL with new ranking functions and existing aggregate functions. This gave the Transact-SQL developer the ability to easily generate row numbers and compute sums, averages, etc. while returning detailed data rows. But the ANSI/ISO SQL standard had defined additional windowing functionality and SQL Server 2012 now supports more of it. This includes the ability to frame the scope of the window and new functions like LAG, LEAD, FIRST_VALUE and LAST_VALUE. These enhancements extend the set-based functionality of Transact-SQL.

Speaker(s):

Jeff Jones

Track and Room: App Dev - N/A

Title: Training Certifications for SQL Server 2012

Abstract: Are you interested in becoming certified in SQL Server? Do you already hold a SQL certification and wonder about getting certified in the new program? In this session, David ikeda will provide an overview of the certifications and training offered by Microsoft for SQL Server 2012. We’ll discuss the value of being certified, and then discuss the different certifications, upgrade paths and the related training options offered by Microsoft Learning.

Speaker(s):

David Ikeda

Track and Room: Professional Development / Azure - N/A

Title: Introduction to SQL Server 2012 AlwaysON

Abstract: In this session, you’ll learn how to configure and implement SQL Server AlwaysOn Availability groups. We’ll explore the architecture, concepts, and steps for configuring High Availability in SQL Server 2012

Speaker(s):

David Ikeda

Track and Room: Microsoft - N/A

Title: Dynamic MDX: Packing a Punch into One .rdl

Abstract: Dynamic MDX can be a great way to reuse, reduce, and recycle .rdls and simplify report maintenance. Have a lot of reports that are practically the same, minus a few pesky exceptions? Dynamic MDX could be the answer! In this session we’ll walk through how to create a basic .rdl that can support a variety of MDX queries that will be generated dynamically. We will also discuss the pros and cons of this approach so that you can make an informed decision of when and if Dynamic MDX is the solution for you.

Speaker(s):

Erika Bakse

Track and Room: BI Delivery - N/A

Title: Stupid SQL and the Programmers that Write it

Abstract: You work with smart people, but there you are in a code review of a co-worker’s SQL ready to be rushed into production and it is so elaborately stupid that you don’t know where to start. How did we get here? Why is the level of SQL literacy so low? There are two goals in the session. First, we will look at lot’s of stupid SQL. Second, we will talk about how to encourage co-workers to write better SQL. Looking at stupid SQL can help even experienced programmers as we examine why something is wrong. Along the way, we note where SQL Server itself is stupid (e.g. the IsNumeric function) We will also look at some places where some subtleties of SQL can trip even an experienced Pro.

Speaker(s):

Mark Bosley

Track and Room: App Dev - N/A

Title: Understanding SQL Server XML Features

Abstract: The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA’s shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.

Speaker(s):

Randy Knight

Track and Room: App Dev / DBA - N/A

Title: Think Outside the Group! Take MDX to the next leve

Abstract: Reporting Services is a powerful tool that can make designing reports a snap…most of the time. But every once in a while you have to format a report very specifically, and that starts with your data query. In this session, we’ll think outside the group! Learn about how to use named sets, dummy members, and other MDX tricks to craft your queries in a way that allows you to conquer the trickiest report layouts.

Speaker(s):

Erika Bakse

Track and Room: BI Delivery - N/A

Title: DW Architecture: More than just Facts Dimensions

Abstract: Facts and Dimensions are the essence of any Data Warehouse, but there are many other components required to make the environment scalable, flexible and fully automated.

There are lots of decisions to be made: Should you have a separate database for staging or not? How do you fully automate the ETL sub-system and parameterize it?

In this session we will discuss a practical approach to designing the Data Warehouse back-end, based on personal experience.

Speaker(s):

Martin Schoombee

Track and Room: BI Architecture - N/A

Title: The Best Dashboard on the Block

Abstract: Many BI developers are familiar with generating dashboards using Performance Point or other drag and drop non-coding solutions. However, it’s time to take it up a notch. Come to my session and learn how to develop amazing interactive Silverlight dashboard applications that impress your users but doesn’t cost your company an arm and a leg. After attending my session you will learn the basics about Silverlight, WCF, and very simple to implement 3rd party controls which take your dashboard from basic to amazing. Rest assured you don’t have to be an expert in web development to be successful in creating a dashboard in Silverlight that simply rocks.

Speaker(s):

Jeff Renz

Track and Room: BI Delivery - N/A

Title: 6 Steps to a Stellar Performance Review

Abstract: Being a database professional can be a thankless job. No one thinks about the database when it works well. So how do you get the proper recognition when performance review time rolls around? How do you distinguish yourselves among your peers? This session will cover 6 things you can focus on to ace your next performance review!

Speaker(s):

Wil Sisney

Track and Room: Professional Development / Azure - N/A

Title: The 2012 Data Warehouse Architecture Debate

Abstract: Data vault is a compelling new architecture for an enterprise data warehouse. Star schema data warehouses are the most well-known design pattern in the industry. Are hub, link and satellite tables your cup of tea or are you more of a fact and dimension type of person? Come with an open mind to our session and cast your vote for the architecture that you prefer. No matter which way you vote, you will come away with a deeper understanding of the data vault and star schema architectures, the pros and cons of both, and new implementation techniques to leverage new features of SQL Server 2012.

Speaker(s):

Jeff Renz

Track and Room: BI Architecture - N/A

Title: Become Bilingual! Oracle for the SQL Server DBA

Abstract: In today’s enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA’s for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.

Speaker(s):

Randy Knight

Track and Room: App Dev / DBA - N/A

Title: How To Create A BI Semantic Model

Abstract: This session will demonstrate how a BI semantic model is created, how it’s used once it’s created, and how to maintain it once it’s deployed. The BI semantic model is a critical component in the new SQL 2012 BI capabilities.

Speaker(s):

Jason Volpe

Track and Room: BI Architecture - N/A

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 and cheer as SQL Server MVP Stacia Misner is challenged by her progeny and protégé Erika Bakse to an hour of word play, all wrapped up in SQL Server Reporting Services. They’ll push the limits with what can be built in SSRS and have a stupid amount of fun while doing it. Swag, trash talk, board games and SQL…who could ask for more?

Speaker(s):

Stacia Varga

Track and Room: BI Delivery - N/A

Title: The Ins and Outs of PowerView

Abstract: In this session, we’ll demonstrate how to build reports in the new SQL Server 2012 PowerView reporting toolset. In addition, we’ll tackle some of the more complex features so you, too, can build beautiful looking reports.

Speaker(s):

Jason Volpe

Track and Room: Microsoft - N/A

Title: Data Visualization in Reporting Services

Abstract: Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what’s new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.

Speaker(s):

Stacia Varga

Track and Room: BI Delivery - N/A

Title: “BEGIN…COMMIT” is Not Enough

Abstract: Understanding Transactions Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance.

Speaker(s):

Denise McInerney

Track and Room: App Dev / DBA - N/A

Title: Many-to-Many: Multiple Calendars in a Single Cube

Abstract: Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes’ date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services “many-to-many” dimension scenario.

Speaker(s):

William E Pearson III

Track and Room: BI Architecture - N/A

Title: Advanced SQL Server Integration Services

Abstract: This is a demo intensive deep dive showing a variety of SSIS methods that you can use to load unstructured text files, gigabyte size files, images, XML, Excel, email, and binary files. I will share techniques that allow files to be loaded in real time with a queue system to load small files separate from large files, file merging for fast loading, and parallel file loading using master/child packages and custom SSIS objects. Finally, I will share useful C# code for parsing complex strings, data manipulation and file archival.

Speaker(s):

Jeff Renz

Track and Room: SSIS - N/A

Title: But it worked great in Dev! Perfomance for Devs

Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.

Speaker(s):

Randy Knight

Track and Room: App Dev - N/A

Title: Temporal Fact Tables: The Road Less Traveled

Abstract: Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate.

In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations.

Speaker(s):

Martin Schoombee

Track and Room: BI Architecture - N/A

Title: Troubleshooting SQL Server Performance

Abstract: SQL Server database administrators need to proactively prevent or minimize performance problems when they occur, and diagnose the cause to take the appropriate corrective action. The reasons for performance problems can range from a poorly designed database to a system that is improperly configured for the workload. This talk will focus on understanding common performance problems, diagnosing and troubleshooting using publicly available tools, and provide a general methodology for diagnosing and troubleshooting SQL Server performance problems using common customer scenarios.

Speaker(s):

Gus Apostol

Track and Room: Microsoft - N/A

Title: What Does SQL 2012 Mean For SharePoint

Abstract: With over 500 new features coming in SQL Server 2012, it’s important to clearly illustrate how those new features impact SharePoint and what you need to be aware of. SharePoint is the cornerstone for collaboration in the Microsoft Business Intelligence Platform so make sure you know what to look out for as well as what you can take advantage of in the new SQL Server 2012 Platform.

Speaker(s):

Jason Volpe

Track and Room: Microsoft - N/A

Title: Power View: A Peek Behind the Curtain

Abstract: Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View .

Speaker(s):

Stacia Varga

Track and Room: BI Delivery - N/A

Title: 5 SSIS Tricks to Take You from Beginner to Awesome

Abstract: You know how to create a connection manager, and you can extract data to a flat file. So how do you get past basic package creation? This presentation will cover 5 high-level techniques you can use to become the “go-to” person for SSIS in your organization. This session will be packed with demos of packages you can use to achieve SSIS Awesomeness!

Speaker(s):

Wil Sisney

Track and Room: SSIS - N/A

Title: Encryption in SQL Server

Abstract: There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion.

Speaker(s):

Steve Jones

Track and Room: App Dev - N/A

Title: Powershell for the DBA

Abstract: This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive. This will also include examples for SQL Server 2012.

Speaker(s):

Colin Smith

Track and Room: DBA - N/A

Title: What’s New in SQL Server 2012 SSIS Development

Abstract: Since its initial release in Microsoft SQL Server 2005, Integration Services has been incrementally improved in each subsequent version. However, those changes were minor in comparison to the major enhancements, performance improvements, and new features introduced in SQL Server 2012 Integration Services. These changes can be organized into the categories of development, deployment and administration. This presentation will be focused on what’s new in SQL Server 2012 SSIS development.

Speaker(s):

Brad Baker

Track and Room: SSIS - N/A

Title: SSAS/MDX - Performing “point in time” analysis

Abstract: In this talk, we discuss how to use the LastNonEmpty AggregateFunction available in SSAS Enterprise Edition to enable “point in time” reporting and analysis. We’ll also discuss point in time reporting strategies if you don’t have SSAS Enterprise Edition.

Speaker(s):

Josh Sivey

Track and Room: BI Architecture - N/A

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.

Speaker(s):

Steve Jones

Track and Room: Professional Development / Azure - N/A

Title: Replication Basics

Abstract: Let’s cover the basics of setting up and monitoring SQL server Replication. I will focus on configuring transactional replication including options for the distributor, and where to run your log reader agents - but rest assured we will touch on merge and snapshot replication as well.

Speaker(s):

Meredith Ryan-Smith

Track and Room: App Dev / DBA - N/A

Title: SSRS 2012 and SharePoint 2010 Integration

Abstract: No more SSRS report database??? Learn about the new SSRS architecture in SQL 2012 for SharePoint 2010 integration and how the architecture has been pushed away from SQL into SharePoint.

Speaker(s):

Jacob Wilson

Track and Room: BI Delivery - N/A

Title: Backup Basics - Know your options

Abstract: Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.

Speaker(s):

Meredith Ryan-Smith

Track and Room: DBA - N/A

Title: What’s this columnstore index thing all about?

Abstract: Let’s take a look at this new feature of SQL 2012 and see if we truly can get PowerPivot Performance in a database. After that we will cover potential use cases and identify where it can be used in your org.

Speaker(s):

Matt Smith

Track and Room: BI Architecture - N/A

Title: SSAS - Usage Based Optimization

Abstract: Join me in learning how to design aggregations for your SSAS cubes using Usage Based Optimization. We’ll learn about capturing usage patterns in the SSAS query log and then using that log information to help the Agregation Design Wizard design aggregations to improve the overall performance of a partition.

Speaker(s):

Josh Sivey

Track and Room: BI Architecture - N/A

Title: Using TVPs in .Net applications

Abstract: SQL Server introduced the ability to define TVPs (aka, User-Defined Table Types) as a Read-Only parameter-type in stored procedures. As usual, the .Net out-of-the-box experience is not the most performant. To truly realize the full performance benefit with passing data from a .Net application via a TVP requires additional development.

Speaker(s):

Robert Miller

Track and Room: App Dev - N/A

Title: Best Practices for Monitoring Databases on VMware

Abstract: SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

Speaker(s):

Kathy Gibbs

Track and Room: DBA - N/A

Title: SSIS 2012 Mgmt Considerations Best Practices

Abstract: SSIS 2012 Management Considerations and Best PracticesSQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages.

Speaker(s):

Rushabh Mehta

Track and Room: SSIS - N/A

Title: What is this cache and how did it get so big?

Abstract: Ever wonder what’s in your SQL Plan cache? Wonder why or how the plan cache got so big? This session will cover what the cache is, how it is used, and how poor application and query design can make it worse. Rather than put participants to sleep with dozens of slides we will get down and dirty with lots of demos including .Net code and some cool DMVs to guide the way.

Speaker(s):

Doug Brendle

Track and Room: DBA - N/A

Title: Migrating Oracle to SQL Server

Abstract: Session will cover overall method to migrate from an Oracle database to a SQL Server database. Will address architecture. Key components: Methodology, Demonstration of SSMA (Reports, potentially data migration itself, time permitting) (Using Oracle 11i database(data warehouse structure) to SQL Server 2012.)

Speaker(s):

Lou Carbone

Track and Room: Microsoft - N/A

Title: Using Change Tracking and Change Data Capture

Abstract: Review and compare Change-Tracking and Change Data Capture functionality.

Speaker(s):

Robert Miller

Track and Room: App Dev - N/A

Title: Automation and Monitoring for the DBA

Abstract: Are you finding your mornings filled with busy work? Trying to manage a large and growing number of SQL servers and feeling a bit overwhelmed? We’ll take a look at tools that can help such as the SQL Server Tacklebox and a monitoring tool with a funny name - Zabbix. http://data.samgreene.com for more info.

Speaker(s):

Samuel greene

Track and Room: DBA - N/A

Title: Agile modeling and reporting with BISM and Azure

Abstract: In this session you will learn how to integrate Azure Marketplace data and other Odata feeds into your Semantic Model to provide rich and robust modeling and reporting without the need to create complex workflows or copy and paste formulas every time you manually integrate external data. You will also learn how to publish your data to the marketplace and the roadmap for Microsoft’s private data hubs – bringing the power of the Azure Marketplace to your datacenter.

Speaker(s):

Kathrine Lord

Track and Room: Professional Development / Azure - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Meredith Ryan-Smith

Twitter: - @coffegrl

Contact: http://meredithryansmith.wordpress.com

Meredith is the database administrator for The Bell Group. With more than 10 years of experience in IT, Meredith’s responsibilities have included everything from manning the Help Desk to VAX/VMS cluster administration. Most recently she has served as the production database administrator specializing in cluster administration and performance. Meredith has attended seven PASS Summits, and had volunteered with the WIT Virtual Chapter since early 2009. Most recently Meredith became the chapter leader for the Women In Technology Virtual Chapter, and has kept busy speaking at SQLSaturday events in the western half of the US.

Samuel greene

Contact: http://data.samgreene.com

I’m a the lead DBA for Mesa, the 36th largest city in the US, closing in on 500,000 people.

David Ikeda

David Ikeda is a Technology Architect at the Microsoft Technology Center in Irvine focusing on SQL Server Solutions. He has been working for Microsoft Corporation for 19 years architecting and implementing mission critical high scale transactional systems and large scale data warehouses. David is a 2008 SQL Server MCM and has guided and developed the Microsoft Certified Masters and Architect certifications for SQL Server.

Mark Bosley

Mark Bosley has been programming SQL ( DB2, Oracle, most SQL Server) for close to 20 years. He has worked in Corporate offices and in Internet startup studios–serving in various roles from data modeler to digital janitor. SQL, Regexes and XPath–he will do anything to save himself from writing procedural code. He has read Joe Celko’s SQL for Smarties cover to cover, which pretty much qualifies him in his mind as a Smarty

Colin Smith

Twitter: - @smithco32

Contact: http://itknowledgeexchange.techtarget.com/dba/

I am a SQL Server and Oracle DBA. I focus mostly on SQL Server. I use Powershell every day and I make my life as a DBA much easier by scripting most tasks in Powershell. I enjoy helping others with Powershell and SQL Server, even though I claim to be an expert in neither. I enjoy technology and spending time with my wife and new child.

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Lou Carbone

Lou Carbone is a Solutions Architect at Microsoft. He is also their US Database and Business Intelligence Communities Leader. Lou has over 30 years of experience in IT, with a consistent focus on data, database and data architectures. Prior to Microsoft, Lou has worked at ATT, Quest Diagnostics, Oracle, JP Morgan Chase and Coach where he has architected a number of large-scale implementations across diverse technologies.

Tom Kallal

Tom is a data architect with 20 years of experience in multiple industries. He specializes in data modeling, T-SQL programming, data warehousing and BI. He is a frequent contributor to the Phoenix Chapter of the SQL Server User’s Group.

Jason Volpe

Contact: http://jasonvolpe.com

will populate at a later time

Wil Sisney

Twitter: - @HanSQL

Contact: http://www.wilsisney.com

Wil Sisney is a senior database administrator for a large health insurance company, managing business-critical databases. Wil is a Microsoft Certified Professional, holding MCITP certifications in Administration and Development in SQL Server 2008. When Wil isn’t speaking about SQL Server, he’s saving the world from zombies with his website www.zombieprep.net. Find Wil online at: http://www.wilsisney.com

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Robert Miller

Twitter: - https://twitter.com/RobertMiller

LinkedIn: Robert Miller

Contact: http://sqlhuman.com

Robert Miller has managed Microsoft SQL Server implementations for the past twenty years. Additional, he is an accomplished architect, application developer, SAN and Systems administrator. In addition to Microsoft SQL Server, he has experience with Oracle and VMS/Rdb database environments. Robert#39;s specialty is working in and architecting high-performance, high-availability environments.

Denise McInerney

Twitter: - @denisemc06

LinkedIn: Denise McInerney

Contact: http://weblogs.sqlteam.com/denisem/default.aspx

Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Jason Volpe

Contact: http://jasonvolpe.com

will populate at a later time

Kathrine Lord

Kathrine Lord is the Global Business Intelligent Director at Avanade Inc. She joined Avanade in November, 2011 after working at Microsoft for over 11 years. Prior to working at Microsoft she was in roles spanning developer, project manager, and IT Director before she landed as the CIO for a state agency here in Arizona. She traveled throughout the US frequently in her previous roles and joined Avanade with the hope of traveling internationally to work with global companies solving their BI.

Erika Bakse

Erika Bakse began her business intelligence career three years ago when she joined the Data Inspirations team. She has helped develop training curricula for use of the various SQL Server business intelligence technologies and is a contributing author of Microsoft SQL Server 2008 Reporting Services Step by Step (Microsoft Press, 2006). Her blog is available at erikasblog.datainspirations.com, and she tweets as @BakseDoesBI

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Meredith Ryan-Smith

Twitter: - @coffegrl

Contact: http://meredithryansmith.wordpress.com

Doug Brendle

Twitter: - @sql_db

Doug Brendle is a Solution Architect with Scalability Experts and has worked with SQL Server for over 10 years covering 7.0 to 2008r2. In one capacity or another he’s been involved with one database platform or another for over (almost entirely SQL Server from SQL Server, but with also enough MySQL and Oracle enough to be very dangerous) either as a developer, DBA or a consultant. Doug has been a member of PASS since 2005 and been active in his local SSUG and SQLSaturday events delivering his “What is this Cache and how did it get so big?” presentation to appreciative audiences. He also has recently discovered eerie similarities between tuning a query and tuning a banjo.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Tom Marek

Twitter: - https://twitter.com/TWMarek

LinkedIn: Tom Marek

Contact: http://blogs.neudesic.com/

I have over 15 years of experience leading teams working on various database systems and analytic tools. These range from small simple databases to extremely large systems based on data analysis. Currently I am GM of the BI practice for Neudesic helping manage thought leadership, development of IP for use with clients and training of consultants. I also act as a liaison to CxO level clients to gather information on their business and help find ways to analyze it to make them more efficient.

Gus Apostol

Gus Apostol is a Principal Program Manager on the Microsoft SQL Server product development team. He is responsible for developing database engine technologies and driving performance and scalability initiatives for the SQL Server Relational and Storage engines and the SQL Azure platform as part of SQLCAT.

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Jeff Jones

Jeff Jones has over 35 years of experience working with database technology to solve business problem. He has been teaching SQL Server at Interface Technical Training in Phoenix for the last 11 years.

Gus Apostol

Tom Marek

Twitter: - https://twitter.com/TWMarek

LinkedIn: Tom Marek

Contact: http://blogs.neudesic.com/

Wil Sisney

Twitter: - @HanSQL

Contact: http://www.wilsisney.com

Amy Lewis

Twitter: - @amy_lewisAZ

LinkedIn: Amy Lewis

Contact: http://amylewisAZ.wordpress.com

Data and Business Intelligence Architect and Developer with over 20 years experience in a variety of industries. My current focus is the development of end-to-end business intelligence solutions using the Microsoft Business Intelligence suite of products.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Andrew Thornton-Smith

Twitter: - https://twitter.com/AThorntonSmith

LinkedIn: Andrew Thornton-Smith

I am a Specialist SharePoint Consultant at Mint Management Technologies South Africa, and have been in the industry for about 10 years. I have been dabbling in the dark and mystical art of SharePoint for many a year and have learnt many tips and tricks, Do#39;s and Do not#39;s!! I enjoy new tech toys and anything radio controlled especially monster trucks and quad copters.

Josh Sivey

Twitter: - @joshsivey

LinkedIn: Josh Sivey

Josh Sivey is a Microsoft Certified Professional with over fifteen years of experience delivering solutions using Microsoft technologies. He enjoys helping empower users to unlock the power of corporate data using the Microsoft BI stack. Josh is a Technology Solutions Professional with Microsoft. In his free time, he enjoys saving Hyrule from the clutches of Ganon with his son and playing My Little Ponies with his daughter.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

David Ikeda

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Robert Miller

Twitter: - https://twitter.com/RobertMiller

LinkedIn: Robert Miller

Contact: http://sqlhuman.com

Matt Smith

Twitter: - @SmithMattC

LinkedIn: Matt Smith

Matt is currently a Data Platform Business Intelligence Technology Solution Professional and works heavily with Enterprise level architectural, analytical, and operational solutions. His technical and leadership experience spans across numerous industries. He has a strong interest in remaining tactical in while working at the strategic level.

His goal is to assist clients in analyzing, cleansing, and presenting their data so they can make more educated decisions about their business.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Kathy Gibbs

Twitter: - KGdba

LinkedIn: Kathy Gibbs

Kathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions

Jason Volpe

Contact: http://jasonvolpe.com

will populate at a later time

Erika Bakse

Angel Abundez

Twitter: - AngelStreamline

LinkedIn: Angel Abundez

Contact: http://angelstreamline.com

Angel leads the Solutions Architecture team at DesignMind, helping design and build world class data-related systems. His expertise includes Microsoft SQL Server BI tools, Power BI, Azure-based database services, and Tableau. His team develops Proofs of Concept, Pilots, and highly scalable production systems. Angel co-leads the Bay Area Microsoft Business Intelligence User Group and the San Francisco Power BI User Group. He speaks at Data Analytics events throughout the U.S. and writes for SQL Server Central. He is a graduate of Cal Poly SLO with a BS in Mechanical Engineering.

Josh Sivey

Twitter: - @joshsivey

LinkedIn: Josh Sivey

Brad Baker

With more than 15 years experience developing and implementing operational and business intelligence systems, Brad has participated in all phases of systems development, from requirements definition through deployment and maintenance. His responsibilities have included technical architecture and design, product selection and installation, data / dimensional modeling, ETL design and development, and BI / Operational application specification and development.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Jacob Wilson

Contact: http://sharepoint.jacobtwilson.com

Jacob Wilson is the Regional Practice Director for Portals Collaboration for Neudesic’s Desert region and is a SharePoint 2010 Microsoft Certified Master (MCM) with 6 years of SharePoint architecture, infrastructure, and development experience. Jacob also comes from a Business Intelligence background and has worked on various implementations for integrating the Microsoft BI platform with SharePoint 2010 including SSRS 2008/2012, PowerPivot 2008/2012, PerformancePoint Services, and Power View.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

SQLSaturday #131 - Phoenix 2012

Sessions

Title: Mobile BI with SSRS and SharePoint

Title: SQL Server 2012 Memory Manager Changes

Title: Real-time Data Warehouse and Reporting

Title: BISM Partitions, Security and Hierarchies

Title: SQL Considerations for SharePoint 2010 Farms

Title: Documenting Your Integrated Microsoft BI Solution

Title: Fast-track to BI Analytics with SQL Server 2012

Title: T-SQL Utilities for Serious DBAs

Title: Data Cleansing Using the “Scrubbing Bubbles” of SS

Title: Beyond Plateaux: Optimize SSAS with Best Practices

Title: “Ad Hoc Analytics – Can my customer do that?”

Title: Transact-SQL does Windows

Title: Training Certifications for SQL Server 2012

Title: Introduction to SQL Server 2012 AlwaysON

Title: Dynamic MDX: Packing a Punch into One .rdl

Title: Stupid SQL and the Programmers that Write it

Title: Understanding SQL Server XML Features

Title: Think Outside the Group! Take MDX to the next leve

Title: DW Architecture: More than just Facts Dimensions

Title: The Best Dashboard on the Block

Title: 6 Steps to a Stellar Performance Review

Title: The 2012 Data Warehouse Architecture Debate

Title: Become Bilingual! Oracle for the SQL Server DBA

Title: How To Create A BI Semantic Model

Title: (Way Too Much) Fun with Reporting Services

Title: The Ins and Outs of PowerView

Title: Data Visualization in Reporting Services

Title: “BEGIN…COMMIT” is Not Enough

Title: Many-to-Many: Multiple Calendars in a Single Cube

Title: Advanced SQL Server Integration Services

Title: But it worked great in Dev! Perfomance for Devs

Title: Temporal Fact Tables: The Road Less Traveled

Title: Troubleshooting SQL Server Performance

Title: What Does SQL 2012 Mean For SharePoint

Title: Power View: A Peek Behind the Curtain

Title: 5 SSIS Tricks to Take You from Beginner to Awesome

Title: Encryption in SQL Server

Title: Powershell for the DBA

Title: What’s New in SQL Server 2012 SSIS Development

Title: SSAS/MDX - Performing “point in time” analysis

Title: Branding Yourself for a Dream Job

Title: Replication Basics

Title: SSRS 2012 and SharePoint 2010 Integration

Title: Backup Basics - Know your options

Title: What’s this columnstore index thing all about?

Title: SSAS - Usage Based Optimization

Title: Using TVPs in .Net applications

Title: Best Practices for Monitoring Databases on VMware

Title: SSIS 2012 Mgmt Considerations Best Practices

Title: What is this cache and how did it get so big?

Title: Migrating Oracle to SQL Server

Title: Using Change Tracking and Change Data Capture

Title: Automation and Monitoring for the DBA

Title: Agile modeling and reporting with BISM and Azure

Speakers

Sponsors