Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

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.

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

SQL Saturday 89 Pre-Con

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

BLOG

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

ARTICLE

Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor

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

FORUM

DATABASE PERFORMANCE ISSUE

DATABASE PERFORMANCE ISSUE - SQL SERVER 2000

FORUM

Database Performance

Database Performance

Tags
events    
sql saturday    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones