SQLSaturday #274 - Slovenia 2013
Event Date: 12/21/2013 00:00:00
Event Location:
- pixi labs
- Poslovna cona A 2
- Sencur - Ljubljana, , Slovenia
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: Autogenerating a process data warehouse
Abstract: In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like “What are the typical waiting times in our order process?” are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems.
In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
Speaker(s):
- Kennie Pontoppidan
Track and Room: BI - 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: DEV - N/A
Title: FILETABLEs: What They Are and How to Use Them
Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker(s):
- Matija Lah
Track and Room: DBA - N/A
Title: Harder, Better, Stronger and more secure
Abstract: With natural disasters like earthquakes and fires in the news so often, IT Professionals know that many disasters can shut down a SQL Server. Microsoft has already implemented a lot of HA/DR solutions in previous editions of SQL Server, like AlwaysOn failover clustering, AlwaysOn Availability Groups, log shipping, … But,when it comes to high availability, SQL Server 2014 changes the game by enhancing the availability, scalability, and flexibility of AlwaysOn. How about your HA/DR solution? Did your management decide the DR site is still too expensive? Are your backups secure? In this session, you will learn all about the new and enhanced features of AlwaysOn in SQL Server 2014 like managing backups to Azure, encrypting backups, adding
Speaker(s):
- Pieter Vanhove
Track and Room: DBA - N/A
Title: From SQL Traces to Extended Events. The next big switch.
Abstract: This session will give you insight into both of the current tracing technologies in SQL Server with emphasis on Extended Events.
The old SQL Trace which has served us well over the past 10 or so years is on its way out because the overhead and details it produces are no longer enough to deal with today’s loads. The new Extended Events are a new lightweight tracing mechanism built directly into the SQLOS thus giving us information SQL Trace just couldn’t. They were designed and built with performance in mind and it shows. Mastering Extended Events requires learning at least one new skill: XML querying. We’ll look at how the Extended Events work with only a brief overview of old SQL Trace architecure.
Speaker(s):
- Mladen Prajdić
Track and Room: DBA - N/A
Title: Automate your SSIS development with BIML
Abstract: Ever tried to import a file with the Import/Export wizard? Or created a bunch of SSIS packages to process a data warehouse load? Then you know how much work it is to specify the metadata correctly just to create a package that actually works. Wouldn’t it be cool if you had a descriptive language which looks at your metadata and just created the packages for you? This is what BIML is all about. In this session I explain what BIML is, how it works and I’ll show you how you can generate your packages and quickly respond to changes. You can expect a demo rich session with lots of notes from the field and practical examples. This is not just for BI developers, DBA’s or SQL dev’s who need to import or export data occasionally will learn some quick and easy tricks as well.
Speaker(s):
- André Kamman
Track and Room: BI - N/A
Title: Using Data Quality services on Customer related data
Abstract:
Customer related data are center focus of every system dealing with customer orientated data. Having data prepared for statistical analysis, data mining, olap, reporting and any derived form of semi-aggregated data. Providing a knowledge-driven solution for managing quality, integrity and consistency of data is of high value.
Main focus of this session will be usage of data quality services with practical examples on managing quality, integrity and consistency of data for further data usage. Session will show how to build a knowledge base, manage domains and use data cleaning and matching.
Speaker(s):
- Tomaž Kaštrun
Track and Room: BI - N/A
Title: TSQL Performance Tips
Abstract: SQL Server optimizer doesn’t use and index seek for execution of your query although the quer is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions? How to avoid non-SARG-able WHERE clauses? Which query takes about 3 minutes in SQL Server 2008 and only one second in SQL Server 2012?
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: DEV - N/A
Title: Optimizing BI with SQL2014 In-Memory tables
Abstract:
Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can’t optimize our BI solutions with this new feature.
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process.
The session will use the latest CTP release and is constantly updated to include the latest news on the topic.
Speaker(s):
- Rasmus Reinholdt
Track and Room: BI - N/A
Title: Replay your workload as it’s your actual one!
Abstract: Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there’s a feature for that! It’s called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!
Speaker(s):
- Boris Hristov
Track and Room: DBA - N/A
Title: .NET Development for the SQL Server Developer
Abstract: Every SQL Server DBA or Developer needs to create some kind of applications: a dashboard for data, a management console, a data-entry tool. Like SQL Server, .NET have evolved over years. Linq and ORM, ASP.NET MVC, Javascript/jQuery, async programming, Azure and the Cloud. I’ll present a fast entry to .net and some scenarios and sample applications that a typical SQL Server DBA or Developer can use in his daily work.
Speaker(s):
- Marco Parenzan
Track and Room: DEV - N/A
Title: Analysis Services for the DBA
Abstract: Many DBAs have heard the term Analysis Services, but don’t really know what it’s for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution.This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and Tabular mode.
Speaker(s):
- Mark Stacey
Track and Room: BI - N/A
Title: Indexing for denormalization
Abstract: What has the biggest impact on SQL Server overall performance? Hardware, SQL Server configuration or maybe query tuning? No, none of those frequently discussed options. They are important, but the single, most important factor is the database design. A third normal form is great, but sometime a database really should be denormalized to gain a performance boost. This is where indices shine. During this session you will see: how important a proper table design can be, when to use indices on computed columns and why they are way better than triggers, how to create useful indexed views and how to asses their costs and benefits.
Speaker(s):
- Marcin Szeliga
Track and Room: DEV - 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: DEV - N/A
Title: SQL Server Consolidation - Resistance is Futile
Abstract: The IT world is currently in cost-saving mode - cutbacks are all over the place and then Microsoft pushes out SQL Server price hikes.
In this session we will discuss how consolidating SQL Server can reduce overall costs and increase efficiency. We will cover the reasons for consolidation along with the advantages and the disadvantages of consolidating SQL Servers. We will also take a look at some of the tools that can assist with a consolidation project and some pitfalls that I have experienced on previous consolidation projects.
Speaker(s):
- William Durkin
Track and Room: DBA - 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.
Pieter Vanhove
Contact: http://pietervanhove.azurewebsites.net/
Pieter Vanhove is a SQL Server MVP and Database Consultant in Belgium and has been working with SQL Server since 2000. Performance tuning, SQL audits, migrations and training are part of the job. Pieter has also a profound knowledge in implementing HA/DR solutions and loves the new Azure stuff. Together with the SQLUG in Belgium, he helps organizing SQL Server Days and is also a regular speaker at Belgian and international events. Pieter recently won the Speaker Idol Contest at PASS Summit 2014.
Marco Parenzan
Twitter: - @marco_parenzan
LinkedIn: Marco Parenzan
Contact: https://www.linkedin.com/in/marcoparenzan/
Marco Parenzan is an independent Cloud and IoT Architect and .NET Developer. He has been awarded as a MVP on Microsoft Azure since 2014. He is a speaker in major community events in Italy about Azure and .NET development. He is a community lead for 1nn0va, an official Microsoft community in Pordenone, Italy. He has written a book on Azure in 2016. He loves developing retrogames and reading comix.
Marco Parenzan è professionista per le architetture Cloud e IoT e lo sviluppo in .NET. Ha ricevuto il titolo di MVP su Microsoft Azure dal 2014. È uno speaker in Italia su Azure e lo sviluppo di .NET. E’ un community lead per 1nn0va, una community ufficiale Microsoft a Pordenone, in Italia. Ha scritto un libro su Azure nel 2016.
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).
William Durkin
Twitter: - @sql_williamd
LinkedIn: William Durkin
Contact: http://williamdurkin.com
William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for Data Masterminds (http://datamasterminds.io). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular event SQLGrillen (http://sqlgrillen.com).
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.
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.
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.
Mark Stacey
Twitter: - @MarkGStacey
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
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.
André Kamman
Contact: http://andrekamman.com
André is a freelance SQL Server specialist. In previous roles he’s done a lot of DBA work on 100’s of servers where he discovered his love for Powershell and automating processes in general. Today the better part of his day he’s building and tuning ETL processes. André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Rally Amsterdam and SQLSaturday Holland
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.
Rasmus Reinholdt
Twitter: - @RasmusReinholdt
LinkedIn: Rasmus Reinholdt
Contact: http://rasmusreinholdt.wordpress.com
Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.
Kennie Pontoppidan
Twitter: - @KennieNP
LinkedIn: Kennie Pontoppidan
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
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.
Sponsors
The following is a list of sponsors that helped fund the event: