| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 02-03-2015 00:00 | André Kamman | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Build Your Own Monitoring System with PowerShell |
| 02-03-2015 00:00 | Klaus Aschenbrenner | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Latches, Spinlocks, and Lock Free Data Structures |
| 02-03-2015 00:00 | Tim Peterson | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Use the Power of Analytical Hierarchies in Your Cubes |
| 02-03-2015 00:00 | Reza Rad | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Azure Data Factory vs SSIS |
| 02-03-2015 00:00 | Damian Widera | Regular Session (60 minutes) | Database and Application Development | Clustered Columnstore Indexes in Great Depth |
| 02-03-2015 00:00 | Margarita Naumova | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | A Deep Dive into SQL Server Plan Cache Management |
| 02-03-2015 00:00 | Gerhard Brueckl | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Deep-Dive to Analysis Services Security |
| 02-03-2015 00:00 | Matan Yungman | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Query Progress Tracking in SQL Server |
| 02-03-2015 00:00 | Florian Eiden | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | A Modern BI Platform using Azure in PaaS |
| 02-03-2015 00:00 | Jen Stirrup | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Pulling Back the Green Curtain: Data Forensics, Power BI, and Dataviz |
| 02-03-2015 00:00 | Joseph D'Antoni | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | SQL Server DR in Microsoft Azure—Building your Second Data Centre |
| 02-03-2015 00:00 | Scott Klein | Pre-Conference Session (full day) | Database and Application Development | Microsoft’s Cloud Data Services; What You Need to Know |
| 02-03-2015 00:00 | Mark Souza | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Microsoft SQL Server: Hybrid computing evolution |
| 02-03-2015 00:00 | Nigel Ellis | Regular Session (60 minutes) | Database and Application Development | Microsoft Azure SQL DB – An Inside Look |
| 02-03-2015 00:00 | Rohan Kumar | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Microsoft SQL Server In Memory Technology from the inside |
| 02-03-2015 00:00 | Simon Lyngby Kokkendorff, Thorbjørn Nielsen | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Denmark in Minecraft – a geosocial experiment |
| 02-03-2015 00:00 | Itzik Ben-Gan | Regular Session (60 minutes) | Database and Application Development | Identity, Sequence and ROW_NUMBER |
| 02-03-2015 00:00 | Reeves Smith | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | A New Approach to Unit and Integration Testing in SSIS |
| 02-03-2015 00:00 | Leila Etaati | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Show Me Potential Customers: Data Mining Approach |
| 02-03-2015 00:00 | Emanuele Zanchettin | Regular Session (60 minutes) | Database and Application Development | Implementing and Maintaining an Azure SQL Database Project |
| 02-03-2015 00:00 | Peter Myers | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | Superhero Power BI |
| 02-03-2015 00:00 | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Integration Services (SSIS) for the DBA | |
| 02-03-2015 00:00 | Michael Frandsen | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | High Performance Infrastructure for SQL Server 2014 |
| 02-03-2015 00:00 | Uwe Ricken | Regular Session (60 minutes) | Database and Application Development | Building Abstract Layers for Data Protection and Business Logic |
| 02-03-2015 00:00 | Brent Ozar | Regular Session (60 minutes) | Database and Application Development | Watch Brent Tune Queries |
| 02-03-2015 00:00 | Steve Simon | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Challenges to Designing Financial Warehouses and Lessons Learned |
| 02-03-2015 00:00 | Paresh Motiwala | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Database Forensics |
| 02-03-2015 00:00 | Grant Fritchey | Regular Session (60 minutes) | Database and Application Development | Automating Your Database Deployments |
| 02-03-2015 00:00 | Rasmus Reinholdt | Regular Session (60 minutes) | Database and Application Development | Taking Your Application to Memory |
| 02-03-2015 00:00 | Itzik Ben-Gan | Pre-Conference Session (full day) | Database and Application Development | Practical T-SQL: Efficient Solutions |
| 02-03-2015 00:00 | Grant Fritchey | Pre-Conference Session (full day) | Database and Application Development | Query Performance Tuning: Start to Finish |
| 02-03-2015 00:00 | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | Understanding SSIS Internals and Performance Tuning | |
| 02-03-2015 00:00 | Rafal Lukawiecki | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | Advanced Analytics with Azure Machine Learning, SQL Data Mining, and R |
| 02-03-2015 00:00 | Brent Ozar | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | SQL Server Performance Tuning |
| 02-03-2015 00:00 | Peter Myers | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Big Data Analytics with Excel |
| 02-03-2015 00:00 | Pieter Vanhove | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Advanced Backup and Restore |
| 02-03-2015 00:00 | Guy Glantser | Regular Session (60 minutes) | Database and Application Development | How to Use Parameters Like a Pro and Boost Performance |
| 02-03-2015 00:00 | Alberto Ferrari | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Budgeting with PowerPivot |
| 02-03-2015 00:00 | Marco Russo | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Power BI Dashboarding |
| 02-03-2015 00:00 | Scott Klein | Regular Session (60 minutes) | Database and Application Development | Data-Tier Considerations of Cloud-Based Application Design |
| 02-03-2015 00:00 | John Martin | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | SQL Server AlwaysOn in a Multi-site World |
| 02-03-2015 00:00 | Kevin Boles | Regular Session (60 minutes) | Database and Application Development | SQL Server Unit Testing |
| 02-03-2015 00:00 | Tobias Koprowski | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | SQL Security in the Cloud |
| 02-03-2015 00:00 | Hugo Kornelis | Regular Session (60 minutes) | Database and Application Development | Now Where Does THAT Estimate Come From? |
| 02-03-2015 00:00 | Joe Chang | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Automating Execution Plan Analysis |
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Let's build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We'll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I'll show you how to store the results and report on it across all your servers in one go.
This session will be presented based on an existing solution and will have lots of notes from the field. The focus will be mainly on configuring, debugging and using remoting and parallel processing but I will also show how to set up the plumbing around it to create a complete system.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
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.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
In this hands-on session, we will go over the ways SQL Server gives us for tracking progress of processes and queries, and identifying bottlenecks in real-time. Among other topics, we will talk about the percent_complete column, how the CXPacket wait type can help us, to Rollback or not to Rollback, and how the new sys.dm_exec_query_profiles DMV can help us.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Let’s make sense of all that and define canonical architectures for modern data platform, adapted to real world scenarios, used not only for reporting but also for analytics.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Traditionally, this would limit available options for disaster recovery (DR). However, now with Windows Azure virtual machines and SQL Server, you can design and build a highly available hybrid solution.
This session will showcase how you can use all of SQL Server’s DR features in this model, as well as how to build an environment solely in Windows Azure. You will learn to back up your databases to Azure Blob storage to protect backups. You will gain an understanding of the networking model within Azure. You will see the implementation of log shipping, replication, mirroring, and AlwaysOn Availability Groups in a hybrid model.
You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
This presentation is targeted at SQL Server practitioners interested in learning more about Azure SQL Database and will provide them with working knowledge of the what/why and an outline of the internals of the system.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
January 1 2013 marked a paradigm shift when a vast array of public sector information was made publicly available at no cost for private companies and citizens. To demonstrate an alternative use of the free public data, and to spur the interest for geographic data in education, the Geodata Agency launched the project “Denmark’s Free Geodata in a Minecraft World” in April 2014. The project comprises a nationwide set of Minecraft files available for download and an online demonstration hosted on three servers.
In this talk we will present some of the technical challenges in creating the Minecraft model of Denmark, the data we used and the overwhelmingly positive response the initiative has received.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This development pattern uses metadata authored by analysts to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
how to set data sets and use different data mining algorithms to get predictive results and then demonstrate how to find the best predictions.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
The aim of this session is to excite you with the potential of Microsoft's new self-service suite of BI products and collaboration platform, called Power BI. You will learn about four “Power” authoring products available in Excel and how they function to discover, acquire, transform, relate, and enrich data for analysis and reporting. Topics include Power Query, PowerPivot, Power View, and Power Map.
You will also learn how to effectively share and collaborate on Power BI solutions in the cloud with Office 365. Topics include data refresh to on-premise data, the data catalog to search for data queries, natural language query (Q&A) to intuitively query data, and a mobile application for Power BI.
This session has been designed to provide perspective across the Power BI story. Theory and an end-to-end series of real-world demonstrations will allow you to appreciate how the Power BI products span on-premise and cloud environments and how they attain super-strength as they work together.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
In this session, you will learn what SSIS is and which components it consist of. You will also learn how to use the SSIS catalog, which is new in SQL Server 2012, to track the execution of the package. As well as how to troubleshoot packages when they fail or cause problems.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
In this session, we will discuss the new storage features in Windows Server 2012 and R2 and how they relate to SQL Server 2012 and how SQL Server 2014 expands on this.
In working with the Core Windows Server team in Redmond during the development of Windows 8/2012 and 8.1/R2, the presenter did a lot of work with technologies which have been around for some time, but unavailable to Windows Server installations. We will talk about InfiniBand, SMB, Multi-path I/O, RDMA, RoCE, NAND Flash storage, latency and much more.
Having worked on the development of SQL Server 2014 and Win8.1, the speaker will share completely new concepts of integration between SQL Server and modern hardware. A sneak peek of Windows 10 and SQL Server vNext will be touched
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
We will discuss the goals of a forensic investigation, define breaches, types of breaches and how to verify them. We will also learn about various database file formats, methodology of forensic investigation, collection and analysis of artifacts. We will take a look at native SQL methods. We will also cover what artifacts to collect and why.
We will also cover a couple of third party tools available in the market. Understand why it is not always easy to use these tools.
Can we retrace the DML/DDL statements and possibly undo the harm?
We will also learn how to preserve the evidence, how to setup HoneyPots.
We will also look at the Initial and Advanced Response Toolkit. How to use SQL Binaries to determine hack.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development
This full-day seminar is dedicated to correct understanding of T-SQL querying fundamentals. You will learn about the principal elements in the foundations of the language. You will learn about logical query processing—what I find to be the most critical aspect of T-SQL that any T-SQL practitioner should master. Then the seminar covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators. If time will permit, the seminar will also cover the fundamentals of more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window functions.
Know your T-SQL querying fundamentals well, and then tackling advanced problems will be so much easier.
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development
We will start by covering how to gather query performance metrics using tools available directly from Microsoft, such as dynamic management objects and extended events. We’ll then move into common performance problems, how they show themselves in the metrics and execution plans, and how to address them. You will leave with a working knowledge of query performance tuning, a set of methods for identifying poorly performing queries, scripts to help out, and the knowledge you need to fix your own systems.
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
The first part of this full-day session will cover the internals of SSIS. Starting with an overview, we will move into the details of the control flow engine and the data flow engine. At the end of the internals section, you will have a deep understanding of the strengths and weaknesses of SSIS and what is the best way to design your packages.
The second part will cover the architecture of the SSIS Server, which came with SQL Server 2012. We will dive into the SSIS catalog and the host process used to execute the packages.
The third part will cover how we can use the knowledge about the internals of SSIS to gain better performance. This part will show practical examples of common performance problems, and how these can be solved. Furthermore we will look at how designing and tuning your data flows can increase performance significantly.
Module 1: SSIS package internals
Module 2: SSIS Server architecture
Module 3: Performance tuning
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
• Introduction to predictive analytics, data mining, machine learning, and rudimentary descriptive statistics, as well as data and content types used in the process (this will be at level 200) • Data preparation, model building, and its very important validation, on-premise, using SQL Server Data Mining (level 300) • Model building and testing in the cloud, using Azure ML (level 250) • Use and deployment of both on-premise models (using T-SQL and DMX) and cloud-based models (using REST web services API) at level 300 • A level 300-400+ look into the specifics of a few interesting and useful algorithms, including Regression and Classification Decision Trees, Random Forests and Jungles, Association Rules, Neural Networks and Logistic Regression, and a brief, level 400+ look at balancing model performance to user requirements by selecting the correct sensitivity vs specificity thresholds.
At the end of the day you will have learned the entire process of machine learning and data mining, focusing on the often missed out part of correct data preparation, which should enable you to start experimenting with your own data straight away. Although we cannot promise that, we will also do our best to make sure you are tired, as this will be a very intensive day, so please sign up if you like the idea of learning lots in a short span of time.
Event Date: 02-03-2015 00:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
You'll learn:
This session is for developers and DBAs who have to make SQL Server go faster. You should be comfortable writing queries and creating tables, but not as confident about interpreting SQL Server's DMVs and diagnostic data.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
This session will be of interest to those new to the concept of big data, and who are interested to see a series of demonstrations that setup a big data cluster, prepare data, and use Pig and Hive to process and retrieve big data results. With a specific focus on self-service querying with Excel, big data results will be retrieved with Power Query, and queried by using Hive to process a Power Pivot data model.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
This session is bulk loaded with demos and it will give you a good idea what infrequently features can be helpful in your environment, like:
- Backup
? Partial backups
? Full File Backups
? Backup Encryption
? Backup striping and backup I/O buffers
- Restore
? Restart an Interrupted Restore
? Files and Filegroups
? Online Restore
? Restore pages
? Piecemeal Restore
- Backup and Restore System Databases
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
When it comes to budgeting, each company is a unique scenario. In this session, Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on products which do not yet exist.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
With the introduction of Availability Groups and Multi-subnet capability with SQL Server 2012 it is now even easier to build a multi-site & multi-subnet solution.
With this ease of deployment it is more important than ever to look at the important configuration options that can have a big impact in multi-site implementations but not in single-site. Covering things like Asymmetric storage configurations, DNS considerations and the advances in clustering.
By the end of this session, you will be in a position to confidently start building out multi-site Highly Available and effective Disaster Recovery solutions that meet the complex needs of your business, for on-premises, hybrid and cloud based deployments.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are used to estimate row counts, and how filters and joins further influence those estimates. Though the focus of this session is on understanding the cause of bad estimates, you will also learn some ways to fix the problems and get better estimates - and hence, better performing queries.
Event Date: 02-03-2015 00:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment