SQLSaturday #221 - Holland 2013
Event Date: 04/06/2013 00:00:00
Event Location:
- Info Support
- Kruisboog 42
- Veenendaal, Netherlands
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: Nieuwe T-SQL opties om queries te vereenvoudigen
Abstract: Wie kent ze niet: queries waar je ‘s nachts gillend van wakker wordt. Ingewikkelde monster die werken, al snapt niemand meer waarom. De tijd is gekomen om het beest te temmen, en er is nu, in SQL Server 2012, een oplossing voorhanden. Nieuwe T-SQL functies bieden standaard oplossing waar voorheen complexe trucs voor nodig waren. Paging, running totals, moving aggregates, YTD - dat alles en veel meer is nu makkelijker dan ooit tevoren. Het enige dat je hoeft te doen, is de nieuwe syntax leren. En dat is precies wat deze sessie biedt: een uitgebreide beschrijving van de syntax, en heel veel demo’s om te zien hoe je deze nieuwe features kan gebruiken.
Speaker(s):
- Hugo Kornelis
Track and Room: Track 1 - N/A
Title: Mobile Business Intelligence - Apprentice Style!
Abstract: It’s Friday afternoon and your boss has just set you an ‘Apprentice’ style challenge: to implement mobile Business Intelligence, using Microsoft technologies. Budget: meager. Delivery date: yesterday. How do you start? What’s available? What can you deliver? We will look at the mobile roadmap, but we will also look at what you can do - right now. During the session, the audience will be invited to try out mobile Business Intelligence on mobile devices so you can maximise your learning experience about this technology. Using mobile technology, come to this demo-rich session to discover a number of novel ways to implement mobile Business Intelligence from the technical perspective. We will look at a variety of ways to deploy mobile Business Intelligence using Microsoft technologies such as: - Sharepoint - SQL Server Reporting Services - SQL Azure - Excel Services - Power Pivot
Speaker(s):
- Robert Hartskeerl
Track and Room: Track 1 - N/A
Title: Data Vault generatie in SQL Server 2012 omgeving
Abstract: In onze projecten passen we steeds vaker een data vault laag toe in onze architectuur. De data vault methode leent zich erg goed voor de opslag van historische data. Dankzij de gestandaardiseerde structuur van een data vault model, kun je de modellen én de ETL logica om ze te laden heel goed automatiseren. Wij doen dat met een in .NET gebouwde generator die in een SQL Server 2012 omgeving draait. In deze sessie nemen we je mee van bron tot rapport en laten we zien waarom en hoe we onze source data vaults genereren, hoe we daar een business vault op bouwen met business rules, hoe we omgaan met tijd (Point-In-Time en actueel), hoe we een data mart bouwen op de business vault en hoe we daar weer een eindproduct (rapport) op bouwen.
Speaker(s):
- Steven Koppenol
Track and Room: Track 4 - N/A
Title: MDX, zo moeilijk niet!
Abstract: Mijn eerste ervaring met MDX was: o mooi, dat lijkt op SQL: SELECT..FROM..WHERE. In tweede instantie bleek dat behoorlijk tegen te vallen. Maar in derde instantie blijken MDX queries conceptueel toch erg vergelijkbaar met SQL queries. In deze sessie hoop ik je meteen in die derde fase te krijgen. We beginnen met de basis, tuples en sets. Daarna gebruiken we onze ervaring met SQL om snel begrip te krijgen in MDX queries. Uiteraard ondersteunen we het leerproces met veel demo’s. Deze sessie is voor iedereen die met MDX moet gaan werken en nog weinig tot geen ervaring heeft. Maar ook mensen die er al mee werken maar eens wat meer wil weten over de opbouw om daarmee hun begrip te vergroten, zullen voordeel hebben van deze sessie.
Speaker(s):
- Peter ter Braake
Track and Room: Track 3 - N/A
Title: LogParser-quicker than SSIS, easier than BCP
Abstract: This session will introduce people to a free tool from Microsoft that will speed up adhoc data import processes and file parsing among other data manipulation uses. LogParser uses a SQL-like query language to work with data in many formats (CSV, IISW3C, HTML, XML, ADS, REG, EVT, BIN and many more) and can convert the data into may outputs types (CSV, NAT, SQL, W3C, XML etc). It has many uses and can be employed in many ways to assist a busy DBA.
Speaker(s):
- Jonathan Allen
Track and Room: Track 3 - N/A
Title: Running SQL Server in a Windows Azure Virtual Machine – Deep Dive
Abstract: Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.
Speaker(s):
- Robert Hartskeerl
Track and Room: Track 4 - N/A
Title: Process Intelligence met SQL : Case Gasunie
Abstract: Bij Gasunie wordt Microsoft SQL BI onder andere gebruikt voor inzicht in de proces automatisering en de processen die nodig zijn om het gas bij de huishoudens te krijgen. De DataWarehouse wordt naast de functie van opslag gebruikt voor rapportages en analyses ten behoeve van efficiënctie verbetering. Tijdens de presentatie zal de totstandkoming tot de toekonst van het project aan bod komen met alle valkuilen die daarbij horen. De gebruikte hardware oplossing, het ETL proces met SSIS, Cubing met SSAS, Reporting met SSRS en Dashboarding met ASP.NET MVC4.
Speaker(s):
- Rik Opdam
Track and Room: Track 4 - N/A
Title: Tracing with Extended Events. - Adios Profiler
Abstract: “Hasta la vista, Profiler.” – Introduction into Tracing with Extended Events. Focus: historical deadlock analysis
Extended Events, although in the product since SQL Server 2008 have been known to Insiders as an extremely well performing and flexible Tracing-Framework. Since SQL Server 2012 this important feature, which will replace SQL Trace, is available in SSMS. In this introductory to advanced session we will also especially have a look at the System Health Session and how it can be used for historical deadlock-analysis right out of the box. („Hasta la vista, Profiler. Hasta la vista Traceflags 1204, 1222“)
Speaker(s):
- Andreas Wolter
Track and Room: Track 1 - N/A
Title: Creëer inzicht met OpsMgr 2012
Abstract: Iedereen moet zijn SQL Server omgeving monitoren. Problemen ligger overal op de loer maar ook de root cause analyse is makkelijker als je de juiste context beschikbaar hebt. In deze sessie gaan we kijken hoe we OpsMgr kunnen gebruiken om meer inzicht in onze SQL Server omgeving krijgen. Maar ook hoe we OpsMgr kunnen uitbreiden om informatie die wij interessant vinden eruit te halen.
Speaker(s):
- Robert Hartskeerl
Track and Room: Track 2 - N/A
Title: Database development with SSDT
Abstract: SQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio. SSDT provides a rich SQL Server development experience with first class language services and VS integration, as well as declarative, model-based tools that can be utilized for both online and offline development. In this session we’ll dive into Online and Offline development as well as the Productivity and tools that the SSDT team keeps providing to us.
Speaker(s):
- Regis Baccaro
Track and Room: Track 3 - N/A
Title: - SQL Server Internals Series: On Disk Structures
Abstract: o De sessie laat SQL onder de motorkap zien. Hoe zijn de files die we op disk zetten eigenlijk opgebouwd? Hoe is een record opgebouwd, en wat voor een invloed hebben features als filestream, version store en column sets eigenlijk op de manier hoe we een record opslaan. Deze sessie heeft als doel om achtergrond kennis te geven die in de praktijk toepasbaar is. Een paar bytes overhead op een record is op het eerste gezicht wellicht niet schokkend, maar als er 1,8 miljard rijen in je tabel zitten zijn het stiekum toch wel heel veel bytes!
Speaker(s):
- Menzo Steinhorst
Track and Room: Track 1 - N/A
Title: Troubleshooting the most difficult SQL Server Prob
Abstract: Do you have enough from “normal” performance tuning sessions? You can’t hear anything about Indexing and Execution Plans anymore? Then you are right in this session! In this session we will walk into the heart of SQL Server, and you will see performance bottlenecks and error conditions, from which your production SQL Server’s should be afraid of. You will learn some troubleshooting techniques with which you can identify and solve the most difficult SQL Server problems. Agenda at a glance:
*) Hold Locks with Read Committed *) ThreadPool Starvation *) TempDb Latch Contention *) Spinlock Contention *) Cross NUMA Node Latency Problems
Speaker(s):
- Klaus Aschenbrenner
Track and Room: Track 2 - N/A
Title: Performance Tuning SSIS packages
Abstract: In deze sessie laat ik zien hoe je SSIS packages kunt aanpassen om ze zo sneller te laten draaien. Tips voor beginners, maar ook voor ontwikkelaars die al even bezig zijn met SSIS. Veel demo en weinig slides.
Speaker(s):
- Joost van Rossum
Track and Room: Track 2 - N/A
Title: Powershell: The DBA as a consumer
Abstract: Focus for this session is demonstrating some quick benefits Powershell brings to day-to-day operations for a DBA and some gotchas experienced during the learning curve.
Speaker(s):
- Johan Bijnens
Track and Room: Track 4 - N/A
Title: Slowly changing dimensions- an integrated approach
Abstract: There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services
Speaker(s):
- Mark Stacey
Track and Room: Track 2 - N/A
Title: Native File Streaming with SQL Server 2012
Abstract: In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.
Speaker(s):
- Leonard Lobel
Track and Room: Track 3 - 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.
Peter ter Braake
Twitter: - @pbraake
LinkedIn: Peter ter Braake
Peter ter Braake, SQL Server MVP, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQLSaturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.
Steven Koppenol
Steven Koppenol is vanaf 2008 werkzaam in de IT. Eerst als software ontwikkelaar, tegenwoordig als ontwikkelaar / ontwerper binnen het BI vakgebied. Sinds 2010 werkt hij bij Info Support en is hij als BI consultant ingezet in diverse projecten in de zorg en industrie sectoren.
Robert Hartskeerl
Twitter: - @rhartskeerl
Contact: http://robert.hartskeerl.nl
With over 10 years of experience with SQL Server my knowledge goes a long way. But there is always room for more. That’s the reason why I love to help people face and solve their everyday or incidental challenges. This helps me to get more out of SQL Server. My main role is as a DBA but I love to hang around in Visual Studio and not afraid to take you up on a discussion about ADO.NET or the Entity Framework.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Johan Bijnens
Twitter: - @alzdba
LinkedIn: Johan Bijnens
Johan Bijnens is a database firefighter, involved with SQLserver since 2000, who works at Aperam Genk as member of the Industrial IT support department. Involved in designing architectural solutions based on the Microsoft SQL Server Platform. Performing operational performance and troubleshooting support in co-operation with the dev teams.
Joost van Rossum
Contact: http://microsoft-ssis.blogspot.com/
Ben sinds het afronden van mijn studie Bedrijfskundige Informatica in 1999 werkzaam in de ICT. De eerste jaren vooral aan de web-kant (ASP 3.0, ASP.Net, Microsoft Content Management Server) gewerkt en heb rond 2005 de overstap gemaakt naar Business Intelligence. In het begin veel andere tools zoals Powercenter en Cognos en naar maten Microsoft steeds populairder werd eigenlijk alleen nog maar Microsoft BI opdrachten gedaan. De focus ligt vooral bij SSIS.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Regis Baccaro
Twitter: - @regbac
LinkedIn: Regis Baccaro
Contact: http://theblobfarm.wordpress.com
Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.
Robert Hartskeerl
Twitter: - @rhartskeerl
Contact: http://robert.hartskeerl.nl
With over 10 years of experience with SQL Server my knowledge goes a long way. But there is always room for more. That’s the reason why I love to help people face and solve their everyday or incidental challenges. This helps me to get more out of SQL Server. My main role is as a DBA but I love to hang around in Visual Studio and not afraid to take you up on a discussion about ADO.NET or the Entity Framework.
Andreas Wolter
Twitter: - AndreasWolter
LinkedIn: Andreas Wolter
Contact: http://www.andreas-wolter.com/blog/
Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.
Robert Hartskeerl
Twitter: - @rhartskeerl
Contact: http://robert.hartskeerl.nl
With over 10 years of experience with SQL Server my knowledge goes a long way. But there is always room for more. That’s the reason why I love to help people face and solve their everyday or incidental challenges. This helps me to get more out of SQL Server. My main role is as a DBA but I love to hang around in Visual Studio and not afraid to take you up on a discussion about ADO.NET or the Entity Framework.
Menzo Steinhorst
x
Jonathan Allen
Contact: http://www.simple-talk.com/community/blogs/jonathanallen/default.aspx
Jonathan has been working with SQL Server since 1999. He enjoys performance tuning, development and using SQL Server to provide appropriate business solutions. He is the founder and leader of the PASS SQL South West user group http://www.sqlsouthwest.co.uk , is a moderator at SQL Q + A forum ask.sqlservercentral.com and is on twitter at @fatherjack. He has spoken at SQLBits and SQL in the City, SQLSaturdays and local user groups across the UK and Europe.
Rik Opdam
Contact: http://www.microsoftsql.nl/blog/
RIk Opdam heeft ruim 12 jaar ervaring in Business Intelligence en ICT. Gespecialiseerd in DataWarehousing, IoT en Grote Databases.
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
Sponsors
The following is a list of sponsors that helped fund the event: