Nr: 115
SQLSaturday #115 - Portugal 2012
SessionID: 13975
Security enhancements in SQL Server 2012 (Denali):
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 4. SQL Azure + Extras
Speaker: Etienne Lopes
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
SessionID: 18488
The Turbo-Booster in SQL 2012: Columnstore Indexes
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 2. DBA
Speaker: Klaus Aschenbrenner
Title: The Turbo-Booster in SQL 2012: Columnstore Indexes
Abstract:
SessionID: 22621
SQL Server vs. SQL Azure - FIGHT!
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 4. SQL Azure + Extras
Speaker: Virgílio Esteves
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.
SessionID: 23575
More Agile Business Intelligence with Microsoft BI
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 3. BI
Speaker: Rui Quintino
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.
SessionID: 28591
Exceed your business with SharePoint Server 2010
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 4. SQL Azure + Extras
Speaker: Alexandre Mendeiros
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
SessionID: 28631
Making Data Fit for Business using DQS
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 3. BI
Speaker: Allan Mitchell
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
SessionID: 29298
SQL Internal Storage
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 2. DBA
Speaker: Bruno Basto
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.
SessionID: 30090
New TSQL features in SQL12 with OVER clause and ..
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 1. Dev
Speaker: Eladio Rincon
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.
SessionID: 30343
Advanced indexing
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 1. Dev
Speaker: Hugo Kornelis
Title: Advanced indexing
Abstract:
SessionID: 30346
All about MERGE
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 1. Dev
Speaker: Hugo Kornelis
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.
SessionID: 30375
T-SQL Enhancements in SQL Server 2012
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 1. Dev
Speaker: Niko Neugebauer
Title: T-SQL Enhancements in SQL Server 2012
Abstract:
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.
SessionID: 30718
Business Intelligence in Azure: SSIS SSRS focus
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 4. SQL Azure + Extras
Speaker: Jen Stirrup
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.
SessionID: 30719
Power View from the Data Visualisation Perspective
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 3. BI
Speaker: Jen Stirrup
Title: Power View from the Data Visualisation Perspective
Abstract:
- 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.
SessionID: 30889
Mission-Critical Solutions Using AlwaysOn
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 2. DBA
Speaker: João Loureiro
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.
SessionID: 31524
SQL Server 2012 Extended Events
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 2. DBA
Speaker: Luís Canastreiro
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
SessionID: 31571
Enter the Dragon: SQL 2012 on Server Core
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 2. DBA
Speaker: Mark Broadbent
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
SessionID: 31912
Parameter Sniffing Problem with Stored Procedures
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 1. Dev
Speaker: Miloš Radivojević
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.
SessionID: 32055
Effective Data Management using Data Compression
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 2. DBA
Speaker: Neil Hambly
Title: Effective Data Management using Data Compression
Abstract:
I present this session @ Red Gate SQL-in-the-City Conference (London - July 2011) will also be presenting this @ SQLSaturday #105 Dublin event
SessionID: 32195
SQL Server 2012 SHOWPLAN - What's new?
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 1. Dev
Speaker: Pedro Lopes
Title: SQL Server 2012 SHOWPLAN - What's new?
Abstract:
SessionID: 32319
First look to SSIS 2012
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 3. BI
Speaker: Pedro Perfeito
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.
SessionID: 9197
Hidden gems in BISM Tabular models for Power View
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 3. BI
Speaker: Alejandro Leguizamo
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.
SessionID: 9199
The H Hour:Hadoop, the awakening of the BigData I
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 4. SQL Azure + Extras
Speaker: Alejandro Leguizamo
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!
SessionID: 9400
SSAS 2012: Tabular and Multidimensional
Event Date: 17-03-2012 - Session time: 00:00:00 - Track: 3. BI
Speaker: Andro Moreira
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.