sqlpasshistory

ID: 26

Back to Main list

PASS SQLRally 2013 Nordic

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
04-11-2013 00:00	Ewan Fairweather	Regular Session (60 minutes)	Database and Application Development	CAT: Azure SQL DB Premium Offering – Deep Dive and Mythbuster
04-11-2013 09:00	Davide Mauri, Thomas Kejser	Pre-Conference Session (full day)	BI Platform Architecture, Development and Administration	Data Warehouse Modeling – Making the Right Choices
04-11-2013 09:00	Brent Ozar	Pre-Conference Session (full day)	Database and Application Development	This Year's SQL Server Setup Best Practices
04-11-2013 09:00	Adam Machanic	Pre-Conference Session (full day)	Database and Application Development	No More Guessing! An Enlightened Approach to Performance Troubleshooting
04-11-2013 09:00	Kalen Delaney	Pre-Conference Session (full day)	Database and Application Development	Performance Tuning with Indexes: Internals and Best Practice
05-11-2013 10:30	Adam Machanic	Regular Session (60 minutes)	Database and Application Development	Data, Faster: SQL Server Performance Techniques with SQLCLR
05-11-2013 10:30	Kevin Kline	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	SQL Server Internals and Architecture
05-11-2013 10:30	Marco Russo	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Optimizing Data Models in Tabular & PowerPivot
05-11-2013 11:45	Kalen Delaney	Regular Session (60 minutes)	Database and Application Development	Hekaton for the DBA: A Whole New World
05-11-2013 11:45	Hugo Kornelis	Regular Session (60 minutes)	Database and Application Development	Powerful T-SQL Improvements that Reduce Query Complexity
05-11-2013 11:45		Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	10 Tips and Tricks for better SSIS Performance
05-11-2013 14:00	Brent Ozar	Regular Session (60 minutes)	Database and Application Development	How the SQL Server Engine Thinks
05-11-2013 14:00	Stephen Archbold	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	Getting the most from your SAN - File and Filegroup layout
05-11-2013 14:00	Henk van der Valk	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	SQL Server 2012 PDW (V2) Insights
05-11-2013 15:15	Adam Machanic	Regular Session (60 minutes)	Database and Application Development	Using Your Brain to Beat SQL Server
05-11-2013 15:15	Scott Klein	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	Kung-Fu Migration to Windows Azure SQL Database
05-11-2013 15:15	Alberto Ferrari	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Optimizing DAX Queries
05-11-2013 16:45	Marcel Franke	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Create a Data Science Lab with Microsoft and Open Source tools
05-11-2013 16:45	Klaus Aschenbrenner	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	Index Impact Workload Analysis
05-11-2013 16:45	Uwe Ricken	Regular Session (60 minutes)	Database and Application Development	INSERT / UPDATE / DELETE - internals
06-11-2013 09:00	Tobias Koprowski	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	High Availability of SQL Server in the Context of SLA
06-11-2013 09:00	Jen Stirrup	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Analysing Data with Power View
06-11-2013 09:00	Ewan Fairweather	Regular Session (60 minutes)	Database and Application Development	Azure Premium DB, Virtual Machines & Other Azure Storage Options
06-11-2013 10:15	Lord Richard Douglas	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	The Day After Tomorrow: Why you need to baseline
06-11-2013 10:15	Alexei Khalyako	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Data Warehouse in the Cloud – Marketing or Reality?
06-11-2013 10:15	John Martin	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Compliance & the Data Professional
06-11-2013 11:45	Davide Mauri	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Automating DWH Patterns through Metadata
06-11-2013 11:45	Regis Baccaro	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	Sharepoint for the DBA
06-11-2013 11:45	Tobias Ternstrom	Regular Session (60 minutes)	Database and Application Development	Cloud Optimizing your database app
06-11-2013 14:00	Mikael Wedham	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	The log, the whole log and nothing but the log
06-11-2013 14:00	Margarita Naumova	Regular Session (60 minutes)	Database and Application Development	Does the optimistic concurrency resolve your blocking problems
06-11-2013 14:00	Tim Peterson	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Use the Power of Analytical Hierarchies in Your Cubes
06-11-2013 15:15	Vesa Tikkanen	Regular Session (60 minutes)	Database and Application Development	Data-Tools: Important part of modern Software design
06-11-2013 15:15	Turgay Sahtiyan, Umit Sunar	Regular Session (60 minutes)	Enterprise Database Administration and Deployment	Architecting SQL Server HA and DR Solutions on Windows Azure
06-11-2013 15:15	Gerhard Brueckl	Regular Session (60 minutes)	BI Platform Architecture, Development and Administration	Microsoft Power BI 101

