SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Saturday #188 - Lisbon

By Press Release,

Come to SQL Saturday #188 on March 16, 2013 in Lisbon, Portugal

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Join of for a free day of SQL Server training and networking.


Rua do Fogo de Santelmo, Lote 2.07.02
Microsoft Portugal
Lisbon, Portugal 1990-110

Pre-conference Workshop

There are three paid pre-conference workshops taking place the day before SQL Saturday #188.

Glenn Berry (MVP, SQLSkills) – Scaling SQL Server 2012
Matthew Roche (Microsoft) – Getting the Most from SQL Server 2012 Integration Services
Scott Klein (Microsoft) – Application and database migration to Windows Azure

The price was €100 but this may have gone up. Contact workshops@sqlport.com to sign up and find out more.

Conference Information

Below are some of the speaker tracks available at the Lisbon SQL Saturday.

SQL Azure - What is it and why do you need it

Scott Klein

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.

SQL Server 2012 SSIS Change Data Capture

Allan Mitchell

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.

UDFs, or: How to kill performance in one easy step

Hugo Kornelis

User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus?

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.

Dr. DMV: How to Use Dynamic Management Views

Glenn Berry

SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

Total article views: 224 | Views in the last 30 days: 1
Related Articles

SQL Saturday 89 Pre-Con

Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Serv...


Microsoft Releases Updated White Paper on Troubleshooting SQL Server 2008 Performance

Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for S...


Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite On the Database Scale page we can decide on the performance level that we wa...


Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor

Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to ...




sql saturday