SQLSaturday #188 - Portugal 2013 3/16/2013 12:00:00 AM (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat188 Rua do Fogo de Santelmo, Lote 2.07.02 Microsoft Portugal (Parque das Nações, (junto ao Oceanário)) Lisbon , Portugal 1990-110 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 2923 Microsoft Portugal Diamond http://www.microsoft.pt http://sqlport.com/sql-server/sites/default/files/microsoft.png 60 170 2946 Bi4all Consultores de Gestão Lda Gold Sponsor http://www.bi4all.pt http://www.bi4all.pt/OWATemplate/BI4all_170_60.png 60 170 3165 Rumos - Formação e Comunicação, S. A. Gold Sponsor http://formacao.rumos.pt http://formacao.rumos.pt/mmedia/logo%20Rumos%202012_400px_72dpi.jpg 60 170 2925 DevScope Silver Sponsor http://www.devscope.net http://rquintino.files.wordpress.com/2013/01/devscope-logo-sqlsat1.png 60 170 3034 Actual Training, Lda Bronze Sponsor http://www.actualtraining.pt http://www.actualtraining.pt/ATLogo.jpg 60 170 2924 DevScope Blog Sponsor http://rquintino.wordpress.com/ http://www.sqlport.com/sql-server/sqlsat/rui_quintino_sqlsat.jpg 40 100 2932 Nikoport Blog Sponsor http://www.nikoport.com http://www.sqlport.com/sql-server/sqlsat/niko_sqlsat_2013.jpg 40 100 2935 Red Gate Software Swag Sponsor http://redg.at/Xpx81I http://www.red-gate.com/assets/images/common/logo.png 40 100 3127 Pluralsight Swag Sponsor http://pluralsight.com/training http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png 40 100 3164 Wintech Media Partner http://www.wintech.pt http://www.sqlsaturday.com/files/4d9b4a6c-ed11-4de2-9c84-4ac7e97b685f.png 40 100 3224 1stidea Media Partner http://www.1stidea.pt http://www.sqlsaturday.com/files/043e7c50-0a06-4244-b54c-3755931ba37d.jpg 40 100 11859 SQLSaturday 188 Track 1 Room 1 3/16/2013 8:30:00 AM 3/16/2013 9:00:00 AM 11859 SQLSaturday 188 Track 2 Room 2 3/16/2013 8:30:00 AM 3/16/2013 9:00:00 AM 11859 SQLSaturday 188 Track 3 Room 3 3/16/2013 8:30:00 AM 3/16/2013 9:00:00 AM 11859 SQLSaturday 188 Track 4 Room 4 3/16/2013 8:30:00 AM 3/16/2013 9:00:00 AM 11859 SQLSaturday 188 Track 5 Room 5 3/16/2013 8:30:00 AM 3/16/2013 9:00:00 AM 11860 SQLSaturday 188 Track 5 Room 5 3/16/2013 6:15:00 PM 3/16/2013 6:45:00 PM 11860 SQLSaturday 188 Track 4 Room 4 3/16/2013 6:15:00 PM 3/16/2013 6:45:00 PM 11860 SQLSaturday 188 Track 3 Room 3 3/16/2013 6:15:00 PM 3/16/2013 6:45:00 PM 11860 SQLSaturday 188 Track 2 Room 2 3/16/2013 6:15:00 PM 3/16/2013 6:45:00 PM 11860 SQLSaturday 188 Track 1 Room 1 3/16/2013 6:15:00 PM 3/16/2013 6:45:00 PM 11903 Leonard Lobel Track 3 Room 3 The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today! 3/16/2013 1:30:00 PM 3/16/2013 2:30:00 PM 11913 Bruno Basto Track 3 Room 3 This session describes how SQL Server internally stores table data. Although you can use SQL without understanding the internals of data storage, a deep knowledge of how data is stored will improve the development of efficient applications. This session explores the basic of metadata that keeps track of data and index storage information. 3/16/2013 4:00:00 PM 3/16/2013 5:00:00 PM 11953 Scott Klein Track 4 Room 4 This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about. 3/16/2013 11:30:00 AM 3/16/2013 12:30:00 PM 11954 Scott Klein Track 4 Room 4 With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits. 3/16/2013 5:15:00 PM 3/16/2013 6:15:00 PM 11959 Allan Mitchell Track 1 Room 1 We are storing more and more data FACT We have less time to move data around our environment FACT Businesses want close to real-time analytics FACT. We therefore need to plan our data movement strategy better. In this session I will show you the improvements to CDC being made in SQL Server 2012 and suggest why this is something you will want to know. 3/16/2013 10:15:00 AM 3/16/2013 11:15:00 AM 11962 Régis Baccaro Track 3 Room 3 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. 3/16/2013 9:00:00 AM 3/16/2013 10:00:00 AM 11976 Oliver Engels Track 1 Room 1 This session shows via live demonstration the use of Integration Services, Data Quality- and Master Data Services to create a closed loop information management solution, which cleans, standardize, merge and purges data all with the new data curation tools of SQL Server 2012. The session will also cover principals and best practises for each of the technology used. 3/16/2013 1:30:00 PM 3/16/2013 2:30:00 PM 11998 Oliver Engels Track 1 Room 1 With the new Data Quality Services (DQS) Microsoft has an offering for Data Quality Management. This session gives you insights how to use DQS efficiently. In demos you will understand best practises in setting up a knowledge base, correct matching rules and how to integrate DQS to your processes as DQS is never an island solution. DQS performance aspects and how to report your quality improvements will round up the session. The session assumes that you have already tested DQS and want to get further with this toolset. 3/16/2013 2:45:00 PM 3/16/2013 3:45:00 PM 12031 Niko Neugebauer Track 2 Room 2 Microsoft is looking to bring a brand new type of database for the OLTP systems – in-memory, codename 'Hekaton'. Promising some of the before unseen speed improvements, the aim is to reach 100 times improvement over existing traditional OLTP performance. One of the most exciting and promising projects of the SQL Server history, Hekaton is a beginning of a new SQL Server era. Dive with me into review of the some of the already available architectural information, we will be looking into the differences with the traditional 8K pages, trying to understand this new 'native' way of functioning for the SQL Server. 3/16/2013 11:30:00 AM 3/16/2013 12:30:00 PM 12035 Milos Radivojevic Track 3 Room 3 Sometimes SQL Server spills sort operation to tempdb although there is no memory pressure. Why and when it happens and why SQL Server raises a 'Sort Warnings' event and what does it mean you can find in this session. We will see how to identify this problem in SQL Server 2008 and more elegant in SQL Server 2012 and of course we can discuss how to prevent this problem. 3/16/2013 5:15:00 PM 3/16/2013 6:15:00 PM 12069 Mark Broadbent Track 2 Room 2 Mark Broadbent is a SQL Server specialist since 1998 and has worked with numerous HA solutions, is the SQLCambs Chapter Leader and held the UKs first ever SQLSaturday in Cambridge. He has presented at numerous events around the globe such as SQLBits 7/ 8/ 9, X, SQLRally Orlando, SQLRally Dallas, SQLRelay, SQLPASS 2011/ 2012 and many international SQLSaturday events and was awarded the Microsoft Community Contributor award in recognition of his contribution towards the SQL Server Community. 3/16/2013 2:45:00 PM 3/16/2013 3:45:00 PM 12137 Hugo Kornelis Track 3 Room 3 User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of SQL Server and still get good performance. 3/16/2013 2:45:00 PM 3/16/2013 3:45:00 PM 12178 Pedro Lopes Track 2 Room 2 This 400-level session is a deep-dive on the various types of memory pressure a SQL Server may experience, how to identify this type of bottleneck, and how the database engine copes with these scenarios. 3/16/2013 4:00:00 PM 3/16/2013 5:00:00 PM 12475 Pedro correia Track 3 Room 3 The aim of this session is to take the audience in a quest for the original (or equivalent) T-SQL, that was in the origin of the different transactions recorded, by inspecting the transaction log records and dissecting its data. In a session that tackles several internals storage issues, needed to fulfill its objective, we will go in a travel that starts by the end of the log and will, hopefully, only end at the birth of the database. 3/16/2013 10:15:00 AM 3/16/2013 11:15:00 AM 12513 Glenn Berry Track 2 Room 2 The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD. 3/16/2013 10:15:00 AM 3/16/2013 11:15:00 AM 12514 Glenn Berry Track 2 Room 2 SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment. 3/16/2013 5:15:00 PM 3/16/2013 6:15:00 PM 12632 Etienne Lopes Track 3 Room 3 This session describes some performance boosters as well as performance killers and some techniques that can lead T-SQL queries, functions and stored procedures to take a few seconds instead of lots of minutes to execute. For instance: - What is best, CTE’s or Temporary Tables? When? - When joining more than two tables (or intermediate result sets), should we still care about the join order? - Did you ever expect to see an Index Seek in your execution plan but what you find is an Index Scan, although you took care of parameter sniffing and your statistics are updated? - Do you care about what isolation level you use? Using real life based demonstrations, this session will provide answers to these and other questions. 3/16/2013 11:30:00 AM 3/16/2013 12:30:00 PM 12638 Mihail Mateev Track 5 Room 5 This talk is about how to deploy a report server project to Windows Azure SQL Reporting report server, and provide initial information for application developers who integrate reports hosted by Windows Azure SQL Reporting in their applications, as well as develop management tools against SQL Reporting report servers. 3/16/2013 1:30:00 PM 3/16/2013 2:30:00 PM 12806 André Kamman Track 2 Room 2 Well, kidding of course. Someone needs to maintain those scripts :-) But there is a lot of repetitive work that can easily be scripted. And powershell is so versatile that it can be used to make scripts that 'think' the way a DBA thinks. It will solve problems or complete a task for you that includes reacting to various (un)expected circumstances. I will show you how to use some cool new features of Powershell 3, like workflows and web access, and I'll use some of my own scripts to demonstrate how this all comes together. 3/16/2013 1:30:00 PM 3/16/2013 2:30:00 PM 12811 Neil Hambly Track 4 Room 4 Extended Events is a replacement for profiler, it will become the premium tool for capturing diagnostic data within SQL Server with its advanced capabilities, however like any new feature it can take time to learn, becoming effective with the tool can be a hurdle to its usage This session is specifically focused to make you effective with the Extended Events feature by demonstrating some common troubleshooting examples 3/16/2013 4:00:00 PM 3/16/2013 5:00:00 PM 12849 Jen Stirrup Track 1 Room 1 As a report creator and designer, it's your role to make the message of the data come alive for data consumers and decision-makers. This requires a balance between conveying the 'truth' of the data across to the target audience, in addition to making the report look interesting that it will draw people's attentions in the first place. SSRS is one of the most widely-used Business Intelligence products within the Microsoft stack. Come to this session to pick up some tips and tricks for advanced reporting writing, that is also in accordance with thinking by Data Visualisation gurus such as Stephen Few and Edward Tufte. This session will cover more advanced and less well-known features of reporting services with Data Viz in mind! 3/16/2013 4:00:00 PM 3/16/2013 5:00:00 PM 12851 Jen Stirrup Track 1 Room 1 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 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, including Azure, SharePoint and SSRS. 3/16/2013 11:30:00 AM 3/16/2013 12:30:00 PM 12892 Constantin Klein Track 4 Room 4 The number of sensors is growing and growing and brings us closer to the 'Internet of things'. Applications, that have to process a big amount of data from event streams are a logical consequence. Some developers might have heard from Reactive Extensions (Rx) already, but Microsoft offers with StreamInsight (SI) another comprehensive platform for these scenarios. In this session you will learn what a great addition for your toolbox StreamInsight is, if you have to develop applications, that have to handle complex events (CEP- Complex Event Processing). See how you can start with this technologie and how easy it is to jump in for .NET developers. 3/16/2013 2:45:00 PM 3/16/2013 3:45:00 PM 12961 Rodrigo Pinto Track 5 Room 5 In this light session, get to know starter pointers for developing in SharePoint Development 3/16/2013 9:00:00 AM 3/16/2013 10:00:00 AM 12981 Enrique Catala Bañuls Track 4 Room 4 In this session we will discuss about the parallelism in SQL Server. We will talk about configuration parameters, parallel execution plans, parallel operators and more. We also will talk about problems and best practices. 3/16/2013 10:15:00 AM 3/16/2013 11:15:00 AM 12984 Eladio Rincón Track 4 Room 4 Transactional Replication exists in SQL Server since 1995; It's an stable solution, reliable and scalable if it's used properly. Obviously is not a solution for everything so you will have to decide wether this technology fits for your needs or not. In this session we will introduce the main concepts about transactional replication and two real cases to show the scale-out benefits of this technology. At the end we will talk about common best practices for transactional replication. 3/16/2013 1:30:00 PM 3/16/2013 2:30:00 PM 12990 João Lopes Track 4 Room 4 In this session we will travel through the basic concepts of BI, address the differences between relational modeling (OLTP) and dimensional (OLAP) and present the Microsoft BI platform from the perspective of those who live in the relational world and aims to explore the potential of BI. This session will be co-presented with Fernando Marçal 3/16/2013 9:00:00 AM 3/16/2013 10:00:00 AM 12995 Quilson Antunes Track 5 Room 5 SQL Server Data Compression 3/16/2013 4:00:00 PM 3/16/2013 5:00:00 PM 12997 Ruben Pertusa Track 1 Room 1 We live in a world of social data. There are tweets, Facebook posts, updates, book reviews or forum discussions written in Social Networks. As an insight, we can find sentiment in all these social texts. This session reviews some text mining and integration techniques for extracting and incorporating these insights from Big Data into our analytical platform. Real life samples and practical demos will be shown using Microsoft technologies. Co-speaker: Javier Torrenteras (SolidQ BI Manager) 3/16/2013 5:15:00 PM 3/16/2013 6:15:00 PM 13001 Rui Quintino Track 1 Room 1 What-if insights from your business data were just a few seconds/clicks away? What-if we could instantly explore our data with rich fully interactive dashboards using the amazing new features of Excel 2013, PowerPivot and PowerView? Without needing to build auxiliary reference tables, complex dax or powerpivot modelling? What-if instead self-service we could be 'instantly-served'? 3/16/2013 9:00:00 AM 3/16/2013 10:00:00 AM 13004 Artur Santos Track 5 Room 5 Scripting an intire Instalation Configuration through Scripts PowerShell 3/16/2013 11:30:00 AM 3/16/2013 12:30:00 PM 13380 Luís Canastreiro Track 2 Room 2 Nesta sessão o objectivo passa por detalhar que ferramentas estão disponíveis para a monitorização de uma solução de AlwaysOn Availability Groups e que tipo de troubleshooting poderá ser empregue tentar resolver alguns problemas que podem surgir durante a implementação e utilização de Availability Groups. 3/16/2013 9:00:00 AM 3/16/2013 10:00:00 AM 13588 Global Community Track 5 Room 5 Lightning Talks 3/16/2013 2:45:00 PM 3/16/2013 3:45:00 PM 14131 Global Community Track 5 Room 5 Come and join other interested people to gain insights via our informative discussion on Networking for Techies – and join in a speed networking session! Attendees will share insights and experience, stimulate new ideas and have an engaging discussion! Topics include: · How to use LinkedIn? · Does ‘speed networking’ work? · How to network at technical events? · Ice-breakers? If you’re interested in learning about how to network better, please join us for this facilitated discussion and find ways in which to move your career to the next stage. 3/16/2013 10:15:00 AM 3/16/2013 11:15:00 AM