SessionID: 5534

CAT: Azure SQL DB Premium Offering – Deep Dive and Mythbuster

Back to calendar

Event Date: 04-11-2013 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Ewan Fairweather

Title: CAT: Azure SQL DB Premium Offering – Deep Dive and Mythbuster

Description:

SessionID: 5807

Data Warehouse Modeling – Making the Right Choices

Back to calendar

Event Date: 04-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Davide Mauri, Thomas Kejser

Title: Data Warehouse Modeling – Making the Right Choices

Description:

Data warehouses play a central role in any BI solution. It's the back end upon which everything in years to come will be created. For this reason, it must be rock solid and yet flexible at the same time. To develop such a data warehouse, you must have a clear idea of its architecture, a thorough understanding of the concepts of Measures and Dimensions, and a proven engineered way to build it so that quality and stability can go hand-in-hand with cost reduction and scalability. In this workshop, Thomas Kejser and Davide Mauri will share all the information they learned since they started working with data warehouses, giving you the guidance and tips you need to start your BI project in the best way possible?avoiding errors, making implementation effective and efficient, paving the way for a winning Agile approach, and helping you define how your team should work so that your BI solution will stand the test of time.

You'll learn:

Data warehouse architecture and justification Agile methodology Dimensional modeling, including Kimball vs. Inmon, SCD1/SCD2/SCD3, Junk and Degenerate Dimensions, and Huge Dimensions Best practices, naming conventions, and lessons learned Loading the data warehous, including loading Dimensions, loading Facts (Full Load, Incremental Load, Partitioned Load) Data warehouses and Big Data (Hadoop) Unit testing Tracking historical changes and managing large sizes

SessionID: 5806

This Year's SQL Server Setup Best Practices

Back to calendar

Event Date: 04-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development

Speaker(s): Brent Ozar

Title: This Year's SQL Server Setup Best Practices

Description:

You don’t build a lot of SQL Servers, but this year, you need to build one for your company – and it’d better work. You need it to be reliable and fast the very first time. Unfortunately, everything keeps changing, and yesterday’s best practices don’t cover solid state drives, FusionIO, AlwaysOn Availability Groups, and clusters without shared storage. In this all-day session, Microsoft Certified Master Brent Ozar will bring you up to speed. He’ll teach you how to pick storage, when it’s okay to use virtual servers, how to turn business requirements into clustering/mirroring/AlwaysOn/log-shipping, and where to put your data files, log files, and TempDB. This session is for developers and DBAs who need to pick SQL Server hardware and aren’t sure about the options today.

SessionID: 5805

No More Guessing! An Enlightened Approach to Performance Troubleshooting

Back to calendar

Event Date: 04-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development

Speaker(s): Adam Machanic

Title: No More Guessing! An Enlightened Approach to Performance Troubleshooting

Description:

Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution?or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when.

In this full-day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues. All of this will be illustrated through demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper?pinpointing the exact problem and helping you quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.

SessionID: 5803

Performance Tuning with Indexes: Internals and Best Practice

Back to calendar

Event Date: 04-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development

Speaker(s): Kalen Delaney

Title: Performance Tuning with Indexes: Internals and Best Practice

Description:

Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. And knowing how indexes are useful lets us generalize some best-practice recommendations. In this seminar, we’ll look at the following topics:

Basic index structures, including clustered vs. nonclustered, unique vs. non-unique, and Included columns Tools for exploring index structures Index maintenance, including page splits, fragmentation, and defragmentation Index design considerations, including ANDs/ORs, JOINs, and Composite indexes Best-practice guidelines Columnstore index storage Columnstore index guidelines

SessionID: 5439

Data, Faster: SQL Server Performance Techniques with SQLCLR

Back to calendar

Event Date: 05-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Adam Machanic

Title: Data, Faster: SQL Server Performance Techniques with SQLCLR

Description:

Sometimes it seems like business users are constantly more demanding: They want more data, more analytics, more insight, and the output needs to be faster, faster, faster. And so we database developers struggle to write ever more complex queries, tune our hardware, carefully choose indexes...and sometimes it’s just not enough. Where do you go when you’ve hit the performance wall? As more and more developers are discovering, a great choice is to make use of SQL Server’s CLR capabilities. User-defined aggregates, table valued functions, and user-defined types are more than just logical constructs; properly applied, they can make complex, logic-driven queries many times faster. This session will show you when and how to use these powerful tools in ways you may not have previously considered. If you’re ready to take your SQL Server development skills to the next level, this session is definitely your starting point.

SessionID: 5444

SQL Server Internals and Architecture

Back to calendar

Event Date: 05-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Kevin Kline

Title: SQL Server Internals and Architecture

Description:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

• What’s different about 32- and 64-bit systems?
• 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?
• What happens when transaction logs and databases grow or shrinks?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

SessionID: 5394

Optimizing Data Models in Tabular & PowerPivot

Back to calendar

Event Date: 05-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Marco Russo

Title: Optimizing Data Models in Tabular & PowerPivot

Description:

Is your new Tabular solution performing at its best? Are you using the best practices to reduce memory footprint, increase query speed and get the best out of the new engine? In this session, we will look at several techniques that can really make the difference in a Tabular solution. Distinct count reduction, join optimizations, condition consolidation, pros and cons of normalized data models, selection of the columns to store in the database are some of the topics covered in this session, which will highlight not only the best practices, but also practices that were best in Multidimensional and became worst in Tabular. As I am used to say: if you know Multidimensional, you need to forget it in order to let the new concepts of Tabular shape your model.

SessionID: 5809

Hekaton for the DBA: A Whole New World

Back to calendar

Event Date: 05-11-2013 11:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Kalen Delaney

Title: Hekaton for the DBA: A Whole New World

Description:

SQL Server Hekaton, Microsoft’s new In-Memory table technology to be shipped as part of SQL Server 2014, will completely change the way you think about data management. As a DBA, you will need to analyze your memory and storage needs completely differently. All Hekaton data is always stored in memory, and the data stored on disk is basically just a REDO log used to regenerate the contents of your memory-optimized tables. This session will show you the in-memory architecture for your Hekaton data and indexes and discuss what gets written to disk during checkpoints, as well as what gets logged. You will also learn how the recovery process recreates your Hekaton tables.

SessionID: 5373

Powerful T-SQL Improvements that Reduce Query Complexity

Back to calendar

Event Date: 05-11-2013 11:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Hugo Kornelis

Title: Powerful T-SQL Improvements that Reduce Query Complexity

Description:

We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012.

New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features. Attend this session to boldly take SQL Server where it has never gone before!

SessionID: 5385

10 Tips and Tricks for better SSIS Performance

Back to calendar

Event Date: 05-11-2013 11:45 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s):

Title: 10 Tips and Tricks for better SSIS Performance

Description:

Your SSIS packages are taking longer than they should, but you are not sure what to do about it. Join this session to get 10 tips and tricks for gaining better performance. You’ll learn not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and much more.

SessionID: 5415

How the SQL Server Engine Thinks

Back to calendar

Event Date: 05-11-2013 14:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Brent Ozar

Title: How the SQL Server Engine Thinks

Description:

When you pass in a query, how does SQL Server build the results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.

SessionID: 5428

Getting the most from your SAN - File and Filegroup layout

Back to calendar

Event Date: 05-11-2013 14:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Stephen Archbold

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

Description:

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 customers table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include:

• Layout for OLTP
• Data Warehousing Fast Track Style
• Data Warehousing on a SAN
• Get data into your SSAS cubes faster (ProcessData)
• Hidden options and “go faster” buttons
• How to maximise performance in enterprise edition and master read ahead

SessionID: 5340

SQL Server 2012 PDW (V2) Insights

Back to calendar

Event Date: 05-11-2013 14:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Henk van der Valk

Title: SQL Server 2012 PDW (V2) Insights

Description:

Learn about the basic (MPP) architecture & appliance approach of PDW compared to an “traditional” SQL Server20xx SMP and where PDW can help you to analyze more (Big) data easier & faster with new features like the updateable columnstore index and Hadoop integration. Real world customer cases and their benefits achieved by using PDW will be shown.

SessionID: 5437

Using Your Brain to Beat SQL Server

Back to calendar

Event Date: 05-11-2013 15:15 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Adam Machanic

Title: Using Your Brain to Beat SQL Server

Description:

Thought you did everything right? Indexes are finely tuned. Statistics are fully scanned and updated. Your nice big server seems to have plenty of power. But you are still not getting the performance you expect from SQL Server. Why is the optimiser failing you?

