sqlpasshistory

ID: 27

Back to Main list

PASS SQLRally 2013 Amsterdam

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
06-11-2013 09:00 Adam Machanic Pre-Conference Session (full day) Database and Application Development No More Guessing! An Enlightened Approach to Performance Troubleshooting
06-11-2013 09:00 Brent Ozar Pre-Conference Session (full day) BI Platform Architecture, Development and Administration This Year's SQL Server Setup Best Practices
06-11-2013 09:00 Denny Cherry Pre-Conference Session (full day) Database and Application Development Storage and Virtualization for DBAs
06-11-2013 09:00 Dejan Sarka Pre-Conference Session (full day) BI Platform Architecture, Development and Administration Enterprise Information Management with SQL Server 2012
06-11-2013 09:00 Marco Russo, Alberto Ferrari Pre-Conference Session (full day) BI Platform Architecture, Development and Administration 0 to DAX
07-11-2013 09:00 Steve Simon Regular Session (60 minutes) BI Platform Architecture, Development and Administration Master Data Services Best Practices
07-11-2013 09:00 Brent Ozar Regular Session (60 minutes) Enterprise Database Administration and Deployment Why is SQL Server Slow Right Now?
07-11-2013 09:00 Dejan Sarka Regular Session (60 minutes) BI Platform Architecture, Development and Administration Advanced Analytics in Excel 2013
07-11-2013 09:00 Matija Lah Regular Session (60 minutes) Database and Application Development SQL Server and XML Query
07-11-2013 12:00 Kennie Pontoppidan Regular Session (60 minutes) Database and Application Development SQL anti patterns
07-11-2013 12:00 Jacky van Hogen Regular Session (60 minutes) Database and Application Development SQL Server Availability Groups
07-11-2013 12:00 Hans Geurtsen Regular Session (60 minutes) BI Platform Architecture, Development and Administration Choosing between Tabular and Multidimensional
07-11-2013 12:00 Denny Cherry Regular Session (60 minutes) Enterprise Database Administration and Deployment Flash vs. Disk vs. SSD
07-11-2013 14:15 Francesco Cogno Regular Session (60 minutes) Database and Application Development How to call Windows Azure REST API from CLR
07-11-2013 14:15 Uwe Ricken Regular Session (60 minutes) Database and Application Development FILLFACTOR - pro and con
07-11-2013 14:15 Scott Klein Regular Session (60 minutes) Database and Application Development Microsoft SQL Server In-Memory OLTP Deep Dive
07-11-2013 14:15 Alberto Ferrari Regular Session (60 minutes) BI Platform Architecture, Development and Administration Optimizing Data Models in Tabular & PowerPivot
07-11-2013 15:45 Matija Lah Regular Session (60 minutes) Database and Application Development FILETABLEs: What They Are and How to Use Them
07-11-2013 15:45 Niko Neugebauer Regular Session (60 minutes) BI Platform Architecture, Development and Administration Clustered Columnstore - Deep Dive
07-11-2013 15:45 Henk Van der Valk, Jan Pieter Posthuma Regular Session (60 minutes) BI Platform Architecture, Development and Administration Hadoop
07-11-2013 15:45 Andreas Wolter Regular Session (60 minutes) Enterprise Database Administration and Deployment “SQL Attack…ed” – SQL Server under attack.
07-11-2013 17:00 Adam Machanic Regular Session (60 minutes) Database and Application Development Data, Faster: SQL Server Performance Techniques with SQLCLR
07-11-2013 17:00 Regular Session (60 minutes) BI Platform Architecture, Development and Administration 10 Tips and Tricks for better SSIS Performance
07-11-2013 17:00 Neil Hambly Regular Session (60 minutes) Enterprise Database Administration and Deployment Load Testing with SQL Server Tools
07-11-2013 17:00 Rafal Lukawiecki Regular Session (60 minutes) BI Platform Architecture, Development and Administration Predictive Analytics with SQL Server Data Mining and R
08-11-2013 09:00 Jen Stirrup Regular Session (60 minutes) BI Platform Architecture, Development and Administration Analysing Data with Power View
08-11-2013 09:00 Klaus Aschenbrenner Regular Session (60 minutes) Enterprise Database Administration and Deployment Index Impact Workload Analysis
08-11-2013 09:00 Hugo Kornelis Regular Session (60 minutes) Database and Application Development T-SQL User-defined Functions
08-11-2013 09:00 Oliver Engels, Julian Breunung Regular Session (60 minutes) BI Platform Architecture, Development and Administration M versus P versus R
08-11-2013 10:30 Davide Mauri Regular Session (60 minutes) BI Platform Architecture, Development and Administration Automating DWH Patterns through Metadata
08-11-2013 10:30 Dave Ballantyne Regular Session (60 minutes) Database and Application Development Estimation and Statistics : The basis of query optimization
08-11-2013 10:30 Constantin Klein Regular Session (60 minutes) Database and Application Development StreamInsight: Complex Event Processing by MS
08-11-2013 10:30 Adam Machanic, Thomas Kejser Regular Session (60 minutes) Database and Application Development Using Your Brain to Beat SQL Server
08-11-2013 13:15 Alessandro Recino Regular Session (60 minutes) BI Platform Architecture, Development and Administration Business Intelligence Stack and the Kerberos Authentication Jungle
08-11-2013 13:15 Lord Richard Douglas Regular Session (60 minutes) Enterprise Database Administration and Deployment The Day After Tomorrow: Why you need to baseline
08-11-2013 13:15 Peter Larsson Regular Session (60 minutes) Database and Application Development Fix your EAV data model with a new EAV design
08-11-2013 13:15 Alberto Ferrari Regular Session (60 minutes) BI Platform Architecture, Development and Administration Inside xVelocity Engine
08-11-2013 14:45 Christina Leo Regular Session (60 minutes) Database and Application Development The Secret Life of APPLY: Helping Us Work Smarter, Not Harder
08-11-2013 14:45 Menzo Steinhorst Regular Session (60 minutes) Database and Application Development Reading Query Plans
08-11-2013 14:45 Marcel Westra Regular Session (60 minutes) BI Platform Architecture, Development and Administration Big Data
08-11-2013 14:45 Jenny Rjinbeek Regular Session (60 minutes) Database and Application Development Next Generation Databases with SQLServer 2012 & FusionIO
08-11-2013 16:00 Emanuele Zanchettin Regular Session (60 minutes) Database and Application Development rewrite query with SQLServer2012
08-11-2013 16:00 Paul te Braak Regular Session (60 minutes) BI Platform Architecture, Development and Administration Data Mining - the Art of Unkonwn Business Intelligence
08-11-2013 16:00 Marcel Fernee Regular Session (60 minutes) Database and Application Development SQL IaaS/Private Cloud
08-11-2013 16:00 Brent Ozar Regular Session (60 minutes) Database and Application Development How the SQL Server Engine Thinks

