- 20 teams,
- of up to 3 people,
- passion and the ability to work with data
Microsoft SQL Server 2016 Hackathon the first ever marathon dedicated to the SQL Server 2016. It is also the only such event dedicated to broader analysis, based on the components of the Microsoft data platform. Whether you are a programmer, a database administrator or a Business Intelligence specialist - or just a geek - you can strive for victory and secure immortality (there are spoils to be shared!). The rules are simple: score the most points and win the overall crown – though additional honors are bestowed on the winners of each stage. During the hackathon, seminars with masters and experts who will discuss the latest functionality of MS SQL Server 2016 will also be held. And that’s not all! - but the rest is a surprise.
Passionate about Microsoft technology, which he works with every day - from the design and administration of databases and data warehouses, through to the creation of ETL processes and reporting, to self-service BI solutions. He supports his team in terms of both development and architecture. The depth of his knowledge is confirmed by the award of a number of technology certificates in the field of Business Intelligence and Microsoft technology databases. He loves to share this knowledge as a coach at various meetings, both industry-based and for students. Currently, as a consultant for Business Intelligence at JCommerce SA, he is expanding his knowledge of Data Science and optimization of BI solutions. In his private life, he’s a big fan of music, good books and football.
Business Intelligence consultant and a big fan of Microsoft technologies. Designs and implements BI solutions on the Microsoft SQL Server using both traditional BI tools and Power BI functionality. In addition, he is developing his own interest in programming in .NET and the discovery of knowledge from data. He has worked with various systems including Oracle, SAP, IBM, QlikView and even Pervasive in Poland and abroad. He has been a speaker and trainer at various conferences from both business and technical perspectives. Currently he is a Technical Expert at JCommerce SA.
Data philosopher and independent consultant with 20 years of professional experience in working with SQL Server. He specializes in DW / BI systems, with particular emphasis on data mining systems, solving data quality and database optimization issues. In the past three years, he has been a Microsoft Poland external expert and has worked closely with ISV partners and key customers of Microsoft. In addition, since 2003, he has authored books and articles on SQL Server. Awarded the prestigious title of MVP since 2006, he holds multiple Microsoft certifications, including MCT, MCSE: Data Platform & Business Intelligence and MCSD: Azure Solutions Architect & Microsoft .NET.
For 15 years he has been involved in the design, development and implementation of applications using platforms: .NET, SQL Server and Oracle. He is an IT trainer, software developer, database administrator, creator of documentation and business analyst. He was co-author of the book "SQL Server 2008. Administration and programming" and has been a speaker at many industry conferences. He has been certified in Microsoft MCT, MCITP-DBA, MCITP-DD, MCSD.NET. Awarded the prestigious title of MVP in the SQL Server category (now Data Platform MVP) since 2009.
Registration is closed
Creation of the most efficient ETL process performing individual competition tasks in line with the attached specifications and business requirements using Microsoft SQL Server Integration Services, the Microsoft SQL Server 2016 engine itself, and writing effective T-SQL queries.
Preparation of the process of knowledge discovery using Microsoft SQL Server Analysis Services 2016, Microsoft SQL Server + R or Power BI + R and knowledge of various algorithms for knowledge discovery, dealing with specific issues pertaining to data analysis and responding to specific questions and problems. The analyses are carried out on the basis of a data set prepared specifically for this purpose.
Preparation of the most interesting reports (in graphical and operational terms) and cockpits in the Power BI service using the latest version of Power BI Desktop with either ready-made or one’s own additional visualizations and implementation of the charts from the R program. The visualization will present a graphic image of the set of data, or data which users will be able to find on the Internet at their discretion and add to the model by means of Power Query, supplied for the competition. Some tasks will also concern the new reporting functionality of Microsoft SQL Server Reporting Services 2016 tools.
A series of tasks related to improving performance of inquiries and procedures, prepared for the competition, and thoroughly checking the knowledge of users in the field of inquiry optimization, database, and the database server itself, as well as the knowledge of the internal structures of login and capturing server activity.
A set of problems associated with server administration and databases focusing on advanced knowledge of the configuration and repair of the damaged server, database and backup. Tasks will focus, among other things, on the detection of bottlenecks and faulty configuration and repair of non-functional structures and objects.