SQL Server's query optimizer, often very good at coming up with decently-performing plans, also regularly goes down the wrong path. The problem domain is simply too large and complex for it to adequately cover all cases. When the going gets tough, you mind is a better machine for the job. So don't trust optimisation to a mere piece of code! In this session we will teach you how to recognise various real world cases where the optimiser fails. We will show you why these queries aren't performing as well as they should and how to work around the optimiser's lack of insight. You will learn to turn your brain into a better query optimiser and make your queries faster than you thought possible.

SessionID: 5182

Kung-Fu Migration to Windows Azure SQL Database

Back to calendar

Event Date: 05-11-2013 15:15 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Scott Klein

Title: Kung-Fu Migration to Windows Azure SQL Database

Description:

As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database to the cloud is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database. Focusing primarily on SQL Server Data Tools, the DAC Framework and the Import/Export service, this session will focus on how these tools can make you a kung-fu migration master by showing how these tools can simplify the migration process, provide flexibility and more granular control of the migration, and ultimately ease many of the challenges of getting your on-premises database ready for migration to Windows Azure SQL Database.

SessionID: 5421

Optimizing DAX Queries

Back to calendar

Event Date: 05-11-2013 15:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Alberto Ferrari

Title: Optimizing DAX Queries

Description:

A deep dive into the details of how the DAX query engine works by means of looking and understanding the DAX query plans. We will take several queries and we will optimize live on stage.

SessionID: 5458

Create a Data Science Lab with Microsoft and Open Source tools

Back to calendar

Event Date: 05-11-2013 16:45 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Marcel Franke

Title: Create a Data Science Lab with Microsoft and Open Source tools

Description:

The role of the Data Scientist came up with the Big Data area. But it’s not a quite new role in the enterprise business. So what makes him now so different and how can we establish a laboratory and factory workplace with Microsoft Tools? In this session I will demonstrate how to Setup a typical Data Science workplace with SQL Server, Hadoop, Excel and Power Query, R and other Analytic Tools you need. I will also demonstrate how to leverage all these tools together in order to analyze datasets.

SessionID: 5329

Index Impact Workload Analysis

Back to calendar

Event Date: 05-11-2013 16:45 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Klaus Aschenbrenner

Title: Index Impact Workload Analysis

Description:

Should we add this additional index, should we modify existing ones, or does it make sense to drop unused (?) indexes to improve workload performance? A lot of different questions, but finding correct, profound answers is very hard and difficult. In this session you will learn a proven approach how you can identify if an index change was a good or bad one. We will take a real SQL Server OLTP workload, establish a baseline against it, and use that baseline together with some tools to determine if index changes should be applied to our production databases, or not. After attending this session, it is very easy for you to apply the same techniques to your production environment.

SessionID: 5411

INSERT / UPDATE / DELETE - internals

Back to calendar

Event Date: 05-11-2013 16:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Uwe Ricken

Title: INSERT / UPDATE / DELETE - internals

Description:

Get a deep dive into the log internals when an insert, update, delete happens to your data.

See the tremendous differences between DML of a HEAP and a CLUSTERED INDEX.

What happens to NCI if you run any DML? SEE, what happens when you run your DML

SessionID: 5459

High Availability of SQL Server in the Context of SLA

Back to calendar

Event Date: 06-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Tobias Koprowski

Title: High Availability of SQL Server in the Context of SLA

Description:

If SQL Server is heart of our environment, his health should be very important, right? If SQL Server is important, his availability for our businesses (internal and external) is important to. For our customers doesn't matter where data are stored, how are stored and what we do with those data. Especially for our managers. The data must be available on demand, on time, at he moment of request. High Availability is our responsibility. How we can prepare our environment for HA? How HA is connected for with SLA? And why Service Level Agreement are important for us? In this session I want to discuss about HA options for SQL Server (2008, 2012, 2014), about our different customers, and about Service Level Agreement (formal or not).

SessionID: 5364

Analysing Data with Power View

Back to calendar

Event Date: 06-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Jen Stirrup

Title: Analysing Data with Power View

Description:

Power View is Microsoft's Data Visualisation tool, and is used to analyse data. Using demos, we learn about using Power View to analyse data, whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will: - investigate Power View based on current cognitive research around Data Visualisation principles - examine how data can be analysed with Power View - look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.

SessionID: 5811

Azure Premium DB, Virtual Machines & Other Azure Storage Options

Back to calendar

Event Date: 06-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Ewan Fairweather

Title: Azure Premium DB, Virtual Machines & Other Azure Storage Options

Description:

A number of relational and non-relational storage options are available on Azure, including Azure SQL Database, the new Premium Database offering, SQL in a Virtual Machine, and table storage. In this session, we will do a deep dive into the new Premium offering that Azure SQL Database has in preview. We will describe how it’s implemented and show you how to determine in a systematic way when to use this technology and estimate your capacity needs. You’ll gain an understanding of the performance and scale you can achieve when leveraging Azure SQL Database Premium and how this compares to storage technology and scale-out approaches on Azure. You will also learn how to select the most appropriate technology for a certain scenario and understand what it can provide. We will demonstrate the lessons and best practices gathered during real customer engagements over the past 12 months with the Premium database

SessionID: 5431

The Day After Tomorrow: Why you need to baseline

Back to calendar

Event Date: 06-11-2013 10:15 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Lord Richard Douglas

Title: The Day After Tomorrow: Why you need to baseline

Description:

Ensuring peak SQL Server performance isn’t always easy and requires a lot of work on the part of the DBA. To maintain the best-possible performance, you need to make sure you’re monitoring the right things. But how do you know if the figures you’re seeing are good or bad? Baseline comparisons can help, and in this educational session, SQL Server expert Richard Douglas will show you how to get the most from them. Richard will explain what a baseline is, why and when you need to take one, and how you can create one. You’ll also learn about a number of native Windows and SQL Server tools that will allow you to do just that.

SessionID: 5808

Data Warehouse in the Cloud – Marketing or Reality?

Back to calendar

Event Date: 06-11-2013 10:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Alexei Khalyako

Title: Data Warehouse in the Cloud – Marketing or Reality?

Description:

Despite the buzz around cloud-based solutions, IT and business still have concerns: Is the cloud-based platform reliable? Will I meet my SLA? Will the solution scale? Even more critical yet, can it handle heavy workloads such as data warehouses? Running SQL Server on Windows Azure Virtual Machines, we have validated the scenarios around these questions, using SQL Server 2012 as well as the early bits of SQL Server 2014. And the answer is “Yes!” Join us to find out what we have learned from our research and get some useful tips for future development

SessionID: 5401

Compliance & the Data Professional

Back to calendar

Event Date: 06-11-2013 10:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): John Martin

Title: Compliance & the Data Professional

Description:

Compliance.... It's something that is becoming more and more prevalent in all areas of the IT industry, especially where data professionals are concerned. In this session I will cover some of the considerations of the main compliance regulations that I see most often, PCI-DSS, Sarbanes-Oxley and the Data Protection Act. What are they and how do they apply to me I hear you say, the answer in many cases is "it depends" so bring your questions and we can discuss them.

In addition to this I will also discuss how compliance can help build better systems and drive improvements in processes for all areas of data systems, ranging from the DBA, Developer all the way through the BI spectrum to Big Data.

SessionID: 5367

Automating DWH Patterns through Metadata

Back to calendar

Event Date: 06-11-2013 11:45 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Davide Mauri

Title: Automating DWH Patterns through Metadata

Description:

Something around 80% of the work of a BI solution is spent building the ETL phase. ETL is also usually a quite big challenge, but it can be easily broken down into two - at least - separated processes. One is strictly related to business modeling, and therefore cannot be replicated by definition. The other one is a purely technical processes, always the same regardless of the reality in which we operate, and as so can then be deeply automated.

In this session we will look at the well-known patterns to solve common problems and how they can automated, with the help of specific tools and techniques that utilizes metadata in order to reduce development time and bugs to a minimum. The presented engineered will enable the adoption on an Agile approach to your BI solution.

SessionID: 5441

Sharepoint for the DBA

Back to calendar

Event Date: 06-11-2013 11:45 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Regis Baccaro

Title: Sharepoint for the DBA

Description:

SharePoint Databases are considered as a black box - touch it and you lose support. Furthermore SharePoint leaves a unitelligible track of database names and GUIDs on your server. They promises it scales but how and how much ? There are some techniques that a DBA should be aware of in order to optimize SharePoint performance and scalability.

This demo-packed session based on real life experiences will show you how to tune you SQL Server for SharePoint and how to customize you SharePoint installation so it fits your IT conventions and not the other way round.

SessionID: 5478

Cloud Optimizing your database app

Back to calendar

Event Date: 06-11-2013 11:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Tobias Ternstrom

Title: Cloud Optimizing your database app

Description:

SQL as well as database access techniques have been around and evolved for decades. What changes to your database development tool-belt should you consider when building next generation cloud applications? Come learn about how you can continue to leverage the power of T-SQL and relational databases in the cloud world and avoid common issues.