SessionID: 5522

No More Guessing! An Enlightened Approach to Performance Troubleshooting

Back to calendar

Event Date: 06-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: 5521

This Year's SQL Server Setup Best Practices

Back to calendar

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

Speaker(s): Brent Ozar

Title: This Year's SQL Server Setup Best Practices

Description:

SessionID: 5523

Storage and Virtualization for DBAs

Back to calendar

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

Speaker(s): Denny Cherry

Title: Storage and Virtualization for DBAs

Description:

This two-part seminar will focus on two of the biggest topics in the DBA field: how to properly design your SAN storage solution and how to properly design your virtualization solution. The storage portion of this workshop will focus on SAN storage, but most of the material will apply to direct attached storage as well.

We will begin by focusing on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. It ís also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In the first half of this seminar, we will look at storage from both the database and storage perspectives. We will dig into LUNs, HBAs, and the fabric. Then we will examine advanced storage configurations, including RAID groups, multi-pathing software, and proper redundant storage network design. We will also cover some advanced storage array backup techniques, including taking storage level clones and snapshots, then see best practices for using them to back up the SQL Server environment to provide maximum redundancy with no recurring tape costs. In addition to theory, we will look at an actual SAN so we can translate what we see in the Storage Array with what we see on the actual server.

In the second half of the day, we will explore the pros and cons of moving SQL Servers into a virtual server environment, when it is not be a good idea, and when virtualizing a SQL Server is a good idea and can save you some money. We will see how to gather the metrics you need to make the appropriate decision for your environment. We will also look at how to tie the virtual platforms to the storage array so that you can maximize the storage performance for your SQL Servers and the virtual environment.

SessionID: 5525

Enterprise Information Management with SQL Server 2012

Back to calendar

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

Speaker(s): Dejan Sarka

Title: Enterprise Information Management with SQL Server 2012

Description:

Companies want to gather information from their data, so they start BI projects. They design a data warehouse and start developing extract – transform – load (ETL) applications. Then they discover they have data quality (DQ) issues. While poor data quality can cause problems in line-of-business applications, data quality can be a huge obstacle to a successful BI project.

Every company has "master data" - certain data that is used everywhere, in every transaction, such as customers data and products data. The people who manage master data are often called data stewards. Processes and activities for maintaining master data are known as master data management (MDM). In this workshop, we will discuss ETL, DQ, and MDM challenges and look at Microsoft SQL Server technologies and tools that can help you with solutions, including SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS), and other tools for data profiling and matching. Workshop modules include:

  1. Master Data and Master Data Management
  2. Introduction to ETL with SQL Server Integration Services
  3. Improving Data Quality with Data Quality Services
  4. Managing Master Data with Master Data Services
  5. Data Profiling in Depth
  6. Identity Mapping and De-Duplicating

SessionID: 5524

0 to DAX

Back to calendar

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

Speaker(s): Marco Russo, Alberto Ferrari

Title: 0 to DAX

Description:

The DAX language is the foundation of self-service Business Intelligence using the Microsoft stack. It is the language used to query and program both PowerPivot for Excel 2013 and the new SQL Server Analysis Services Tabular model. Learning the basics of DAX is very simple, but mastering it is a different story because it requires a mindset that requires some study, for both BI professionals and Information Workers.

During this full-day workshop, the authors of the bestselling books Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning will guide you through the process of learning the DAX language, using many examples and scenarios that will help you understand important DAX concepts and how to leverage them in your everyday work. This workshop is for data professionals in many different roles, including Information Workers interested in exploiting the many interesting features of PowerPivot for Excel 2013 and BI developers who want to learn the DAX language.

SessionID: 5234

Master Data Services Best Practices

Back to calendar

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

Speaker(s): Steve Simon

Title: Master Data Services Best Practices

Description:

Master Data Services has come a long way since its inception in SQL Server 2008. This has provided a vast wealth of knowledge of best practices from practical production environments. In the presentation we shall be looking best ways to model Master Data Services entities and we shall discuss the design decisions that should be taken into consideration to ensure efficient and effective solutions.

SessionID: 5417

Why is SQL Server Slow Right Now?

Back to calendar

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

Speaker(s): Brent Ozar

Title: Why is SQL Server Slow Right Now?

Description:

You need a fast, easy way to troubleshoot temporary slowdowns on SQL Server 2005, 2008, and 2012. Before you open Task Manager or run sp_who2, join this session for a simple script to rapidly identify common culprits such as blocking queries, long-running jobs, and CPU spikes. You've used sp_Blitz to find out general problems with the SQL Server and you know it's not perfect, but why is it unusually slow RIGHT NOW? Let's tackle it together. When you get back to the office, you'll have: * An easy-to-use script to find bottlenecks fast * Instructions on how to let anybody run it without being SA * Fewer help desk tickets and phone calls pestering you

SessionID: 5528

Advanced Analytics in Excel 2013

Back to calendar

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

Speaker(s): Dejan Sarka

Title: Advanced Analytics in Excel 2013

Description:

Excel is “The” analytical tool in Microsoft suite for advanced analysts. You can use it as a SQL Server Analysis Services client or as a standalone analytical engine. With Excel, you can analyze both, relational and unstructured big data. With PowerPivot, Excel becomes a single-user Analysis Services in tabular mode. The performance of your analytical processing is amazing. With Power View inside Excel, you can create ad-hoc reports on the tabular model with minimal effort. With Data Mining Add-in, you can perform even the most advanced analyzes on your Excel data. This session introduces Excel 2013 and 2010 business intelligence capabilities, and then focuses on the most advanced part, on data mining with Excel.

SessionID: 5248

SQL Server and XML Query

Back to calendar

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

Speaker(s): Matija Lah

Title: SQL Server and XML Query

Description:

XML was added to the collection of SQL Server native data types in SQL Server 2005. Being a complex data type, not only is XML accompanied by a set of dedicated T-SQL functions, but also with a complete querying language. In this session you will learn about the Microsoft SQL Server 2008 implementation of the World Wide Web Consortium's XML Query Recommendation, and learn how to compose XML data – from existing SQL Server data or simply "from scratch", how to retrieve (relational) data from XML Documents to be used in a SQL Server database, and how to manipulate XML data using Transact-SQL and the XML Data Manipulation Language (XML DML). You've already mastered all the primitive SQL Server data types, why would XML be an exception?

SessionID: 5259

SQL anti patterns

Back to calendar

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

Speaker(s): Kennie Pontoppidan

Title: SQL anti patterns

Description:

Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet. We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues.

The session is relevant for developers and DBAs.

SessionID: 5529

SQL Server Availability Groups

Back to calendar

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

Speaker(s): Jacky van Hogen

Title: SQL Server Availability Groups

Description:

This session is about how to configure one or more readable Secondaries for SQL Server 2012 AlwaysOn and the (unexpected) impact of this configuration on the primary Instance.

SessionID: 5240

Choosing between Tabular and Multidimensional

Back to calendar

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

Speaker(s): Hans Geurtsen

Title: Choosing between Tabular and Multidimensional

Description:

OLAP functionality has been part of SQL Server ever since the introduction of OLAP Services in SQL Server 7. Considering the functionality already exists far more than a decade, Analysis Services is still not used as much as one would expect for a feature freely available to all SQL Server customers. One of the reasons why Microsoft added a new choice to Analysis Services which makes building and deploying it easier: tabular mode. In this session you will learn the differences between this new mode and the ‘old’ multidimensional mode. We will look at the BI Semantic Model, which is the foundation of both modes. We will also take a look under the hood to find the xVelocity Engine which makes tabular mode impressively fast. And of course you will see tabular mode in action and learn how easy it is to build a tabular mode Analysis Services database.

SessionID: 5241

Flash vs. Disk vs. SSD

Back to calendar

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

Speaker(s): Denny Cherry

Title: Flash vs. Disk vs. SSD

Description:

In this session we will review the differences between flash, spinning disk and solid state drives. After reviewing the various different kinds of disks we will examine the pros and cons of each kind of disk, finishing with when you want to use each kind of disk in your SQL Server database servers.

SessionID: 5533

How to call Windows Azure REST API from CLR

Back to calendar

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

Speaker(s): Francesco Cogno

Title: How to call Windows Azure REST API from CLR

Description:

Do you like the backup to Windows Azure blob storage feature? Do you know that many Windows Azure features are already available to be exploited to enhance your code?

In this session we'll show you how to cross the gap separating SQL Server from the Windows Azure Platform using the CLR and the Windows Azure REST API. We'll talk about Windows Azure queues, Windows Azure table storage and Windows Azure blob storage and how to exploit them from your T-SQL code. We'll explain in detail how to construct a Windows Azure REST request and how to secure it using both shared key and certificate authentication. Finally, to give you a complete insight of the topic, we'll also talk about debugging tools and techniques useful in the cloud world.

SessionID: 5311

FILLFACTOR - pro and con

Back to calendar

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

Speaker(s): Uwe Ricken

Title: FILLFACTOR - pro and con

Description:

FILLFACTOR is a common option for indexing with heavy workloads (INSERT and UPDATE) in OLTP-Systems.

Learn how to determin the right choice for FILLFACTOR by using index statistics and it's evaluation

SessionID: 5519

Microsoft SQL Server In-Memory OLTP Deep Dive

Back to calendar

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

Speaker(s): Scott Klein

Title: Microsoft SQL Server In-Memory OLTP Deep Dive

Description:

SessionID: 5302

Optimizing Data Models in Tabular & PowerPivot

Back to calendar

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

Speaker(s): Alberto Ferrari

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 we are used to teach: if you known Multidimensional, you need to forget it in order to let the new concepts of Tabular shape your model.

SessionID: 5249

FILETABLEs: What They Are and How to Use Them

Back to calendar

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

Speaker(s): Matija Lah

Title: FILETABLEs: What They Are and How to Use Them

Description:

Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous data store where large objects are stored in tables.

SessionID: 5346

Clustered Columnstore - Deep Dive

Back to calendar

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

Speaker(s): Niko Neugebauer

Title: Clustered Columnstore - Deep Dive

Description:

So you already know and understand Row Groups, Delta Stores and Compression Methods, but let me show you how Clustered Columnstore Indexes work when locking & blocking, when using different compression methods and technics. Let us dive deep into the Dictionaries creation and different methods for the ETL processes.

SessionID: 5651

Hadoop

Back to calendar

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

Speaker(s): Henk Van der Valk, Jan Pieter Posthuma

Title: Hadoop

Description:

Everybody is talking about Hadoop, but what can you do with it? As organizations collect more and more data, they can turn to multiple solutions in the Microsoft stack – including Hadoop and PDW - to store, query, and analyze large amounts of data. But which is better or easier to use for your situation? And how to they compare? In this demo-rich session, learn the basics of Hadoop, how Microsoft has combined the worlds of Hadoop and SQL Server via PolyBase in PDW, and how to use Hadoop data directly in SQL Server PDW via External Tables.

SessionID: 5392

“SQL Attack…ed” – SQL Server under attack.

Back to calendar

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

Speaker(s): Andreas Wolter

Title: “SQL Attack…ed” – SQL Server under attack.

Description:

Although SQL Server is considered "secure by default", one of the most often successfully attacked targets is the data that resides in a SQL Server. Most of the exploited weaknesses are due to misconfiguration or weak coding practices. In this purely demo-based security session, I will show several real life attack scenarios on different layers. Due to special request this includes some special SQL Injection types. Furthermore I show how an evaluation of privileges attack is possible due to a not too uncommon configuration as well as an “insider-exploit” with a database root kit. – Note: there will be no instructions on how to attack a system, but rather highlight common weaknesses. – (almost) no slides: Demos Demos Demos

SessionID: 5440

Data, Faster: SQL Server Performance Techniques with SQLCLR

Back to calendar

Event Date: 07-11-2013 17:00 - 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: 5386

10 Tips and Tricks for better SSIS Performance

Back to calendar

Event Date: 07-11-2013 17:00 - 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: 5235

Load Testing with SQL Server Tools

Back to calendar

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

Speaker(s): Neil Hambly

Title: Load Testing with SQL Server Tools

Description:

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.

Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.

SessionID: 5873

Predictive Analytics with SQL Server Data Mining and R

Back to calendar

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

Speaker(s): Rafal Lukawiecki

Title: Predictive Analytics with SQL Server Data Mining and R

Description:

SessionID: 5363

Analysing Data with Power View

Back to calendar

Event Date: 08-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: 5331

Index Impact Workload Analysis

Back to calendar

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

Speaker(s): Klaus Aschenbrenner

Title: Index Impact Workload Analysis

Description:

Index Impact Workload Analysis

============================== 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: 5526

T-SQL User-defined Functions

Back to calendar

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

Speaker(s): Hugo Kornelis

Title: T-SQL User-defined Functions

Description:

User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus?

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 code encapsulation and reuse, and still get good performance.

SessionID: 5408

M versus P versus R

Back to calendar

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

Speaker(s): Oliver Engels, Julian Breunung

Title: M versus P versus R

Description:

Power Query the new Excel Add In is a great data exploration toolset combined with other add ons

like Power Pivot, Power View and Power Map. This session will take a deep dive into the language behind the Data Explorer: "M". We will take the language concepts and possibilities and compare them with other cool kids in town: "P" (for Python) an "R" THE language for statistical computing and data mining. What possibilities do these languages offer, where can you use them best and how good is the integration to the Microsoft stack. The session is driven by demos and you will take away a good starting point how to work with these three languages.

SessionID: 5368

Automating DWH Patterns through Metadata

Back to calendar

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

Speaker(s): Davide Mauri

Title: Automating DWH Patterns through Metadata

Description:

SessionID: 5315

Estimation and Statistics : The basis of query optimization

Back to calendar

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

Speaker(s): Dave Ballantyne

Title: Estimation and Statistics : The basis of query optimization

Description:

At the heart of SQL Server is the cost based optimizer. Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken. How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t. It estimates! How does it estimate ? That is statistics. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.

SessionID: 5451

StreamInsight: Complex Event Processing by MS

Back to calendar

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

Speaker(s): Constantin Klein

Title: StreamInsight: Complex Event Processing by MS

Description:

The number of sensors is growing and growing and brings us closer to the "Internet of things". Applications, that have to process a big amount of data from event streams are a logical consequence. Some developers might have heard from Reactive Extensions (Rx) already, but Microsoft offers with StreamInsight (SI) another comprehensive platform for these scenarios. 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: 5438

Using Your Brain to Beat SQL Server

Back to calendar

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

Speaker(s): Adam Machanic, Thomas Kejser

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

Business Intelligence Stack and the Kerberos Authentication Jungle

Back to calendar

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

Speaker(s): Alessandro Recino

Title: Business Intelligence Stack and the Kerberos Authentication Jungle

Description:

