Nr: 336
SQLSaturday #336 - Holland 2014
SessionID: 11575
Understanding SQL Server Parallelism
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Christian Bolton
Title: Understanding SQL Server Parallelism
Abstract:
In this session you’ll learn how SQL Server chooses parallel operations, how to investigate what’s going on and whether your parallel query is running as efficiently as it could be.
SessionID: 12086
Session Details not available
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 13159
SQL Server Deep Dive
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Denis Reznik
Title: SQL Server Deep Dive
Abstract:
SessionID: 13722
Power BI: what, how, why?
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Edgar Walther
Title: Power BI: what, how, why?
Abstract:
This talk is about the self-service BI products that Microsoft has to offer. What is Power BI, how does it fit into a corporate BI environment with SQL Server and why do we want to use it? The Power BI products, Power Query, Power Pivot, Power View, Power Map, will also be shown in this demo-heavy session.
SessionID: 13805
No more waiting – an introduction to SQL Server wait statistics
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Enrico van de Laar
Title: No more waiting – an introduction to SQL Server wait statistics
Abstract:
SessionID: 14800
Building a Database Deployment Pipeline
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Grant Fritchey
Title: Building a Database Deployment Pipeline
Abstract:
The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.
SessionID: 14801
Getting Started Reading Execution Plans
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Grant Fritchey
Title: Getting Started Reading Execution Plans
Abstract:
SessionID: 14959
SQL Server PDW (APS) vs SQL Server, let's see the big differences
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Henk Van der Valk
Title: SQL Server PDW (APS) vs SQL Server, let's see the big differences
Abstract:
SessionID: 15109
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Hugo Kornelis
Abstract:
What to do? Blaming SQL Server is a good start, but won’t solve the problems. You can of course hire a database consultant to make all your performance problems (and all your money) disappear - but why not first take a look yourself?
This session will show you seven simple things, that might alleviate most of your database related performance problems. Use these tricks at your workplace, and you can be the hero of the department!
SessionID: 15114
Advanced Indexing
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Hugo Kornelis
Title: Advanced Indexing
Abstract:
So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!
Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
SessionID: 16243
Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Joseph D'Antoni
Title: Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.
Abstract:
Data Warehouse workloads can be very large and taxing on your database server. With the modern demands of real-time analytics against growing volumes of data this challenge continues. When columnstore indexes and batch mode query processing were introduced in SQL Server 2012 were a performance game changer. In the 2012 implementation of columnstore, direct updating and inserting of data was not supported and other restrictions, such as data types limited the use of the feature. SQL 2014 removes those limitations—you can use a columnstore index as a clustered index, and more importantly directly perform DML against the index. Also, more query operators support batch mode, which means more of your queries can see performance benefits. You will understand the changes for 2014—and how having updateable columnstore indexes may cause changes to your process design. You will see the power of columnstore indexes in analytics, their limits, and how to include them into your system design.
SessionID: 16434
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Jen Stirrup
Abstract:
SessionID: 16926
From Impaired To Insightful Geospatial Reporting
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Julie Koesmarno
Title: From Impaired To Insightful Geospatial Reporting
Abstract:
It is expected that business reports be insightful and engaging. Region based reporting can be transformed from boring grids to visually interactive maps. This session will describe how to embark upon self-service and mobile BI solutions that are available within the Microsoft BI stack for analytical geospatial reporting. You will learn the basics of geographical data, including GIS, Longitude-Latitude coordinates and free form text. Using these different data types, we will discuss SSRS 2012, Power View and Excel 2013 tools that can leverage insightful analysis. Finally and most importantly, attending this talk will get you started in learning the essential techniques to deliver geospatial reports that tell meaningful stories for users.
SessionID: 16927
Understanding Query Modes in Tabular Model
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Julie Koesmarno
Title: Understanding Query Modes in Tabular Model
Abstract:
Using live demo, this session will outline advantages and disadvantages between DirectQuery and In-Memory modes. We will also highlight impersonation and partitioning differences between the two modes. Finally, we will also cover the definition of a Hybrid Tabular Model solution.
SessionID: 17782
Get started with troubleshooting SQL Server
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Justin Langford
Title: Get started with troubleshooting SQL Server
Abstract:
SessionID: 18236
Top 10 Admininistrator Mistakes on SQL Server
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Kevin Kline
Title: Top 10 Admininistrator Mistakes on SQL Server
Abstract:
SessionID: 18516
Latches, Spinlocks, and Lock Free Data Structures
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Klaus Aschenbrenner
Title: Latches, Spinlocks, and Lock Free Data Structures
Abstract:
You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect! Join me in this session to make a further deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks. We will cover the differences between both, and their use-cases in SQL Server. You will learn about best practices how to analyze and resolve Latch- and Spinlock contentation for your performance critical workload. At the end we will talk about lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server 2014.
SessionID: 18521
Troubleshooting TempDb
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Klaus Aschenbrenner
Title: Troubleshooting TempDb
Abstract:
SessionID: 18936
Writing your solutions using PowerShell
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Laerte Junior
Title: Writing your solutions using PowerShell
Abstract:
Some frequently asked question of those who are starting out with PowerShell:
Creating solutions that meet my needs?
Script or function? When and why?
I want to write codes thinking as PowerShell, but how?
If you have these questions, this is the right session for you. In this session we will see a introduction to PowerShell, passing through some
of its most important concepts and ending in your first solution in the Shell.
It is time to you look at the future right ?
SessionID: 19156
How do you create nice/horrible packages?
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Joost van Rossum
Title: How do you create nice/horrible packages?
Abstract:
SSIS Development Best Practices:
I have seen my share of unreadable and unmaintainable SSIS packages. Last year I showed how to create faster packages, this time I want to show you how to create better packages with a list of do's and don'ts when creating packages and working in a project team. And how do you use/setup a product like TFS when working with SSIS?
SessionID: 19477
Power Query in Modern Corporate BI
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Marco Russo
Title: Power Query in Modern Corporate BI
Abstract:
In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, and Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage and validate the access to corporate data sources? How do you share and validate new queries created by end users? How can users extract data at the right granularity level? Power Query bridges the gap between corporate and self-service BI. It empowers end-users so that they can extract and manipulate data from several data sources, inside and outside of the company. In this session, learn the Power Query best practices that enable the extraction of data from existing database and cubes, guided by an expert who understands both worlds (Corporate BI and Power Pivot data models).
SessionID: 21097
Storage For the DBA
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Denny Cherry
Title: Storage For the DBA
Abstract:
SessionID: 21396
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Neil Hambly
Abstract:
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: 22154
1, 2, 3, … 100. How to manage many SQL Servers the easy way?
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Pieter Vanhove
Title: 1, 2, 3, … 100. How to manage many SQL Servers the easy way?
Abstract:
Quote: “A good DBA is a lazy DBA”. When you have to manage a few SQL Servers, it’s not that hard to be a lazy DBA and to automate your day to day activities. But when you have to manage over 100 instances, it can become a tough job. Just imagine how you will deploy a new maintenance job on all your instances? Are you going to connect to each server one by one? Not really… Microsoft provides an enhanced set of multi-server management tools. The purpose of this sessions is to point out which SQL Server tools you can use for multi-server management. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment.
SessionID: 23357
Get ready, here is the cloud
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Robert Hartskeerl
Title: Get ready, here is the cloud
Abstract:
SessionID: 24744
Building a BI Solution in the Cloud
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Stacia Varga
Title: Building a BI Solution in the Cloud
Abstract:
Office 365 Power BI offers new and exciting features that are leading a lot of companies into the cloud. However, there are several additional considerations that you must factor into deciding how to architect your overall BI solution.
In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
SessionID: 24804
Digging Into the .Net SqlClient
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Mladen Prajdić
Title: Digging Into the .Net SqlClient
Abstract:
The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? In this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader() and SqlCommand.ExecuteNonQuery().
SessionID: 27022
Usage of R in SQL Server for better data understanding
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Tomaž Kaštrun
Title: Usage of R in SQL Server for better data understanding
Abstract:
Language R for Statistical computing is powerful language for data analysis with all great features for data import from SQL environment. Using R with SQL server data will help data scientists and data analysts prepare, explore and validate data much easier, as well as to use wide range of statistics; from uni-variate to multivariate.
Session will focus mainly on:
- on connecting R Language with SQL server using standard ODBC connectors and T-SQL procedures.
- how to validate data with using classical statistical methods on SQL transactional data.
- how to use R output in SSRS and bring extra information to reports.
SessionID: 27079
Top 10 issues for SQL Server Healthchecks
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Peter ter Braake
Title: Top 10 issues for SQL Server Healthchecks
Abstract:
Top 10 issues for SQL Server Healthchecks
SessionID: 35852
Unlock the Power of Pivot Tables
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Sander van der hoeff
Title: Unlock the Power of Pivot Tables
Abstract:
Given the small amount of documented knowledge about the use of tabular models by means of Excel, I will show you how to get the best of your tabular models by using Excel as a self-service business intelligence tool. Filters, named sets, and calculations in the pivot table: I will explain it all!