Nr: 188
SQLSaturday #188 - Portugal 2013
SessionID: 10992
SQL Internal Storage – P1
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Bruno Basto
Title: SQL Internal Storage – P1
Abstract:
SessionID: 11792
StreamInsight: Complex Event Processing by MS
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Constantin Klein
Title: StreamInsight: Complex Event Processing by MS
Abstract:
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.
SessionID: 11826
CAST([Transaction Log] as T.SQL)
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Pedro Correia
Title: CAST([Transaction Log] as T.SQL)
Abstract:
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.
SessionID: 13644
Parallelism in SQL Server
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Enrique Catala
Title: Parallelism in SQL Server
Abstract:
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.
SessionID: 13952
Scale-out scenarios with Transactional Replication
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Eladio Rincon
Title: Scale-out scenarios with Transactional Replication
Abstract:
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.
SessionID: 13973
Optimizing implementation techniques
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Etienne Lopes
Title: Optimizing implementation techniques
Abstract:
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.
SessionID: 14677
Hardware 201: Selecting Database Hardware
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Glenn Berry
Title: Hardware 201: Selecting Database Hardware
Abstract:
SessionID: 14678
Dr. DMV: How to Use Dynamic Management Views
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Glenn Berry
Title: Dr. DMV: How to Use Dynamic Management Views
Abstract:
SessionID: 15055
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Hugo Kornelis
Abstract:
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.
SessionID: 15391
Project Hekaton
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Niko Neugebauer
Title: Project Hekaton
Abstract:
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.
SessionID: 16565
Advanced Data Visualisation with Reporting Service
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jen Stirrup
Title: Advanced Data Visualisation with Reporting Service
Abstract:
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!
SessionID: 16567
Mobile Business Intelligence - Apprentice Style!
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jen Stirrup
Title: Mobile Business Intelligence - Apprentice Style!
Abstract:
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.
SessionID: 17076
Travel from Relational to BI
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: João Lopes
Title: Travel from Relational to BI
Abstract:
SessionID: 19026
Geospatial Data Types in SQL Server 2012
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Leonard Lobel
Title: Geospatial Data Types in SQL Server 2012
Abstract:
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!
SessionID: 19296
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Luis Canastreiro
Abstract:
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.
SessionID: 19549
READPAST Furious:Transactions,Locking,Isolation
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark Broadbent
Title: READPAST Furious:Transactions,Locking,Isolation
Abstract:
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.
SessionID: 20263
Windows Azure SQL Reporting for App developers
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Mihail Mateev
Title: Windows Azure SQL Reporting for App developers
Abstract:
SessionID: 20746
Identifying and Solving Sort Warning Problems
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Miloš Radivojević
Title: Identifying and Solving Sort Warning Problems
Abstract:
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.
SessionID: 21335
Extended Events – Effective Usage
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Neil Hambly
Title: Extended Events – Effective Usage
Abstract:
This session is specifically focused to make you effective with the Extended Events feature by demonstrating some common troubleshooting examples
SessionID: 21528
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Oliver Engels
Abstract:
SessionID: 21531
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Oliver Engels
Abstract:
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.
SessionID: 21914
Understanting Memory Pressure
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Pedro Lopes
Title: Understanting Memory Pressure
Abstract:
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.
SessionID: 22412
SQL Server Data Compression
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Quilson Antunes
Title: SQL Server Data Compression
Abstract:
SQL Server Data Compression
SessionID: 22811
Database development with SSDT
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Regis Baccaro
Title: Database development with SSDT
Abstract:
SessionID: 23488
Sentiment analysis using SSAS 2012
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Ruben Pertusa Lopez
Title: Sentiment analysis using SSAS 2012
Abstract:
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)
SessionID: 23573
"Faster than the speed of light"... with #MSBI
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Rui Quintino
Title: "Faster than the speed of light"... with #MSBI
Abstract:
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"?
SessionID: 24153
SQL Azure - What is it and why do you need it
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Scott Klein
Title: SQL Azure - What is it and why do you need it
Abstract:
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.
SessionID: 24154
SQL Azure Scalability with Federations
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Scott Klein
Title: SQL Azure Scalability with Federations
Abstract:
SessionID: 34574
How to outsource yourself with a Powershell script
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: André Kamman
Title: How to outsource yourself with a Powershell script
Abstract:
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.
SessionID: 9303
SQL Server 2012 SSIS Change Data Capture
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Allan Mitchell
Title: SQL Server 2012 SSIS Change Data Capture
Abstract:
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.
SessionID: 9873
Scripting SQL 2012 SharePoint 2013 Installation
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Artur Santos
Title: Scripting SQL 2012 SharePoint 2013 Installation
Abstract:
Scripting an intire Instalation Configuration through Scripts PowerShell