Claim, Kerberos, EffectiveUserName, Secure store.

If you work with Business intelligence solutions either native or integrated with SharePoint, sooner or later you will come across some decision to make around authentication. In this session you will learn do's and don’ts, how and when to configure the appropriate authentication method for Microsoft BI services.

SessionID: 5432

The Day After Tomorrow: Why you need to baseline

Back to calendar

Event Date: 08-11-2013 13: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: 5333

Fix your EAV data model with a new EAV design

Back to calendar

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

Speaker(s): Peter Larsson

Title: Fix your EAV data model with a new EAV design

Description:

In some cases, the EAV data model is the only way to go for storing your data. I will show you how to build a hybrid EAV data model with a massive execution performance gain.

SessionID: 5429

Inside xVelocity Engine

Back to calendar

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

Speaker(s): Alberto Ferrari

Title: Inside xVelocity Engine

Description:

The xVelocity engine in SQL Server Analysis Services 2012 Tabular is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq. We will show common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model.

SessionID: 5379

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

Back to calendar

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

Speaker(s): Christina Leo

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

Description:

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

Reading Query Plans

Back to calendar

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

Speaker(s): Menzo Steinhorst

Title: Reading Query Plans

Description:

T-SQL is a declarative language. We tell SQL Server what needs to be done, not how to do it. That’s where query plans come in: they tell us how SQL Server executed our queries. And that can be very interesting! This session will be based on real-world scenarios. We will have a look at common operators and check whether they were good or bad. And in which situations those operators are bad. I’ll also show how to change the plan with indexes, statistics and hints.

SessionID: 5527

Big Data

Back to calendar

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

Speaker(s): Marcel Westra

Title: Big Data

Description:

Is Big Data a hype or is it really something new. The intention of this session is to inspire and get new ideas what is possible in the world of data. It will start with a story about the origin of Big Data and continues with a model how you can talk about Big Data. Based on this model all functionality around Big Data of the Microsoft platform will be explained ( Polybase, Power BI, SQL Server Azure Hadoop). The different technologies will be explained with demos and real life examples.

SessionID: 5874

Next Generation Databases with SQLServer 2012 & FusionIO

Back to calendar

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

Speaker(s): Jenny Rjinbeek

Title: Next Generation Databases with SQLServer 2012 & FusionIO

Description:

SessionID: 5466

rewrite query with SQLServer2012

Back to calendar

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

Speaker(s): Emanuele Zanchettin

Title: rewrite query with SQLServer2012

Description:

Among the topics covered are extensions of the ORDER BY clause that simplify the construction of ad hoc query result-set, the news of the OVER clause in SQL Server 2012 greatly expanded through the implementation of options and windowing functions, the new SEQUENCE objects able to generate sequences of numerical values??, the new command that improves the error handling ... and more

SessionID: 5419

Data Mining - the Art of Unkonwn Business Intelligence

Back to calendar

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

Speaker(s): Paul te Braak

Title: Data Mining - the Art of Unkonwn Business Intelligence

Description:

Data mining (or knowledge discovery in databases) is a technique used to derive previously unknown information from large amounts of data. The process of discovery can help to uncover new patterns that lie within the data and therefore can help the analyst understand the data that they are looking at. Additionally, once these rules have been defined, they can be used to predict the likelihood of some event occurring and be used in predictive modelling.

Analysis Services (OLAP) includes a data mining engine which can be used at various levels within the organisation, from Analyst to Developer. This presentation looks at all facets of data mining within Analysis Services by explaining what data mining is and how it can be used across the organisation. We look at simple and complex implementations of data mining so that new information can be extracted from data and used in novel ways.

SessionID: 5532

SQL IaaS/Private Cloud

Back to calendar

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

Speaker(s): Marcel Fernee

Title: SQL IaaS/Private Cloud

Description:

This session shares the lessons learned of customer case on a private cloud. This private cloud is about middleware as a service (for instance SQL Server, SharePoint, etc.) and not infrastructure as a server. You will learn different implementation strategies of the SQL Server HA options and understand the pros and cons of these. During the session you will get to understand the basics of System Center Virtual Machine Manager and learn how to use Service Templates to deploy and service a database application.

This session is relevant for you, if you plan to work on SQL Server in the private cloud. This includes re-usable ‘VM deployments of SQL Server’.

SessionID: 5416

How the SQL Server Engine Thinks

Back to calendar

Event Date: 08-11-2013 16: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.