SQLSaturday #791 - Banja Luka 2018
Event Date: 11/03/2018 00:00:00
Event Location:
- SqlSaturdayBL
- 23a Jovana Dučića
- Banja Luka, Republika Srpska, Bosnia and Herzegovina
This event has completed. All data shown below is from the historical XML public data available.
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: Staatistical Analysis with T-SQL
Abstract: Transact-SQL language in latest editions of SQL Server has so many business intelligence (BI) improvements that it might become your primary analytic database system. You might even decide to use T-SQL for advanced analyses directly, without including R, Python, SSAS or Azure ML. However, to get the maximum out of these language constructs, you need to learn how to properly use them. This in-depth session shows extremely efficient statistical queries that use the window functions and are optimized through algorithms that use mathematical knowledge and creativity. During the session, the formulas and usage of those statistical procedures are explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries. Or maybe you want to become a data scientist? Then you need to know statistics and programming. You get the best of both in this session.
Speaker(s):
- Dejan Sarka
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: Data Overview and Manipulation – T-SQL, R, Python
Abstract: In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages from R and Python. After this session, you will understand what tasks data preparation involves, and what tools you have in SQL Server suite for these tasks.
Speaker(s):
- Dejan Sarka
Track and Room: Analytics and Visualization - Room 2
Title: Most common mistakes data scientists make
Abstract: In the middle of deploying the model, team of data scientists realize that the predictions are “somewhat-off”. Troubleshooting on the horizon and what to do.
Session will guide you through most common mistakes data scientists and statisticians are making when preparing and engineering the data using T-SQL or any other database system. Further more, we will explore common statistical and data science mistakes when modeling data, extracting know-how from the data, finding the hidden patterns and running different test against the structural models using mainly R, Python, or Spark.
What not-to-do will be replaced with what to-do explanations using sample datasets and sample codes.
Some statistical knowledge or background is a plus!
Speaker(s):
- Tomaž Kaštrun
Track and Room: Advanced Analysis Techniques - Room 3
Title: Data Science for beginners
Abstract: Data science can be hard to grasp, complex and big, but making data science easy to understand and bringing it closer to all who want to tackle this new emerging field is an important task in world of data. Exploring, extracting and finding hidden gems from data using statistical and mathematical methods, computer science and several different technologies is essentially what data science is doing. In practice this means, data science is an iterative process of harvesting data, managing and cleaning the data, performing analysis and and at the end interpreting, visualizing and using information that will bring insights to end-user, business people and making decisions much easier. We will focus on answering 5 simple questions.
1) is this weird? 2) is A better than B, respectively? 3) how much / many of this is needed? 4) this belong to group A? 5) what is next?
Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
Speaker(s):
- Tomaž Kaštrun
Track and Room: BI Information Delivery - Room 2
Title: Најчешће грешке и заблуде на релацији програмер – SQL Server
Abstract: У овој популистичкој сесији аутор ће уприличити рестроспективу типичних грешака које праве програмери и тзв. софтвер девелопери приликом рада са базом података MS SQL Server. Неке од њих почивају на ограничењима и неконзистентности самог производа; већина је, пак, последица неразумевања функционисања дејтабез енџина, недостатка времена и/или потребе за дубљим разумевањем процеса оптимизације и извршења упита. Неке су, истини за вољу, последице и ограничења самог девелопера.
У сесији ће бити речи о узроцима грешака, те начинима за избегавање или ублажавање њихових последица, а пашће и који савет како да се побољша опхођење према овом веома респектабилном РДБМС производу
Speaker(s):
- Miloš Radivojević
Track and Room: Application Database Development - Room 1
Title: Continuous Integration Pipelines With Jenkins, Docker and SQL Server
Abstract: Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker(s):
- Christopher Adkin
Track and Room: Application Database Development - Room 1
Title: Beyond image classification - object detection with multi-task deep models
Abstract: Object detection can be challenging to understand, mostly because there is a gap in the literature between image classification and object detection — the former is explained in deluge of easy to understand blog posts and articles, the latter is the subject of research papers, full of scary looking math. In this session we will take different approach and built state of the art object detection model in easy to understand steps. First, we are going to make sure that everybody understand concepts of convolution networks, the importance of model architecture and loss function. Then we are going to build a model that will classify single object, a model that finds this object on a picture, and a model that combine both and is able to classify and localize the largest object in each image. Finally, we will move to multiple objects detection, discus latest architectures and design appropriate loss function for this task. All this illustrated with examples built using fastai library.
Speaker(s):
- Marcin Szeliga
Track and Room: Advanced Analysis Techniques - Room 3
Title: CI/CD Database deployment
Abstract: Almost an every enterprise system needs a some kind of database in the background. In the process of development, architects, developers, they need to prepare and build a database. When the application comes into the production, can be a very difficult to move new changes and that slow down our process of release. Also, here can happen a problem with a bad script, a poor thing can gone happened and all goes into a bad situation. This is the right place for CI/CD process, helping to teams how to manage new database changes in a different environment. In this lecture we’ll see how to set up CI/CD process for database pipeline, deploy database changes into the Azure SQL Database and move that change into the production. It will be demonstrated how to include RedGate tools in the process. Also, there will be a best practices notes how to deploy a very large database.
Speaker(s):
- Ratomir Vukadin
Track and Room: Application Database Development - Room 3
Title: Minimizing consequences of data breach using SQL Server
Abstract: Intrusions into the systems have become so common, that there is no single day without news headline. User’s data, trade secrets, private habits of users are becoming the subject of “public” unauthorized access. Outcomes are blackmailing, loss of reputation and credibility. Database is a service that represents the last line of defense and as such deserves special your attention.
This session is about how to implement state of the art cryptographic features that are built in in to SQL Server (current version 2017). Focus is on the inside and outside threats. We will demonstrate the following : transparent database encryption, backup encryption, column level encryption and encryption data in the motion.
Speaker(s):
- Jasmin Azemović
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Bulk Load and Minimal Logging
Abstract: Session subject is bulk load and minimal logging. I will show you on various demos how bulk load and minimal logging behieves on heap and cluster tables, in-memory tables, clustered and non-clustered columnstore tables and on all combinations as well.
Speaker(s):
- Dean Savović
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: SQL Security in the Cloud
Abstract: Our data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The Cloud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.
Speaker(s):
- Tobias Koprowski
Track and Room: Enterprise Database Administration Deployment - Room 3
Title: Getting To Know SQL Server Encryption Capabilities
Abstract: With stricter EU privacy laws like GDPR, the need to encrypt data is greater than ever. In this session we’ll look at what SQL Server offers in this area: 1) symmetric and asymmetric server encryption which lets the server encrypt table data and control the keys, 2) Always Encrypted (AE) which works similarly to server encryption but the client control the keys meaning server can’t decrypt the data 3) Transparent Data Encryption (TDE) which encrypts your data at rest making getting data from stolen drives useless 4) creating secure SSL/TLS communication channels between your apps and the server to prevent clear text network traffic which can be observed
Speaker(s):
- Mladen Prajdić
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Building production-ready APIs with ASP.NET Core 2.x
Abstract: Creating REST APIs with ASP.NET Core is simple and comes down to defining controllers and routes. But, there are a lot of things to take care of before the API becomes ready for production. This talk is about best practices, authorization, routing, logging, data formatting, testing, documentation, versioning and monitoring REST APIs built with ASP.NET Core 2.x.
Speaker(s):
- Miroslav Popovic
Track and Room: Application Database Development - Room 3
Title: “SQL-like” or query languages in Azure IoT
Abstract: If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms. In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.
Speaker(s):
- Catalin Gheorghiu
Track and Room: Application Database Development - Room 1
Title: How to downgrade a database
Abstract: You just can’t simply move or restore a database to a SQL server with lower build version. Some would say that this is impossible! Well it’s not!
In this session we’ll discuss why would you need to downgrade a database and then I will demonstrate a few ways how it can be done for different levels of database complexity.
Speaker(s):
- Dejan Dular
Track and Room: Application Database Development - Room 1
Title: Maintenance Plans: A Daily Task
Abstract: Maintenance Plans is one of the best helpers for daily DBA work. Some novice DBA never touches this feature, some accidental DBA never touch this feature. Sometimes even senior DBA did not know too much how it works and how powerful tool it could be. Powerful and dangerous. In my session I would to show how Maintenance Plans can help us, how strong and in the same way dangerous could be. few slides, few demos, few topics for discussion in fifty-five minutes.
Speaker(s):
- Tobias Koprowski
Track and Room: Enterprise Database Administration Deployment - Room 1
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
Title: Optimizing Database Access And Diving Into .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? Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we’ll dive into the workings of the .Net SqlClient and give you insight into things like connection pools, transaction scopes, batch inserting, async data access and more.
Speaker(s):
- Mladen Prajdić
Track and Room: Application Database Development - Room 1
Title: Azure SQL Data Warehouse
Abstract: Azure SQL Data Warehouse - what is it and how it is different from SQL Database. During the session I’ll demonstrate how to create SQL DWH databases and different methods of importing data from on-premise database and files.
Speaker(s):
- Tomasz Libera
Track and Room: Cloud Application Development Deployment - Room 2
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Ratomir Vukadin
Twitter: - https://twitter.com/Ratko_V
LinkedIn: Ratomir Vukadin
I am a passionate person about technology and special for the software industry. I have B.Sc. in Computer Science area. Currently, I’m on study for the Master Engineer degree. I am in software industry almost of half decade and deal with an enterprise business system. I was class mentor at the couple of Microsoft courses. I really like to share my experience with my colleagues. I have been two public sessions at the Microsoft conference, Microsoft community 2017 and the MS Network 2018 in the Neum BiH. Also, there are a couple of local meetings for me, where I was a speaker. I have a plan to graduate with a Master thesis about Machine learning, AI and some really cool stuffs about real time medicine.
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.
Marcin Szeliga
LinkedIn: Marcin Szeliga
Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.
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.
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.
Miroslav Popovic
Twitter: - miroslavpopovic
LinkedIn: Miroslav Popovic
Contact: https://miroslavpopovic.com
Miroslav is senior software architect for .NET and JavaScript, employed as Technical Lead at Seavus. He uses .NET from version 1.0. From Windows Forms, through WPF and Silverlight, all the way to ASP.NET Core. Currently, he is focused on ASP.NET Core, client-side JavaScript development and software craftsmanship. During his career, he worked on a lot of small and big projects, including a couple of local startups. He was one of the members of the development team for the Kicks platform and one of the moderators for https://javascriptkicks.com and https://dotnetkicks.com. Besides that, he is an active community member, conference speaker and one of the leaders of “BLbit Banja Luka” user group.
Mladen Prajdić
Twitter: - @MladenPrajdic
LinkedIn: Mladen Prajdić
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.
Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.
Traveler. Coffee Addicted.
Dejan Dular
Twitter: - @dejandular
LinkedIn: Dejan Dular
Dejan is an independent .NET and SQL developer. During his career he developed applications mainly in the area of Customer Management Systems and Supply Chain Management. In the last years he specialized as a back-end developer and data specialist. He is also a Microsoft Dynamics CRM expert.
In his free time he is working with IoT and calls himself a DIY freak.
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.
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.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his 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 co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
Mladen Prajdić
Twitter: - @MladenPrajdic
LinkedIn: Mladen Prajdić
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
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.
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.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his 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 co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
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.
Tomasz Libera
Twitter: - https://twitter.com/tomasz_libera
LinkedIn: Tomasz Libera
MVP Data Platform, MCT, leader of Krakow Data Community Poland user group. Organizer of SQLDay and SQLSaturday conferences. SQL Server Developer and academic trainer. Speaker at group meetings and conferences.
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.
Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.
Traveler. Coffee Addicted.
Sponsors
The following is a list of sponsors that helped fund the event: