SQL Saturday Event #43 – June 12th Redmond, WA
I can’t believe that SQL Saturday 43 (#sqlsat43) Redmond, WA is only a couple of days away. I am looking forward to learning new things, meeting new people, and just absorbing SQL.
As of today these are the sessions that I am planning on attending.
I chose Scott’s session because I have just started using SSIS and want to learn more about it.
Scott Stauffer @SQLSocialite “SSIS for the faint of heart”
Scott’s gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use the tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server’s DTS functionality. ETL? It’s okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your “Extract, Transform, and Load” processes.
I haven’t made up my mind on which one that I want to attend. They both look interesting. It will be a game time decision.
Dean Richards “Tuna Helper for DBAs and Developers”
Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process I use with great success and it will include topics such as: SQL diagramming, wait type data, column selectivity, and others that will help you succeed on future tuning projects.
Donabel Santos @sqlbelle “SQL 2008 Reporting from the Ground up”
In this session we will explore the rich reporting features introduced in SQL Server 2008 and 2008 R2 Reporting Services, including Report Builder 3.0. We will walk through how to create basic reports, add parameters, enhance layout, and integrate new visualization components including sparklines, data bars, gauges and maps.
LUNCH “I will definitely attend”
The 12:30pm session was also a tough choice. I am interested in Donabel’s PowerShell session, but I can’t miss out on seeing Kalen Delaney, the Queen of SQL Server.
Kalen Delaney “The Compression Session”
SQL Server 2008 allows you to compress your data in several different ways. Your tables can be compressed using row compression or page compression, and you can also choose to compress your backups. In this session we’ll look at what kinds of data give you the most space savings when compressed, and we’ll also discuss the algorithms SQL Server uses to compress your data. Knowing how SQL Server performs compression will allow us to evaluate when the space savings will be worth the cost, and when you might want to avoid compression.
The 2 pm was also tough choice, because there are really 3 sessions that I would love to attend. Robert Davis’s @SQLSoldier “Profiler” and Todd McDermid’s @Todd_McDermid “Data warehouse” session. I chose Clifford Dibble’s “UCP” just because I wanted to learn more about this feature.
Clifford Dibble “Utility Control Point in SQL 2008 R2”
Learn how the Utility Control Point (UCP) in SQL 2008 R2 can help you with your capacity management and consolidation projects. In this talk, you will learn the key concepts around the UCP and see a demo. This is also your chance to give us feedback about how you want the UCP to evolve in the 11.0 release of SQL Server.
There is no doubt about this session. Seeing Buck Woody is worth the price of admission, oh it’s free. Well he is still worth every penny. I have had the pleasure to see and hear Buck present multiple times at multiple SQL Saturday events, PASS 2009, and other misc. webcasts and podcasts. He is a great presenter, very entertaining, and knowledgeable. Even though the topic mentions the “O” word I know that I will take away something from his session, if not, it will at least be very entertaining.
Buck Woody @BuckWoody “SQL Server for the Oracle DBA”
Come hear Buck Woody, Microsoft’s “Real World DBA” give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary – we’ll cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you’re an Oracle professional and you want to add SQL Server to your “knowledge arsenal”, come hear this overview. You’ll also get a list of resources that will enable you to research further.
The event is getting bigger and better each time. Last I heard there were over 400 signed up with more than 40 on the waiting list. Awesome!
Hope to see you there.