Nr: 105
SQLSaturday #105 - Dublin 2012
SessionID: 10537
SQL 2012 Always On-Deep Dive
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 2
Speaker: Bob Duffy
Title: SQL 2012 Always On-Deep Dive
Abstract:
Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.
During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery.
This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.
SessionID: 21934
Get the right SQL Certifications for your business
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 2
Speaker: Pete Harris
Title: Get the right SQL Certifications for your business
Abstract:
Pete Harris, SQL Server Product Planner for Microsoft will lead you through the training offered by Microsoft in the area of SQL Server 2012 and SQL Server 2008. He will be supported by Chris Testa-O’Neill, e-learning author, Microsoft Certified Trainer and Senior Consultant at Coeo and a guest MCM / MCA. The session will cover certifications such as:
• Microsoft Certified Technical Specialist
• Microsoft Certified IT Professional
• Microsoft Certified Master
• Microsoft Certified Architect
The Session will also identify and explore available learning channels (Microsoft official courses – instructor led training / e-learning / press books) to support you in achieving your certification
SessionID: 23110
SSIS 2012 Management Considerations and Best Pract
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 4
Speaker: Rushabh Mehta
Title: SSIS 2012 Management Considerations and Best Pract
Abstract:
SessionID: 23446
Drive Greater Application ROI
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 4
Speaker: TBC TBC
Title: Drive Greater Application ROI
Abstract:
Drive Greater Application ROI, Deeper Business Insights, and Faster Time to Market...
Learn how SQL Server 2012 can help you Reduce Your Costs and Increase ROI on Mission Critical Applications while Innovating with New Technology.
• Reduce total cost of ownership of Mission critical and line of business applications
• Increase ROI on current IT investments
• Improve time to market on new IT investments
• SQL Server 2012: an overview of changes to SKU line-up and licensing model
SessionID: 28447
T-SQL : Bad Habits to Kick
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 3
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits to Kick
Abstract:
The session will cover a collection of minor bad habits that can occasionally lead to major problems.
SessionID: 28629
Making Data Fit for Business using DQS
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 2
Speaker: Allan Mitchell
Title: Making Data Fit for Business using DQS
Abstract:
There are lots of DQ issues we are going to talk about some of the common issues and later see how we can handle them. Issues such as
- Misspelled names
- Misspelled addresses – addresses which do not exist, e-mail addresses
- Duplication
Pretty much everyone suffers from these problems so come to this session to learn a new way to deal with them in SQL Server 2012 Data Quality Services
SessionID: 29114
Searching over data and files with SQL Server 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 3
Speaker: Bob Beauchemin
Title: Searching over data and files with SQL Server 2012
Abstract:
With the addition of non-transactional filestream, filetable, semantic search and full-text search support for property search, SQL Server 2012 provides an excellent platform for searching over traditional relational as well as unstructured document data. This talk covers the motivation, implementation, and components that expands and inegrates search capabilities.
SessionID: 29477
Intro to Tabular Model in Analysis Services 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 3
Speaker: Chris Webb
Title: Intro to Tabular Model in Analysis Services 2012
Abstract:
Introduction to the Tabular Model in Analysis Services 2012
The Tabular model in Analysis Services 2012 is the new alternative to building cubes: it’s easier to develop with (especially if you come from a relational database background) and its in-memory, column-store database provides blindingly fast performance. This session will provide a basic introduction to building Tabular models and discuss their strengths and weaknesses compared to cubes.
SessionID: 29540
SQL Server Internals: It's What's for Dinner!
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 1
Speaker: Christina Leo
Title: SQL Server Internals: It's What's for Dinner!
Abstract:
Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server.
SessionID: 29668
Session Details not available
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 2
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 30411
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 1
Speaker: James Baldwin
Abstract:
While historical best practices will continue to apply, added product features such as AlwaysOn, PowerView, Column Store, now brings an extra dimension to consider when deploying and optimizing storage for SQL Server 2012.
This session will cover Storage Best Practices for both existing SQL Server editions and 2012 in common and feature-intense areas. Designing for OLTP, OLAP/DW/BI environments also is addressed.
SessionID: 30716
SQL Server 2012: Business Intelligence Data Viz
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 2
Speaker: Jen Stirrup
Title: SQL Server 2012: Business Intelligence Data Viz
Abstract:
The new Business Intelligence and Data Visualisation functionality are key to the changes in SQL Server 2012. We will take a look at:
- Power View and its impact for Data Visualisation
- PowerPivot improvements and new features
- Reporting Services and its future in Sharepoint
Come to this session in order to 'hit the ground running' with Business Intelligence and Data Visualisation in SQL Server 2012.
SessionID: 31183
Database Design Contentious Issues
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 3
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 31317
Top Ten Things Every Developer Should Know
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 3
Speaker: Kevin Kline
Title: Top Ten Things Every Developer Should Know
Abstract:
SessionID: 31393
Advanced SQL Server 2008 Troubleshooting
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 4
Speaker: Klaus Aschenbrenner
Title: Advanced SQL Server 2008 Troubleshooting
Abstract:
SessionID: 31573
Moves like Jagger-Upgrading to SQL Server 2012
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 1
Speaker: Mark Broadbent
Title: Moves like Jagger-Upgrading to SQL Server 2012
Abstract:
This session will therefore look at some advanced scenarios such as SQL Server 2012 on Server Core, preparing for Always On Availability Groups, upgrading your SQL Failover Cluster, storage migration.
Attend this must see session and you too can have the “Moves like Jagger”.
SessionID: 31612
SSIS in SQL Server 2012: Development Enhancements
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 4
Speaker: Matt Masson
Title: SSIS in SQL Server 2012: Development Enhancements
Abstract:
SessionID: 31709
Analysis Services for the DBA
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 2
Speaker: Mark Stacey
Title: Analysis Services for the DBA
Abstract:
This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and the new Tabular mode.
SessionID: 32052
Effective Data Management using Data Compression
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 1
Speaker: Neil Hambly
Title: Effective Data Management using Data Compression
Abstract:
SessionID: 34345
Getting Started with MDX: The (Very) Basics
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 4
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.
SessionID: 34580
Build a monitoring system with Powershell Remoting
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 1
Speaker: André Kamman
Title: Build a monitoring system with Powershell Remoting
Abstract:
My last session on managing large environments turned out to be more talk than proof, it contained a bunch of war stories and almost no demos.
This session will be the other way around, we're going to spend most of our time in powershell and we'll build a whole monitoring system from scratch.
I'll use powershell remoting and real world demo's based on my own day to day practice.
To keep the promise of a level 300 session I'll spend some time in the beginning to explain the concepts of powershell remoting,
after which I'll build a monitoring system step by step in the second part of the session.
SessionID: 9668
Event Date: 24-03-2012 - Session time: 00:00:00 - Track: Room 3
Speaker: Noemi Moreno Tom Austin
Abstract: