SQLSaturday #529 - Bratislava 2016
Event Date: 06/04/2016 00:00:00
Event Location:
- Microsoft Slovakia, Apollo Business Center II, Prievozská 4D
- Prievozská 4D
- 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: Revolutionary R integration in SQL Server 2016
Abstract:
The R integration brings a lot of benefits and new scenarios to on premises data platform systems:
• R can greatly simplify collection of different data.
• Data manipulation and preparation can also be way easier with R.
• You can use R to quickly explore and visualize data.
• Last but not least, R brings the whole power of modern data mining techniques to SQL Server.
As if this was not enough, you can use familiar user interface and SQL Server Enterprise R Services to work with large datasets and multi-threaded, multi-core, multi-process computations. So, even if you don’t know R at all, come and see how natural this language is for everybody who already think in rows and columns.
Speaker(s):
- Marcin Szeliga
Track and Room: Advanced Analysis Techniques - Room #2
Title: To NHibernate or not to NHibernate
Abstract: Every developer heard at least once about NHibernate. There are lots of articles and performance tests describing how fast it runs and how easy is to integrate NHibernate into your application.
In this session I will try to explain why would one consider NHibernate as an option for his application stack, how to solve typical DBA complaints and give a brief comparison of how fast is NHibernate versus ADO.NET with stored procedures.
This session will be interesting to application developers who never worked with NHibernate but want to start, as well as for DBAs to gather some knowledge about how an application works including database layer. I will also provide some demos to show why NHibernate is not as good as developers might think, and why it is better than DBAs think about this tool.
Speaker(s):
- Volodymyr Usarskyy
Track and Room: Application Database Development - Room #1
Title: Fun with Legal Information in SQL Server: Data Retrieval
Abstract: Learn about typical challenges in legal information retrieval, the techniques used in querying data by determining its legal relevance, and how SQL Server 2016 can be used to simplify some of these techniques. For instance, a very important element of legal proceedings is determining which law should be used. Legal rules change over time, resulting in multiple versions of the same law. Laws do not last forever, and can be replaced by other laws (one old law can be replaced by one or more new laws). The timeline of events that are relevant to a particular court case provide one set of criteria to be used to determine the correct law and the correct version of the law. Another example is the trade of products and/or services. In order for a contract to be valid there must be a clear correlation between the offer to buy (or to sell) a product or a service and the corresponding counter-offer. They must both be valid simultaneously, they must both specify the same products or services, and
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Room #1
Title: Easy ETL with Biml
Abstract: Can ETL be fun? Unfortunately very often creation of ETL layer is a time-consuming, tedious, and error-prone task. What’s more, any change in requirements needs a lot of work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and BimlStudio programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again.
Speaker(s):
- Andrzej Kukula
Track and Room: BI Platform Architecture, Development Administration - Room #2
Title: Azure Machine Learning: From Design to Integration
Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.
In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.
This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Speaker(s):
- Peter Myers
Track and Room: BI Platform Architecture, Development Administration - Room #2
Title: Power BI Desktop – Leveraging the magic of Power BI - ON-PREM
Abstract: It won’t be long before we host the majority of our data, compute power, reporting, and BI visualizations in the cloud, but we’re not all there quite yet. In this presentation, we will discuss ONLY those options that are available on-premises, covering functionality differences between Power BI and Power BI Desktop as well as the critical integration of .pbix dashboards and visualizations with other enterprise reporting and collaboration tools, such as SharePoint, PowerPoint, Excel, and SQL Server Reporting Services. We’ll also highlight the Microsoft BI roadmap for SQL Server 2016, SSRS Paginated and Mobile Reports, Power BI, and what it means specifically for on-premise customers.
Speaker(s):
- Sam Lester
Track and Room: BI Information Delivery - Room #1
Title: Using offline shopping data to boost e-shop sales
Abstract: Utilising the off-line sales data of retail chain to significantly increase their on-line sales. Show casing different levels of sophistication for product suggestions, from easy collaborative filtering to advanced models. Explaining what it takes SQL-wise to build each stage of the progress of suggestion engine.
Speaker(s):
- Filip Vitek
Track and Room: Advanced Analysis Techniques - Room #2
Title: Power BI – “5 Minutes to WOW”, but HOW?
Abstract: Microsoft Corporate VP James Phillips summarizes Power BI with the simple phrase “5 minutes to WOW!”, but how do we make this a reality? In this talk, we’ll use Power BI to connect multiple data sources to unlock the mysteries of the data to allow application owners and senior leadership to better understand and make key decisions with their data. We’ll talk about the “how” you need to create compelling data presentations even if you don’t have a data warehouse or SSAS environment: dashboards from SharePoint lists, Excel, web sites or SQL Server databases will also get you that “wow”. Attend the talk today and create your first amazing dashboard tomorrow!
Speaker(s):
- Sam Lester
Track and Room: BI Information Delivery - Room #1
Title: SQL Server 2016 Security Enhancements
Abstract: In this session we’ll explore new security features of SQL Server 2016. There’s a big list of new features making SQL Server even more secure and flexible. We’ll talk about row level security, dynamic data masking, always encrypted and others. All these new features will be explained with practical examples on their usage for production deployments.
Speaker(s):
- Marek Chmel
Track and Room: Enterprise Database Administration Deployment - Room #2
Title: What Application Developers Should Know About SQL Server?
Abstract: Nowadays many companies don’t have dedicated developer positions. Therefore the most of the SQL code has been written by application developers. And they use only a subset of SQL Server features and usually in a suboptimal manner. I spent last ten years working with application developers and have collected common mistakes and misunderstandings between them and DBAs that increase development, test and deployment costs and reduce the overall quality. In this session we will cover the most important things they need to know about SQL Server and that cannot be easily or cheap fixed by DBAs or consultants.
Speaker(s):
- Miloš Radivojević
Track and Room: Application Database Development - Room #1
Title: Reporting Services 2016, a reborn product
Abstract: Since 2008 version Reporting Services was a product that didn’t show significative enhancements, today it has several interesting novelties, a new Web Portal, Mobile Report Published, improved Report Builder, integration to pin reports in Power BI Dahsboards, Custom Parameter Panel, all these topics will we covered in this session.
Speaker(s):
- LEONEL ABREU
Track and Room: BI Information Delivery - Room #1
Title: Top 10 SSAS Solution Design Best Practices
Abstract: Proper design of cubes, dimensions, hierarchies and attributes is critical to optimal performance of SQL Server Analysis Services solutions.
I’ve collected a number of best practices during the years I’ve spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Speaker(s):
- Zoltán Horváth
Track and Room: BI Platform Architecture, Development Administration - 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.
Filip Vitek
Twitter: - https://mobile.twitter.com/FilipVitek
LinkedIn: Filip Vitek
Contact: http://blog.etrend.sk/filip-vitek.html
[Health care] Accepted challenge to start CRM for Health care Group. Thrilled to launch CRM for Health Insurer, Pharmacy chain, set of Polyclinics and Hospitals.
[Banking] Started career in Process management via analyzing amp; rebuilding distribution network for major retail bank. Took a role of crises-manager for banking branch. Joined team for plotting mid-term bank strategy. Managed amp; reorganized large operations/customer service unit (100+ employees) with focus on dealing with sales spikes. In another retail bank built CRM unit from scratch, including customer intelligence function. Tripled direct marketing revenue in 12 months. Researched and implemented behavior segmentation, designed detailed value preposition.
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.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
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.
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.
Sam Lester
Contact: http://blogs.msdn.com/b/samlester
Sam Lester has spent the past 14 years working for Microsoft in various SQL Server related roles. After nearly 12 years working in the SQL Server development team in Redmond, WA, he has recently made the switch to a consulting role to work hands-on with European customers. While in the product group, Sam worked on numerous features including setup, migration, SSMS/manageability, Utility Control Point, Data-Tier Application Component, SSDT, Intellisense, amp; TSQL Debugger.
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.
Volodymyr Usarskyy
LinkedIn: Volodymyr Usarskyy
I came into software development industry as .NET software developer in 2005. Right now I work as a consultant in DACH region. Most of the time I am busy implementing different kinds of back- and frontend stuff but quite some time I spend with SQL Server as well.
Andrzej Kukula
Twitter: - @andrzejkukula
LinkedIn: Andrzej Kukula
Consultant and trainer in SQLExpert.pl with more than 20 years of IT experience. Architect of HA/DR solutions, BI solutions, Data Platform solutions, cloud solutions. Solves SQL Server related problems, including performance tuning. Passionate about SQL Server and programming. Speaker at various conferences including SQLSaturday, SQLDay, SQLNexus, AzureDay, Global Azure Bootcamp and local user groups.
Zoltán Horváth
Twitter: - @zoltanhorvath
LinkedIn: Zoltán Horváth
Contact: http://addictivemeasures.blogspot.com
Zolt#225;n is a BI specialist with more than a decade of expertise. He leads the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL), the Hungarian Chapter of PASS. MCSE: BI and MCSE: Data Platform. SQL Server MVP since 2015.
Sam Lester
Contact: http://blogs.msdn.com/b/samlester
Sam Lester has spent the past 14 years working for Microsoft in various SQL Server related roles. After nearly 12 years working in the SQL Server development team in Redmond, WA, he has recently made the switch to a consulting role to work hands-on with European customers. While in the product group, Sam worked on numerous features including setup, migration, SSMS/manageability, Utility Control Point, Data-Tier Application Component, SSDT, Intellisense, amp; TSQL Debugger.
LEONEL ABREU
Twitter: - leonel_abreu
LinkedIn: LEONEL ABREU
An IT Pro who likes to play chess and baseball.
System Engineer degree since 2007, formerly Data Warehousing teacher at university levels from 2008 to 2009. Microsoft Student Partner during the years 2006 - 2007, Second Place in Microsoft Andean Imagine Cup (2006), MCTS, MCITP and MCP with over a decade of experience with SQL Server, working in BI, DBA, Database Development, .net Development, SharePoint and other several areas.
Since 2014 based in Barcelona, Spain. Learning enthusiast and always with passion for new technologies and new challenges.
Sponsors
The following is a list of sponsors that helped fund the event: