SQLSaturday #434 - Holland 20159/26/2015 12:00:00 AM350(GMT+01:00) Sarajevo, Skopje, Warsaw, ZagrebSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsatHollandUniversity of Utrecht - Marinus Ruppert BuildingLeuvenlaan 21UtrechtUtrecht, Netherlands3584 CE1021SanDiskPlatinum Sponsorhttp://www.sandisk.comhttp://www.sqlpass.org/files/8c03ba71-c441-404f-9673-ff879cb4c5f7.png601701450Motion10Platinum Sponsorhttp://www.motion10.nl/https://1.bp.blogspot.com/-982s5GtaTS0/V_a9kAmoMjI/AAAAAAAAEME/3B4XjbfgiB86mnREXrHqAKgDGxpBbwybwCLcB/s1600/Motion10.png60170719Info SupportPlatinum Sponsorhttp://www.infosupport.comhttp://www.sqlpass.org/files/95a0fde7-d154-4466-b5f8-acb9c1603908.png6017013Quest SoftwareGold Sponsorhttps://www.quest.com/http://www.sqlsaturday.com/images/sqlsaturday/eventsponsors/Quest_170x60.png60170687hpGold Sponsorhttp://www.valid.nl/http://1.bp.blogspot.com/-S4tCVJCkApw/VetK1s1IToI/AAAAAAAADpE/iHE2bCXn-to/s1600/HP_Blue_RGB_150_MX.png601701451Monkey Recruitment B.V.Gold Sponsorhttp://www.monkeyrecruitment.nl/http://4.bp.blogspot.com/-uQe2J42mJQM/VXFG1rFvkwI/AAAAAAAADcA/MlDi1Kin-O0/s1600/Monkey.png601701405COZYROCGold Sponsorhttp://www.cozyroc.com/?utm_source=sqlviennapage2018utm_medium=bannerutm_campaign=sqlviennahttps://www.cozyroc.com/sites/default/files/cozyroc-big.png60170941PernixDataGold Sponsorhttp://www.pernixdata.comhttp://3.bp.blogspot.com/-BE7RSSaO0QA/VYm16ETe3eI/AAAAAAAADf4/AINR9bxLpUg/s320/PernixLogo.png6017072Violin MemoryGold Sponsorhttp://www.violin-memory.comhttp://www.sqlpass.org/images/SQLSaturday/EventSponsors/Violin_Memory_Logo.png601701452RubiconGold Sponsorhttp://www.rubicon.nlhttp://1.bp.blogspot.com/-WtO-_UdBd0g/VXHZ6uNoCFI/AAAAAAAADco/Cl7BaasJwQM/s1600/Rubicon-160.jpg601701458ilionXGold Sponsorhttp://www.ilionx.comhttp://2.bp.blogspot.com/-kXJnPA8AxN0/WLnVjL5mAbI/AAAAAAAAEjk/SwqWLNvwajAs7DvJcmm4rPmhOAs6DgJrQCK4B/s1600/ilionx%2Blogo%2Bblog.png6017070Tegile SystemsSilver Sponsorhttp://www.tegile.comhttp://www.sqlpass.org/images/SQLSaturday/EventSponsors/Tegile_170x60.png6017036363Dandy WeynWith over 20 years of experience in the database world, Dandy Weyn is very experienced on database platforms and business intelligence. As content developer for hands-on-labs, owner of technical events, and multiple years as international consultant and trainer Dandy offers the unique combination of deep technical and solid presentation skills. He is an MCM for SQL Server, Microsoft Certified Trainer and Global Technical Lead for Data Platform in the Enterprise Partner Group (EPG) at Microsoft.ILIKESQLhttps://www.linkedin.com/in/dandyweynhttp://WWW.ILIKESQL.COMhttps://api.twitter.com/1/users/profile_image?screen_name=ILIKESQL484836437Henk VlootmanHenk Vlootman is trainer in Excel and Power pivot to managers throughout the world in the Dutch or English language since 1992. I also do assignments from the industry, partly consultancy and partly direct modelling. I do seminars and congresses. With Michiel Rozema (Rubicon, The Netherlands, I wrote the quot;Practice Book PowerPivot in Excel.quot; At this moment, again with Michiel Rozema I’m finishing a new Power pivot book. I write a monthly blog on Power BI for two different Dutch (financial) e-magazine. I’m manager of the LinkedIn group Power BI Gebruikersgroep. Henk is board member of the Dutch Power BI gebruikersgroep.Henk4Excelhttps://www.linkedin.com/in/vlootmanhttp://www.vlootman.nlhttps://api.twitter.com/1/users/profile_image?screen_name=Henk4Excel484836917Jan Pieter PosthumaJan Pieter Posthuma is a certified Microsoft Data Consultant at his own company DataScenarios and has helped multiple clients as the leading (technical) expert in their Microsoft Data challenges.
Besides working for customers is Jan Pieter also involved into the Microsoft Data Platform community by co-organizing the yearly Dutch SQLSaturday event and presenting at local and foreign Microsoft Data Platform events.
Also he has created several community solution for the Microsoft Data Platform, like Power BI custom visuals and VisualStudio Team Services extensions.jppphttps://nl.linkedin.com/in/jpposthumahttps://azurebi.jppp.orghttps://api.twitter.com/1/users/profile_image?screen_name=jppp484836370Dejan SarkaDejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of the 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 sixteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.@DejanSarkahttp://blogs.solidq.com/dsarka/Home.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@DejanSarka484839215Scott KleinScott Klein is a Microsoft Data Platform Technical Evangelist who lives and breathes data. His passion for data technologies brought him to Microsoft in 2011 which has allowed him to travel all over the globe evangelizing SQL Server and Microsoft’s cloud data services. Prior to Microsoft Scott was one of the first 4 SQL Azure MVPs, and even though those don’t exist anymore, he still claims it. Scott continues to look for ways to help developers grok the benefits of cloud computing.@SQLScotthttp://aka.ms/sqlscotthttps://api.twitter.com/1/users/profile_image?screen_name=@SQLScott484836759Klaus AschenbrennerKlaus 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).@Aschenbrennerhttp://www.SQLpassion.at/bloghttps://api.twitter.com/1/users/profile_image?screen_name=@Aschenbrenner484836364Tanja VukovTanja Vukov, PhD – research associate at Institute for Biological Research, University of Belgrade. She is an expert in biostatistics and her role is to transform data into meaningful scientific conclusions. As a bio-analyst she helped to develop new practices in a field of agriculture and medicine. She published more than 20 papers in leading international scientific journals. She was a speaker on using different Azure technologies. She holds a PhD in Evolutionary biology. https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profilehttps://api.twitter.com/1/users/profile_image?screen_name=484836574Aaron BertrandAaron Bertrand is a product evangelist for SQL Sentry, makers of performance monitoring and event management software for Microsoft#39;s full SQL Server stack. He blogs at sqlperformance.com, has been a Microsoft MVP since 1997, is a four-time SQL Cruiser, and speaks frequently at various community events. You can find his MVP profile at https://mvp.support.microsoft.com/profile/Aaron.@AaronBertrandhttp://blogs.sqlsentry.com/author/AaronBertrandhttps://api.twitter.com/1/users/profile_image?screen_name=@AaronBertrand484836413Leonard LobelLeonard Lobel is a Data Platform MVP and co-founder/CTO 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 Gold Competency Partner.
Programming since 1979, 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, author of several SQL Server books and Pluralsight courses, and professional trainer.@lennilobelhttp://www.linkedin.com/in/lennilobelhttp://lennilobel.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@lennilobel484840635Hugo KornelisHugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was an SQL Server MVP from January 2006 to December 2016.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.@Hugo_Kornelishttp://nl.linkedin.com/in/hugokornelishttp://sqlblog.com/blogs/hugo_kornelis/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@Hugo_Kornelis484837478Pieter VanhovePieter Vanhove is a Technical Sales Professional at Microsoft Belgium and has been working with SQL Server since 2000. Pieter has a profound knowledge in implementing high availability and disaster recovery solutions and loves the new Azure stuff. Together with the SQLUG in Belgium, he helps organizing dataMinds Connect and is also a regular speaker at Belgian and international events.http://twitter.com/Pieter_Vanhovehttp://be.linkedin.com/pub/dir/Pieter/Vanhovehttp://pietervanhove.azurewebsites.net/https://api.twitter.com/1/users/profile_image?screen_name=http://twitter.com/Pieter_Vanhove484836372John MartinJohn (@SQLDiplomat) is the Product Manager at SentryOne, looking after SQL Sentry and the core monitoring suite. John is also a Microsoft Data Platform MVP, with over a decade of experience with SQL Server and the Microsoft Data Platform. Having worked with SQL Server for the last decade, John has gained a level of experience as a DBA, Developer, and former Microsoft Premier Field Engineer. Gaining a broad understanding of how you can use, and misuse, SQL Server.@SQLDiplomathttp://uk.linkedin.com/in/johnqmartin/http://blogs.sqlsentry.com/author/JohnMartin/https://api.twitter.com/1/users/profile_image?screen_name=@SQLDiplomat484839220Niall MacLeodNiall is a Senior Applications Architect for SanDisk, specializing in Microsoft SQL Server and Flash Storage Solutions. Niall has extensive knowledge and experience in utilizing infrastructure resources to deliver application performance. Having began his career in IT in the late 1990s at Data General and EMC, Niall has since worked with several enterprise storage companies; the latter being Fusion-io where he was responsible for the direction of technical marketing in EMEA.https://api.twitter.com/1/users/profile_image?screen_name=484836924M StreutkerT.b.d.https://twitter.com/mstreutkerhttps://www.linkedin.com/pub/mark-streutker/0/942/8b9https://api.twitter.com/1/users/profile_image?screen_name=https://twitter.com/mstreutker484837355Joseph D'AntoniJoseph D'Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016”.@jdantonhttp://www.linkedin.com/profile/view?id=3997984amp;trk=hb_tab_pro_tophttp://joeydantoni.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484837567Matija LahMatija 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 (Windows Server System SQL Server). 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.@MatijaLahhttp://si.linkedin.com/in/matijalah/http://milambda.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MatijaLah484836391David PostlethwaiteDavid Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England for the past 7 years.
He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services.
In 2015 David built and deployed the company's first cloud solution using Microsoft Azure SQL Database and web services
Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.
He is an occasional blogger on www.gethynellis.com
David is a regular speaker for SQL Saturday@postledmhttp://www.linkedin.com/in/davidpostlethwaitehttp://www.gethynellis.com/https://api.twitter.com/1/users/profile_image?screen_name=@postledm484837466David WilliamsDavid is a cross product dba (SQL Server,DB2,Oracle,Informix,Sybase) who has worked for 20 years as a DBA for both private,local government and central government customers and now works at a leading investment bank. Certifications include MCSE 2012,MCITP SQL Server 2008 DBA and Developer, MCTS 2008 BI as well as certifcations in other products. @smooth1x1https://www.linkedin.com/profile/view?id=14051454amp;trk=nav_responsive_tab_profilehttp://justdave.infohttps://api.twitter.com/1/users/profile_image?screen_name=@smooth1x1484837282Gabi MünsterGabi Muenster is working as a Business Intelligence consultant and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, Master Data Services as well as project management into the community as a regional chapter lead. She also is passionate about motivating other women to start a technical career and therefore initiates and supports "Women in Technology" events. Apart from SQL Saturdays she also spoke at SQLBits, SQL Nexus, Tuga IT and 2015's PASS Summit.@SQLMissSunshinehttps://www.linkedin.com/in/gabimuenster/https://api.twitter.com/1/users/profile_image?screen_name=@SQLMissSunshine484836381Neil HamblyNeil Hambly is a SQL Server consultant, founder Consultant @ DataMovements a Microsoft Partner Data Analytics Consulting company, previously roles at Northdoor PLC, ABN AMRO, Accenture, ASOS, BBC, Confio Software
Neil has 18+ years in a variety of SQL Server roles
Presented at 150+ events, at numerous usergroup and PASS events, PASS Summits SQL Saturdays many UK events (SQLBits, SQLRelay), Leader of PASS London (UK) amp; Professional Development VC, Melissa Data MVP, SQL Cruise Technical Lead who likes Guinness, Loves whisky and dancing.@Neil_Hamblyhttp://uk.linkedin.com/in/neilhamblyhttp://dataidol.com/NeilHamblyhttps://api.twitter.com/1/users/profile_image?screen_name=@Neil_Hambly484836968Enrico van de LaarEnrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Data Masterminds where he helps organizations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.dotnine.net.twitter.com/evdlaarhttp://nl.linkedin.com/pub/enrico-van-de-laar/33/882/756/http://www.dotnine.nlhttps://api.twitter.com/1/users/profile_image?screen_name=twitter.com/evdlaar484837584Sander van der hoeffWith over 20 years of experience in automation Sander van der Hoeff knows his way around in the ICT business. Since 2000 Sander is Specialized in business intelligence and data warehousing using the full SQLServer Stack. In 2012 Sander founded his own BI-company: Du Sabot. Nowadays Sander spends his time on several BI- and DWH-projects as an independent professional. Sander combines deep technical knowledge with the capability to explain difficult BI- and DWH-concepts to the non-technical peopleshoeffhttp://nl.linkedin.com/in/shoeffhttp://www.du-sabot.nlhttps://api.twitter.com/1/users/profile_image?screen_name=shoeff484838723Tobiasz KoprowskiCEO of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in West Bridgford (England). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, freelancer and consultant. Subject Matter Expert at CQURE. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. Member of the boards: PTI amp; ISSA (Poland#39;s Chapter). Since 1st July 2010 Data Platform MVP. Former President of the Polish SQL Server USer Group. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conf@KoprowskiThttps://uk.linkedin.com/in/koprowskithttp://koprowskit.eu/geek/https://api.twitter.com/1/users/profile_image?screen_name=@KoprowskiT484837531Hugo KornelisHugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was an SQL Server MVP from January 2006 to December 2016.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.@Hugo_Kornelishttp://nl.linkedin.com/in/hugokornelishttp://sqlblog.com/blogs/hugo_kornelis/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@Hugo_Kornelis484837608Jan Van humbeekJan Van humbeek is a Microsoft BI consultant working for Ordina Belgium.
Over the years, he’s gathered experience with all the core BI components the SQL Server stack has to offer.
This led him to becoming fully MCSE certified on the SQL Server stack and more recently he achieved an MCSA certification in Office 365.
When the working day is done, he loves learning about all the latest and greatest features Microsoft has to offer.@janvanhumbeekhttps://be.linkedin.com/in/janvanhumbeekhttp://blog.janvanhumbeek.com/https://api.twitter.com/1/users/profile_image?screen_name=@janvanhumbeek484837412Denny CherryDenny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2012, including the MCM and MVP.@mrdennyhttps://www.linkedin.com/in/mrdennyhttp://www.dcac.cohttps://api.twitter.com/1/users/profile_image?screen_name=@mrdenny484840257Henk van der ValkSince 2000 Henk has specialized in optimizing large-scale Microsoft application and database solutions.
He’s been authoring and contributing numerous whitepapers around SQL Server performance tuning and also produced the famous ETL Data loading World Record with SSIS.
In his role at Microsoft he’s focusing now on technical presales around Microsoft Data Warehouse and Big Data technology both on-premise as in the cloud. He run’s POCs for customers throughout Western Europe.
http://nl.linkedin.com/in/henkvandervalkhttp://www.henkvandervalk.comhttps://api.twitter.com/1/users/profile_image?screen_name=484837199Joost van RossumI#39;m a Microsoft Business Intelligence consultant at ilionx with a focus on SQL Server Integration Services (SSIS). I started my career with some ASP, ASP.Net, MCMS and SPS assignments and made the switch to BI when Microsoft released SQL Server 2005.
I try to blog at least once a month about SSIS (and related stuff) and try to answer questions on the SSIS forum on MSDN where I#39;m a moderator. And last year I wrote an SSIS Scripting book to show you how to use C# or VB.Net within SSIS.https://twitter.com/ssisjoosthttp://nl.linkedin.com/in/joostvanrossumhttp://microsoft-ssis.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=https://twitter.com/ssisjoost484836380Jeffrey VerheulJeffrey Verheul is a DBA and database developer from the Netherlands, with over 8 years experience in the Microsoft stack. After a short side-track as a software engineer, he returned to his true love: SQL Server. His main focus is on database development, performance tuning and database administration. He is a member of the Friends of Red Gate and the Professional Association for SQL Server (PASS), and blogs regularly on devjef.wordpress.com.@devjefhttp://nl.linkedin.com/pub/jeffrey-verheul/63/92/6a4/http://devjef.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@devjef484836932Peter JonkPeter Jonk is a Premier Field Engineer for Microsoft Services and supports customers to get the most out of SQL Server. Areas of expertise include high availability, SQL migrations and performance tuning.https://twitter.com/dba60k/http://nl.linkedin.com/in/peterjonkhttp://dba60k.nethttps://api.twitter.com/1/users/profile_image?screen_name=https://twitter.com/dba60k/484837399Niels NagléNiels Nagl#233; is a Data Solution consultant and Trainer at Info Support. He has worked with the Microsoft’s SQL Server stack to deliver data and BI solutions for various organizations. He is passionate about helping customers understand and work with their data. Niels loves to share ideas and teach other BI developers/designers/end users the necessary know how and tipsamp;tricks of the Microsoft BI stack. Other subjects he finds interesting are Social Media, ML, AI, AR, VR Unstructured amp; Big Data.https://twitter.com/NielsNaglehttp://nl.linkedin.com/in/nielsnaglehttp://blogs.infosupport.com/author/nielsn/https://api.twitter.com/1/users/profile_image?screen_name=https://twitter.com/NielsNagle484837680Edgar WaltherEdgar Walther has been an independent BI consultant for over 12 years and specializes in the Microsoft Data Platform. He runs a BI consulting firm, ITsmart, based in the Netherlands, and he is one of the founders of the Dutch Power BI User Group. With a background of both Business Economics and IT development the area of Business Intelligence is where he can bridge the gap between Business and IT. He is very eager to stay up to date with the latest developments in Microsoft BI products, and he likes to share them with other BI enthusiasts. He has been a speaker at several SQL Server and Power BI events.@edgarwaltherhttp://nl.linkedin.com/in/edgarwalther/http://www.itsmart.eu/Blog/tabid/180/Default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@edgarwalther484837037Bob DuffyBob 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.@bob_duffyhttp://www.linkedin.com/profile/view?id=8301243amp;authType=NAME_SEARCHamp;authToken=MWkaamp;locale=en_USamp;srchid=83012431382480825815amp;srchindex=1amp;srchtotal=767amp;trk=vsrp_people_res_nameamp;trkInfo=VSRPsearchId%3A83012431382480825815%2CVSRPtargetId%3A8301243%2CVSRPcmpt%3Aprimaryhttp://blogs.prodata.ie/author/bob.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@bob_duffy48483637036370Dejan SarkaData ScienceZaal DSQL Server Power BI Geographic and Temporal PredictionsData science, predictive analytics, insights, statistics… There are so many buzzwords around these days. These words are frequently used in an introduction to some technical article, at the beginning of a presentation, and even in regular talk. However, when it comes down to a real analysis, you typically get reports with very nice Power BI graphs, but without real forecasting. It is up to you to recognize the patterns and then probably make some kind of interpolation by yourself. Data mining is the part that is based on statistics and can really make forecasts automatically. Data mining is part of SSAS installed in multidimensional mode. Is it possible to get the best from both words? This advanced session explains the forecasting algorithms and shows how you can integrate geographic and temporal predictions in Power View and Power Map visualizations and interactive animations. Popular buzzwords finally get some real meat behind them.9/26/2015 4:00:00 PM9/26/2015 5:30:00 PM3641336413Leonard LobelCloudZaal DIntroduction to Azure DocumentDBAzure DocumentDB is a new highly-scalable NoSQL database platform on Microsoft Azure, designed as a fully managed cloud service for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports schema-free designs, and scales across replicas with fast write performance and eventual consistency. But DocumentDB also offers several unique features that make it a compelling candidate for NoSQL scenarios, which you will learn about in this session. The platform is based on HTTP/REST, embraces JSON as a standard document format, and is supported by a wide range of SDKs for .NET, JavaScript, Java, Python, and Node.js. Without defining any index paths, new documents are queryable within milliseconds, using SQL grammar or LINQ. Learn these and other capabilities, including server-side JavaScript-based stored procedures, user-defined functions, triggers, tunable consistency, and more.9/26/2015 2:45:00 PM9/26/2015 3:45:00 PM3636436364Tanja VukovData ScienceZaal DAzure Machine Learning - drag, drop, predictMicrosoft Azure Machine Learning (AML) changes the way we work with data and what knowledge and skills are required in order to predict outcome of future events. AML is a comprehensive “drag, drop, predict” technology with all the benefits of the cloud. The transfer of machine learning to the new platform with ability to use R programming language makes common machine learning tasks very simple for the different customers and academic community.9/26/2015 11:30:00 AM9/26/2015 12:30:00 PM3657436574Aaron BertrandDatabase DevelopmentZaal AT-SQL : Bad Habits Best PracticesBad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.9/26/2015 10:15:00 AM9/26/2015 11:45:00 AM3636336363Dandy WeynCloudZaal 040Become the DBA of the future, everything you need to know about AIn the world of Data Platform a variety of solutions are available going from on premises, hybrid to cloud solutions. Database Administrators play a crucial role in application design and architecture, providing mission critical and highly available solutions. In this session you will learn everything a DBA needs to know about Azure. You’ll learn about SQL Server running in Windows Azure virtual machines, Azure Storage and network configurations, SQL Database and how to manage and support workloads running in a traditional, hybrid and cloud based environment.
Become the DBA of the future!
9/26/2015 4:00:00 PM9/26/2015 5:00:00 PM3643736437Henk VlootmanBusiness IntelligenceZaal 042Best practices in modelling Power pivot.Power pivot in Excel or SQL server have quite similar in user interfaces. Power pivot in SQL server has a lot more to offer, which you, as Excel user, will like. You prototype in Excel Power pivot, while bearing in mind you want to port your Excel power pivot model to SQL server Power pivot. There are best practices you should stick to in order to port without problems. This session will discuss the advantage and disadvantages of porting your Excel Power pivot model to SQL. After that the best practices in using formula, structuring Power pivot models and even before that how to look at your data will be showed. 9/26/2015 2:45:00 PM9/26/2015 3:45:00 PM3638136381Neil HamblyDatabase AdminstrationZaal 040Performance Troubleshooting Using DMVsPerformance troubleshooting is a complex subject with many factors under consideration when you find poorly performing SQL statements, using proven methodologies, and evaluating performance data available in the Dynamic Management Views and Functions. In this session, we’ll go over a foundation of how and which DMVs to use to identify those problematic statements for versions of SQL Server from 2005 – 2014.
We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available9/26/2015 11:30:00 AM9/26/2015 3:30:00 PM3675936759Klaus AschenbrennerDatabase DevelopmentZaal 040The dangerous beauty of Bookmark LookupsYou know Bookmark Lookups in SQL Server? You like their flexibility to retrieve data? If yes, you have to know that you are dealing with the most dangerous concept in SQL Server! Bookmark Lookups can lead to massive performance losses that blows up your CPU and I/O resources! Join me in this session to get a basic understanding of Bookmark Lookups, and how they are used by SQL Server. After laying out the foundation we will talk in more details about the various performance problems they can introduce. After attending this session you have a better understanding of Bookmark Lookup and you are finally able to tell if a specific Bookmark Lookup is a good or bad one.9/26/2015 9:00:00 AM9/26/2015 10:00:00 AM3735537355Joseph D'AntoniCloudZaal RoodFlying Through the Clouds--Performance Tuning in AzureSo between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:
• Optimizing TempDB in an Azure VM
• Reducing latency between application VMs and database VMs
• Right sizing Azure VMs for performance and cost
• Striping I/O across devices in Azure VMs
• Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.
9/26/2015 2:45:00 PM9/26/2015 3:45:00 PM3696836968Enrico van de LaarDatabase AdminstrationZaal 2Debugging SQL ServerWhen you were young, did you enjoy taking things apart to look at their inner workings? If you did, or still do, this session might be just the thing for you! Combining SQL Server internals with our curiosity on how things work, we will take a look underneath the hood of SQL Server by debugging it.
In this session we will debug the various parts of SQL Server using WinDbg. I’ll show you how to setup, configure and use WinDbg to extract information from a running SQL Server process. We will take a look at the various dump files that record information when a SQL Server crash occurs, capturing valuable information on why SQL Server crashed. And finally, I will demonstrate how you can use Extended Events to create dump files when specific conditions occur, helping you learn more about why they occur.
Don't worry if you are not a programmer. We will go through this session at a relaxed pace without causing (too many) headaches!
9/26/2015 2:45:00 PM9/26/2015 3:45:00 PM3739937399Niels NagléData ScienceZaal DDive into NoSQL with AzureAre you curious about the array of NoSQL technologies available in Azure, but aren't sure how they differ from each other or the relational models available? Or maybe you've got specific data in mind, but aren't sure which NoSQL technology is best for your application.
Microsoft Azure supports a variety of NoSQL technologies (i.e. key/value, document, column and graph databases). In this session we walk through the options, explaining what each one provides. 9/26/2015 1:30:00 PM9/26/2015 2:30:00 PM3768037680Edgar WaltherSQL Server 2016Zaal RoodTemporal Tables in SQL 2016SQL Server 2016 offers a cool new feature: Temporal Tables. This new functionality allows you to have the system "automagically" record all changes that happen to the data. Querying the data is also much easier than it was before with the workarounds that we had to use. In this hour you will understand the concept, learn how to create temporal tables and how to query them, and what the pros and cons are.
9/26/2015 11:30:00 AM9/26/2015 12:30:00 PM3753137531Hugo KornelisDatabase DevelopmentZaal ANow Where Did THAT Estimate Come From? - Part 1NB: This is part one of a two-part session
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there?
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.9/26/2015 1:30:00 PM9/26/2015 2:30:00 PM3921539215Scott KleinBusiness IntelligenceZaal DBig Data for the SQL NinjaAs more enterprises start implementing big data solutions, how does the DBA support these efforts and do they have the skills and knowledge to integrate big data solutions into your current architecture and processes? This demo-filled session has two purposes; first, to help DBAs understand how to apply their existing SQL Server skills in understanding and utilizing HDInsight and related technologies. Big data technologies don’t need to be intimidating, and this session will help DBAs see how they can easily apply their current skill when working with big data. Second, this session will show how SQL Server and HDInsight be used together to create solutions to solve big data problems without the complexities of massive learning curves and using technologies DBAs are already familiar with. We’ll look at technologies that make working with big data much less daunting, including HiveQL and Sqoop, both of which don’t require a rocket science degree to use.9/26/2015 10:15:00 AM9/26/2015 11:15:00 AM3637236372John MartinDatabase AdminstrationZaal 040Monitoring SQL Server, Key performance metrics and how to interpret themSQL Server has many moving parts with a massive amount of metrics that you can monitor to see how your system is performing, but which ones do you need to pay attention to, what do they mean and how do you interpret them? In this session we will look at the key areas of CPU, Memory and Storage, from performance counters to DMVs that you can use to check on the health of your server and gain insight into how it is performing. We will also look at some of the configuration options that exist which you can use to ensure that you have a healthy base on which to build.9/26/2015 2:45:00 PM9/26/2015 3:45:00 PM3922039220Niall MacLeodBusiness IntelligenceZaal AMicrosoft SQL Server Data Warehouse Fast Track – Understanding thThe SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures optimized for a range of enterprise data warehousing needs. DWFT is a joint effort between Microsoft and many hardware partners. The goal is to help enterprise customers deploy Data Warehouse solutions with recommended hardware configuration appropriate for the requirements of the workload with reduced risk, cost and complexity.9/26/2015 4:00:00 PM9/26/2015 5:00:00 PM4025740257Henk van der ValkBI Platform Architecture, Development AdministrationZaal RoodIntroductie van Azure SQL Data Warehouse (MPP in de cloud) SQL DW is wederom een mijlpaal in de geschiedenis van SQL Server voor wat betreft schaalbaarheid: deze Massive Parallel Processing (MPP) SQL Server versie @ Cloud scale biedt de mogelijkheid om binnen een minuut de rekenkracht en in-memory geheugencapaciteit met een factor 60x op te schalen of in z’n geheel te pauzeren wanneer je de database even niet nodig hebt! Tijdens deze presentatie krijg je via een boel live demo's snel een overzicht van de mogelijkheden van SQL DW inclusief antwoord op vragen als: hoe werkt SQL DW en hoe begin ik hiermee? Hoe migreer ik m’n database naar SQL DW? Hoe kan ik het beste data laden, via BCP of Polybase? En met welke dmv’s kan ik SQLDW het beste monitoren ? 9/26/2015 1:30:00 PM9/26/2015 2:30:00 PM4063540635Hugo KornelisDatabase DevelopmentZaal ANow Where Did THAT Estimate Come From? - Part 2NB: This is part two of a two-part session
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there?
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.9/26/2015 2:45:00 PM9/26/2015 3:45:00 PM3639136391David PostlethwaiteDatabase AdminstrationZaal 040Taming the Beast – How a SQL DBA can keep Kerberos under controlThe word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators.
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare.
This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
9/26/2015 1:30:00 PM9/26/2015 2:30:00 PM3691736917Jan Pieter PosthumaBusiness IntelligenceZaal 042Power BI APIWith the release of the Power BI Preview, last year, Power BI is now also accessible via an API. Although (at this moment) the API is limited, it provides the basic operations which can be used for real-time dashboarding scenarios. During this session I will show the possibilities of the API and how it can be integrated with other services, like Stream Analytics and AzureML, to provide real time dashboard for realistic IoT scenarios.9/26/2015 11:30:00 AM9/26/2015 12:30:00 PM3703737037Bob DuffyBusiness IntelligenceZaal 042Desigining Complex Tabular Models - A Case StudyWhile building of Tabular Models may be straight forward it rapidly becomes more complex when you steer off-piste and into more complex design pattern such as:
- Many to Many relationships
- Semi-Additive Measures
- Last Ever Non Empty
- Events in Progress
- Versioned Fact Tables
- Almost real time processing requirements
- Huge volume
- Non Star Schema Data Warehouses
- measure explosion and lack of calculated dimensions
- Selecting Hardware
This one hour session will walk through an actual case study of a tabular model and discuss the pain points we encountered on the way, along with solutions and workarounds.
9/26/2015 9:00:00 AM9/26/2015 10:30:00 AM3692436924M StreutkerData ScienceZaal DAn introduction to Data ScienceData Science is hot.
But what does it take to be a Data Scientist? And how do you get started?
This session will give you a brief introduction to Data Science.
We’ll explore the steps involved to take on an analytical endeavour, and show how these concepts work with several demos.
Attend this session and discover what (Microsoft) tools and technologies you can use to extract value from (big) data!
This session will be co-presented by Maarten van Duren. 9/26/2015 9:00:00 AM9/26/2015 10:00:00 AM3638036380Jeffrey VerheulData ScienceZaal 4Boost your analytical superpowers with spatial dataAnalyzing huge sets of data isn't something humans are made for. Humans are more suitable for making decisions based on things they can see. So how do you bring that into the business? One of the options you have is to visualize some of your (location based) data on maps. A feature for this in SQL Server is called spatial data (geo data). By using physical locations and shapes to visualize data, you can quickly analyze big sets of data.
In this session, we're going to take a look at how spatial data works, how you can query it, and how to use it to leverage your decision making process.9/26/2015 10:15:00 AM9/26/2015 11:15:00 AM3746637466David WilliamsSQL Server 2016Zaal RoodSQL Server 2016 New Feaures (Not Query Store!)SQL Server 2016 New Features (Not Query Store!)
- In-memory OLTP Enhancements
- Native JSON
- Always Encrypted
- Row Level Security
- Dynamic Data Masking
- Enhance Database Caching
- Enhanced Always On
- Power Query for Analytics and Reporting
- Enterprise Grade Analysis Services
- Enhanced MDS
- Enhanced Reporting Services
- Built in Advanced Analytics with R9/26/2015 9:00:00 AM9/26/2015 10:00:00 AM3760837608Jan Van humbeekBusiness IntelligenceZaal 042Datazen – Microsoft’s shiny dashboard-toolTo compete with other vendors supplying mobile BI dashboarding solutions, Datazen has entered the SQL Server BI stack.
In this session we will discover what it has to offer and what kind of effort is needed for publishing your very own dashboards.
We will go through local dashboards on Excel and evolve to a basic server setup with your dashboards published to mobile devices and SharePoint.
Let us guide you on your way to the future of mobile BI.9/26/2015 1:30:00 PM9/26/2015 2:30:00 PM3728237282Gabi MünsterBusiness IntelligenceZaal 042Scoped assignments – Threat or salvation? Some real life experiences… Did you ever reach the state in your multidimensional projects when you just didn’t want to implement a new scoped assignment? Will it have any side effects on existing scopes? How about performance?
Sometimes your projects get that complex. You will need to choose between many options and it might get hard to even measure the impact or test out all consequences. This session will not answer all your questions, but you will get some real life experiences on what better not to do…9/26/2015 10:15:00 AM9/26/2015 11:15:00 AM3693236932Peter JonkSQL Server 2016Zaal RoodMoving away from SQL Profiler to use Extended EventsThis session will guide you with practical tips tricks to move away from SQL Profiler and use Extended Events instead.
Extended Events were first introduced in SQL Server 2008 and should be used instead of the SQL Profiler. Still lots of DBA's and DEV's use SQL Profiler nowadays because of the convenience and lack of an Extended Events GUI in SQL 2008.
Extended events however impose a minimal performance penalty on SQL Server and provides much more detailed tracing.9/26/2015 4:00:00 PM9/26/2015 5:00:00 PM3758437584Sander van der hoeffBusiness IntelligenceZaal 042Agile BI from the cloud with Team Foundation ServicesAgile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have?
With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more.
In my session you will get the directions to a quick start with Visual Studio Online.
You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.
9/26/2015 4:00:00 PM9/26/2015 5:00:00 PM3872338723Tobiasz KoprowskiCloudZaal ASQL Security in the CloudOur data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The CLoud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.9/26/2015 9:00:00 AM9/26/2015 10:00:00 AM3741237412Denny CherryDatabase AdminstrationZaal 040Optimizing SQL Server Performance in a Virtual EnvironmentIn this session, we'll explore some of the things you should be looking at within your virtual environment to ensure that you are getting the best possible performance out of it.
We will discuss how to look for CPU performance issues at the host level. We will also be looking at the Memory Balloon drivers and what they actually do, as well as how you should be configuring them and why.
We will then talk about some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server, and we’ll finish up the session with some storage configuration options.
9/26/2015 10:15:00 AM9/26/2015 11:15:00 AM3719937199Joost van RossumSQL Server 2016Zaal RoodWhat's new in SSIS 2016This session is about all the new SSIS features in SQL Server 2016 public preview that was released summer 2016.9/26/2015 10:15:00 AM9/26/2015 11:15:00 AM3756737567Matija LahDatabase DevelopmentZaal ASQL Server 2014 Memory-optimized Data ExchangeSQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules - either within the database, or between client applications and databases:
- Memory-optimized Table Variables; and
- Memory-optimized Table-valued Parameters.9/26/2015 11:30:00 AM9/26/2015 12:30:00 PM3747837478Pieter VanhoveSQL Server 2016Zaal 5SQL Server 2016 Security InnovationsMicrosoft and the SQL Server team take security very seriously. SQL Server has the lowest number of security vulnerabilities across the major database vendors. To keep this number of vulnerabilities as low as possible, Microsoft introduced several security innovations in SQL Server 2016. In this session you will get an overview of the new security features in SQL Server 2016 like Always Encrypted – Row-Level Security – Dynamic Data Masking - SQL Server audit tools and many more. After attending this session you will have a good idea which new features might be helpful for you, when it comes to security for your mission-critical applications.9/26/2015 1:30:00 PM9/26/2015 2:30:00 PM