SQLSaturday #644 - Bratislava 2017
Event Date: 06/24/2017 00:00:00
Event Location:
- Microsoft Slovakia s.r.o.
- Apollo Business Center II, Block E, Prievozská 4D, Bratislava
- Bratislava, Bratislavský, Slovakia
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: Mobile BI with Microsoft tools
Abstract: In SQL Server 2016 Microsoft added support for mobile reports to Reporting Services. They also released the Mobile Report Publisher for authoring and creation of mobile reports. This application is based on Datazen technology, a company that Microsoft acquired in 2015. As Microsoft stated, using only one mobile BI app users will access dashboards and reports on mobile devices.
Now developers must choose a tool for developing BI optimized for mobile devices: SSRS, Mobile Report Publisher (former Datazen) or Power BI? The question is: which one to choose? What are the key factor for supporting the correct decision? We will provide a clear and understandable overview of each product, highlighting strengths and weaknesses. Based on some real examples we will set out a comparison matrix to find the best way to meet your needs with the right mobile reporting tool.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: BI Information Delivery - Madagascar
Title: T-SQL User-Defined Functions, or: How to kill performance in one, easy step
Abstract: User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
Speaker(s):
- Hugo Kornelis
Track and Room: Application Database Development - Borneo
Title: Forecasting with MS BI Suite
Abstract: Forecasting is one of the most exciting data mining and machine learning task. In MS BI suite, there are many different tools that help you with this task. This session introduces the most popular forecasting algorithms from the ARTXP and ARIMA families, and then drives you through the implementations in MS tools. You will learn how to do forecasting with R, Azure ML, SSAS, Excel, and Power BI.
Speaker(s):
- Dejan Sarka
Track and Room: BI Platform Architecture, Development Administration - Madagascar
Title: In the name of the resources: Aggregating data
Abstract: The queries that are used for reports are usually the least efficient because you are dealing with huge amounts of data from tables sometimes joined many, many times. In this session we will go through good and bad examples of aggregating the data from your relational database. You will see tips on how to get good use of the indexes, how to lower the number of actual table queries and other tricks that will make your queries run faster.
Speaker(s):
- Dejan Dular
Track and Room: Application Database Development - Borneo
Title: Doing Hadoop with Azure HDInsight
Abstract: Hadoop is everywhere. Growing from a project within Yahoo, it soon became a very popular tool for data analytics. Today, there are a lot of Hadoop installations in major companies and Hadoop is capable of analyzing large amounts of data. In this session, we will have a look at what Hadoop by outlining different tools such as HCatalog, Hive, Pig, Storm, Spark and HBase and will then look at HDInsight and its benefits.
Speaker(s):
- Mario Meir-Huber
Track and Room: Cloud Application Development Deployment - Madagascar
Title: String Concatenation Done Right
Abstract: Numerous techniques for concatenating string data can be found online, and even in some books. In this session you will learn two of them that are reliable, and fairly easy to understand, implement, and deploy. You will also learn how to control the order of the values being concatenated, a feature that is not natively provided by SQL Server.
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Borneo
Title: Building Disaster Recovery solution with AlwaysOn
Abstract: This presentation will cover generic issues and challenges involved in building a Disaster Recovery site, and then show you how you can build a hot DR site using the AlwaysOn Availability Groups technology in SQL Server 2016. It will provide tips and recommendations based on real life implementation. While the focus of the session will be on building a remote DR solution, much of the content will also be applicable to maintaining a local standby server using AlwaysOn.
Speaker(s):
- Roman Rehak
Track and Room: Enterprise Database Administration Deployment - Madagascar
Title: Beginning Data Science-From Novice to Professional
Abstract: Where to begin the step 1 of data science to become a Data scientist? What are these Data Scientists up to? This is an initial data science session, for a novice and learn how easily you can step in to Data Science and start to become a professional.
How can we see and try using a data scientist statistical model in our day to day familiar tool like Microsoft SQL Server?
Thanks to Microsoft for integrating R Revolution within SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016 and also to utilize it for any applications and/or Reporting services.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Analytics and Visualization - Madagascar
Title: Running SQL Server as a Container
Abstract: In this session we’ll see how you can quickly benefit from using the new Windows Server 2016 feature called containers to run SQL servers in your environment. We will talk about the container technology which can be directly used for DevOps with SQL.
Speaker(s):
- Marek Chmel
Track and Room: Strategy and Architecture - Madagascar
Title: Window functions are your friends
Abstract: What does SUM(Salary) OVER (ORDER BY EmployeeID RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) do exactly? Did you know that you can delete all duplicates in a table with just one query?
Window functions are great! They open a whole new world of elegant data analysis. Their only problem is that they seem complicated at first glance. In this session we will get OVER() them and see how can we use them together with aggregation, analytic and ranking functions. After this session creating queries with things like running totals will be a piece of cake!
Speaker(s):
- Dejan Dular
Track and Room: Application Database Development - Borneo
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 - Borneo
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Andrea Martorana Tusa
Twitter: - bruco441
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category
Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.
Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano 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.
Hugo Kornelis
Twitter: - Hugo_Kornelis
LinkedIn: Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
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.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
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.
Marek Chmel
LinkedIn: Marek Chmel
Contact: http://www.prosql.cz
I have started working in IT as a consultant and trainer for Microsoft server systems and from the beginning I did focus mainly on SQL Server. Few years back I have joined atamp;t, where I workin a team responsible for 24/7 operations for large SQL server environments. Our primary focus is architecture, delpoyment, performance tuning and disaster recovery for SQL Server ranging various sizes, versions and editions. If there#39;s any free time left, you can catch me speaking at a conference or teaching a Microsoft or security class in a training center.
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.
Mario Meir-Huber
Mario Meir-Huber is a Big Data Architect for Microsoft in Austria. Before joining Microsoft, Mario worked 7 years in the area of Big Data, mainly Hadoop in Eastern Europe. Next to work, he teaches Big Data and Hadoop at several national and international universities and wrote two books on Cloud Computing. He is a frequent speaker at national and international events on Big Data
Roman Rehak
LinkedIn: Roman Rehak
Contact: http://sqlblog.com/blogs/roman_rehak/
Roman Rehak is a Principal Database Architect at MyWebGrocer.com in Burlington, VT. He specializes in SQL Server development and database architecture. He writes articles for Visual Studio Magazine, SQL Server Magazine, SearchSqlServer.com and other technical publications. Roman presents at user groups and conferences in US and Canada. He has served as the Tech Chair for the SQL Server track at DevTeach and PASS conferences, and is the president of the Vermont SQL Server User Group.
Sponsors
The following is a list of sponsors that helped fund the event: