Jelentkezés menete

Előadók és témák

Kevin Boles: Tune Like a Guru!

In this Pre-Con event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a long-time relational engine consultant I have repeatedly found that the majority of clients I work with get amazing improvements by simply putting to use a fairly small collection of knowledge and tools. We will cover many topics, including:

Optimization processes

Statistics usage and maintenance

Index creation, usage and maintenance

Understanding query plans

Server and database configuration

Improving design

Improving code

Profiler and trace analysis

Temporary object usage

Waits and IO stall analysis

We will look at all of these things and more from a variety of angles, while also covering many of the tips, tricks, tools and tribal knowledge I have collected in my almost 45,000 man hours of working with SQL Server. I promise you will come away with lots of immediately-applicable information which you can take back to work and Tune Like A Guru!!

Kevin is a SQL Server expert, working exclusively with the product since v6.5. With over 20 years of database experience and almost 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. He has been a very successful independent consultant for over 15 years. Kevin is also a very frequent speaker, having presented at countless User Groups and pushing 100 SQL Saturday conferences! His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Dejan Sarka: Data Mining Algorithms in SSAS, Excel, R, and Azure ML

Data mining as the most advanced data analysis technique is gaining popularity. With modern data mining engines, products and packages, like SQL Server Analysis Services (SSAS), Excel, R, and Azure ML, data mining has become a black box. It is possible to use data mining without knowing how it works. However, not knowing how the algorithms work might lead to many problems, including using the wrong algorithm for a task, misinterpretation of the results, and more. This course explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm as well. Demonstrations show the algorithms usage in SQL Server Analysis Services, Excel 2013 using the SQL Server algorithms, R, and Azure ML using the R algorithms.

Algorithms usage is explained through real life use case as well, on a fraud detection example.

Dejan Sarka, MCT and SQL Server MVP, focuses on development of database & business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of twelve books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.

Régis Baccaro: A SharePoint BI Deep Dive

SharePoint – let’s admit it – is here to stay; It has become the business collaboration platform of choice for the enterprise and the binding element in the Office family of tools. However deploying and configuring can be a challenging task for the IT pro. In this whole day session we will walk through the configuration of a complete on-premises BI platform with SharePoint. We will configure different scenarios, and the technologies necessary for building the infrastructure. After this session you will be able to setup the applications and all the supporting services to make SharePoint a successful and performant BI platform. From Excel services to Kerberos delegation.

Business Intelligence (BI) capabilities in SharePoint 2013 are vast and in many cases are achieved with a combination of SharePoint and Microsoft Office or SharePoint and SQL Server’s capabilities.

SharePoint 2013 provides a Business Intelligence Center site that enables your organization to centrally store and manage data connections, reports, scorecards, dashboards, Apps and Web Part pages as shown below:

The Components of SharePoint BI

Microsoft Excel 2013

Excel Services

PowerPivot

PerformancePoint

Visio Services

The Microsoft BI stack and SharePoint

SSAS Tabular and Multidimensional

SQL Server

Reporting Services

The SharePoint infrastructure

High availability

Rolle based security with or without constrained delegation

Self-Service BI Architectural Overview

Excel PowerView

Reporting Services PowerView

SharePoint BI “From the Consulting Trenches”

A collection of best practices from my 10+ years of experience with SharePoint and BI

Governance to make adoption smooth

Régis has more than 15 years of experience with SQL Server, SharePoint and .Net. His background and work experience mixes technology and business, providing him a unique edge to contribute to BI projects and developing, being able to effectively interact with technical and business decision makers. Régis is a frequent speakers at SQL Server conferences and is a board member of the Danish SQL Server User Group and the founder and lead organizer of the SQL Saturday Denmark community event.

Rasmus Reinholdt: Building the ETL architecture of the future with BIML and MDS

In this hands-on / bring your laptop precon session Rasmus will show how you can take your ETL to the next level with BIML and metadata. No more going over hundreds of packages to change a datatype or add a column, all you need is a change to your metadata and you are home free.

As this is a bring your own laptop invitation, we will build the solution together and you will have a working BIML model that you have build yourselves and understands at the end of the day. Therefore; after this precon, your can go straight to work and start implementing your new BIML metadata framework. You should have a working knowledge about SSIS and general ETL concepts to get the most out of the day but no prior knowledge about BIML is required, we will start from scratch.

Rasmus is an individual contractor based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards and as of lately also SharePoint.