Nr: 255
SQLSaturday #255 - Dallas 2013
SessionID: 11047
Let's Hadoop!
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Bryan Smith
Title: Let's Hadoop!
Abstract:
This session provides a demonstration-rich introduction to the fundamentals of Hadoop and the Microsoft implementation, HDInsight. If you have heard of Hadoop but have struggled to get started with the technology, this session is for you.
SessionID: 11397
Real-Time Analytics with Power View and SSAS Tabular in DirectQuery Mode
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Chaitanya Khaladkar
Title: Real-Time Analytics with Power View and SSAS Tabular in DirectQuery Mode
Abstract:
In this session we will explore how SQL Server Analysis Services Tabular, running in DirectQuery mode, can be used to power real-time analytics. In DirectQuery mode the data is guaranteed to be up-to-date, no refreshing or processing is necessary, because DirectQuery mode queries data stored in a SQL Server database. We will provide concepts and step-by-step examples of setting up a BI Semantic Model, including security, best practices for getting the most out of Power View and the differences between DirectQuery and the In-Memory VertiPaq cache, so you are equipped to start building real-time analytics solutions with SSAS and Power View.
SessionID: 11632
Mastering your Resume Interview: Tips to Get Hired
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Christine Assaf
Title: Mastering your Resume Interview: Tips to Get Hired
Abstract:
Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.
SessionID: 11633
Interview Tips for Managers
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Christine Assaf
Title: Interview Tips for Managers
Abstract:
If you are a Manager needing some interviewing education - this is your course! This session focuses on basic interviewing guidelines, including: preliminary interviews, types of testing, secondary or follow-up interviews, while keeping in mind EEO guidelines and best practices. Learn tips and tricks of the trade from an HR guru who is "in the trenches."
SessionID: 12435
Biml - The Next Step in Agile Data Warehousing
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: David Stein
Title: Biml - The Next Step in Agile Data Warehousing
Abstract:
SessionID: 13186
SQL Transaction Log Internals
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Denzil Ribeiro
Title: SQL Transaction Log Internals
Abstract:
The transaction log plays a most critical role in any SQL Server database. In this session, Microsoft Premier Field Engineer and SQL Server Certified Masters (MCM) Denzil Ribeiro will discuss the importance of the transaction log and the roles it plays inside the database engine. He will look at how logging and recovery works, composition of log records, common logging patterns, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database
SessionID: 13951
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Erin Welker
Abstract:
In this session, we’ll look at the high-level system as a whole and discuss possible areas contributing to a lag in performance. We’ll also talk about implementing instrumentation components to monitor all aspects of the ETL solution, using SSIS 2012's Catalog. We’ll use this monitoring data and an example case study to walk through the process of tuning the ETL system to make sure the data warehouse is consistently available at the required time.
SessionID: 14572
The ABCs of SSIS
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Glenda Gable
Title: The ABCs of SSIS
Abstract:
This presentation shows the basics of SSIS to help with automating database tasks, such as maintenance, importing and exporting data, or ETL transactions. The discussion will start with an understanding of when SSIS should be used vs. when a database object, such as a view or stored procedure. You will also learn about the different categories of transformations, see how to create a basic package, and how to use package configurations. Lastly, we will talk about the importance of organizing the overall SSIS structure.
SessionID: 14581
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Greg Galloway
Abstract:
SessionID: 14735
Common Problems in Backup and Recovery and How to Handle Them
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Grant Fritchey
Title: Common Problems in Backup and Recovery and How to Handle Them
Abstract:
The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we'll explore the most common problems around SQL Server backup and recovery, so that you can spot any issues in your own environment. Then, we'll talk about how to prevent these issues in the first place. The foundation of disaster recovery is having a verified backup in place, so the knowledge you'll gain from this session could help to save your business.
SessionID: 14928
T-SQL Throwdown
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Hakim Ali
Title: T-SQL Throwdown
Abstract:
Join us for a game of SQL that combines fun, learning SQL, networking, and friendly competition with your peers. Create your team for a SQL-off against other teams. If you can write a SQL query, you have the skills required to play. Each team must bring a laptop with SQL Server 2012 Express and AdventureWorks 2012 pre-installed. Please read full rules here: http://www.sqlzen.com/t-sql-throwdown.html
SessionID: 16084
Nested Sets model for Trees Hierarchies
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Joe Celko
Title: Nested Sets model for Trees Hierarchies
Abstract:
Most newer SQL programmers use the adjacency list model for Trees Hierarchies in their DDL. This is not a relational approach and experienced programmers use the Nested Sets model. However, they do not know all of the programming idioms for the method. That is what this session is about.
SessionID: 16870
Analytical MDM with Master Data Services 2012
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jeff Johnston
Title: Analytical MDM with Master Data Services 2012
Abstract:
In this session we will take a deep dive in to Analytical Master Data Management and how it differs from Operational Master Data Management. We will examine how you can leverage SQL 2012 Master Data Services to manage your data warehouse dimensions and hierarchies. Come learn how you can leverage the new features of SQL 2012 Master Data Services to enroll business users in the process of master data management to reduce the burden on IT and as a result, maximize the value of your Master Data Management solution.
SessionID: 17645
Wish you could live the glamorous consulting life?
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Juan Soto
Title: Wish you could live the glamorous consulting life?
Abstract:
Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way.
In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out
SessionID: 17717
Table Partitioning: the Secret Weapon for your Big Data Problems.
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: John Sterrett
Title: Table Partitioning: the Secret Weapon for your Big Data Problems.
Abstract:
Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.
SessionID: 18413
Women in Tech Panel
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Kathi Kellenberger
Title: Women in Tech Panel
Abstract:
This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women -- and men -- in tech. Everyone welcome to this very interactive session.
SessionID: 18414
Writing Better Queries with Window Functions
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Kathi Kellenberger
Title: Writing Better Queries with Window Functions
Abstract:
SessionID: 19509
Tell Better Stories with Microsoft BI and PowerMap
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: marek koenig
Title: Tell Better Stories with Microsoft BI and PowerMap
Abstract:
Storytelling seems to be a lost art form; in this fast-paced world people are more interested in getting as many bits of information as they can. But without a story, something to pull all the data together, the target audience will probably gloss over your message. Throwing a few numbers and charts at the reader has become pretty acceptable nowadays. But to make something truly memorable, and hopefully shared with someone else, you need some kind of story. You need something to tie it all together, to give it some meaning. That’s where Microsoft steps in with its latest addition to the Business Intelligence Analytics space with an add-in to Excel called PowerMap.
SessionID: 19571
Optimizing Stored Procedures
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Mark Rosenberg
Title: Optimizing Stored Procedures
Abstract:
SessionID: 19625
Introduction to SQL Spatial Analysis and Reporting
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Mark Verret
Title: Introduction to SQL Spatial Analysis and Reporting
Abstract:
SessionID: 19858
SQL Security Best Practices Shrinking Your Attack Surface
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Matthew Brimer
Title: SQL Security Best Practices Shrinking Your Attack Surface
Abstract:
Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA's tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data.
In addition, attending this talk is worth 1.5 Continuing Education credits.
SessionID: 19931
Master of All I Survey - track code changes and more across your environment
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Michael Bourgon
Title: Master of All I Survey - track code changes and more across your environment
Abstract:
Almost everyone's seen it happen - problems due changes made on servers, be it SPs, index rebuilds, or even configuration changes. But what if you could look historically across servers and track down what changes were made when, by who, and from where? It exists, it's already built into SQL Server standard edition from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment.
SessionID: 19936
Nuts and Bolts of Table Compression
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Mike Byrd
Title: Nuts and Bolts of Table Compression
Abstract:
Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results -- they were surprising to me!
SessionID: 20188
Extreme Design – A Real World 10+ Exabyte Data Warehouse
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Mike Hotek
Title: Extreme Design – A Real World 10+ Exabyte Data Warehouse
Abstract:
SessionID: 20198
SQL Server 2014 – In memory OLTP Development
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hotek
Title: SQL Server 2014 – In memory OLTP Development
Abstract:
SessionID: 21483
SQL 2012 AlwaysOn Quickstart
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Ryan Adams
Title: SQL 2012 AlwaysOn Quickstart
Abstract:
In this presentation I'll explain what the new SQL 2012 AlwaysOn high availability and disaster recovery solution is all about. I'll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We'll discuss how these three things come together to protect your databases. We'll finish with a dive into availability group configuration and the new capabilities it gives us.
SessionID: 21748
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Pat Sinthusan
Abstract:
• The evolution of disk and Flash storage
• The Physics behind Flash
• The Different types of Flash (Server, Hybrid and Storage)
• How to leverage Flash to get the most out of SQL Server
SessionID: 22869
Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power View
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Reinaldo Kibel
Title: Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power View
Abstract:
They need to analyze customer behavior, then take this information and tie in with customer 360 view, straight from Sales force to do demand generation.
In this session you will see tips and tricks for setting up an enterprise infrastructure based on SQL Server 2012 Business Intelligence analytical tools Power View and PowerPivot that includes SharePoint 2013, SQL Server Engine 2012, SSIS 2012, Analysis Services Multidimensional, Tabular, and PowerPivot modes as well as SQL Reporting Services, PowerPivot and Power View. How to create OLAP cubes, PowerPivot data, and export to SSAS Tabular. Create reports with Power View based on the PowerPivot data extracted.
SessionID: 23423
Moving to Windows Azure SQL Database(WASD)
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Rohit Nayak
Title: Moving to Windows Azure SQL Database(WASD)
Abstract:
Are you a SQL Server DBA who is now being asked to migrate databases to Windows Azure SQL Database (WASD)? Are you a developer who is writing code for a cloud service that shall use SQL Database as the back-end? Come attend this talk by CSS engineers for guidance strategies you can use to make a smooth transition to this new platform. The content is based on lessons learnt supporting customers already using WASD and will touch upon topics like •How to get your data from on-premise SQL Server to WASD?•What are common DBA type tasks you will need to perform on WASD?•How can you troubleshoot query performance issues on WASD?
SessionID: 23668
Introduction to the XML source
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Russel Loski
Title: Introduction to the XML source
Abstract:
XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents.
Attendees will be able to import simple XML using SSIS. They will be able to create import routines that pull data from different elements of more complex XML. They will understand the role the XML Schema plays in defining the XML data they import.
SessionID: 23669
SSRS data driven subscription using SSIS
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Russel Loski
Title: SSRS data driven subscription using SSIS
Abstract:
SessionID: 25227
Turbo charge your DBA career
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Sri Sridharan
Title: Turbo charge your DBA career
Abstract:
You have been a DBA for so many years and struggle to decide on what next. Attend this session and find ways to rejuvenate your career to the next step.
SessionID: 25804
SQL Server Amnesia - Memory Troubleshooting
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Steven Ormrod
Title: SQL Server Amnesia - Memory Troubleshooting
Abstract:
SessionID: 25884
Explore and Troubleshoot the power-packed new features of SQL Server 2014
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Suresh Kandoth
Title: Explore and Troubleshoot the power-packed new features of SQL Server 2014
Abstract:
SessionID: 26606
Make Your SSIS Packages Run Faster: 15 Quick Tips
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Tim Mitchell
Title: Make Your SSIS Packages Run Faster: 15 Quick Tips
Abstract:
SessionID: 26788
Window Functions in SQL Server 2012
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Tim Costello
Title: Window Functions in SQL Server 2012
Abstract:
SessionID: 27396
Care and Feeding of Your System Databases
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Vicky Harp
Title: Care and Feeding of Your System Databases
Abstract:
Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
SessionID: 28183
SQL Server Permissions and Security Principals
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: William Assaf
Title: SQL Server Permissions and Security Principals
Abstract:
A review of SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more.
SessionID: 9122
Without A SQLTrace-Getting To Know Extended Events
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: AJ Mendo
Title: Without A SQLTrace-Getting To Know Extended Events
Abstract:
SessionID: 9381
Physical Join Operators
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Ami Levin
Title: Physical Join Operators
Abstract:
SessionID: 9501
Hacking the SSIS 2012 Catalog
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Andy Leonard
Title: Hacking the SSIS 2012 Catalog
Abstract:
Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!
SessionID: 9929
Intro to SharePoint BI
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Allen Smith
Title: Intro to SharePoint BI
Abstract:
Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we start with an overview of the basics by sharing a SQL table as a 'List' using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.