Nr: 265
SQLSaturday #265 - Oregon 2013
SessionID: 11074
ETL in a Nutshell with SSIS
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 7. Admin Tools
Speaker: Brett Tomson
Title: ETL in a Nutshell with SSIS
Abstract:
SessionID: 11390
The Rise of the Flash Powered Economy
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 8. Cloud Big Data
Speaker: Chad Chapman
Title: The Rise of the Flash Powered Economy
Abstract:
Flash storage has revolutionized everything from smart phones and mobile computers, to web searches and social media. Unfortunately, it's been nearly impossible to deploy flash across a data center without breaking the bank. Pure Storage has cracked the code and destroyed the disk status quo. All-flash storage is now affordable enough to use broadly across any enterprise. Every company should enjoy the performance, space and efficiency advantages of flash as well as the lower maintenance, power, cooling, rack space and management costs. With Pure Storage, your business can achieve things that weren’t even imaginable with disk. No more wondering how much data you can analyze, how fast you can respond to a customer, or how quickly you can launch a new service. It’s time to unlock the productivity and creativity of your company while delivering a responsive experience to both customers and employees. All applications. All customers. All budgets. Flash for all.
SessionID: 11428
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 2. Business Intelligence
Speaker: Robert Davis
Abstract:
SessionID: 11798
Clear View: The power of Window Functions
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 4. Design
Speaker: Constantin Klein
Title: Clear View: The power of Window Functions
Abstract:
SQL Server 2005 introduced partial support for window functions. SQL Server 2012 added much more. If you want to see what's available now and which problems you can adress with window functions, then this is for you. You will also learn about new analytical functions in SQL Server 2012 and you will be ready to use window functions in your own solutions after this session.
SessionID: 12878
Life++: Data mining your life
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 6. Professional Development
Speaker: Dan Beutler
Title: Life++: Data mining your life
Abstract:
SessionID: 13359
How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise Edition
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 7. Admin Tools
Speaker: Carl Berglund
Title: How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise Edition
Abstract:
Learn how to make your next SQL Server deployment or tech refresh the basis of a consolidated, elastic, self-managed SQL Server utility. This session will help you understand how to build a highly available SQL Server farm to maximize flexibility and agility while avoiding the traps that force you to SQL Server Enterprise Edition.Are you currently dealing with…• Standards that force the most expensive software stack? • High licensing and yearly subscription costs associated with vendor lock-in?• Multiple deployment models that increase project complexity and dependencies while reducing your flexibility and agility? Wouldn’t you like to...• Reduce the cost of both SQL Server licensing and infrastructure?• Have a single operational model that solves all deployment requirements?• Deploy the edition of SQL server that best solves the business problem without being forced to Enterprise Edition?
SessionID: 13964
PostgreSQL for the SQL Server Pro
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 8. Cloud Big Data
Speaker: Ed Snajder
Title: PostgreSQL for the SQL Server Pro
Abstract:
PostgreSQL is a mature, robust and fast open-source database whose popularity grows with each new release. Let's take a look at the latest version of PostgreSQL, 9.3, and consider its strengths and weaknesses from an SQL DBA perspective. We'll dive right into the "why?" and look at some of the features Postgres has going for it, as well as some of its limitations. By the end, you should find Postgres operation and administration to be fairly similar to SQL Server, indefinitely configurable, and another good tool for any data pro's toolbox.
I'll be demonstrating with Postgres 9.3 running on a CentOS 6.2 VM, if you would like to follow along, bring your own Linux box or Virtual Machine!
SessionID: 14727
Lunch -Common DBA Tasks
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 3. Performance
Speaker: Jose Chinchilla
Title: Lunch -Common DBA Tasks
Abstract:
SessionID: 14729
What to Look for in Execution Plans
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 3. Performance
Speaker: Grant Fritchey
Title: What to Look for in Execution Plans
Abstract:
SessionID: 14811
Alice's SQL Server DBA Training Plan
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 6. Professional Development
Speaker: Greg Larsen
Title: Alice's SQL Server DBA Training Plan
Abstract:
Congratulations on landing your first SQL Server DBA Job. Do you have a DBA Training Plan?
In this presentation we will follow Alice as she steps into her first days as a new DBA. We will travel with Alice as she navigates through SQL Server Land following her DBA Training Plan. We will be watching Alice as she discovers, learns, and actually performs those typical tasks to maintain a SQL Server environment.
In this presentation Alice will discover the following and more:
• Monitoring your server
• Backup / Recovery
• Managing Databases
• Managing and Monitor Resources
• Installation considerations
• Managing Security and Auditing
• SQL Server version management
As Alice travels through SQL Server Land we will be watching Alice as she performs her on the job training exercises. These demos that Alice will be working through should provide those attending with some examples that will walk us through the actual mechanics of what Alice will need to deal with as SQL Server
SessionID: 15693
Extend Your Knowledge with Extended Events - Super Size
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 7. Admin Tools
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events - Super Size
Abstract:
SessionID: 16590
Much Ado About Hadoop
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 8. Cloud Big Data
Speaker: Jeremiah Peschka
Title: Much Ado About Hadoop
Abstract:
By now you've probably heard the words "Big Data" and "Hadoop", but you're not sure what they mean, much less how to get started. Maybe you're struggling with storing a lot of data, rapidly processing a huge volume of data, or maybe you're just curious. There are a bewildering array of options and use cases within the Hadoop ecosystem. Every day I help customers understand their data problems, understand where Hadoop fits into their environment, and determine how they can use Hadoop to solve their problem. This session provides an introduction to what Hadoop is, when it's appropriate to use Hadoop, and guidance on how to get started.
SessionID: 16634
Index Methods You're Not Using
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 3. Performance
Speaker: Jes Schultz
Title: Index Methods You're Not Using
Abstract:
SessionID: 16635
You CAN Give a Technical Presentation!
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 6. Professional Development
Speaker: Jes Schultz
Title: You CAN Give a Technical Presentation!
Abstract:
You're dreaming. In the dream, you’re standing in front of a room full of dozens of people, presentation mouse in hand, about to present to them on (insert SQL Server feature here). You wake up in a cold sweat. You’re either terrified - or excited and terrified. Are you ready to start presenting? Join Jes as she shares her secrets to building and giving successful technical presentations! (Follow up this session with the Workshop.)
SessionID: 16636
Technical Presentation Workshop
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 1. Fun Starts Here
Speaker: Jes Schultz
Title: Technical Presentation Workshop
Abstract:
Follow Up to Jes' Borland's session 'You Can Give a Technical Presentation!'. During this workshop, participants will practice their Lightening Talks on the stage.
SessionID: 16911
Understanding Query Modes in Tabular Model
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 2. Business Intelligence
Speaker: Julie Koesmarno
Title: Understanding Query Modes in Tabular Model
Abstract:
Using live demo, this session will outline advantages and disadvantages between DirectQuery and In-Memory modes. We will also highlight impersonation and partitioning differences between the two modes. Finally, we will also cover the definition of a Hybrid Tabular Model solution
SessionID: 17860
Hybrid cloud scenarios enabled in SQL Server 2014
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 8. Cloud Big Data
Speaker: Karthika Raman
Title: Hybrid cloud scenarios enabled in SQL Server 2014
Abstract:
Learn about the hybrid cloud scenarios enabled in SQL Server 2014 CTP2: Learn about Backup to Windows Azure options, Using Azure storage for your data files, and about the new wizard to deploy a secondary replica to Windows Azure. This session is for people who want to understand how to leverage Windows Azure to extend their on-premises applications in HA and DR scenarios.
SessionID: 17964
DAX Evaluation Context
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 2. Business Intelligence
Speaker: Jeffrey Wang
Title: DAX Evaluation Context
Abstract:
DAX is the query and programming language for Analysis Services tabular models, yet many users found DAX hard to learn because they couldn't grasp what the "evaluation context" was. This session will turn you into a DAX expert by mastering this core concept of DAX. You will learn what row context and filter context are and how to access them. You will learn functions which modify row and filter contexts. You will learn the initial context of a calculated column expression, a row level security expression, and a measure expression. You will learn how initial context is created from an MDX query. You will learn how to manipulate filter context using the overwrite and intersect semantics. You will see a lot of examples and learn a few DAX tricks along the way.
SessionID: 19170
How to Find Bad Queries, Fast
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 3. Performance
Speaker: Kendra Little
Title: How to Find Bad Queries, Fast
Abstract:
SessionID: 19857
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 9. New Features
Speaker: Matthew Roche
Abstract:
In this session SQL Server Senior Program Manager Matthew Roche will introduce Power BI, with a focus on self-service information management (SSIM) and data stewardship. You’ll leave with a solid understanding of the capabilities of the Power BI platform, how it can empower business users and data experts within your organization, and how to get started right away.
SessionID: 20450
Deadlocks: What to do about the dreaded 1205
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 5. T-SQL
Speaker: Michael DeFehr
Title: Deadlocks: What to do about the dreaded 1205
Abstract:
Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.
SessionID: 21536
Power BI - The self service BI Lifecycle in the cloud
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 8. Cloud Big Data
Speaker: Oliver Engels
Title: Power BI - The self service BI Lifecycle in the cloud
Abstract:
With the new Power BI Preview Microsoft brings more Self-service BI functionality to the users. In this session we will look from a different perspective to the offering: What about Governance, Application LifeCycle, Enterprise Integration? We will review what is currently possible in the preview for sharong querys, integrating the cloud offering with your enterprise data sources, monitoring datasources and gateways and what is possible to use it on Windows Mobile devices. This session is complete demo driven.
SessionID: 21827
BI Expert Panel - Part 1
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 2. Business Intelligence
Speaker: Paul Turley
Title: BI Expert Panel - Part 1
Abstract:
SessionID: 21828
BI Expert Panel - Part 2
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 2. Business Intelligence
Speaker: Paul Turley
Title: BI Expert Panel - Part 2
Abstract:
In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Brett Tomson and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
SessionID: 21952
Mastering the Excel CUBE Functions
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 2. Business Intelligence
Speaker: Peter Myers
Title: Mastering the Excel CUBE Functions
Abstract:
This session explores the seven CUBE functions that are natively available in Excel. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts.This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is applicable to Excel 2007, 2010 and 2013.
SessionID: 23120
SSIS 2012 Management Considerations and Best Practices
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 7. Admin Tools
Speaker: Rushabh Mehta
Title: SSIS 2012 Management Considerations and Best Practices
Abstract:
SessionID: 23376
The Things You Don't Think About...
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 5. T-SQL
Speaker: Rob Vieira
Title: The Things You Don't Think About...
Abstract:
As developers of data driven applications, we spend a lot of time thinking about performance. We read articles on how to best index, or how to how to write a better query. We make trial runs and analyze them using Show Plan. We read still other articles on using views, versus functions, versus stored procs. We learn patterns to write the most maintainable code. The list goes on…. But what about the things we don’t think about?From DMV’s to lesser talked about new features, The building blocks we code on haveall sorts of things going on that we all too often either don’t know or don’t think about. In this session, we’ll take a somewhat random stroll around data development and topics that you may not know about, or may simply have not thought about in a while, and examine what they mean to your code maintainability or performance.
SessionID: 24353
Query Optimizer and Statsitics
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 3. Performance
Speaker: Sergey Olontsev
Title: Query Optimizer and Statsitics
Abstract:
SessionID: 24354
Overview of In-Memory OLTP feature (Hekaton) in SQL Server 2014 CTP
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 9. New Features
Speaker: Sergey Olontsev
Title: Overview of In-Memory OLTP feature (Hekaton) in SQL Server 2014 CTP
Abstract:
SessionID: 24496
The Encryption Primer
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 4. Design
Speaker: Steve Jones
Title: The Encryption Primer
Abstract:
Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
SessionID: 24497
Branding Yourself for a Dream Job
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 6. Professional Development
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 24503
A Database Deployment Roundtable
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 7. Admin Tools
Speaker: Steve Jones
Title: A Database Deployment Roundtable
Abstract:
If you dread database deployments and find them to be problematic, come join Steve Jones for a discussion of the issues and challenges in this area. Steve will present a vision of the work Red Gate has done in trying to make database deployments easier and faster.
SessionID: 24748
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 7. Admin Tools
Speaker: Steve Moss
Abstract:
The importance of data quality and common problems associated with data quality.
Companies spend considerable time and money making sure financial data is complete and correct, but don't always excercise the same care and processes with their operational data. This session will be centered on practical solutions, with just enough theory to give some context. It will include the following topics:
- Data Screening: extensible approach to implementing data quality and monitoring it pioneered by Kimball Group.
- MS Data Quality Services: Overview of functionality and working examples and strong points/limitations.
- Combining data screens and DQS.
- Master Data or Data Quality: where to start
SessionID: 24853
Developers vs. DBA's: Cats Dogs
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 9. New Features
Speaker: David Moutray
Title: Developers vs. DBA's: Cats Dogs
Abstract:
Application Developers focus on delivering working code, while DBA's focus on Data Quality. Since developers vastly outnumber us, we must - somehow - persuade them that our objectives are important, too. This, in turn, requires that we understand the source of the conflict and learn to see the world from multiple points of view.
SessionID: 25748
Common Table Expressions - Introduction
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 5. T-SQL
Speaker: Steve Stedman
Title: Common Table Expressions - Introduction
Abstract:
Have you ever wanted to create a recursive query, but didn't see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE's for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE's. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. The class is designed for people who haven’t used CTE’s before, or for those who want to learn the basics of CTEs including data paging. This session pairs well with the Advanced Common Table Expressions ses
SessionID: 25749
Common Table Expressions - Advanced
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 5. T-SQL
Speaker: Steve Stedman
Title: Common Table Expressions - Advanced
Abstract:
SessionID: 25951
Advanced Data Visualization with SQL Server Report
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 8. Cloud Big Data
Speaker: Tillmann Eitelberg
Title: Advanced Data Visualization with SQL Server Report
Abstract:
SessionID: 26867
High IO, High IO, It's a Case Study Yo Ho!
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 3. Performance
Speaker: Tim Ford
Title: High IO, High IO, It's a Case Study Yo Ho!
Abstract:
Confronted with the highest IO of any Windows server in our environment one intrepid DBA was able to reduce IO, space consumption, and blocking to new lows. This is a case study, based upon actual events where the names of the innocent as well as the guilty are changed to protect the DBA. Topics covered: DMVs, online operations, Filegroups, Page Compression, and disk formatting best practices.
SessionID: 27377
The Significance of Choosing and Using Data Types
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 4. Design
Speaker: Vern Rabe
Title: The Significance of Choosing and Using Data Types
Abstract:
SessionID: 27420
What Developers Need to Know About Hekaton
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 9. New Features
Speaker: Victor Isakov
Title: What Developers Need to Know About Hekaton
Abstract:
SessionID: 8838
SQL Server Database Development with SSDT
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 9. New Features
Speaker: Aaron Nelson
Title: SQL Server Database Development with SSDT
Abstract:
SessionID: 9372
Physical Join Operators
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 4. Design
Speaker: Ami Levin
Title: Physical Join Operators
Abstract:
SessionID: 9373
Where did I put my (primary) keys?
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 4. Design
Speaker: Ami Levin
Title: Where did I put my (primary) keys?
Abstract:
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
SessionID: 9864
Stop Schemers with Schema Security
Event Date: 16-11-2013 - Session time: 00:00:00 - Track: 5. T-SQL
Speaker: Arnie Rowland
Title: Stop Schemers with Schema Security
Abstract:
In releases prior to SQL Server 2005, database object owners and users were the same things. SQL Server 2005 introduced the concept of database schemas and the separation between database objects and ownership by users. An object owned by a database user is no longer tied to that user. The object now belongs to a schema – a container that can hold many database objects. The schema owner may own one or many schemas. This concept creates opportunities to expose database objects within a database for consumption yet protect them from modification, direct access using poor query techniques, or removal by users other than the owner.
The ability to protect database objects in this way has many practical applications. One example of relevance is the protection of database objects in application development environments where developers and testers share the same set of database objects.