Nr: 172
SQLSaturday #172 - Oregon 2012
SessionID: 10438
2012 TSQL Sweets
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 2 -SQL Dev
Speaker: Bill Fellows
Title: 2012 TSQL Sweets
Abstract:
The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
SessionID: 10593
The Skinny on Data Compression
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 1 -Indexes
Speaker: Bob Pusateri
Title: The Skinny on Data Compression
Abstract:
SessionID: 10728
Building Faster SQL Servers
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 5 -On/Off Prem
Speaker: Brent Ozar
Title: Building Faster SQL Servers
Abstract:
SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field.
SessionID: 11099
The Cloud is Coming for Your Career - Buwahahahaha
Event Date: 03-11-2012 - Session time: 00:00:00 - Track:
Speaker: Buck Woody
Title: The Cloud is Coming for Your Career - Buwahahahaha
Abstract:
Oh noes! Everyone tells me to throw away all my servers, and just move everything to the cloud! What will happen to my job? How will my children go to college? Buck Woody, Senior Technical Specialist on Windows Azure will answer these other questions, including: Why do they call something technical a “cloud”, since a cloud is something with undefined borders made of vapor? Isn’t this just the latest hype, a new buzzword that will soon be gone? Is anyone really using it for production? Are there real reasons to do that? If it’s real, how does it affect my job as a technical professional? What do I need to learn, and where can I learn it? This isn’t sales or marketing - a technical discussion on architectures and how they affect what you do.
SessionID: 11173
Authorization Access Rights w/ SharePoint SQL
Event Date: 03-11-2012 - Session time: 00:00:00 - Track:
Speaker: Carl Rabeler
Title: Authorization Access Rights w/ SharePoint SQL
Abstract:
SessionID: 11444
Recovering from Corruption
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 6 -Performance
Speaker: Robert Davis
Title: Recovering from Corruption
Abstract:
Corruption cannot always be avoided. You can take steps to ensure early detection, and you can prepare for the eventuality of it occurring, but it's not possible to completely prevent it. Early detection is your best protection against data lost due to corruption.
In this session, we will discuss the protections within SQL Server to help identify corruption and to help recover from it. We will look at the different types of corruption that could hit your database and the best way to deal with each type. Includes live demos recovering from different types of corrupt databases.
SessionID: 12730
Overview of PowerPivot
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 3 -BI Treats
Speaker: David Eichner
Title: Overview of PowerPivot
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users of Excel to extract business intelligence from a variety of data sources. This introductory session will demonstrate the power of PowerPivot in analyzing large sets of data quickly and efficiently.
SessionID: 13397
Agile Data Warehousing with WhereScape
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 2 -SQL Dev
Speaker: Douglas Barrett
Title: Agile Data Warehousing with WhereScape
Abstract:
SessionID: 13965
Powershell Smoke for SQL Server Mirrors
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 4 -Powershell
Speaker: Ed Snajder
Title: Powershell Smoke for SQL Server Mirrors
Abstract:
SQL Server mirrors are a great way to maintain highly available, fast-failover systems that run on independent disk sets. While it is easy enough to work through the GUI or T-SQL to manage your mirrors, if you have a lot of them, the processes can become tedious. Also, there is not a fast easy way to tear down and build up a mirror after something goes wrong.
I’ll show how I leveraged some of the SMO mirroring objects, so that I could not only build and tear down database mirrors efficiently, but to also monitor their health. These same objects can be used to build mirror-aware applications, or ones that could automate the provisioning of highly available databases for critical applications.
SessionID: 14082
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 6 -Performance
Speaker: Eddie Wuerch
Abstract:
SessionID: 15052
Understanding Indexes
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 1 -Indexes
Speaker: Hugo Kornelis
Title: Understanding Indexes
Abstract:
The key to answering this is understanding how SQL Server lays out your data on disk, how this changes when you add an index, and how SQL Server uses these indexes to find the information required for your queries.
In this presentation, Hugo explains (with animated visualization) how heaps, clustered indexes, and nonclustered indexes are organized on disk, and used for scans, seeks, and lookups. Armed with this information, you should be able to find just the right set of indexes for your workload.
SessionID: 15053
Advanced Indexing
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 1 -Indexes
Speaker: Hugo Kornelis
Title: Advanced Indexing
Abstract:
So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!
Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
SessionID: 15669
Extend Your Knowledge with Extended Events!
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 7 -Getting it Right
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15837
Isn't that Spatial! (BI Edition)
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 3 -BI Treats
Speaker: Jason Horner
Title: Isn't that Spatial! (BI Edition)
Abstract:
In this session, we will walk through the process of building a spatial data
warehouse from the ground up. We will first design a basic spatial data
warehouse, then identify and import a spatial data source by using Microsoft
SQL Server Integration Services (SSIS), and finally write a spatial query to
provide data to SQL Server Reporting Services (SSRS). We will also review
basic concepts of working with spatial data in SQL Server.
SessionID: 16584
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 6 -Performance
Speaker: Jeremiah Peschka
Abstract:
The database the most critical piece of any environment; performance problems in the database cascade outward to effect everyone. This talk will cover tried and true techniques to ease the pain of growing a database while improving application performance from the perspective of both a large enterprise and a small business.
SessionID: 16722
Looking to the future - Tabular Mode SSAS
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 8 -ETL Analysis
Speaker: Josh Fennessy
Title: Looking to the future - Tabular Mode SSAS
Abstract:
In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.
SessionID: 16885
The Accidental Programmer
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 2 -SQL Dev
Speaker: Jason Kassay
Title: The Accidental Programmer
Abstract:
Most people in the database world have heard of the term, "The Accidental DBA", those programmers who have to work with databases. How about the other side of the coin? What about DBA's an Dev's who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.
SessionID: 16906
Power View for Geographical Analysis
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 3 -BI Treats
Speaker: Julie Koesmarno
Title: Power View for Geographical Analysis
Abstract:
SessionID: 17106
SSIS Patterns and Practices: Loading Fact Tables
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 8 -ETL Analysis
Speaker: Joe Salvatore
Title: SSIS Patterns and Practices: Loading Fact Tables
Abstract:
This session focuses on many patterns, practices, and important considerations for loading data warehouse fact tables using SQL Server Integration Services.
SessionID: 18919
Troubleshooting SQL Server with PowerShell
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 4 -Powershell
Speaker: Laerte Junior
Title: Troubleshooting SQL Server with PowerShell
Abstract:
SessionID: 19169
Index Psychiatry: The Top 5 Disorders
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 1 -Indexes
Speaker: Kendra Little
Title: Index Psychiatry: The Top 5 Disorders
Abstract:
SessionID: 19546
READPAST Furious-Transactions,LockingIsolation
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 6 -Performance
Speaker: Mark Broadbent
Title: READPAST Furious-Transactions,LockingIsolation
Abstract:
Do you really understand SQL Servers’ Concurrency behaviour?
Are you sure that Transactions are an ALL or NOTHING operation?
Do you believe Read operations cannot start a Transaction?
Do you really know if READ UNCOMMITTED is safe for reporting?
Is being Optimistic really better than being Pessimistic?
Can SQL Server 2012 be the solution to all our problems or our worst nightmare?
I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner.
SessionID: 19792
SQLCAT - Building scalable cloud applications
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 5 -On/Off Prem
Speaker: Mark Simms
Title: SQLCAT - Building scalable cloud applications
Abstract:
The SQLCAT team has successfully architected, designed and built over 50 SQL Server cloud projects. We want to share the learnings on how to design a cloud application to scale to handle large, complex workloads using Windows Azure SQL Database. Building cloud applications are different than building on premise database driven applications.
SessionID: 19833
Efficient On-Premise to Cloud Data Transfer
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 5 -On/Off Prem
Speaker: Matt Masson
Title: Efficient On-Premise to Cloud Data Transfer
Abstract:
SessionID: 20365
The Most Ignored Best Practices
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 7 -Getting it Right
Speaker: Michael Swinarski
Title: The Most Ignored Best Practices
Abstract:
SessionID: 20377
Rapidly Deploying SQL Server with PowerShell
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 4 -Powershell
Speaker: Michael Wells
Title: Rapidly Deploying SQL Server with PowerShell
Abstract:
As much as you love SQL Server, do you cringe anytime you hear that you’ll need to stand up yet another SQL Server instance? Sure it’s fun, but who has the time? Maybe you’ve thought there must be a better way of doing this? Sure, you have the ability to generate an unattended install file, but what about all the other things that will need to be done? In this talk, we will explore a process that was created to truly automate not just the SQL Server install, but all of the configurations and the deployment of your organizations standard objects, all using a set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours for one organization and can do the same for yours.
SessionID: 20378
Running SQL Server 2012 on Server Core: Why How
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 5 -On/Off Prem
Speaker: Michael Wells
Title: Running SQL Server 2012 on Server Core: Why How
Abstract:
Security and Performance are always two of the top issues for SQL Server DBAs. Until recently the cost of the Operating System was something that you had almost no control over, but with SQL Server 2012 (Denali) you now have the option of running on the Core edition of Windows Server. While Core edition has been used primarily for infrastructure servers like Domain Controllers and DNS servers, SQL Server 2012 now brings support for running the database engine on it. This session will talk about when you may want to consider running SQL on Server Core and will guide you through the task of installing and configuring your server when you no longer have most of the Windows configuration tools that you may be used to.
SessionID: 21737
New Data Management Capabilities with SQL Server 2
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 7 -Getting it Right
Speaker: Pat Sinthusan
Title: New Data Management Capabilities with SQL Server 2
Abstract:
SessionID: 21834
Power View and PowerPivot: High-Octane Self-svc BI
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 3 -BI Treats
Speaker: Paul Turley
Title: Power View and PowerPivot: High-Octane Self-svc BI
Abstract:
SessionID: 21978
What's New for Self-Service BI in Excel 2013
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 3 -BI Treats
Speaker: Peter Myers
Title: What's New for Self-Service BI in Excel 2013
Abstract:
SessionID: 21979
Introduction to SQL Server 2012 MDS and DQS
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 8 -ETL Analysis
Speaker: Peter Myers
Title: Introduction to SQL Server 2012 MDS and DQS
Abstract:
This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).
MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.
DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.
SessionID: 23001
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 2 -SQL Dev
Speaker: Rick Morelan
Abstract:
SessionID: 23235
Schema Design: Advanced Data Validation Techniques
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 7 -Getting it Right
Speaker: Rob Garrison
Title: Schema Design: Advanced Data Validation Techniques
Abstract:
Fixing bad data is a huge problem. How about if you could design your schema so that it checked the data on the way in?
The beginner-level techniques here are very important and useful: primary key, alternate key/unique index, foreign key, etc. But what else can you do to lock down the data in your database? You will leave this session with a better understanding of the normal techniques and some new ones that you probably haven't used before.
SessionID: 23627
SSRS data driven subscription using SSIS
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 8 -ETL Analysis
Speaker: Russel Loski
Title: SSRS data driven subscription using SSIS
Abstract:
SessionID: 23998
A Tour in The Indexing World!
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 1 -Indexes
Speaker: Hossam Alfraih
Title: A Tour in The Indexing World!
Abstract:
SessionID: 24133
SQL Azure - What is it and why do you need it?
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 5 -On/Off Prem
Speaker: Scott Klein
Title: SQL Azure - What is it and why do you need it?
Abstract:
This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about.
SessionID: 25737
Unleashing Common Table Expressions in SQL Server
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 2 -SQL Dev
Speaker: Steve Stedman
Title: Unleashing Common Table Expressions in SQL Server
Abstract:
SessionID: 26612
SSIS Incremental Load Design Patterns
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 8 -ETL Analysis
Speaker: Tim Mitchell
Title: SSIS Incremental Load Design Patterns
Abstract:
(Note: This session will be co-presented by Tim Mitchell and Matt Masson)
In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion:
•Deciding whether an incremental load is appropriate
•Pick your tool: T-SQL or SSIS?
•Methods for de
SessionID: 26845
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 6 -Performance
Speaker: Tim Ford
Abstract:
SessionID: 27374
The Significance of Choosing and Using Data Types
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 7 -Getting it Right
Speaker: Vern Rabe
Title: The Significance of Choosing and Using Data Types
Abstract:
SessionID: 27442
What DBAs Should Know About Windows Server 2012
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 2 -SQL Dev
Speaker: Victor Isakov
Title: What DBAs Should Know About Windows Server 2012
Abstract:
SessionID: 8852
PowerShell for Data Professionals
Event Date: 03-11-2012 - Session time: 00:00:00 - Track: 4 -Powershell
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract: