SQLSaturday #115 - Portugal 2012
Event Date: 03/17/2012 00:00:00
Event Location:
- Universidade Autónoma de Lisboa
- Rua de Santa Marta, nº 56
- Lisbon, Portugal
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Power View from the Data Visualisation Perspective
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
Track and Room: 3. BI - N/A
Title: New TSQL features in SQL12 with OVER clause and ..
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
Track and Room: 1. Dev - N/A
Title: Enter the Dragon: SQL 2012 on Server Core
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
Track and Room: 2. DBA - N/A
Title: The Turbo-Booster in SQL 2012: Columnstore Indexes
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
Track and Room: 2. DBA - N/A
Title: Parameter Sniffing Problem with Stored Procedures
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ć
Track and Room: 1. Dev - N/A
Title: Security enhancements in SQL Server 2012 (Denali):
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
Track and Room: 4. SQL Azure + Extras - N/A
Title: SQL Server 2012 Extended Events
Abstract: The three main topics of this session are:
- Perform a brief introduction what Extended Events are and the basic concepts/objects behind this feature.
- Talk about the what’s new in SQL Server 2012 and show the new UI and how to use it
- Present some tipical scenarios where Xevents can help on the troubleshooting of different kind of issues
Speaker(s):
- Luís Canastreiro
Track and Room: 2. DBA - N/A
Title: More Agile Business Intelligence with Microsoft BI
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
Track and Room: 3. BI - N/A
Title: Effective Data Management using Data Compression
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
Track and Room: 2. DBA - N/A
Title: Making Data Fit for Business using DQS
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
- Misspelled names
- Misspelled addresses – addresses which do not exist, e-mail addresses
- 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
Track and Room: 3. BI - N/A
Title: Business Intelligence in Azure: SSIS SSRS focus
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
Track and Room: 4. SQL Azure + Extras - N/A
Title: SQL Server 2012 SHOWPLAN - What’s new?
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
Track and Room: 1. Dev - N/A
Title: Advanced indexing
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
Track and Room: 1. Dev - N/A
Title: The H Hour:Hadoop, the awakening of the BigData I
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
Track and Room: 4. SQL Azure + Extras - N/A
Title: First look to SSIS 2012
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
Track and Room: 3. BI - N/A
Title: SQL Internal Storage
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
Track and Room: 2. DBA - N/A
Title: T-SQL Enhancements in SQL Server 2012
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
Track and Room: 1. Dev - N/A
Title: All about MERGE
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
Track and Room: 1. Dev - N/A
Title: SQL Server vs. SQL Azure - FIGHT!
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
Track and Room: 4. SQL Azure + Extras - N/A
Title: Mission-Critical Solutions Using AlwaysOn
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
Track and Room: 2. DBA - N/A
Title: Exceed your business with SharePoint Server 2010
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
Track and Room: 4. SQL Azure + Extras - N/A
Title: Hidden gems in BISM Tabular models for Power View
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
Track and Room: 3. BI - N/A
Title: SSAS 2012: Tabular and Multidimensional
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
Track and Room: 3. BI - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
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.
Rui Quintino
Twitter: - rquintino
LinkedIn: Rui Quintino
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.
Pedro Perfeito
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
Luís Canastreiro
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.
Mark Broadbent
Twitter: - retracement
LinkedIn: Mark Broadbent
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.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
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).
Allan Mitchell
Twitter: - @allanSQLIS
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.
Jen Stirrup
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.
Alexandre Mendeiros
Joined Microsoft in January of 2011 as a PFE for Customer support
Hugo Kornelis
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.
Etienne Lopes
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/
Alejandro Leguizamo
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
João Loureiro
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.
Hugo Kornelis
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.
Jen Stirrup
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.
Virgílio Esteves
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.
Andro Moreira
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
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.
Pedro Lopes
Twitter: - SQLPedro
LinkedIn: Pedro Lopes
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).
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
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.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
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.
Eladio Rincon
Twitter: - @erincon
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
Alejandro Leguizamo
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
Sponsors
The following is a list of sponsors that helped fund the event: