SQLSaturday #115 - Portugal 2012 3/17/2012 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. #sqlsat115 Universidade Autónoma de Lisboa Rua de Santa Marta, nº 56 Lisbon , Portugal 1169-023 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 1670 Microsoft Portugal Gold Sponsor http://www.microsoft.pt http://www.microsoft.com/presspass/images/gallery/logos/web/mslogo-1.jpg 60 170 1717 Universidade Autónoma de Lisboa Gold Sponsor http://www.ual.pt http://www.sqlsaturday.com/files/53729293-16a3-42de-8af8-e252ea95702d.jpg 60 170 1727 Actual Training Gold Sponsor http://www.actualtraining.pt/ http://www.sqlport.com/sql-server/sqlsat/actualtraining-logo.jpg 60 170 1882 Bi4all Consultores de Gestão Lda Silver Sponsor http://www.bi4all.pt http://www.sqlport.com/sql-server/sqlsat/bi4all.png 60 170 1923 Rumos Silver Sponsor http://www.rumos.pt/ http://www.sqlport.com/sql-server/sites/default/files/Rumos.jpg 60 170 1952 Idera Silver Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2076 SQLServer 2012 SharePoint Connections Silver Sponsor http://www.nccomms-events.com/sql-sp-connections http://www.sqlport.com/sql-server/sqlsat/sqlconnections_2.jpg 60 170 1921 Wrox Swag Sponsor http://www.wrox.com http://www.sqlport.com/sql-server/sqlsat/wrox.gif 40 100 1982 Sapien Swag Sponsor http://www.sapien.com http://www.sqlport.com/sql-server/sqlsat/sapien_logo.jpg 40 100 1983 O'Reily Swag Sponsor http://oreilly.com/ http://www.sqlport.com/sql-server/sqlsat/oreily_logo.JPG 40 100 2043 Pluralsight Swag Sponsor http://www.pluralsight.com http://www.pluralsight-training.net/microsoft/content/img/logo/pluralsight-fullcolor-175x39-v1.png 40 100 2070 FCA Swag Sponsor http://www.fca.pt http://www.sqlport.com/sql-server/sqlsat/fca.jpg 40 100 2078 Morgan Kaufman Swag Sponsor http://mkp.com/ http://sqlport.com/sql-server/sites/default/files/MK_logo.gif 40 100 1700 StrateSQL Blog Sponsor http://www.jasonstrate.com/ http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 1885 WinTech Blog Sponsor http://www.wintech.com.pt/ http://www.sqlport.com/sql-server/sqlsat/wintech_100_40.jpg 40 100 6347 Milos Radivojevic 1. Dev Room 1 In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario. 3/17/2012 2:15:00 PM 3/17/2012 3:15:00 PM 6619 Jen Stirrup 4. SQL Azure + Extras Room 4 What does Azure offer to Business Intelligence developers, and to those who use Business Intelligence every day? Come to this session to see how you can transfer your skills in SSIS and SSRS to add Azure to your existing Business Intelligence skill set. We will look at: - the differences in developing SSIS packages that use Azure as a source and as a target. - developing SSRS reports deployed to Azure. - mobile devices and Azure such as tablets Come and see the similarities and differences in using Azure SQL Business Intelligence, and learn to avoid some of the 'gotcha!' pitfalls. 3/17/2012 12:00:00 PM 3/17/2012 1:00:00 PM 6620 Jen Stirrup 3. BI Room 3 Power View is Microsoft's Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will: - investigate Power View based on current cognitive research around Data Visualisation principles - look at the features of Power View - look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View. 3/17/2012 4:00:00 PM 3/17/2012 5:00:00 PM 6621 Allan Mitchell 3. BI Room 3 There are lots of DQ issues we are going to talk about some of the common issues and later see how we can handle them. Issues such as 1. Misspelled names 2. Misspelled addresses – addresses which do not exist, e-mail addresses 3. Duplication Pretty much everyone suffers from these problems so come to this session to learn a new way to deal with them in SQL Server 2012 Data Quality Services 3/17/2012 12:00:00 PM 3/17/2012 1:00:00 PM 6698 eladio rincon 1. Dev Room 1 The complete title is: Open your mind to new Transact-SQL features in SQL Server 2012: OVER clause and Running and Sliding Aggregates The session will have two speakers (Eladio and Enrique Catalá (ecatala@solidq.com) SQL Server 2012 is closer than ever to fully implement the ANSI Windowing functions. In this session we will get deeply into the OVER clause; you will understand how to use the OVER clause in SQL Server 2008, and what are the improvements in SQL Server 2012. The session will cover practical examples with running and sliding aggregates, running totals, and the new analytical functions; The attendee will learn by practical examples how to dramatically improve the performance in his/her Transact-SQL queries. 3/17/2012 4:00:00 PM 3/17/2012 5:00:00 PM 6702 Niko Neugebauer 1. Dev Room 1 SQL Server is an amazing tool, which has all imaginable components for Creating, Editing, Moving, Analizing and Reporting data. The most important and the most commonly used of them all is the T-SQL, the Transact-SQL implementation by Microsoft. This session will focus on some of the new programability features that will be available in SQL Server 2012, that will make lifes of the developers much easier, like SEQUENCE object, OFFSET functionality, new conversion functions (TRY_CONVERT), new logical and conversion functions like IIF and CONCAT. 3/17/2012 9:30:00 AM 3/17/2012 10:30:00 AM 6711 Alexandre Mendeiros 4. SQL Azure + Extras Room 4 Want to know what's new in SQL Server 2010 BI stack?Come and see what cool features you can take advantage of SQL Server with SharePoint Server 2010 3/17/2012 5:15:00 PM 3/17/2012 6:15:00 PM 6713 Pedro Lopes 1. Dev Room 1 This demo driven session will show some of the most outstanding from SQL 2008R2 to 2012 in terms of differences in information output by SHOWPLAN, which may prove helpfull when you are troubleshooting or performing query tuning. 3/17/2012 12:00:00 PM 3/17/2012 1:00:00 PM 6728 Pedro Perfeito 3. BI Room 3 In this session will be shown a first look to the new SSIS 2012 version. This new version has lot of enhancements and new features. New environment, new tasks, new approaches to deal with packages, and several other stuff that I evaluated during last months of writing a SSIS book for the Packtpub publisher. 3/17/2012 9:30:00 AM 3/17/2012 10:30:00 AM 6746 Luís Canastreiro 2. DBA Room 2 The three main topics of this session are: 1. Perform a brief introduction what Extended Events are and the basic concepts/objects behind this feature. 2. Talk about the what's new in SQL Server 2012 and show the new UI and how to use it 3. Present some tipical scenarios where Xevents can help on the troubleshooting of different kind of issues 3/17/2012 10:45:00 AM 3/17/2012 11:45:00 AM 6754 Neil Hambly 2. DBA Room 2 This session will explain the basic principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads. We will look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements. I present this session @ Red Gate SQL-in-the-City Conference (London - July 2011) will also be presenting this @ SQLSaturday #105 Dublin event 3/17/2012 12:00:00 PM 3/17/2012 1:00:00 PM 6863 Bruno Basto 2. DBA Room 2 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/17/2012 4:00:00 PM 3/17/2012 5:00:00 PM 7020 João Loureiro 2. DBA Room 2 The session provides an overview of AlwaysOn and introduces the key new features and capabilities that will help businesses achieve the high availability SLA for mission critical applications. 3/17/2012 9:30:00 AM 3/17/2012 10:30:00 AM 7026 Hugo Kornelis 1. Dev Room 1 So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!I will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries, But I will also show the dangers of using too many indexes, and the tools SQL Server itself hands you to help identify just the right subset of indexes. 3/17/2012 5:15:00 PM 3/17/2012 6:15:00 PM 7029 Hugo Kornelis 1. Dev Room 1 The MERGE statement was introduced in SQL Server 2008, and it offers a tremendous value. Most people do know the basic function of MERGE: synchronising imported data with base data by inserting new rows and updating existing rows, all in one go. But MERGE can do much, much more. In this demo-rich session, Hugo Kornelis will present the full syntax of the MERGE statement, explain all the options, and show the possibilities. He will also demonstrate that the introduction of MERGE might have made your existing triggers incorrect, and how to fix the problems. 3/17/2012 10:45:00 AM 3/17/2012 11:45:00 AM 7076 Mark Broadbent 2. DBA Room 2 In 1982 the Dragon 32 entered the home computer market but unfortunately there was one small problem ...lower-case letters were almost impossible to access. Two years later, Dragon was no more. In 2008 MS released Server Core providing a fast streamlined edition of Windows with minimal GUI support. As of SQL 2012, installation to W2008R2 Core is now a supported option and means the biggest administrative change to a DBA since the release of SQL 2005 ...or will it? We will demonstrate OS configuration through Cmd line utils and PowerShell, SQL installation, Remote Admin and Clustering on Core. Will the lack of GUI support send Server Core in the same direction as the Dragon 32 or spell a bright new future for SQL Windows Server computin 3/17/2012 2:15:00 PM 3/17/2012 3:15:00 PM 7314 Rui Quintino 3. BI Room 3 This session will focus on more agile patterns techniques applied to the usual Microsoft BI stack. Main topics will be: rapid feedback cycles, test automation, flexible integration processes, analysis services flexible models and some others. 3/17/2012 10:45:00 AM 3/17/2012 11:45:00 AM 7424 Etienne Lopes 4. SQL Azure + Extras Room 4 There are several enhancements regarding security and auditing in SQL Server 2012. This session will cover some of them in the following (new) topics: - Default Schema for groups; - User-defined Server Roles; - Contained Databases: - Authentication without Logins; - SQL Users with passwords. anf if time permits: - Sql server audit enhancements: T-SQL Stack Information; User-defined audit event 3/17/2012 9:30:00 AM 3/17/2012 10:30:00 AM 7440 Alejandro Leguizamo 3. BI Room 3 You have seen Power View, and you have seen the new SSAS BISM Tabular models in SQL Server 2012. But are you really a master of the unknown? Come to this session, and join the ranks of those who leave the darkness, and uncover the integration between Power View and BISM Models. Weapons, demos, and techniques will enlighten your way. 3/17/2012 5:15:00 PM 3/17/2012 6:15:00 PM 7442 Alejandro Leguizamo 4. SQL Azure + Extras Room 4 News of increasingly Bigger and Bigger data are coming from different countries and cities around the world. Lisbon is not an exception. Our biggest fears have come true. Big Data is here to stay. We are calling for a secret meeting to everyone: DBAs, Network admins, developers, EVERYONE! . We need you in this war!. Join us in a session that will describe the strategy , the tactics and the plans to deal with this threat to the very existence of your servers: Operation HADOOP! 3/17/2012 10:45:00 AM 3/17/2012 11:45:00 AM 7488 Klaus Aschenbrenner 2. DBA Room 2 Do you want to improve your DWH query performance by 100 times by just adding one additional index? Not possible? Wrong! SQL Server 2012 provides you the new Columnstore Index which changes the paradigm for DWH queries completely. In this session we will look at the details of the new Columnstore Index, when it makes sense, when not, and what are the current restrictions of it. We will look into Row Store vs. Column Store, how to change data in tables that have a Columnstore Index defined, we talk about Segment Elimination, Batch Mode Execution, about Query Memory Grants, and finally about how you can make sure that SQL Server will use your Columnstore Index as effective as possible. 3/17/2012 5:15:00 PM 3/17/2012 6:15:00 PM 7504 Virgílio Esteves 4. SQL Azure + Extras Room 4 SQL Server is the guy being around for quite some time and SQL Azure is the new kid on the block. What would a fight between the two look like? What would each of them bring to the arena? In this session will get a look at the resources that SQL Server, as well as SQL Azure, would get to the fight arena and also see how a team-up between them would leverage a set of scenarios. 3/17/2012 4:00:00 PM 3/17/2012 5:00:00 PM 7736 Portuguese Community 4. SQL Azure + Extras Room 4 Welcome Registration 3/17/2012 8:30:00 AM 3/17/2012 9:00:00 AM 7736 Portuguese Community 3. BI Room 3 Welcome Registration 3/17/2012 8:30:00 AM 3/17/2012 9:00:00 AM 7736 Portuguese Community 2. DBA Room 2 Welcome Registration 3/17/2012 8:30:00 AM 3/17/2012 9:00:00 AM 7736 Portuguese Community 1. Dev Room 1 Welcome Registration 3/17/2012 8:30:00 AM 3/17/2012 9:00:00 AM 7737 Portuguese Community 1. Dev Room 1 KeyNote the technical launch of SQL Server 2012 3/17/2012 9:00:00 AM 3/17/2012 9:25:00 AM 7741 Universidade Autónoma 2. DBA Room 2 A Universidade para uma carreira de sucesso 3/17/2012 3:25:00 PM 3/17/2012 3:55:00 PM 7742 Actual Training 3. BI Room 3 A Actual Training partilhará o porquê do seu lema e a importância da formação de qualidade na área das tecnologias de informação. Os participantes presentes nesta sessão, candidatam-se automaticamente ao sorteio de um voucher para um curso de 5 dias em formação Oficial Microsoft SQL Server 2012, num valor aproximado de 1400€ e a anunciar na sessão de fecho. 3/17/2012 3:25:00 PM 3/17/2012 3:55:00 PM 7744 Portuguese Community 1. Dev Room 1 Women in Technology Mini-session, with following speakers: Jen Stirrup, Bárbara Chambel, Rosa Matias Filipa Matos 3/17/2012 3:25:00 PM 3/17/2012 3:55:00 PM 7745 Global Community 4. SQL Azure + Extras Room 4 Lightning Talk presentations 3/17/2012 2:15:00 PM 3/17/2012 3:15:00 PM 7883 Andro Moreira 3. BI Room 3 In this session we will travel through the two SQL Server 2012 Analysis Services modes: Tabular and Multidimensional. We will focus on the advantages and business scenarios of the new Tabular mode and we will discuss real-life situations in which we should apply tabular or dimensional approaches, focusing on the main differences and features in each mode.This session will be co-presented with Andre Santana. 3/17/2012 2:15:00 PM 3/17/2012 3:15:00 PM