SQLSaturday Budapest 2015 Pre-Con Program



2015. április 17. (a SQLSaturday előtt egy nappal, pénteken) reggel 9 és délután 5 óra között.


A SZÁMALK épülete (1119 Budapest, Mérnök utca 39.)


Minden tréning első három jelentkezőjének 30.000 Ft/fő, az összes többi hely 45.000 Ft/fő. (Ezek nettó árak.) Április 15-ig fizetendő.

Jelentkezés menete

Csak egy emailt kérünk a sqlsaturday376@sqlsaturday.com címre, megjelölve a választott témával, a többit emailben vagy telefonon egyeztetjük.

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 explained include Decision Trees, Naïve Bayes, Support Vector Machine, Neural Networks, Regression Trees, Logistic Regression, Linear Regression, Clustering, Association Rules, Sequence Clustering, Auto-Regressive Trees with Cross-Prediction (ARTXP), Auto-Regressive Integrated Moving Average (ARIMA), and Time Series.

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. 
Rasmus is certified MCITP Sql2008 (BI) and MSCE SQLServer (Data platform & BI). 
As a long time speaker and co-organizer of SQLSaturday Copenhagen, Rasmus has spoken at various SQLSaturdays all over Europe, SQLRally Nordic and SQLBits.
Bármelyik témát is választottad, kattints ide, és jelentkezz!