sqlsathistory

Nr: 229

Back to Main list

SQLSaturday #229 - Dublin 2013

Start Time (24h) Speaker Track Title
00:00:00 Bob Duffy Charlemont 1 Optimising a dot.net solution on the SQL platform
00:00:00 Chris Webb Charlemont 3 DAXMD: SSAS Multidimensional meets DAX and Power View
00:00:00 Christina Leo Charlemont 1 The Secret Life of APPLY: Helping Developers Work Smarter, Not Harder
00:00:00 Niall McLeod Charlemont 2 The all-flash datacentre. Hyperscale acceleration.
00:00:00 n/a n/a Charlemont 4 Session Details not available
00:00:00 David Morrison Charlemont 1 Query Plans Deep Dive
00:00:00 Gail Shaw Charlemont 2 Dos and don’ts of database corruption
00:00:00 Ian Meade Charlemont 1 Dynamic code for efficient searching
00:00:00 Niko Neugebauer Charlemont 3 Analyzing Twitter Data for Everyone
00:00:00 Javier Caceres Charlemont 1 Data Architectural Patterns in C#
00:00:00 Jen Stirrup Charlemont 3 Data Visualisation with Hadoop Mashups, Power View and Excel 2013
00:00:00 John Corley Charlemont 3 SharePoint 2013 and SQL Server 2012 as part of a BI Strategy
00:00:00 Kevin Kline Charlemont 4 SQL Server Internals Architecture
00:00:00 Tobias Koprowski Charlemont 4 SQL Azure from Plan, to Backup, to Cloud
00:00:00 Mark Broadbent Charlemont 1 READPAST Furious-Transactions,LockingIsolation
00:00:00 Matt Masson Charlemont 3 Cats, Facebook, and Online Dating with Microsoft BI
00:00:00 Mark Stacey Charlemont 2 Analysis Services for the DBA
00:00:00 Michael Morris Charlemont 2 Choosing the right Storage technology for SQL Server (Flash or rotating or both? For OLTP or DW)
00:00:00 Neil Hambly Charlemont 2 SQL Server 2012 Memory Management
00:00:00 TBC TBC Charlemont 4 SQL Server in Windows Azure Virtual Machine Scenarios
00:00:00 Satya Jayanty Charlemont 2 SQL Server Data platform upgrade Techniques, best practices notes from the field
00:00:00 Stephen Archbold Charlemont 2 Getting the most from your SAN - File and Filegroup design patterns
00:00:00 Variou Various Charlemont 4 SQL SATURDAY LIGHTNING TALKS
00:00:00 Aaron Bertrand Charlemont 3 T-SQL : Bad Habits Best Practices
00:00:00 Allan Mitchell Charlemont 4 Hadoop for the Microsoft Guy

SessionID: 10555

Optimising a dot.net solution on the SQL platform

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 1

Speaker: Bob Duffy

Title: Optimising a dot.net solution on the SQL platform

Abstract:

In this case study we will take a sample dot.net ecommerce application running in a load test harness and show common performance worst practices, how to correct them and the impact on performance. During a series of live demos we aim to test just how far we can optimise transactional processing.This session is aimed to help developers and DBA’s understand the performance impact of choices made within a dot.net application and its interaction with SQL Server.

SessionID: 11475

DAXMD: SSAS Multidimensional meets DAX and Power View

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 3

Speaker: Chris Webb

Title: DAXMD: SSAS Multidimensional meets DAX and Power View

Abstract:

This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View. It will show how Multidimensional models are mapped to Tabular concepts, what works and what doesn't work in DAX, how Power View works with Multidimensional models and what other benefits there are to using DAX with a Multidimensional model.

SessionID: 11624

The Secret Life of APPLY: Helping Developers Work Smarter, Not Harder

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 1

Speaker: Christina Leo

Title: The Secret Life of APPLY: Helping Developers Work Smarter, Not Harder

Abstract:

At the very least, a T-SQL developer should know that the APPLY operator lets you access data from a table-valued function in a dynamic manner. But why stop there? When getting the data you need requires going around your elbow to get to your nose, that's when the savvy developer remembers the APPLY operator can be used with any table expression. Have you ever wished you could get multiple columns or multiple rows from a correlated sub-query? What about needing to UNPIVOT a data set, or parse some XML code? Have you simply wanted to find a way to handle complex calculations without having to cut and paste the entire formula in the WHERE or GROUP BY clause? This all-demo session answers those needs by revealing the secret life of APPLY, and helping you count yourself among those ace developers that use this handy operator to work smarter, not harder.

SessionID: 11896

The all-flash datacentre. Hyperscale acceleration.

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Niall McLeod

Title: The all-flash datacentre. Hyperscale acceleration.

Abstract:

This session will discuss the topic of an all-flash datacenter where simplified, higher density and more reliable servers make the hyperscale all-flash datacenter more efficient than datacenters based on solid state disk and hard disk systems. Find out how this changes the landscape of your datacenter and what this means for the future?

SessionID: 12081

Session Details not available

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 4

Speaker: n/a n/a

Title: Session Details not available

Abstract:

Session Details not available

SessionID: 12834

Query Plans Deep Dive

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 1

Speaker: David Morrison

Title: Query Plans Deep Dive

Abstract:

In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query.

We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,. Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code

SessionID: 14362

Dos and don’ts of database corruption

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Gail Shaw

Title: Dos and don’ts of database corruption

Abstract:

Database corruption is one of the worst things you can encounter as a DBA. It can result in downtime, data loss, and unhappy users. What’s scary about corruption is that it can strike out of the blue and with no warning, and without having some

In this session we’ll look at • Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption • Best practices for handling a database that you suspect may be corrupted • Actions that can worsen the problem • Appropriate steps to take and methods of recovery

SessionID: 15298

Dynamic code for efficient searching

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 1

Speaker: Ian Meade

Title: Dynamic code for efficient searching

Abstract:

Illustrate how multipurpose queries can lead to issues with scalability and performance. Show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then work through building a dynamic search query to resolve the identified performance issues. Touching on: • Testing. • Tuning each part of the query in isolation. • Plan cache re-use • Security – SQL injection attacks and authorisation / code signing. • Possibly, mentioning greater re-use and extendibility.

SessionID: 15371

Analyzing Twitter Data for Everyone

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 3

Speaker: Niko Neugebauer

Title: Analyzing Twitter Data for Everyone

Abstract:

This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis.

SessionID: 16020

Data Architectural Patterns in C#

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 1

Speaker: Javier Caceres

Title: Data Architectural Patterns in C#

Abstract:

This session will present the following topics:

(1) Data architectural patterns that can be implemented in a modern Software Architecture for favoring non-functional requirements such as resource management (concurrency, even distribution) and resource demand (incremental caching, hash partitions). (2) Design techniques (like Resource Pooling, Do Not Wait / Fire and Forget , preferred caching components) and principles (like Eventual consistency, CAP theorem, Fine grained vs coased grained, Statelessness, Idempotency and fallacy of zero latency) to improve the application performance in the data access layer.

This session is for Software Developers/Designers/Architects and Data Architects interested in exploring the available options

SessionID: 16551

Data Visualisation with Hadoop Mashups, Power View and Excel 2013

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 3

Speaker: Jen Stirrup

Title: Data Visualisation with Hadoop Mashups, Power View and Excel 2013

Abstract:

The Hadoop ecosystem is a valuable tool for Business Intelligence and Data Visualisation practitioners. It allows you to mashup unstructured data from Hadoop with structured data from more traditional relational and multi-dimensional sources. For Business Intelligence practitioners, this is an excellent tool to gain new business insights, and overcome data silos that come from within the organisation, whilst freeing you to make use of external data sources too.

Join us at this session in order to see how your Big Data can empower your business users via familiar Business Intelligence tools such as Excel and Power View.

SessionID: 17149

SharePoint 2013 and SQL Server 2012 as part of a BI Strategy

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 3

Speaker: John Corley

Title: SharePoint 2013 and SQL Server 2012 as part of a BI Strategy

Abstract:

