SQLSaturday #221 - Holland 20134/6/2013 12:00:00 AM(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, ViennaSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat221Info SupportKruisboog 42Veenendaal , Netherlands3905 TG3192Fusion-IOhttp://www.fusionio.com/http://www.sqlsaturday.com/files/ebb90862-dc8c-4e0b-ad65-e8e0f16b528d.jpg601703197HPhttp://www.hp.comhttp://welcome.hp-ww.com/img/hpweb_1-2_topnav_hp_logo.gif601703218Info Supporthttp://www.infosupport.comhttp://www.sqlsaturday.com/files/95a0fde7-d154-4466-b5f8-acb9c1603908.png601703196Red Gatehttp://www.redgate.comhttp://www.red-gate.com/assets/images/common/logo.png601703217Schuberg Philishttp://www.schubergphilis.comhttp://www.sqlsaturday.com/files/4a917490-9483-459e-a570-a22f464690d7.png6017013629Andreas WolterAndreas Wolter is a Microsoft Certified Master SQL Server 2008 (MCM) and holds numerous other certifications, including MCT, MCITPDD, MCITPBID, MCITPDA, MCDBA, and MCSA.
He has worked with SQL Server for over a decade as trainer, consultant and architect and as being active member of the PASS since several years he is a speaker at various international conferences.
His company, Sarpedon Quality Lab (www.SarpedonQualityLab.com specializes on scalable, performing and secure OLTP OLAP deploymen@AndreasWolterhttp://de.linkedin.com/in/andreaswolterhttp://www.vb-magazin.de/forums/blogs/andreaswolterhttps://api.twitter.com/1/users/profile_image?screen_name=@AndreasWolter484813663Hugo KornelisHugo is mede-oprichter en hoofd research en ontwikkeling van perFact BV, een bedrijf dat analyse methodes verbetert, tools ontwikkelt die op basis van de analyse complete applicaties genereren en consultancy diensten levert. In zijn vrije tijd deelt en vergroot Hugo zijn kennis van SQL Server via forums, lezen en schrijven van boeken en blogs, en het bijwonen van en spreken op conferenties. Sinds januari 2006 is Hugo een SQL Server MVP..@Hugo_Kornelishttp://sqlblog.com/blogs/hugo_kornelis/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@Hugo_Kornelis484814190Jennifer StirrupJennifer Stirrup is a newly-awarded SQL Server MVP. She is an independent consultant who specialises in Business Intelligence, with a focus on Data Visualisation. Jen has conducted projects in the UK and mainland Europe. Jen has previously spoken at SQLBits, SQLPASS and other community events on the topic of Business Intelligence and Data Visualisation. She blogs regularly on these topics at www.jenstirrup.com and can be found tweeting at http://twitter.com/jenstirrup@rhartskeerlhttp://nl.linkedin.com/in/rhartskeerl/https://api.twitter.com/1/users/profile_image?screen_name=@rhartskeerl484813661Johan BijnensJohan 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 at Genk as well as ArcelorMittal Ghent and Dunkirk as well as operational performance and troubleshooting support for these sites.
@alzdbahttp://www.linkedin.com/profile/view?id=9488495trk=tab_prohttp://www.sqlservercentral.com/Authors/Articles/Johan_Bijnens/2237/https://api.twitter.com/1/users/profile_image?screen_name=@alzdba484813589Jonathan AllenJonathan 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 SQLSouthWest user group (http://www.sqlsouthwest.co.uk) and enjoys blogging about it all for Simple Talk.@fatherjackhttp://www.simple-talk.com/community/blogs/jonathanallen/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@fatherjack484813750Klaus AschenbrennerKlaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008.@Aschenbrennerhttp://www.SQLpassion.athttps://api.twitter.com/1/users/profile_image?screen_name=@Aschenbrenner484813683Leonard LobelLeonard Lobel is a SQL Server MVP and cofounder/CTO of Sleek Technologies, Inc., a NY-based de-velopment shop with an early adopter philosophy toward new technologies. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains. He is also a consultant, trainer, and frequent speaker at local usergroup meetings and industry conferences worldwide. Lenni is also author of the MS Press book “Programming Microsoft SQL Server 2012.”@lennilobelhttp://www.linkedin.com/in/lennilobelhttp://lennilobel.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@lennilobel484813765Mark StaceyMark founded Pragmatic Works South Africa, the first Pragmatic Works international franchise, and works tirelessly to cross the business / technical boundaries in Business Intelligence, working in both Sharepoint and SQL.He has published a book (Sharepoint 2010 BI), founded the BIDN user group in Johannesburg, and, a rarity, frequently speaks at both SQL Saturday and Sharepoint Saturday events.@MarkGStaceyhttp://www.linkedin.com/in/MarkGStaceyhttp://markgstacey.nethttps://api.twitter.com/1/users/profile_image?screen_name=@MarkGStacey484813818Menzo Steinhorst484813647Peter ter BraakePeter is an independent trainer / consultant focussing solely on SQL Server. He is MCT since he decided to focus on SQL Server in 2002 and he is MVP since 2012.
Peter was co-founder of PASS in the Netherlands and nowadays closely involved in the Dutch SQLSaturday.@pbraakehttp://nl.linkedin.com/pub/peter-ter-braake/1/b87/1aa/https://api.twitter.com/1/users/profile_image?screen_name=@pbraake484813592Régis BaccaroRégis has 10 years of experience with Business Intelligence, SQL Server, SharePoint and .Net. His background and work experience mixes technology and business, providing him a unique edge to contribute to BI projects and developing, being able to effectively interact with technical and business decision makers.
He has a wide experience as speaker at different IT conferences and contributor to books and whitepapers. Latest the Microsoft upgrade guide to SQL Server 2012.
@regbachttp://dk.linkedin.com/in/regisbaccarohttp://theblobfarm.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@regbac484813622Rik OpdamRIk Opdam heeft ruim 12 jaar ervaring in Business Intelligence en ICT. Hij werkt sInds anderhalf jaar bij Gasunie op het project DataHistorian via CGI als Software Engineer en heeft brede kennins op het gebied van Microsoft's BI Stack.@#rikopdamhttp://nl.linkedin.com/in/rikopdamhttp://www.microsoftsql.nl/blog/https://api.twitter.com/1/users/profile_image?screen_name=@#rikopdam484813595Robert HartskeerlRobert Hartskeerl is Premier Field Engineer voor Microsoft Services en SQL Server 2008 MCM. Als PFE ondersteunt hij klanten bij het gebruik van SQL Server. De vraagstukken zijn uiteenlopend van migraties tot HA/DR inrichtingen of performance uitdagingen. Voordat Robert Hartskeerl bij Microsoft ging werken was hij werkzaam bij IVENT. Robert is bijna altijd aanwezig bij SQL Server evenementen in Nederland zoals SQL Zaterdag en SQL PASS bijeenkomsten.@rhartskeerlhttp://nl.linkedin.com/in/rhartskeerl/http://blogs.technet.com/rhartskeerlhttps://api.twitter.com/1/users/profile_image?screen_name=@rhartskeerl484814191Scott KleinTBD@rhartskeerlhttp://nl.linkedin.com/in/rhartskeerl/https://api.twitter.com/1/users/profile_image?screen_name=@rhartskeerl484813572SQLSatruday 221484813573SQLSaturday 221484814096Steven KoppenolSteven 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.@stevenkoppenolhttp://nl.linkedin.com/in/stevenkoppenol/https://api.twitter.com/1/users/profile_image?screen_name=@stevenkoppenol48481357213572SQLSatruday 221Seminarruimte 1Coffee Break4/6/2013 10:30:00 AM4/6/2013 11:00:00 AM1357213572SQLSatruday 221Seminarruimte 1Coffee Break4/6/2013 2:30:00 PM4/6/2013 2:45:00 PM1357213572SQLSatruday 221Seminarruimte 2Coffee Break4/6/2013 10:30:00 AM4/6/2013 11:00:00 AM1357213572SQLSatruday 221Seminarruimte 2Coffee Break4/6/2013 2:30:00 PM4/6/2013 2:45:00 PM1357213572SQLSatruday 2215.20Coffee Break4/6/2013 10:30:00 AM4/6/2013 11:00:00 AM1357213572SQLSatruday 2215.20Coffee Break4/6/2013 2:30:00 PM4/6/2013 2:45:00 PM1357213572SQLSatruday 2215.21Coffee Break4/6/2013 10:30:00 AM4/6/2013 11:00:00 AM1357213572SQLSatruday 2215.21Coffee Break4/6/2013 2:30:00 PM4/6/2013 2:45:00 PM1357313573SQLSaturday 221Seminarruimte 1Lunch Break4/6/2013 12:00:00 PM4/6/2013 1:30:00 PM1357313573SQLSaturday 221Seminarruimte 2Lunch Break4/6/2013 12:00:00 PM4/6/2013 1:30:00 PM1357313573SQLSaturday 2215.20Lunch Break4/6/2013 12:00:00 PM4/6/2013 1:30:00 PM1357313573SQLSaturday 2215.21Lunch Break4/6/2013 12:00:00 PM4/6/2013 1:30:00 PM1357413574SQLSaturday 221Seminarruimte 1Registrations4/6/2013 8:30:00 AM4/6/2013 9:30:00 AM1357413574SQLSaturday 221Seminarruimte 2Registrations4/6/2013 8:30:00 AM4/6/2013 9:30:00 AM1357413574SQLSaturday 2215.20Registrations4/6/2013 8:30:00 AM4/6/2013 9:30:00 AM1357413574SQLSaturday 2215.21Registrations4/6/2013 8:30:00 AM4/6/2013 9:30:00 AM1357513575SQLSaturday 221Seminarruimte 1Raffle4/6/2013 3:45:00 PM4/6/2013 4:00:00 PM1357513575SQLSaturday 221Seminarruimte 2Raffle4/6/2013 3:45:00 PM4/6/2013 4:00:00 PM1357513575SQLSaturday 2215.20Raffle4/6/2013 3:45:00 PM4/6/2013 4:00:00 PM1357513575SQLSaturday 2215.21Raffle4/6/2013 3:45:00 PM4/6/2013 4:00:00 PM1358913589Jonathan Allen5.20LogParser-quicker than SSIS, easier than BCPThis 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. 4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1359213592Régis Baccaro5.20Database development with SSDTSQL 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.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1359513595Robert HartskeerlSeminarruimte 2Creëer inzicht met OpsMgr 2012Iedereen 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.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1362213622Rik Opdam5.21Process Intelligence met SQL : Case GasunieBij 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.4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1362913629Andreas WolterSeminarruimte 1 Tracing with Extended Events. - Adios Profiler“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“)
4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1364713647Peter ter Braake5.20MDX, zo moeilijk niet!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.4/6/2013 9:30:00 AM4/6/2013 10:30:00 AM1364813648Joost van RossumSeminarruimte 2Performance Tuning SSIS packagesIn 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.4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1366113661Johan Bijnens5.21Powershell: The DBA as a consumerFocus 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.
4/6/2013 9:30:00 AM4/6/2013 10:30:00 AM1366313663Hugo KornelisSeminarruimte 1Nieuwe T-SQL opties om queries te vereenvoudigenWie 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.4/6/2013 9:30:00 AM4/6/2013 10:30:00 AM1368313683Leonard Lobel5.20Native File Streaming with SQL Server 2012In 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.4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1375013750Klaus AschenbrennerSeminarruimte 2Troubleshooting the most difficult SQL Server ProbDo 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 Problems4/6/2013 9:30:00 AM4/6/2013 10:30:00 AM1376513765Mark StaceySeminarruimte 2Slowly changing dimensions- an integrated approachThere 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 Services4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1381813818Menzo SteinhorstSeminarruimte 1- SQL Server Internals Series: On Disk Structureso 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!4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1409614096Steven Koppenol5.21Data Vault generatie in SQL Server 2012 omgevingIn 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.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1418914189SQLSaturday 221Seminarruimte 1Sponsor Session4/6/2013 12:30:00 PM4/6/2013 1:15:00 PM1418914189SQLSaturday 221Seminarruimte 2Sponsor Session4/6/2013 12:30:00 PM4/6/2013 1:15:00 PM1418914189SQLSaturday 2215.20Sponsor Session4/6/2013 12:30:00 PM4/6/2013 1:15:00 PM1418914189SQLSaturday 2215.21Sponsor Session4/6/2013 12:30:00 PM4/6/2013 1:15:00 PM1419014190Jennifer StirrupSeminarruimte 1Mobile Business Intelligence - Apprentice Style!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 Pivot4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1419114191Scott Klein5.21Running SQL Server in a Windows Azure Virtual Machine – Deep DiveWindows 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. 4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM