Nr: 120
SQLSaturday #120 - Orange County 2012
SessionID: 10309
From Zero to SQL Azure in 10 Cloudy Steps
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Ben Aminnia
Title: From Zero to SQL Azure in 10 Cloudy Steps
Abstract:
This is my diary of the adventurous road I traveled for exploring the new world of SQL Azure. It spans a time period of about 18 months, with a mix of failures, success stories, and lessons learned.
SessionID: 10310
A Journey through New Features of SQL Server 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 8
Speaker: Ben Aminnia
Title: A Journey through New Features of SQL Server 2012
Abstract:
SessionID: 11322
Preparing Data for Analysis as Tabular Models
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Carlos Bossy
Title: Preparing Data for Analysis as Tabular Models
Abstract:
The new Tabular Model in SQL Server 2012 is being touted as a powerful analytic engine that is faster and easier to implement than traditional cubes using Analysis Service. In this session Carlos Bossy will demonstrate how to develop analytic models using your existing data sources and will discuss best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, Carlos will show you how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience.
SessionID: 11323
Real-time Data Warehouse and Reporting
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Carlos Bossy
Title: Real-time Data Warehouse and Reporting
Abstract:
SessionID: 11468
Extended Events in SQL Server 2008 and 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 7
Speaker: Chris Dickey
Title: Extended Events in SQL Server 2008 and 2012
Abstract:
SessionID: 11732
Optimizing your BI Semantic Model for Power View
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Clint Kunz
Title: Optimizing your BI Semantic Model for Power View
Abstract:
SessionID: 12870
Data Warehouse Best Practices
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Doug Barrett
Title: Data Warehouse Best Practices
Abstract:
This session will describe the best practises for designing a data warehouse to get the most out of SQL Server. Doug has worked in data warehousing for 12 years and will blend experience, with best practises and recommendations from Microsoft's Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
SessionID: 13091
Women in Technology Un-Panel
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Denise McInerney
Title: Women in Technology Un-Panel
Abstract:
There are a variety of issues that affect women working in tech today, both as individuals and as a group. What concerns you as a WIT or someone who supports WIT? Bring your questions and ideas to a WIT un-panel.
SessionID: 13395
Agile Data Warehousing with WhereScape RED
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Douglas Barrett
Title: Agile Data Warehousing with WhereScape RED
Abstract:
SessionID: 14051
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Eddie Wuerch
Abstract:
SessionID: 14052
Join Us! Getting Started as a Technical Speaker
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Eddie Wuerch
Title: Join Us! Getting Started as a Technical Speaker
Abstract:
SessionID: 14053
Page Latches for Mere Mortals
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Eddie Wuerch
Title: Page Latches for Mere Mortals
Abstract:
Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!
SessionID: 14945
Introduction to Log Shipping and Mirroring
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 8
Speaker: Harry Chandra
Title: Introduction to Log Shipping and Mirroring
Abstract:
In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. What are the parts and modes of database mirroring. You will also be introduce to log shipping and how it works. We will have a demo part of the session where we will go through every step of how to set up mirroring and log shipping. By the end of this session, you should have a general understanding and ability to deploy database mirroring and log shipping to meet your High Availability and Disaster Recovery requirement.
SessionID: 16578
Rules, Rules, and Rules
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Jeremiah Peschka
Title: Rules, Rules, and Rules
Abstract:
Database systems are built according to those rules: memory is faster than disk which is faster than the network. Database schemas and queries are built within the rules of database systems. You will hit the limitations of these rules. If you know what the rules are and why they are in place, you'll know when it's time to break them... and how to succeed.
SessionID: 16581
Rewrite your T-SQL for Great Good!
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Jeremiah Peschka
Title: Rewrite your T-SQL for Great Good!
Abstract:
SessionID: 18091
SQL Server First Responder Kit
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Kendra Little
Title: SQL Server First Responder Kit
Abstract:
SessionID: 21463
SQL Azure Data Sync
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 8
Speaker: Nitin Salgar
Title: SQL Azure Data Sync
Abstract:
This session is to discuss the data synchronization strategies. We'll go over setting up a Data Sync service between On Premise and Clound,cloud to cloud and other topologies offered. Will discuss one time data transfer options such as dacpac, Migration wizard and bcp
SessionID: 22112
Up Your Game With OUTPUT
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 7
Speaker: Phil Helmer
Title: Up Your Game With OUTPUT
Abstract:
There are some classic database programming tasks that rely on answering the question "What did I just change?" Prior to SQL Server 2005, we had to use functions like SCOPE_IDENTITY() and some extra tricks for handling multiple rows. Some people even had to resort to triggers. Yikes!! This session focuses on the practical use cases for the T-SQL OUTPUT clause. More importantly, you will find out how you can ditch the tricks of the past for a simpler solution that will help keep you sane.
SessionID: 23013
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Rick Morelan
Abstract:
SessionID: 23014
Avoid Errors on Errors
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Rick Morelan
Title: Avoid Errors on Errors
Abstract:
Did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4.
SessionID: 27564
AlwaysOn – Way to get your 9’s?
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Warren Sifre
Title: AlwaysOn – Way to get your 9’s?
Abstract:
We are always being told 9’s, 9’s and more 9’s, but when implementation time comes to take action, technology / budget limitations get in the way, especially in the High Availability and Disaster Recovery (HA/DR) technology space. Clustering and Mirroring are great and meet many of our needs, but there are some things we have wished for, such as a mirror database that is usable. AlwaysOn solves this limitation by merging both Mirroring and Multi-Node Multi-Subnet Clustering (True Geo-Clustering Support!!!). AlwaysOn also allows the replica database to be used in a Read-Only capacity, so we can use it for reporting purposes. (Imagine that!) Join us in providing a warm welcome to this new functionality with extensive demos.
SessionID: 29024
Discussion-Time Analytics: BI for smart meetings
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Benjamin Muller
Title: Discussion-Time Analytics: BI for smart meetings
Abstract:
Tired of supposedly data-driven discussions that quickly devolve into anarchy, finger pointing, and second guessing? This session will show you how to use new and improved SQL Server 2012 BI capabilities, including PowerPivot v2 and Power View to clear the FUD and get your meetings back on track. We will discuss principals for creating effective, business-oriented BISM models, and visualization techniques that emphasize clarity and usability.
SessionID: 29025
Self-service BI with Power View
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Benjamin Muller
Title: Self-service BI with Power View
Abstract:
SessionID: 29201
Dimensional Modeling Fundamentals
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Brent Greenwood
Title: Dimensional Modeling Fundamentals
Abstract:
In this session, we will walk through the fundamentals of dimensional modeling that are at the core of Kimball method data warehousing. We will cover theory and real world applications of the following:
- The modeling process
- Fact table patterns
- Dimension patterns
- Conforming structures
- Advanced modeling patterns and best practices
SessionID: 29562
SQL Server 2012 EIM (SSIS, DQS, and MDS)
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Matt Hollingsworth
Title: SQL Server 2012 EIM (SSIS, DQS, and MDS)
Abstract:
SessionID: 29980
SQL Server Security 101
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Diana Dee
Title: SQL Server Security 101
Abstract:
Securing SQL Server requires an understanding of how a SQL Server instance and its objects are accessed and how permissions for access are granted or not allowed.
This presentation will cover the entire spectrum from service accounts, logins, and users, to granular permissions and encryption. You should acquire enough understanding to be able to apply the "principle of least privilege" in your own SQL Server environment.
Content:
• Service accounts
• Logins and Users
• Permissions
• Encryption
• Some new security features of SQL 2012
SessionID: 30269
Common Backup Problems and How to Deal With Them
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Grant Fritchey
Title: Common Backup Problems and How to Deal With Them
Abstract:
SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore.
SessionID: 30270
T-SQL Deployment and CI Best Practices
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Grant Fritchey
Title: T-SQL Deployment and CI Best Practices
Abstract:
While most T-SQL developers focus on writing quality T-SQL code and efficient queries, what they often forget is how it should best be deployed. This includes deployment of new applications, as well as upgrades and bug fixes. In this session, you will learn many best practices involving the principles of continuous integration, such as maintaining a code repository, automating builds, self-testing, auditing, automated deployment, and much more. This session is designed for both DBA administrators and developers who want to optimize their T-SQL deployment process.
SessionID: 30360
SQL Azure Federations
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Ike Ellis
Title: SQL Azure Federations
Abstract:
SQL Azure Federations is an amazing way to scale-out relational database applications. You will learn about new T-SQL keywords and why SQL Azure is uniquely suited to solve the relational scale-out problem. Come discover how you can use SQL Azure Federations to handle scale problems of any size!
SessionID: 30481
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Janis Griffin
Title: Don't Panic, DBAs! Databases on VMware made easy.
Abstract:
More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
SessionID: 30483
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 8
Speaker: Janis Griffin
Abstract:
SessionID: 31531
noSQL - why do I care, when how should I use it?
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Lynn Langit
Title: noSQL - why do I care, when how should I use it?
Abstract:
Are you confused (and concerned) by all the talk about noSQL solutions? Are you uncertain as to which solution is right for your situation? (if any). Come to this demo-filled session to understand the noSQL landscape. Includes info about cloud-based BLOB storage from all of the big vendors, i.e. Amazon, Google, Microsoft, Also includes info about Hadoop and other open source databases, such as MongoDB.
SessionID: 31920
Easily Manage your Servers with Policy Based Mgmt
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 7
Speaker: Mitchell Bottel
Title: Easily Manage your Servers with Policy Based Mgmt
Abstract:
In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
SessionID: 31921
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 7
Speaker: Mitchell Bottel
Abstract:
SessionID: 32017
SQL Server Table Partitioning from the ground up
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Denny Cherry
Title: SQL Server Table Partitioning from the ground up
Abstract:
In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will
look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data
from one partition to another and from one table to another with minimal to no impact to the users.
SessionID: 32019
Table Indexing for the .NET Developer
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Denny Cherry
Title: Table Indexing for the .NET Developer
Abstract:
In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best.
SessionID: 32030
SQL 2012 HA/DR Enhancements Overiew
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Steineke
Title: SQL 2012 HA/DR Enhancements Overiew
Abstract:
Overview of new features and enhancements in SQL Server 2012 ‘Denali’ to help support High Availability and Disaster Recovery. Breakdown of AlwaysOn Feature set, and design considerations. What are Availability Groups, and Readable Secondary’s, and how do they work. Multi-Subnet SQL clustering, what no more stretched VLAN? Including demo’s and working systems to review configurations.
SessionID: 32436
Understanding SQL Server XML Features
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Randy Knight
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.
SessionID: 32437
Understanding Transaction Isolation Levels
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 33855
Contained DB? Did it do something wrong?
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Warren Sifre
Title: Contained DB? Did it do something wrong?
Abstract:
Imagine an environment where moving a database from a SQL Instance to another is as simple as just restoring the database. (Yes, no other steps!) SQL Server 2012 RC0 now supports Partial Contained databases. We will cover the different levels of containment, configuring SQL Server to support it, and much more (i.e. Demos).
SessionID: 33856
Introduction to FileTables in SQL 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Warren Sifre
Title: Introduction to FileTables in SQL 2012
Abstract:
SessionID: 8871
PowerShell for Data Professionals
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 7
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 9012
Columnstore Indexes and Data Warehouses
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Benjamin Nevarez
Title: Columnstore Indexes and Data Warehouses
Abstract:
SessionID: 9013
Inside the SQL Server Query Optimizer
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Benjamin Nevarez
Title: Inside the SQL Server Query Optimizer
Abstract:
SessionID: 9014
Understanding Parameter Sniffing
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Benjamin Nevarez
Title: Understanding Parameter Sniffing
Abstract:
SessionID: 9015
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Benjamin Nevarez
Abstract:
SessionID: 9958
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 7
Speaker: Audrey Hammonds
Abstract:
SessionID: 9959
Shiny New T-SQL for SQL Server 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Audrey Hammonds
Title: Shiny New T-SQL for SQL Server 2012
Abstract: