Nr: 248
SQLSaturday #248 - Tampa BI 2013
SessionID: 10757
Getting Started with HDInsight
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (4) Big Data
Speaker: Brian Mitchell
Title: Getting Started with HDInsight
Abstract:
Let's get rid of the barriers to getting started with Hadoop. in this session we will walk through how to setup a HDInsight service cluster in the cloud and how to set up a HDP cluster in VMs.
SessionID: 13006
Dealing With Errors in SSIS 2012
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: David Dye
Title: Dealing With Errors in SSIS 2012
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
SessionID: 15791
5 TSQL Commands I've been missing
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Jason Carter
Title: 5 TSQL Commands I've been missing
Abstract:
Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me. In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing. We will evaluate the usefulness of CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.
SessionID: 16041
Hadoop On-Premise
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (4) Big Data
Speaker: Jon Bloom
Title: Hadoop On-Premise
Abstract:
Hadoop is becoming the industry standard for processing Big Data. Learn about Hadoop offerings from Hortonworks On-Premise. You’ll see both the Linux and Windows versions and get familiar with some of it’s functionality.
SessionID: 16515
Best Practice Data Visualization
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (3) Presentation
Speaker: Jen Underwood
Title: Best Practice Data Visualization
Abstract:
SessionID: 16971
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (3) Presentation
Speaker: James McAuliffe
Abstract:
SessionID: 17205
Moving Big Data - SSIS, Pig, and Sqoop
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (4) Big Data
Speaker: John Welch
Title: Moving Big Data - SSIS, Pig, and Sqoop
Abstract:
SessionID: 17207
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: John Welch
Abstract:
SessionID: 17370
ETL Frameworks using SSIS
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: Jorge Novo
Title: ETL Frameworks using SSIS
Abstract:
The introduction would start from standard ETL File loading using BCP, Bulk Copy, File Delimited and Fixed Width.
Finally we will create a single framework to track and deliver the File (s) to any destination within your organization while maintaining company standards and code consistency.
SessionID: 17371
ETL Data Warehouse loading.
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: Jorge Novo
Title: ETL Data Warehouse loading.
Abstract:
On this session we are going to cover the Type I (Data Refresh) and Type II Slowly changing dimension processes to successfully load and track your historical changes on a SQL Server warehouse and how to keep track of the Raw data for data quality and auditing.
SessionID: 17807
HDInsight: What’s all the Hadoopla about Big Data
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (4) Big Data
Speaker: Jason Virtue
Title: HDInsight: What’s all the Hadoopla about Big Data
Abstract:
SessionID: 18416
SSIS 2012
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: Kathi Kellenberger
Title: SSIS 2012
Abstract:
Microsoft revamped SSIS with the 2012 release. Attend this session to learn about the new project deployment model, parameters, the SSIS catalog and more!
SessionID: 19676
Big Data Microsoft SQL Server in the Real World
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (4) Big Data
Speaker: Mark Kromer
Title: Big Data Microsoft SQL Server in the Real World
Abstract:
Let's go beyond the hype of Big Data and the Microsoft story around Big Data and talk about a real-world actual implementations of Big Data Big Data Analytics solutions. In this session, I'll talk about implementing SQL Server, Big Data Analytics engines, Hadoop and Big Data visualizations tools using specifics of a customer implementation which I was responsible for.
SessionID: 19968
Introduction to Business Intelligence
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: Mike Davis
Title: Introduction to Business Intelligence
Abstract:
In this session Mike shows how a complete BI solution is built from the transactional system to the finished Cube and reports. He will go over the steps involved in planning a BI solution and how to make your project successful. You will get an understanding of the roles SSIS, SSAS, and SSRS play in building a BI solution.
SessionID: 20370
Intro to MDX
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Michael Simon
Title: Intro to MDX
Abstract:
Come see how to write queries against a multidimensional database! We will be covering: How to Think About Writing an MDX Query, Basic Terminology, and Build From Simple to More Powerful Query Components. This will be a great launch into
SessionID: 20481
Introducing Cube World To Users From Flat Table Land
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: Michael Antonovich
Title: Introducing Cube World To Users From Flat Table Land
Abstract:
This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.
SessionID: 20483
Using Excel 2010 as Your Analysis Services Client
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (3) Presentation
Speaker: Michael Antonovich
Title: Using Excel 2010 as Your Analysis Services Client
Abstract:
Self service BI can be a snap even when you build your data models in SQL Server Analysis Services by using PowerPivot for Excel to compress, query and report on the data. This session will begin by showing how to create a cube in Analysis Services and then connect that cube to PowerPivot for Excel. Once in PowerPivot, we will see how to connect this data to other data sources and augment the cube data with calculated DAX expressions. We will close by showing from a user's point-of-view how easy it is to manipulate the data to create a variety of different reports and charts with no code.
SessionID: 21790
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 21943
Heterogeneous Data Environments
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Peter Evans
Title: Heterogeneous Data Environments
Abstract:
Analyzing data across multiple sources for a 360 degree view of your business
Not only is the size of data growing, but so are the number of data sources and the number of requests from the business to analyze it. Today’s data professionals are now required to access a myriad of relational and non-relational sources, mash it up together and provide in-depth reports and visualizations, and usually without a lot of time. In this session, product evangelist Peter Evans will show you how Toad can dramatically reduce time spent on accessing relational and non-relational data, simplify data integration, and how to collaborate with other users for a 360 degree view of your business.
SessionID: 22327
When Reporting is More than Reporting
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (3) Presentation
Speaker: Pam Shaw
Title: When Reporting is More than Reporting
Abstract:
Is your day full of repetitive tasks that you would like to hand off? Maybe you can push them back to the source. SSRS can empower you to empower your users. By pass the UI team and do it yourself. We will discuss options and considerations you should know about to create a report process to populate data your users are asking you to populate with validation and defaults.
SessionID: 23362
Virtualizing our Environment
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Rob Mandeville
Title: Virtualizing our Environment
Abstract:
This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I'll discuss the differences between virtual and physical host metrics and issues surrounding them. We'll discuss some virtualization shortcomings and then show a little about Confio's Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.
SessionID: 25669
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Steve Abraham
Abstract:
SessionID: 26014
Introduction to PowerBI with Office365
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: Jon Bloom
Title: Introduction to PowerBI with Office365
Abstract:
Want to take Self Service BI to the next level. Learn how the new Microsoft PowerBI works in the Cloud. You'll see how to set up Gateways, Data Sources as well as connect using Excel Power Query.
SessionID: 26060
SELECT job FROM firm WHERE hired = 'Yes' 2.0
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Todd Davis
Title: SELECT job FROM firm WHERE hired = 'Yes' 2.0
Abstract:
Find out what hiring managers really want to see throughout the hiring process. This session will walk through the basics that every successful candidate should know: Resume tips, Job search and Interview tips. Yes, recruiters and hiring managers view your LinkedIn page; but, did you realize they also view your twitter account, your blog, your Facebook and that webpage you designed freshman year in college? If you are in a job search, considering one or just want to be prepared for one, then this session will be a great opportunity to find out what "they" are really looking for.
SessionID: 26212
SQL Server 2012 Column Store Index
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Kevin Boles
Title: SQL Server 2012 Column Store Index
Abstract:
SessionID: 26539
Forget "Big Data" ! How About "Smart Data" Instead?
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (4) Big Data
Speaker: Thomas Spetnagel
Title: Forget "Big Data" ! How About "Smart Data" Instead?
Abstract:
SessionID: 26604
Make Your SSIS Packages Run Faster: 15 Quick Tips
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: Tim Mitchell
Title: Make Your SSIS Packages Run Faster: 15 Quick Tips
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 of the most common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
SessionID: 26605
Handling Errors and Data Anomalies in SSIS
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (1) ETL
Speaker: Tim Mitchell
Title: Handling Errors and Data Anomalies in SSIS
Abstract:
SessionID: 28117
Design and Implement BI like Edison!
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: William E Pearson III
Title: Design and Implement BI like Edison!
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
SessionID: 28272
Introduction To Reporting Services
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (3) Presentation
Speaker: Wes Springob
Title: Introduction To Reporting Services
Abstract:
SessionID: 28273
Analytics and Big Data at USF
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: Balaji Padmanabhan
Title: Analytics and Big Data at USF
Abstract:
In this session we will go over some of the breakthroughs that USF has made in Analytics and Big Data.
SessionID: 34548
A Matter of Time... In SSAS
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: Alexander Nykolaiszyn
Title: A Matter of Time... In SSAS
Abstract:
SessionID: 34724
Secrets of Enterprise Data Mining
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (2) Analysis
Speaker: Mark Tabladillo
Title: Secrets of Enterprise Data Mining
Abstract:
SessionID: 9575
PCI For The SQLDBA
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (5) DBA/Misc
Speaker: Andy Warren
Title: PCI For The SQLDBA
Abstract:
Are you storing or planning to store credit card numbers? If so, you need to learn all you can about the requirements for PCI compliance. We'll cover how PCI works from the requirements to the final audit, and eveything in between that you'll need to know something about. We'll talk about encryption, key management, logging, alerting, administration access, granular permissions, tokenization, and as much more as we can fit into an hour. It's a complex topic, but that just makes it more interesting!
SessionID: 9883
SharePoint BI
Event Date: 09-11-2013 - Session time: 00:00:00 - Track: (3) Presentation
Speaker: Clinton Daniel
Title: SharePoint BI
Abstract:
In this session we will go over the most important BI features available in SharePoint.