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.
Location
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.
