SQLSaturday #670 - Banja Luka 2017

Event Date: 09/09/2017 00:00:00

Event Location:

SqlSaturdayBL
Veljka Mlađenovića bb
Banja Luka, Republika Srpska, Bosnia and Herzegovina

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: SQL Server 2016 and R Engine-powerful duo

Abstract: With SQL Server 2016 R Language for statistical programming is now supported with native T-SQL. With this extension we can now integrate powerful R Language with transactional data directly using SSMS. With this feature data stewards and data analysts can now run from simple uni-variate to multi-variate statistics in SSMS. Implementation of R in SQL Server 2016 is one of major parts of BI Landscape.

In this session we will go through: 1) Installation needed (R and MRO by Revolution Analytics (now Microsoft) 2) Exploring the usage of RRO Engine (multi-threated usage and parallel multi-core usage of CPU,…) 3) Using T-SQL for Data analysis with importing and exporting data to SQL Tables 4) Demos with using R in Reporting services (SSRS) and Power BI 5) Using R Engine for enhancing your daily work as DBA or BI Analyst 6) Exploring prediction engine on datasets in your daily business work 7) Use cases how and where can powerful duo make your daily business easier

Session is useful for

Speaker(s):

Tomaž Kaštrun

Track and Room: BI Platform Architecture, Development Administration - Room 2

Title: Power Bi for beginner IoT developer

Abstract: You have IoT solutions, and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast. You would also love to have these data is available on mobile devices. Solutions to this problem is the Power BI these especially if you are already using Azure or Office 365. In this presentation I will try to introduce you to Power BI with at least enough information to know where to start. All with the demo, from hardware, to the cloud, to Power BI.

Speaker(s):

Catalin Gheorghiu

Track and Room: Application Database Development - Room 2

Title: The All Flash DBA

Abstract: We are at a major turning point in the world of storage; the transition from spinning disk to flash and as we move into this new world a lot of conventional wisdom will be turned on its head. Things such as the use of compression, putting different database components on different volumes, the desire to chase large readaheads for sequential scan workloads, how well mixed workloads are handled, the multi threaded log writer and delayed durability, besides this, the session will also cover nand flash fundamentals at 300 level.

Speaker(s):

Christopher Adkin

Track and Room: Enterprise Database Administration Deployment - Room 1

Title: Azure Data Lake Analytics

Abstract: Azure Data Lake Analytics is a new service, built to make big data analytics scalable, performance efficient and distributed and easy. Service is focused on data usability and analytics, rather than setting up the infrastructure.

Besides scaling and faster deployment, it is affordable and cost effective and easy to integrate into your existing IT environment.

For the demo, we will look at the image recognition and emotion detection.

Speaker(s):

Tomaž Kaštrun

Track and Room: Cloud Application Development Deployment - Room 1

Title: Get your data and your model ready for the Cloud using Power BI Desktop

Abstract: Introduction of a free data modelling tool (Power BI Desktop) into Power BI ecosystem have attracted great number of potential users (primarily data analysts and IT professionals) to it. During this session we will talk about and demonstrate available techniques for data retrieval and transformation as well as techniques for creation of data models that you will use as a foundation for future visualization of data in the Cloud.

Speaker(s):

Dejan Pervulov

Track and Room: BI Platform Architecture, Development Administration - Room 2

Title: Introduction to Azure SQL Data Warehouse

Abstract: Azure SQL Data Warehouse is a SQL-based fully managed, petabyte-scale cloud data warehouse. It is highly elastic, enabling you to provision in minutes and scale capacity in seconds. You can scale compute and storage independently, allowing you to burst compute for complex analytical workloads or scale down your warehouse for archival scenarios, and pay based off what you’re using instead of being locked into predefined cluster configurations - helping you derive even more cost efficiency versus traditional data warehouse solutions.

Speaker(s):

Dejan Pervulov

Track and Room: Cloud Application Development Deployment - Room 2

Title: Cardinality Estimator with SQL Server 2014 and 2016

Abstract: Cardinality Estimator had a major upgrade in SQL Server 2014 version and 2016. After a few introductory words, I will speak about model assumptions of Cardinality Estimator, calculation direction, model selection of Cardinality Estimator and improvements in SQL Server versions 2014 and 2016. I will also have a few demos where I will demonstrate how to optimally use the new features.

Speaker(s):

Dean Savović

Track and Room: Enterprise Database Administration Deployment - Room 2

Title: SQL Server on Linux

Abstract: Ono što je do jučer bilo nezamislivo sada je postala realnost. Sigurno nikada niste niti pomislili da će Microsoft krenuti sa open source inicijativom, a da ne govorimo o podršci za Linux. SQL Server je dobio svoju verziju za Linux, tačnije rečeno nekoliko trenutno najpopularnijih distribucija (Ubuntu, SUSE i Red Hat). Da li se radi o istom SQL Server okruženju i mogućnostima? Šta je brže, bolje i kvalitetnije i da li ima uopšte smisla da razmišljate o ovome? Saznajte na ovom predavanju.

Speaker(s):

Jasmin Azemović

Track and Room: BI Platform Architecture, Development Administration - Room 1

Title: Problem Solving With The In-Memory Engine

Abstract: There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

Staging data as fast as possible
Turbo charging scalar aggregate functions
Implementing a scalable sequence
Overcoming the performance limitations of temporary tables
Making the critical path in your code base run faster

Speaker(s):

Christopher Adkin

Track and Room: Application Database Development - Room 1

Title: Query Store and Query Optimization

Abstract: I will talk about advantages of Query Store, features, configuration and query optimization using Query Store. How we can monitor query perfomance, how the Query Store collects data and which are the best practices in using Query Store. During the presentation I will show various demos.

Speaker(s):

Dean Savović

Track and Room: Enterprise Database Administration Deployment - Room 1

Title: Parameter Sniffing Problem with Stored Procedures

Abstract: Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and why parameter sniffing is a problem in SQL Server stored procedures. Of course, several solutions will be presented and it will be discussed which solution is applicable in which scenario.

Speaker(s):

Miloš Radivojević

Track and Room: Application Database Development - Room 2

Title: Transact SQL Performance Tips

Abstract: In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer’s capabilities for choosing an optimal execution plan.

Speaker(s):

Miloš Radivojević

Track and Room: Application Database Development - Room 1

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Miloš Radivojević

Twitter: - MilosSQL

LinkedIn: Miloš Radivojević

Contact: https://milossql.wordpress.com/

Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.

Jasmin Azemović

LinkedIn: Jasmin Azemović

Contact: http://www.youtube/mvpdba

CISO and university professor active in the fields of database systems, information security, data privacy, forensic analysis, and fraud detection. Ph.D. degree in the field of modeling design and developing an environment for the preservation of privacy inside database systems, also the author of many scientific research papers and three books: Writing T-SQL Queries for Beginners Using Microsoft SQL Server 2012, Securing SQL Server 2012 and SQL Server on Linux. Microsoft MVP (Data Platform) for the last 10 years and an information security consultant. Active speaker at many IT professional and community conferences.

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

Dean Savović

Twitter: - https://twitter.com/dsavovic

LinkedIn: Dean Savović

Contact: http://www.savovic.com.hr

Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia, SQLSaturday events, etc… Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in SPAN which is specialized in data management field on Microsoft SQL Server.

Dejan Pervulov

Twitter: - @dekiper

As a technical consultant Dejan participated in numerous ERP, CRM and DWH / BI projects in the CEE region. He is also involved in development with Microsoft technologies for last 18 years. Holds MCT, MCSE, MCSA, MCSD, MCDBA, MCTS and MCITP certifications. As a Microsoft Certified Trainer he was involved in preparation and delivery of trainings in several school centers in Serbia. Since October 2014, he is a Microsoft MVP for SQL Server.

Dejan Pervulov

Twitter: - @dekiper

Catalin Gheorghiu

Twitter: - MrSmersh

LinkedIn: Catalin Gheorghiu

Contact: http://ronua.ro/author/catalin/

Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.

Miloš Radivojević

Twitter: - MilosSQL

LinkedIn: Miloš Radivojević

Contact: https://milossql.wordpress.com/

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Dean Savović

Twitter: - https://twitter.com/dsavovic

LinkedIn: Dean Savović

Contact: http://www.savovic.com.hr