Nr: 198
SQLSaturday #198 - Vancouver, BC 2013
SessionID: 10115
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1205
Speaker: Edwin Sarmiento
Abstract:
SessionID: 10260
SQL Server TDE
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1750
Speaker: Ben Miller
Title: SQL Server TDE
Abstract:
Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE.
SessionID: 11245
What Excel 2013 really means for BI
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1840
Speaker: Cathy Dumas
Title: What Excel 2013 really means for BI
Abstract:
Excel 2013 was silently packed with a slew of new BI features, including native integration of the PowerPivot and Power View add-ins.
Come see some demos of how these new features work. Although you will see some pretty visualizations, there's more to Excel 2013 than dancing bubbles. There are some serious implications to taking advantage of these new technologies. Learn some of the trade-offs involved in taking advantage of these new features, especially when working with multiple data sources.
SessionID: 11438
Implementing Contained Databases
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1205
Speaker: Robert Davis
Title: Implementing Contained Databases
Abstract:
Contained Databases is a new feature introduced in SQL Server 2012. We will take a look at the security implications of contained databases and why it considered only “partially” contained. This technical dive into the feature will demonstrate how to implement contained databases, how to migrate a contained database, and
what “gotchas” to be aware of.
SessionID: 11760
Doing More With Less-SQL Server Policy Based Mgmt
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1750
Speaker: Colin Stasiuk
Title: Doing More With Less-SQL Server Policy Based Mgmt
Abstract:
Do more with less… sound familiar? In this demo rich introduction to Policy Based Management presentation we will be going over what Policy Based Management is and how you can use Policy Based Management and a Central Management Server to evaluate your daily, weekly, and monthly checklists against your entire SQL Server environment. We will be reviewing some of the “out of the box” policies as well as creating some custom policies that you might be interested in evaluating against all of your SQL Server instances.
SessionID: 11800
StreamInsight: Complex Event Processing by MS
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW9 - Room 110
Speaker: Constantin Klein
Title: StreamInsight: Complex Event Processing by MS
Abstract:
In this session you will learn what a great addition for your toolbox StreamInsight is, if you have to develop applications, that have to handle complex events (CEP- Complex Event Processing). See how you can start with this technologie and how easy it is to jump in for .NET developers.
SessionID: 12145
Large SQL Workloads on Microsoft's Private Cloud
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW9 - Room 110
Speaker: Damir Bersinic
Title: Large SQL Workloads on Microsoft's Private Cloud
Abstract:
In this session you will learn about the capabilities in Windows Server 2012 Hyper-V that allow you to take large-scale SQL Server workloads and migrate them to Microsoft’s Private Cloud. You will find out how to configure the key resources – memory, CPU, network, and disk – to help enable the largest SQL Server implementations to perform well. You will see how System Center 2012 SP1 helps you deal with performance and other issues allowing you to respond more quickly to elements that may impact the applications your users depend on. Finally, we will demonstrate how implementing SQL Server on a Private Cloud helps to more easily deal with routine maintenance of both SQL Server and the infrastructure supporting it.
SessionID: 12781
SRS Report Builder for Business Intelligence
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1850
Speaker: David Eichner
Title: SRS Report Builder for Business Intelligence
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!
SessionID: 13363
SQL Server Reporting Services 2012 Jumpstart
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1840
Speaker: Donabel Santos
Title: SQL Server Reporting Services 2012 Jumpstart
Abstract:
SessionID: 14813
Data Profiling with SSIS Data Profiling Task
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1850
Speaker: Greg Larsen
Title: Data Profiling with SSIS Data Profiling Task
Abstract:
SessionID: 14915
New Backup and Deployment features in SQL Server 2
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1750
Speaker: Guy Bowerman
Title: New Backup and Deployment features in SQL Server 2
Abstract:
Cumulative update 2 introduces new features to SQL Server backup and Sysprep which enable important hybrid scenarios. In this session you’ll learn how to use and troubleshoot the new features.
SessionID: 15077
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1710
Speaker: Hugo Kornelis
Abstract:
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.
However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of SQL Server and still get good performance.
SessionID: 15379
Inheriting a database for Developers, version 2
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW9 - Room 110
Speaker: Niko Neugebauer
Title: Inheriting a database for Developers, version 2
Abstract:
SessionID: 16913
Power View for Geographical Analysis
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1840
Speaker: Julie Koesmarno
Title: Power View for Geographical Analysis
Abstract:
SessionID: 17492
Data Quality Services Approach to Cleansing
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1850
Speaker: Joseph Verftido
Title: Data Quality Services Approach to Cleansing
Abstract:
Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. We'll show you how DQS sets itself apart from conventional data cleansing routines that we’re used and go through examples on how to begin your own Data Quality Project. But what really makes DQS unique and powerful is its ability to access shared knowledge. In this presentation, we will also go through how to access and use that shared knowledge.
SessionID: 17514
Demystifying BISM and Tabular Mode SSAS
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1840
Speaker: Josh Fennessy
Title: Demystifying BISM and Tabular Mode SSAS
Abstract:
In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation.
SessionID: 17515
The Essential 8: Narrative Reporting Techniques
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1840
Speaker: Josh Fennessy
Title: The Essential 8: Narrative Reporting Techniques
Abstract:
Providing boring static reports is no longer acceptable in today's business culture. Analytics are expected to be highly visual, interactive, and should tell a meaningful story. The latest version of Microsoft Excel is designed to perform those duties and more. Narrative reporting goes far beyond the tabular format and eliminates the need for comments.
Learn how to craft narrative style reporting in this unique session. Join Josh Fennessy and Julie Koesmarno as they guide you through several design scenarios that are often asked of a business analyst. You'll learn Excel reporting techniques that will enable you to build highly visual and interactive reports without the need for heavy infrastructure requirements.
SessionID: 17574
Configuring SharePoint for Business Intelligence
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1205
Speaker: John White
Title: Configuring SharePoint for Business Intelligence
Abstract:
SessionID: 17613
SSIS Configurations in SQL Server 2012
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1850
Speaker: Jean Rene Roy
Title: SSIS Configurations in SQL Server 2012
Abstract:
SessionID: 17884
Model-Driven Database Design
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1840
Speaker: Karen Lopez
Title: Model-Driven Database Design
Abstract:
Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as "Who does what?", "Why are we doing this?", "Do I have to Use a GUI?" and "Just who do you think you are?". Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.
SessionID: 20048
Entity Framework 5
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1205
Speaker: Medhat Elmasry
Title: Entity Framework 5
Abstract:
Never tried Entity Framework before? Or long term Entity Framework developer? Come learn how Entity Framework 5 makes it very simple to keep both your code and database in sync as you make changes using Code First and Migrations. Plus learn about many other enhancements including Designer improvements and support for new Enums and Spatial types.
SessionID: 20444
Query Plans and Indexes in SQL Server
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1750
Speaker: Michael DeFehr
Title: Query Plans and Indexes in SQL Server
Abstract:
Data access can be easy to set up in your applications with wizards and ORMs, but sometimes your queries are just not as fast as you think they should be – especially on those tables that are getting bigger and bigger. In this session, we will take a peek under the hood and see how SQL server answers the questions you ask of it. This is an introductory session, but it will be jam-packed with demos and useful tips that you will be able to use to make your applications more responsive.
SessionID: 21542
Data Quality rulez! Go best practise
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1850
Speaker: Oliver Engels
Title: Data Quality rulez! Go best practise
Abstract:
With the new Data Quality Services (DQS) Microsoft has an offering for Data
Quality Management. This session gives you insights how to use DQS efficiently.
In demos you will understand best practises in setting up a knowledge base,
correct matching rules and how to integrate DQS to your processes as DQS is
never an island solution. DQS performance aspects and how to report your
quality improvements will round up the session. The session assumes that you
have already tested DQS and want to get further with this toolset.
SessionID: 21744
SQL Server 2012 in Virtualization World
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1025
Speaker: Pat Sinthusan
Title: SQL Server 2012 in Virtualization World
Abstract:
SessionID: 21831
Visualization Choices: What, When, and How?
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1025
Speaker: Paul Turley
Title: Visualization Choices: What, When, and How?
Abstract:
SessionID: 22996
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW9 - Room 110
Speaker: Rick Morelan
Abstract:
SessionID: 22997
New SQL 2012 Functions
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW9 - Room 110
Speaker: Rick Morelan
Title: New SQL 2012 Functions
Abstract:
SessionID: 23032
Deep Dive to SQL Server Parallel Query Processing
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1710
Speaker: Rohan Joackhim
Title: Deep Dive to SQL Server Parallel Query Processing
Abstract:
During query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will start with the basics of parallelism in SQL Server. Then lead you to understand what is under the hood of parallel query execution. How you can avoid or benefit from parallelism in OLTP or OLAP environment.
SessionID: 24079
Kung Fu Migration to Windows Azure SQL Database
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1025
Speaker: Scott Klein
Title: Kung Fu Migration to Windows Azure SQL Database
Abstract:
SessionID: 24683
Taking BI to the Next Level: Collaboration
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1205
Speaker: Stacia Varga
Title: Taking BI to the Next Level: Collaboration
Abstract:
SessionID: 24684
Power View: A Peek Behind the Curtain
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW9 - Room 110
Speaker: Stacia Varga
Title: Power View: A Peek Behind the Curtain
Abstract:
SessionID: 24759
Building apps for SharePoint 2013 and Profiting!
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1205
Speaker: Yaroslav Pentsarskyy
Title: Building apps for SharePoint 2013 and Profiting!
Abstract:
SessionID: 24766
SQL Impossible: Restoring/Undeleting a table
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1750
Speaker: Mladen Prajdić
Title: SQL Impossible: Restoring/Undeleting a table
Abstract:
Yes, you read the title right.
No, it's not about the usual "one table per partition" and "restore full backup then copy the data over" methods.
No, there are no 3rd party tools involved. Just you and your SQL Server.
Yes, it's crazy. No, it's not for production purposes. And yes, that's why it's so much fun.
Prepare to dive into the world of data pages, log records, deletes, truncates and backups and how it all works together to get your table back from the endless void.
Want to know more? Come and see!
SessionID: 25132
Database Design Throwdown
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1710
Speaker: Thomas LaRock
Title: Database Design Throwdown
Abstract:
Karen and Tom debate about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys *NULL vs NOT NULL * Agile Database Design * Database Refactoring * How much does Size Matter? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 25133
Database Design: Size DOES Matter
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1710
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 25741
Exploring the TSQL Enhancements in SQL Server 2012
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1710
Speaker: Steve Stedman
Title: Exploring the TSQL Enhancements in SQL Server 2012
Abstract:
SQL Server 2012 adds many new enhancements to TSQL. Learn how to use the windowing functionality of the OVER clause to create sliding aggregation. Find out about the new SEQUENCE object and when you should or should not use it to replace an IDENTITY. Learn the IIF function and CHOOSE function to replace a common simple CASE functions. OFFSET / FETCH will be covered to show you how to eliminate cursors or CTEs for data paging. With CONCAT you have an easier time building strings in your TSQL statements independent of the data type, and without concern over nulls. With these and other new TSQL enhancements you will be able to take full advantage of the power of TSQL in SQL Server 2012.
SessionID: 27113
SQL Server 2012: AlwaysOn
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1025
Speaker: Richard Baumet
Title: SQL Server 2012: AlwaysOn
Abstract:
Go through the artichecture for setting up AlwaysOn talking about the differnt technogies involved and how you can leverage them to divide up workloads among different replicas. You'll quickly know why this HADR solution is one of SQL Server 2012's biggest feature
SessionID: 34676
DBCC WritePage and Data Recovery
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1025
Speaker: John Huang
Title: DBCC WritePage and Data Recovery
Abstract:
DBCC WritePage is an undocumented command that allows users to modify physical pages directly. It can only be useful for database repairing when there are extreme situations where nothing can help you recover your data. It makes troubles in most of the time. But it's a good tool for learning other stuff. More importantly, you need to know this when others have already known.
In this 500 level session, We will explore some internals, use this command or other ways to break the database integrity, and use this tool to recover it. I will also demonstrate you how to keep yourself safe from using this command.
SessionID: 34719
Applied Enterprise Semantic Mining
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW5 - Room 1850
Speaker: Mark Tabladillo
Title: Applied Enterprise Semantic Mining
Abstract:
Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining.
SessionID: 8853
PowerShell for Data Professionals
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1750
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 8911
T-SQL : Bad Habits and Best Practices
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW3 - Room 1710
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits and Best Practices
Abstract:
The session will cover a collection of minor bad habits that can occasionally lead to major problems.
SessionID: 9251
Demystifying Clustering for the DBA
Event Date: 16-02-2013 - Session time: 00:00:00 - Track: SW1 - Room 1025
Speaker: Allan Hirt
Title: Demystifying Clustering for the DBA
Abstract: