SQLSaturday #278 - Budapest 2014
Event Date: 03/01/2014 00:00:00
Event Location:
- Lurdy Konferencia- és Rendezvényközpont
- Könyves Kálmán körút 12-14.
- Budapest, Hungary
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: Let’s PowerBI Hungary with Big Data!
Abstract: In this fun session, we will use Microsoft’s Big Data and PowerBI tools to learn about Hungary! We will mix and mashup data from a variety of sources such as ‘The Spirit Level’ by Prof Richard Wilkinson, UNICEF, the World Bank and even the CIA to learn more about Hungary. Business Intelligence professionals need to tackle ever-increasing sources of data that are increasing in volume, velocity and variety. Let’s look at fun example of global data about Hungary to look at common data storytelling by BI and BA professionals: analysing open data with varying degrees of data quality, business puzzles versus business mysteries, and deciding on which chart or graph to use when presenting data. If the ‘too much data, too little information’ scenario is familiar, then come to this session, which isn’t just for the international visitors visiting SQLSaturday Budapest like myself! Uncover surprising facts as we mashup, slice and dice the data, and look at Big Data and Data Visualisation along the
Speaker(s):
- Jen Stirrup
Track and Room: 04 BI Track - N/A
Title: Azure SQL Database Tips and Tricks for Beginners
Abstract: Microsoft released SQL Azure more than two years ago - that’s enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services (and not only). In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Speaker(s):
- Tobias Koprowski
Track and Room: 02 Data Platform Track 1 - N/A
Title: Entity Framework 6 New Features
Abstract: This talk is about new features in Microsoft Entity Framework 6 - the new major release of EF. In December 2012 Entity Framework 6 beta was announced and made publicly available. In October 2013 were released EF 6.00 (major release) and EF 6.01. This is the first new version of EF since the announcement in 2012 that the product would be Open Sourced. Entity Framework is hosted on CodePlex. This presentation is about the new features, included in EF 6: Async Query and Save, Custom Code First Conventions, Multi-Tenant Migrations, Configurable Migrations History Table, Code-Based Configuration, Dependency Resolution, Updated Provider Model, Enums, Spatial and Better Performance on .NET 4.x, Stored Procedures Functions in Code First, Connecti
Speaker(s):
- Mihail Mateev
Track and Room: 02 Data Platform Track 1 - N/A
Title: Optimizing Temporal Queries
Abstract: Having a SQL Server solution for a problem does not mean the job is done. Of course, the next immediate issue is the performance. Temporal queries that involve intervals are typically very IO and CPU intensive. For example, a test for overlapping intervals was solved with inefficient queries for years. However, a handful of solutions with fast queries was developed lately. This high-level technical session introduces five different methods to get efficient queries that search for overlapping intervals. Of course, these solutions can be implemented on other temporal problems as well. Actually, the test for overlapping intervals is one of the most complex temporal problems.
Speaker(s):
- Dejan Sarka
Track and Room: 03 Data Platform Track 2 - N/A
Title: Mastering the Excel CUBE Functions
Abstract: This session explores the seven CUBE functions that are natively available in Excel. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts.This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is applicable to Excel 2007, 2010 and 2013.
Speaker(s):
- Peter Myers
Track and Room: 04 BI Track - N/A
Title: The nightmare of locking, blocking and isolation levels!
Abstract: I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!
Speaker(s):
- Boris Hristov
Track and Room: 02 Data Platform Track 1 - N/A
Title: Dynamic code for efficient searching
Abstract: Illustrate how multipurpose queries can lead to issues with scalability and performance. Show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then work through building a dynamic search query to resolve the identified performance issues. Touching on: • Testing. • Tuning each part of the query in isolation. • Plan cache re-use • Security – SQL injection attacks and authorisation / code signing. • Possibly, mentioning greater re-use and extendibility.
Speaker(s):
- Ian Meade
Track and Room: 02 Data Platform Track 1 - N/A
Title: Remodel your old EAV design
Abstract: Sometimes you really need an EAV model. In most cases they are ugly and slow. After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.
There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.
Speaker(s):
- Peter Larsson
Track and Room: 03 Data Platform Track 2 - N/A
Title: SSISDB Catalog Deep Dive
Abstract: SQL Server 2012 Integration Services introduces a new SSIS project deployment model. With the new model comes a completely new SSIS project management solution, named SSIS Server. In this session you will learn about the SSISDB Catalog, the new SSIS data store, and how to deploy, maintain and monitor SSIS project and package executions on SQL Server 2012. There are several significant changes in the way SSIS solutions are administered in SQL Server 2012 compared to previous versions, and you should be familiar with them before using them in production.
Speaker(s):
- Matija Lah
Track and Room: 04 BI Track - N/A
Title: Using Fusion ioMemory to leverage SQL Server 2014 features: Buffer Pool Extension and In-memory OLTP
Abstract: Leveraging Buffer Pool Extension and In-Memory OLTP in SQL Server 2014 with Fusion’s ioDrive2 product line increases database performance by allowing solid state storage to exist alongside DRAM. Fusion’s memory-like performance helps reduce costs by enabling organizations to scale with NAND flash versus DRAM.
Speaker(s):
- Francois-Manuel Billault
Track and Room: 02 Data Platform Track 1 - N/A
Title: Introduction to SQL Server 2012 MDS and DQS
Abstract: This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).
MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.
DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.
Speaker(s):
- Peter Myers
Track and Room: 04 BI Track - N/A
Title: A jó index scan, a rossz index seek avagy hogyan olvassunk végrehajtási tervet
Abstract: Mi az a végrehajtási terv? Miért hozza létre és mire használja az SQL Server? Mik azok az operátorok? Mi a különbség a logikai és fizikai operátorok között? Mit jelent az index seek és az index scan, melyik a jobb? Van-e tábla seek? Hogyan kell jól olvasni a végrehajtási terveket? Az előadás ezekre a kérdésekre ad választ.
Speaker(s):
- Zoltán Hangyál
Track and Room: 01 Magyar nyelvu szekcio - N/A
Title: T-SQL hibakezelés a gyakorlatban
Abstract: Szeretném bemutatni a T-SQL nyelv által biztosított hibakezelési eljárásokat, parancsokat és az elmúlt években szerzett tapasztalatokat. Itt nem csak a trry/catch és a throw használata, hanem az alábbi témakörök kerülnének lefedésre:
- alapvető hibakezelések: kell, nem kell?
- tranzakciók és a hibák
- XACT_ABORT hatása a hibákra és a tranzakciókra
- deadlock hibák kezelése
- hibák logolása
A prezentáció nagy hangsúlyt feketet a demókra, inkább gyakorlati, mint sem ppt alapú.
Speaker(s):
- Janos Berke
Track and Room: 01 Magyar nyelvu szekcio - N/A
Title: Adatbányászat SQL Server Analysis Services-el
Abstract: Egy általános adatbányászatba történő bevezetést követően áttekintjük az SQL Server Analysis Services nyújtotta adatbányászati lehetőségeket. Végignézzük a rendelkezésünkre álló algoritmusokat, valamint azt, hogy melyiket mire lehet használni. Egy konkrét példán kereszül végigmegyünk az adatbányászati struktúra és modell létrehozásának folyamatán, modellt processzálunk és értelmezzük az elért eredményeket. Kicsit elmélyülünk a klaszterezésben, és megmutatjuk azt is, hogyan lehet lekérdezni és integrálni egy adatbányászati modellt.
Speaker(s):
- Balázs Farkas
Track and Room: 01 Magyar nyelvu szekcio - N/A
Title: SQL Server 2014 - New Cardinality Estimator
Abstract: In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?
This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
Speaker(s):
- Miloš Radivojević
Track and Room: 03 Data Platform Track 2 - N/A
Title: Data for everyone with Power BI! The role of the data stewards and analysts inside the organization
Abstract: Introducing the role of datastewards in Power BI. How to share, track and control data assest inside the organization with Power Query and the Data Management Gateway.
Speaker(s):
- Tamás Polner
Track and Room: 01 Magyar nyelvu szekcio - N/A
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract: For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour’s time, and you can take the demo code back home with you to review at your leisure!
Speaker(s):
- Kevin Boles
Track and Room: 02 Data Platform Track 1 - N/A
Title: SQL Server and Transactional Replication - senkit sem hagy hidegen
Abstract: Vajon miért beszélnek az emberek viszonylag keveset a tranzakcionális replikációról? Miért találunk nagyobb eséllyel nyitott kérdéseket ebben a témában egy fórumon, mint például mirroringban vagy mentésben?
És mire jó a tranzakcionális replikáció egyáltalán, és mire nem? És hogyan lehet svájcibicskát csinálni belőle? Ezt próbálom meg körüljárni az összejövetel során.
Speaker(s):
- Erik Bitemo
Track and Room: 01 Magyar nyelvu szekcio - N/A
Title: Stored procedures — facts and myths
Abstract: Everybody knows that use of stored procedures offers a number of benefits over issuing T-SQL code directly from an application. In this demo heavy session I am going to explain to you:
- Why plan caching and reuse is a good thing.
- How to avoid unnecessary recompilations for plan stability-related reasons.
- How to avoid unnecessary recompilations for plan optimality-related reasons.
- When plan reusing is not a good thing and how you can deal with this “Parameter Sniffing” problem.
- Why you should evade conditional logic inside stored procedures that do data access.
Speaker(s):
- Marcin Szeliga
Track and Room: 03 Data Platform Track 2 - N/A
Title: Load Testing Analysis Services
Abstract: Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. Including how to locate resource bottlenecks and the appropriate configuration settings that can help improve performance.
Sample source code will be supplied to help you load test analysis services. We will be focused on the MOLAP engine, but techniques are equally applicable to the tabular model.
Speaker(s):
- Bob Duffy
Track and Room: 04 BI Track - N/A
Title: SQL Server in motion - Page Splits
Abstract: This session is based on participation of the audience for a great movie about SQL Server internals. This session will demonstrate complicated inernal db engine operatoins by using the audience as “objects” replaying each simple task.
So FUN should be the primaray target but step by step the audience will get familiar with the tremendous work SQL Server has to to when “simple” operations may occur
Speaker(s):
- Uwe Ricken
Track and Room: 03 Data Platform Track 2 - N/A
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.
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
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.
Boris Hristov
Twitter: - https://twitter.com/BorisHristov
LinkedIn: Boris Hristov
Contact: http://borishristov.com/blog/
Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
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.
Janos Berke
Twitter: - @JanosBerke
LinkedIn: Janos Berke
Contact: http://www.iamberke.com
I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .
Zoltán Hangyál
1998 óta próbálom megérteni, hogy miért az adott végrehajtási tervet választja az SQL Server. MCT és MCM minősítésekkel rendelkezem, előző életemben évekig tartottam SQL tanfolyamokat az egyik neves oktatóközpontban.
Erik Bitemo
Erik Bitemo is a former SQL Server MVP (2009-2011), SQL DBA and now a Technical Operations Manager for Mickey Mouse. Loves technology and efficient working and believes that work is a great tool to develop… people :)
He thinks SQL Server is the best product Microsoft ever made and especially loves the security, high availability and transactional replication. And Powershell, which makes him think how in the heck he could managed servers (or even his family pictures) before it came out.
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.
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.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Tamás Polner
Data Insight Product Marketing Lead for Central and Eastern Europe
Balázs Farkas
6 éve folgalkozom BI-al, 5 éve használok SQL Servert. Több éven át dolgoztam elemzőként, majd BI csoportvezetőként. Érdeklődési területeim az SQL Server adatbázis oldalról az optimalizálás (lekérdezések, eljárások, indexek, stb), BI szemszögből pedig a nem-standard OLAP módszerek, valamint az adatbányászat. Jelenleg a BI Specialist munkakörben tevékenykedem.
Ian Meade
LinkedIn: Ian Meade
Contact: http://ianmeadedotdotdot.blogspot.ie/
Bob Duffy
Twitter: - @bob_duffy
LinkedIn: Bob Duffy
Contact: http://blogs.prodata.ie/author/bob.aspx
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.
Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.
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.
Peter Larsson
Twitter: - SwePeso
Contact: http://www.sqltopia.com
Peter Larsson is a key player for performance written code. He can turn a 10 hour query into a 3 minute piece of code. Peter is also a SQL Server MVP since 2009. He often hangs out at SQLTeam.com (27k+ posts) and other various sites where he helps all people understand SQL Server.
Francois-Manuel Billault
Contact: http://www.fusionio.com
Francois-Manuel Billault (biography to be changed soon)
Uwe Ricken
Twitter: - https://twitter.com/dbBerater
LinkedIn: Uwe Ricken
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
Sponsors
The following is a list of sponsors that helped fund the event: