Vote for Pass Summit 2011 Sessions

** ONLY OPEN TILL MAY 20th, 2011 !!!

This year PASS is asking for your input in helping them select the sessions that will be added to the roster this year. The program committee will use YOUR input to help them decide which sessions get in and which ones don’t. This sounds like an excellent opening up of the process by PASS and really should be applauded.

So for those of you that want your input heard please go and vote. I have submitted this year four different sessions so if you think they would be interesting….Hmmm, when have my presentations never been interesting??? … then please feel free to vote for them 🙂

PASS Summit Session Voting

Cheers!
AJ

Everything Your Developer Won’t Tell You About SQL Azure [200]
Session Category: Regular Session (75 minutes)
Session Track: SQL Azure
Speaker(s): Arie Jones
Cloud computing is being hailed by some as the future silver bullet to everyone’s data availability woes and as such SQL Azure is Microsoft’s cloud based data platform. However, the platform is much different from simply a SQL Server that sits in the cloud and needs to be approached in an intelligent manner. In this fast paced session, we will be going well beyond the simple “hello world” scenario to show you how to leverage the cloud architecture for data storage as well as educate you in how the cloud works differently than your local database instance. We’ll give you all of the powers and perils that exist in the architecture to ensure that your first flight into the cloud is a successful one. This session is going to be an eye opener for sure and will have many of you dreaming of your data sitting in the cloud.

 

Handling FILESTREAM in SQL Server 2008 R2 [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Arie Jones
SQL Server 2008 introduced the concept of the FILESTREAM support. Most DBAs whom have been around for a while have in one instance or another supported streaming applications by use of the VARBINARY(MAX) data type in order to store file information within the database architecture. However, this has drastic limitations as the RDBMS are not typically set up to deal with data that is not accessible in terms of pages and extents. FILESTREAM support adds a new paradigm to the database platform by marrying the database system with the NTFS file system in order to overcome these old obstacles. In this session, we will delve into FILESTREAM support, the architecture, Remote BLOB Storage, what it takes to implement, and some of the extremely cool things that you can do with this new power.

Introduction to Master Data Services [200]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Arie Jones
Most DBAs at one time or another have been taught the importance of master data management(MDM), which is just comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the release of SQL Server 2008 R2, Microsoft has taken their first swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the basics of the MDS environment as well as how to get started, getting data into the system, data validation, and getting the data out as well. This session will definitely be an eye opener for some that are seeking to bring order to their chaotic data management world.

 

Monitoring Data Changes with Change Data Capture [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Arie Jones
Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.