SessionID: 5342

The log, the whole log and nothing but the log

Back to calendar

Event Date: 06-11-2013 14:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Mikael Wedham

Title: The log, the whole log and nothing but the log

Description:

This session focuses on the transaction log. It begins with a quick glance on what goes on in and around the log in the different recovery modes.

You'll then get a deep dive into log sequence numbers, how to find them and what that info means. The context for theese demos is the backup database and backup log commands. And finally you'll see a demo in which we will recover a database from a total data-drive crash without losing one single transaction. It's all about the log...

SessionID: 5454

Does the optimistic concurrency resolve your blocking problems

Back to calendar

Event Date: 06-11-2013 14:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Margarita Naumova

Title: Does the optimistic concurrency resolve your blocking problems

Description:

Blocking is a common problem in SQL Server databases. There are some well-known recommendations for resolving blocking issues, and one of them is switching to Optimistic Concurrency model. Is it really a solution, when to consider it, how to implement and what to be aware of. The session explains everything you need to know about Optimistic Concurrency in order to make an informed and optimal decision for your solution.

SessionID: 5389

Use the Power of Analytical Hierarchies in Your Cubes

Back to calendar

Event Date: 06-11-2013 14:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Tim Peterson

Title: Use the Power of Analytical Hierarchies in Your Cubes

Description:

Analytical hierarchies bring the questions of the business analyst into the structure of the cubes. This session examines the power of analytical hierarchies, looking specifically at the opportunities provided by calculation hierarchies.

Calculation hierarchies give you the ability to build business models into your cubes. As the insights of business analysts are built into cube calculations, higher levels of insights can be achieved.

Analytical hierarchies can model forecasts and scenarios. They organize multidimensional data into meaningful patterns. Some of the most popular analytical hierarchies provide insight along the time dimension:

Current Period Calculations Relative Date Period Calculations Period To Date and Rolling Average Calculations Comparison, Ratio, and Forecasting Calculations

This session demonstrates all of these types of analytical hierarchies and shows you how you can design and create the specific analytical hierarchies that you need for your organization.

SessionID: 5435

Data-Tools: Important part of modern Software design

Back to calendar

Event Date: 06-11-2013 15:15 - Category: Regular Session (60 minutes) - Track: Database and Application Development

Speaker(s): Vesa Tikkanen

Title: Data-Tools: Important part of modern Software design

Description:

Data Tools is an add-on to Visual Studio. It allows Database development to be one solid part of your Software development process. Database development can be versioned and all the product lifecycle management benefits are part of your database development. In this demo-based presentation you'll see how to take production database to be part of future development. We'll modify the databse for new business requirements and publish the changes as part of our new version. Within demos we'll address the most common issues faced when using data-tools and share the knowledge gained.

SessionID: 5313

Architecting SQL Server HA and DR Solutions on Windows Azure

Back to calendar

Event Date: 06-11-2013 15:15 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Turgay Sahtiyan, Umit Sunar

Title: Architecting SQL Server HA and DR Solutions on Windows Azure

Description:

In the real life scenarios, SQL Server high-availability (HA) and disaster recovery(DR) solutions are not simply cloud-based, on-premises solutions, internally facing or external solutions. They are mix of a little bit everything.

SQL Server Always On offers better availability, higher ROI and simplicity. With easy integration of SQL Server and Windows Azure technologies, you can easily increase the efficiency and effectiveness of your solutions. SQL Server & Windows Azure can easily become the best HA & DR offering for you for multiple aspects.

The session highlights product capabilities, limitations, and trade-offs for various needs such as complex HA & DR scenarios with minimum CAPEX. Cloud is the perfect solution to minimize CAPEX, why they are important to you, how to implement them, and considerations to take.

SessionID: 5467

Microsoft Power BI 101

Back to calendar

Event Date: 06-11-2013 15:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration

Speaker(s): Gerhard Brueckl

Title: Microsoft Power BI 101

Description:

The new “Power BI” suite is Microsoft’s answer to the rising demand for self-service BI solutions on the market. It includes all necessary tools to build a complete BI solution in a couple of minutes within our well know Excel environment. “Power BI” combines former separate tools like DataExplorer (now Power Query) and GeoFlow (now Power Map) with PowerPivot and Power View to offer a complete suite to build self-service BI solutions. This session will cover all of these tools superficially but will also give insights on how to work with them in the real world.