Reliable Business Intelligence is a major factor of success for any organisation. Gartner have stated that information and analytics will power revenue growth in 2013. This session will detail the integration potential between SQL Server 2012 and new release SharePoint 2013, including PowerView and Performance Point. The session will include a demo of SharePoint 2013 to demonstrate the power of SharePoint and SQL Server. As current Information Worker Solutions Partner of the Year and Microsoft Gold Business Intelligence Partners, Spanish Point have deployed highly successful Business Intelligence Projects

SessionID: 18203

SQL Server Internals Architecture

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 4

Speaker: Kevin Kline

Title: SQL Server Internals Architecture

Abstract:

Want to take your skills to the next level? Then it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:- What are the various areas of memory inside of SQL Server?- How are queries handled behind the scenes?- What does SQL Server do with procedural code, like functions, procedures, and triggers?- What happens during checkpoints? Lazywrites?- How are IOs handled with regards to transaction logs and database?This fast paced session will take you through many aspects of the internal operations of SQL Server. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

SessionID: 18728

SQL Azure from Plan, to Backup, to Cloud

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 4

Speaker: Tobias Koprowski

Title: SQL Azure from Plan, to Backup, to Cloud

Abstract:

Microsoft released SQL Azure more than two years ago - that's enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services. In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.

SessionID: 19534

READPAST Furious-Transactions,LockingIsolation

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 1

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: 19837

Cats, Facebook, and Online Dating with Microsoft BI

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 3

Speaker: Matt Masson

Title: Cats, Facebook, and Online Dating with Microsoft BI

Abstract:

SessionID: 20093

Analysis Services for the DBA

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Mark Stacey

Title: Analysis Services for the DBA

Abstract:

Many DBAs have heard the term Analysis Services, but don't really know what it's for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution.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: 20249

Choosing the right Storage technology for SQL Server (Flash or rotating or both? For OLTP or DW)

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Michael Morris

Title: Choosing the right Storage technology for SQL Server (Flash or rotating or both? For OLTP or DW)

Abstract:

* What do I really need

SessionID: 21352

SQL Server 2012 Memory Management

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Neil Hambly

Title: SQL Server 2012 Memory Management

Abstract:

SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory.

This session will dive into questions related to memory primarily for SQL Server 2012.

SessionID: 23445

SQL Server in Windows Azure Virtual Machine Scenarios

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 4

Speaker: TBC TBC

Title: SQL Server in Windows Azure Virtual Machine Scenarios

Abstract:

In this session we will address four key scenarios for customers using SQL Server in a Windows Azure Virtual machine:

SessionID: 25001

SQL Server Data platform upgrade Techniques, best practices notes from the field

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Satya Jayanty

Title: SQL Server Data platform upgrade Techniques, best practices notes from the field

Abstract:

Why Upgrade?

This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices. Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits. In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, SQL Server 2008 R2 (with a good overview on 2012 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution is offered.

SessionID: 25289

Getting the most from your SAN - File and Filegroup design patterns

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 2

Speaker: Stephen Archbold

Title: Getting the most from your SAN - File and Filegroup design patterns

Abstract:

You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you're only seeing 200 MB/s?

This session will dive into how to optimise your File and Filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customer's table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include:

SessionID: 34870

SQL SATURDAY LIGHTNING TALKS

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 4

Speaker: Variou Various

Title: SQL SATURDAY LIGHTNING TALKS

Abstract:

Various speakers will each give a 5 minute talk on a topic of their choice

SessionID: 8912

T-SQL : Bad Habits Best Practices

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 3

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits Best Practices

Abstract:

Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.

SessionID: 9290

Hadoop for the Microsoft Guy

Back to calendar

Event Date: 22-06-2013 - Session time: 00:00:00 - Track: Charlemont 4

Speaker: Allan Mitchell

Title: Hadoop for the Microsoft Guy

Abstract:

Microsoft have released a distribution of Hadoop targeted at making big data accessible to everyone. Hadoop is different to SQL Server. Not necessarily better, just different. It is a tool for a job. if you have only ever worked with an RDBMS such as SQL Server then Hadoop is going to play with your mind a little and you are going to need to rethink a few things.

This session is going to take Hadoop and break it apart. I will also look at some of the tooling Hive and Pig. Keep an open mind and let me show you that Hadoop has lots to offer.

This site is open source. Improve this page.