Event Location:
Universidade Autónoma de Lisboa
Rua de Santa Marta, nº 56
Lisbon, , Portugal
Abstract:
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.
Speaker(s): Jen Stirrup,
Abstract:
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.
Speaker(s): Eladio Rincon,
Abstract:
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
Speaker(s): Mark Broadbent,
Abstract:
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.
Speaker(s): Klaus Aschenbrenner,
Abstract:
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.
Speaker(s): Miloš Radivojević,
Abstract:
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
Speaker(s): Etienne Lopes,
Abstract:
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
Speaker(s): Luís Canastreiro,
Abstract:
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.
Speaker(s): Rui Quintino,
Abstract:
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
Speaker(s): Neil Hambly,
Abstract:
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
Speaker(s): Allan Mitchell,
Abstract:
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.
Speaker(s): Jen Stirrup,
Abstract:
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.
Speaker(s): Pedro Lopes,
Abstract:
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.
Speaker(s): Hugo Kornelis,
Abstract:
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!
Speaker(s): Alejandro Leguizamo,
Abstract:
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.
Speaker(s): Pedro Perfeito,
Abstract:
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.
Speaker(s): Bruno Basto,
Abstract:
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.
Speaker(s): Niko Neugebauer,
Abstract:
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.
Speaker(s): Hugo Kornelis,
Abstract:
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.
Speaker(s): Virgílio Esteves,
Abstract:
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.
Speaker(s): João Loureiro,
Abstract:
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
Speaker(s): Alexandre Mendeiros,
Abstract:
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.
Speaker(s): Alejandro Leguizamo,
Abstract:
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.
Speaker(s): Andro Moreira,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://uk.linkedin.com/in/neilhambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
LinkedIn: https://pt.linkedin.com/in/rquintino
Contact: http://rquintino.wordpress.com
Senior Architect amp; Data Fellow at DevScope. Rui works with Microsoft data related technologies since 1998 and currently leads Data Research amp; Advanced Analytics team at DevScope. Beyond data techonologies, Rui also has strong background in web, mobile amp; security and he likes to mix all of these to get the most out of Microsoft#39;s Data Platform and make the world a better place through the use of data. Despite his assumed introversion he loves to learn amp; share his findings with developers, data lovers and microsoft platform communities on local amp; online events.
Contact: http://www.culto-de-bi.pt
Pedro was born in 1977 in Portugal and currently works as BI Senior Consultant and Invited Lecture in several BI master degrees. He’s also founder and owner of a BI company named “Culto de BI”. He received in 2010, 2011 and 2012 the Microsoft MVP award for all the dedication and contribution helping theoretical and practical issues in the various BI communities. He#39;s also co-author and editor of several books from Packtpub and Syncfusion
Contact: http://blogs.msdn.com/blogdoezequiel
I’m actually a Senior SQL PFE working in the EMEA region, based in Lisbon (Portugal). I’m working with TIER 1 customers doing SQLRaaS and Performance/Design reviews. Nowadays, I’m the Local SQL PFE Tech lead in terms of the Portuguese SQL PFE team. So, I have the responsibility to manage the list of activities and trainings that must be developed and delivered by the local PFEs here in Portugal and I’m also starting to develop some IP related with SQL for the PFE community.
LinkedIn: https://uk.linkedin.com/in/retracement
Contact: http://tenbulls.co.uk
Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Contact: https://onlysearch.wordpress.com/
Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Joined Microsoft in January of 2011 as a PFE for Customer support
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Contact: https://sqland.wordpress.com
Etienne Lopes currently works as a SQL Server DBA at Celfinet. Working with SQL Server since 1997, member of sqlport community (www.sqlport.com), regular speaker since 2012 at SQL Server events such as: SQLSaturday and 24 Hours of Pass. Blog: http://sqland.wordpress.com/
Contact: http://www.solidq.com
Alejandro has been working with SQL Server since 6.5, and with MS Access since Office 97. His core area is Datawarehousing and Business Intelligence, plus ETL. He Has been invited to participate as speaker, trainer , consultant and/or expert to Colombia, USA, Puerto Rico, Perú, Ecuador, Spain, Venezuela, Denmark, Chile, Argentina, Sri Lanka and others, in events like Launch of SQL Server, Developer Days, TechEd and PASS. Alejandro is also awarded with the Microsoft MVP since 2004
Contact: http://blogs.msdn.com/b/joaol/
Working at Microsoft since 2006 as SQL Server Support Escalation Engineer. Engaged on TAP programs for SQL Server beta programs. Providing SQL Server Third tier support and working in close relationship with SQL Server Product Group. Involved on SQL Server KB articles, hotfixes and Service Pack developments.
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Contact: http://pontonetpt.org/blogs/raposo
Virgílio Esteves is a consultant who loves cloud computing and everything else it empowers, having been awarded the Windows Azure MVP title by Microsoft. Speaker in some Microsoft Portugal events, he's also a regular speaker at some user groups meetings (NetPonto, AzurePT, SQLPort) and founder of Coimbra branch of NetPonto User Group.
Contact: http://www.bi4all.pt
Andro Moreira é licenciado em Informática e Gestão de Empresas pelo ISCTE, foi Gestor de Tecnologia Microsoft na Novabase Suporte à Decisão, tendo assumido posteriormente funções idênticas na Sinfic SA. Em 2004 fundou a BI4ALL Consultores de Gestão Lda, Empresa de Consultoria de Gestão focalizada nas áreas de Enterprise Planning, Performance Management, Risk Management e Business Intelligence, da qual é Partner e responsável pela área de serviços de Consultoria.
Bruno Basto, senior consultant #160;and senior trainer #160;at Rumos. SQL certified since 6.5 version (1998). Work with MSFT tools and infrastructure since 1992 in the financial, banking and insurance areas. Responsible for several training projects for software solutions with MSFT infrastructure. Speaker at several MSFT and SQLPass events.
LinkedIn: http://pt.linkedin.com/in/pedroazevedolopes/
Contact: http://aka.ms/sqlserverteam
Pedro Lopes is a Principal Program Manager in the Microsoft Azure SQL Server team, based in Redmond, WA, USA. He is currently responsible for Program Management of database engine features for SQL Server and Azure SQL, with special focus on the Relational Engine (Query Processor, Programmability, Performance). Regular speaker at conferences and user groups events, blogs about all things SQL at http://aka.ms/sqlserverteam, authored the book “Learn T-SQL Querying” (https://aka.ms/LearnTSQLQuerying), and tools in the TigerToolbox on GitHub: AdaptiveIndexDefrag (http://aka.ms/AID), BPCheck for SQL Best Practices and Performance checks (http://aka.ms/BPCheck), or usp_WhatsUp to get an instant view of perf issues (https://aka.ms/uspwhatsup).
LinkedIn: http://pt.linkedin.com/in/webcaravela/
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
LinkedIn: http://at.linkedin.com/pub/milos-radivojevic/1b/7bb/290/de
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer's Guide, SQL Server 2017 Developer's Guide and Mastering SQL Server 2017.
Contact: http://www.solidq.com/blogs
Eladio es MVP en SQL Server desde el a#241;o 2002; es director de bases de datos relacionales de SolidQ en Espa#241;a donde dirige proyectos para clientes de SolidQ en todo el mundo. Ponente habitual en conferencias Microsoft MSDN/TechNet, SQLPASS o grupos de usuarios; participa con sus compa#241;eros en los blogs tecnol#243;gicos de su empresa http://blogs.solidq.com/bigdata-hadoop , http://blogs.solidq.com/elrincondeldba y http://blogs.solidq.com/bigdata-hadoop
Contact: http://www.solidq.com
Alejandro has been working with SQL Server since 6.5, and with MS Access since Office 97. His core area is Datawarehousing and Business Intelligence, plus ETL. He Has been invited to participate as speaker, trainer , consultant and/or expert to Colombia, USA, Puerto Rico, Perú, Ecuador, Spain, Venezuela, Denmark, Chile, Argentina, Sri Lanka and others, in events like Launch of SQL Server, Developer Days, TechEd and PASS. Alejandro is also awarded with the Microsoft MVP since 2004
The following is a list of sponsors that helped fund the event.
Universidade Autónoma de Lisboa
SQLServer 2012 SharePoint Connections