Nr: 193
SQLSaturday #193 - Phoenix 2013
SessionID: 10400
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Brian Flynn
Abstract:
SessionID: 10617
Data Quality Services and SSIS
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / BID
Speaker: Brad Baker
Title: Data Quality Services and SSIS
Abstract:
SessionID: 11334
Enterprise Tabular Models
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA
Speaker: Carlos Bossy
Title: Enterprise Tabular Models
Abstract:
SessionID: 11335
Predictive Modeling with SQL Server Data Mining
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA
Speaker: Carlos Bossy
Title: Predictive Modeling with SQL Server Data Mining
Abstract:
This session will show you how to solve a real-world data mining problem by demonstrating the entire development life cycle of a predictive model. Attendees will learn the essentials required to harness the power of a decision tree algorithm to develop and optimize a production ready predictive model. Carlos will also show how to iterate through the process to improve the model’s effectiveness. Finally, you will see show how to make the most of a predictive model by deploying it and utilizing in your applications and reports
SessionID: 11495
Interview Tips
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Chris Shaw
Title: Interview Tips
Abstract:
Have you been asked for an interview for that perfect job? The job that you would love to have on a team that you really want to be a part of? It is time to sharpen those interview skills.
Every interview is different. During this session we will talk about my observations from many interviews that I have been a part of. There are many examples in this session on how not to present yourself, during an interview. We may laugh at some of the observations, but there are many lessons to learn. Get an inside look at how hiring managers make decisions, and make sure you know what to look for as the candidate.
Have you been tasked with conducting an interview? We will complete the session with some tips on how to make sure that you get the information you need to make a good decision.
SessionID: 11496
"What is the Best Disaster Recovery Solution?"
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Chris Shaw
Title: "What is the Best Disaster Recovery Solution?"
Abstract:
It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.
SessionID: 11756
Delphix Agile Data Management
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV
Speaker: Colin Smith
Title: Delphix Agile Data Management
Abstract:
SessionID: 11757
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Colin Smith
Abstract:
Now that you know the basics, we will dive into functions and profiles. I will show you how to create your own function library so you can call these functions whenever you need to. This session will be very demo driven, and I will show you how to write scripts in order to offload the simple repeatable tasks that you have to do.
SessionID: 12724
Matching and Survivorship
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV
Speaker: David Eichner
Title: Matching and Survivorship
Abstract:
SessionID: 13403
A Heart ot Heart with the Business User
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Azure Big Data Prof Dev
Speaker: Dave Pettengill
Title: A Heart ot Heart with the Business User
Abstract:
This session discusses how we can deliver a better BI product if we learn to better communicate with the business user and get then to think differently about data and about their needs.
Attendees will gain an understanding of how to initiate conversations and begin a process of increasing the quality of user requirements. They will also learn how to start and develop this process to get user buy in. The end goal is to fully utilize BI capabilities to reduce costs, improve performance or identify new business opportunities.
SessionID: 13404
Virtualizing Business Critical SQL Servers
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Dave Pettengill
Title: Virtualizing Business Critical SQL Servers
Abstract:
SessionID: 17481
Global Address Data: Storage and Verification
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV
Speaker: Joseph Verftido
Title: Global Address Data: Storage and Verification
Abstract:
SessionID: 17499
SSRS – Implementing a Rendering Extension
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BID
Speaker: Josh Sivey
Title: SSRS – Implementing a Rendering Extension
Abstract:
SessionID: 17500
Unit Testing your SQL Server database using tSQLt
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV
Speaker: Josh Sivey
Title: Unit Testing your SQL Server database using tSQLt
Abstract:
tSQLt is a database unit testing framework for Microsoft SQL Server. In this session we'll review the main aspects of tSQLt including: installing the tSQLt framework, creating and executing unit tests, isolating code using fake tables/views and stored procedure spies.
SessionID: 17978
Best Practices for Monitoring Databases on VMware
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Kathy Gibbs
Title: Best Practices for Monitoring Databases on VMware
Abstract:
SessionID: 17979
Extend your Knowledge with Extended Events
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / DBA
Speaker: Kathy Gibbs
Title: Extend your Knowledge with Extended Events
Abstract:
With 2012 Extended Events became much easier to use and is a great way to find out more of what is going on in the database. This
presentation will show how you can use Extended Events to find out about items like Deadlocks and Query Performance. We will create a
new Event and I will show you how you can use the data collected to report commonly monitored statistics.
SessionID: 17989
Case studies of Disaster Recovery
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Kat Long
Title: Case studies of Disaster Recovery
Abstract:
From the expect disasters of failed hardware, malicious and unintentional data corruption, to the more unusual disasters of HVac failures, water main breaks, and fire, we will walk through case studies of each type, discuss what went right and what went wrong with the disaster recovery plan and how to plan better in the future. This session is intended to be interactive, to have you thinking about your own environment and what you need to put into place to help you successfully recover from disasters.
SessionID: 19338
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA/BIA
Speaker: Matt Smith
Abstract:
Topics include:
-Parent-Child vs. Natural Hierarchies
-Star vs. Snowflake schemas
-Many to Many relationships
-Partitioning
-Aggregation Designs
-Processing schemes
SessionID: 19749
The 10 Commandments of ETL
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA/BIA
Speaker: Martin Schoombee
Title: The 10 Commandments of ETL
Abstract:
In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I'm sure it will work for you too!!
SessionID: 20139
PowerShell for the SQL Server DBA
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Mark Halstead
Title: PowerShell for the SQL Server DBA
Abstract:
SessionID: 21592
SSAS 2012 Dynamic Security in Tabular Models
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA
Speaker: Orion Gebremedhin
Title: SSAS 2012 Dynamic Security in Tabular Models
Abstract:
An in depth analysis and demonstration of how dynamic security works in SQL Server 2012 Analysis Services tabular models. With a practical demo and comparison to the Multi-Dimensional instance of SQL Server Analysis Services.
SessionID: 21593
MDX For Reporting
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BID
Speaker: Orion Gebremedhin
Title: MDX For Reporting
Abstract:
The multi-dimensional analytic cube is the final output of most data warehousing projects as such a practical understanding of the MDX language as applied to reporting from SSAS multidimensional cubes is extremely important. In this session we will go over some basic to advanced query techniques that any developer can use to create useful data sets from SSAS cubes.
SessionID: 21696
Spatial Data in SQL Server Reporting Services
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BID
Speaker: Nate Locklin
Title: Spatial Data in SQL Server Reporting Services
Abstract:
Will you know where to go when the zombie apocalypse begins? This presentation will offer a fun tutorial for using maps in SQL Server 2012 Reporting Services reports. Sample applications and use of ESRI shapefiles will be included in the demonstration.
SessionID: 21845
Visualization Choices: What, When, and How?
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BID
Speaker: Paul Turley
Title: Visualization Choices: What, When, and How?
Abstract:
SessionID: 21846
Use a custom assembly to extend reports queries
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BID
Speaker: Paul Turley
Title: Use a custom assembly to extend reports queries
Abstract:
Amp up Reporting Services and take your business reports to the next level with custom code written in Visual Studio. Build one dynamic super report to replace several other reports and address business requirements more effectively. Dynamically add or remove query columns, modify groups and sorting options.
SessionID: 22508
Understanding Transaction Isolation Levels
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / DBA
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: 22509
But it worked great in Dev! Perfomance for Devs
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Randy Knight
Title: But it worked great in Dev! Perfomance for Devs
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
SessionID: 22769
Get Into Evaluation Context with DAX, the Language of PowerPivot
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / DBA
Speaker: Reeves Smith
Title: Get Into Evaluation Context with DAX, the Language of PowerPivot
Abstract:
Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demo row and filter context
SessionID: 22770
Master Data Services – 101
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / BID
Speaker: Reeves Smith
Title: Master Data Services – 101
Abstract:
SessionID: 22882
Tabular Models
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA/BIA
Speaker: Jeff Renz
Title: Tabular Models
Abstract:
Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.
SessionID: 22883
Data Vault Data Warehouse Architecture
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA
Speaker: Jeff Renz
Title: Data Vault Data Warehouse Architecture
Abstract:
Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.
SessionID: 23085
Secret life of windowing functions
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV
Speaker: Robert Miller
Title: Secret life of windowing functions
Abstract:
Have you ever wondered what functionality exists in T-SQL for aggregation beyond just using a GROUP BY? Curious as to what Windowing functions are? Curious about the numerous enhancements (developer love) to windowing functions in SQL Server 2012? Then come watch the "Secret life of windowing function" presentation.
SessionID: 23086
You got an OVER clause in my SQL.
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV
Speaker: Robert Miller
Title: You got an OVER clause in my SQL.
Abstract:
The OVER clause tends to be under appreciated and, sometimes, ignored. SQL Server 2012 includes new features in the OVER clause. The new features will be discussed along with what that pesky "Window" thing is and how it fits with the OVER clause.
SessionID: 23564
PowerPivot and Power View for the Business Analyst
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / BID
Speaker: Russ Burns
Title: PowerPivot and Power View for the Business Analyst
Abstract:
Excel 2013 brings PowerPivot and Power View to the desktop (without downloading add-ins) so you should get ready for it. Your users will google Power View and try to make magic with their own data. Unfortunately it isn't as simple as uploading a grid of excel data into PowerPivot and exploring it with Power View. We will work with an imaginary Business Analyst who needs help bringing their data to life.
SessionID: 23565
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / BID
Speaker: Russ Burns
Abstract:
Reporting Services standardizes your report creation and SharePoint enables collaboration and content management. SSRS/SharePoint Integrated Mode gives you a platform to empower your developers, power users, and end users. We will discuss the initial setup of integrated mode, work through some real life strategies using simple out of the box features, and consider some places where more development and planning may be helpful.
SessionID: 23705
Introduction to SQL executions plans
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA/BIA
Speaker: Ryan McCauley
Title: Introduction to SQL executions plans
Abstract:
SessionID: 24146
Kung Fu Migration to Windows Azure SQL Database
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Azure Big Data Prof Dev
Speaker: Scott Klein
Title: Kung Fu Migration to Windows Azure SQL Database
Abstract:
SessionID: 24148
Cloud Database Scalability with SQL Federation
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Azure Big Data Prof Dev
Speaker: Scott Klein
Title: Cloud Database Scalability with SQL Federation
Abstract:
You have migrated your SQL Server database to Windows Azure SQL Database (AKA SQL Azure), and you have migrated your application to Windows Azure. Now what? As the load on your database begins to increase, the need to scale your new SQL Database instance becomes a realization. In this demo-filled session we'll explore SQL Federation, Microsoft's solution for cloud database scalability. This session will look at the scalability model for the cloud and how SQL Federation solves the scale-out issue. We'll look at the architecture of SQL Federation and you can apply SQL Federation to your cloud database solution.
SessionID: 24623
OnPremise to Azure
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Azure Big Data Prof Dev
Speaker: Shannon Lowder
Title: OnPremise to Azure
Abstract:
During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.
SessionID: 24708
A Big Data Primer
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Azure Big Data Prof Dev
Speaker: Stacia Varga
Title: A Big Data Primer
Abstract:
The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
SessionID: 24709
Taking BI to the Next Level: Collaboration
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / BID
Speaker: Stacia Varga
Title: Taking BI to the Next Level: Collaboration
Abstract:
SessionID: 24944
Report Delivery - From Report Manager to the Cloud
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BID
Speaker: Phil Robinson
Title: Report Delivery - From Report Manager to the Cloud
Abstract:
SessionID: 26237
Indexing Deep Dive
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA
Speaker: Kevin Boles
Title: Indexing Deep Dive
Abstract:
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
SessionID: 26238
Common TSQL Mistakes
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA/BIA
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26241
File IO Stalls and Wait Stats - Tune Like Guru!
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Kevin Boles
Title: File IO Stalls and Wait Stats - Tune Like Guru!
Abstract:
SessionID: 27375
The Significance of Choosing and Using Data Types
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Vern Rabe
Title: The Significance of Choosing and Using Data Types
Abstract:
SessionID: 27376
Columnstore Indexes in SQL Server 2012
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / DBA
Speaker: Vern Rabe
Title: Columnstore Indexes in SQL Server 2012
Abstract:
SessionID: 28072
Possible Musics: SSAS Multidimensional vs Tabular
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA
Speaker: William E Pearson III
Title: Possible Musics: SSAS Multidimensional vs Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios.
SessionID: 28074
Getting Started with MDX: The (Very) Basics
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BIA / DBA
Speaker: William E Pearson III
Title: Getting Started with MDX: The (Very) Basics
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
SessionID: 9483
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA/BIA
Speaker: Andrew Duclos
Abstract:
How to successfully deploy permissions, agent job, and better manage the database development life cycle using SSDT.