SQLPeople Richmond 2011

Do you enjoy learning about the cool things people are doing with SQL Server and database technologies? Do you want to know more about how the cool things are designed? Do you want to know more about the people who designed the cool things? If you answered “Yes!” to any of the questions above, you’re a SQLPeople Person!

Join SQLPeople just like yourself as we gather to celebrate and show-off our database technology visions. Will you learn cool new stuff? Absolutely! But educating you is not the focus of this event. Inspiring you is the focus. We’ve bribed, coerced, tricked and trapped some of the most interesting people we know into coming to Richmond to talk about their cool projects. These folks are doing amazing things with database technology and we’ve asked them to prepare short presentations describing their work. After each presentation, the speaker is interviewed and takes questions from the audience.

Our Wonderful Sponsors!

Big thanks to CozyRoc for headlining the very first SQLPeople event! Also much thanks to J. Sargeant Reynolds Community College for acting as gracious hosts!

CozyRoc LogoJ. Sargeant Reynolds Community College

The Talks

Redefining Vocation: Legitimacy and Innovation in Technology by Kendra Little

Our generation is changing the inherent nature of a “career” and what it means to do business with technology. Adaptability and innovation are increasingly key to success. It is no longer sufficient to perform a job well– we must recreate the job itself. As technologists, how do we attain independence? As business people, how do we continuously generate ideas? Kendra Little looks through the lens of Western History to find the source of legitimacy and a practical guide to defining the new professional life.

About Kendra

I put the “L” in Brent Ozar PLF as a Founder/Owner. People sometimes ask me what I like to do for fun. Honestly, my job is fun. It’s all about working with great people who love what they do. I love to draw. Sometimes I read a lot, sometimes I don’t. I like to cook, but I keep it pretty simple. I’m a Microsoft Certified Master (MCM) in SQL Server 2008. As I describe it: The MCM is the biggest, baddest technical certification you can get for SQL Server. This certification takes years of preparation to achieve and requires passing rigorous written and lab examinations. I have a BA from awesome little Shimer College and an MA in Philosophy from Fordham University in the Bronx.

Rules, Rules, and Rules by Jeremiah Peschka

If you asked Jeremiah Peschka to pick three things he’s interested in about computers, he’d say “data” and then look at you funny. If you asked him again, he’d say “data design, database design, and designing around the limits of the first two.” This is a rapid tour of the building blocks of databases, how those choices affect what we do with data, and why we have to break the rules from time to time to get things done.

About Jeremiah

I’m a Founder/Owner at Brent Ozar PLF. I’ve worked as a database and emerging technology expert at Quest Software where I researched new trends and technologies in the world of data storage. Over the course of my career I’ve worked with a number of companies in a variety of industries as a system administrator, developer, and DBA. I’ve been involved with most aspects of application development and deployment. Outside of work, I am involved in a number of local developer associations including CBusPASS and CodeMash. I’ve been involved with PASS as a member of the Board of Directors and as the organizer of the Application Development Virtual Chapter. When I’m not volunteering my time to the community, I can be found writing blog posts, creating presentations, or learning more about information — how people find, use, store, and retrieve it. Ultimately, software is just a way to get data faster, apply meaning to data, and transform the data into information.

Renaissance Age 2.0: The Coming Golden Age of Internet Based Knowledge by Brian Moran

Free content is king. Long live the king. The ROI for most college level and career oriented technical education is fundamentally broken. We have entered a new renaissance period of hyper learning in which a vast amount of knowledge is free for the taking in a 24x7x365 manner with 5 nines. I think of it as Renaissance Age 2.0. Paying for knowledge? Really? That’s so yesterday. Alas, we’re still missing a few key pieces of technology and infrastructure that are necessary to fully unleash Renaissance Age 2.0. I’ll share 20 minutes of my thoughts on what is broken in the collegiate and career educational systems and what needs to change to more fully enable self-directed hyper learning as we consume vast quantities of free, world class, internet based knowledge. What does all of this mean for you, I, and the SQL Server ecosystem we work in? Yeah, I’ll talk about that too.

About Brian

Brian Moran is Chief Servant Officer and co-owner of both Linchpin People and SQL People. He is a contributing editor for SQL Server Magazine and has been active in the SQL Server community for more than 20 years. Brian co-founded what might be the first SQL Server user group in the world, was one of the first SQL Server MVPs, was on the SQL Server Magazine launch team, and has served on the PASS Board of Directors. Brian’s roles in the SQL Server community include technologist, author, community leader, entrepreneur, and executive.

Using SSIS Custom Components to Solve Complex ETL Problems by Michael Coles

SSIS provides dozens of stock components, but every once in a while you run into a complex ETL problem that’s difficult to solve using the built-in standard components. SSIS custom components provide a powerful mechanism to perform even the most complex tasks efficiently. Michael Coles will demonstrate the flexibility and power available to SSIS developers through custom components.

About Micheal

Michael Coles is an independent consultant with 15+ years of SQL Server experience. He has architected several high-performance enterprise ETL solutions for Fortune 500 clients, and has authored or coauthored several books on SQL topics including “Pro T-SQL 2008 Programmer’s Guide”, “Pro SQL Server 2008 XML”, and “SQL Server MVP Deep Dives”. Michael is a Microsoft MVP for SQL Server.

SQL Server 2005 Innovations and Leveraging Features in SQL Server 2008 by Gray Proulx

Topics will include: Service Broker, Spatial Data, Dashboarding and security in Analysis Services for non Active Directory users.

About Gray

Gray Proulx is a professional developer who has been working at Jackson Hewitt Tax Service for the last 17 years. He’s played many different roles developing in everything from C to Delphi to C# but has spent the majority of the last 7 years in the SQL Server role. Gray was the BI architect for several years prior to moving on to the Technical Product Management arena for a couple of years managing the reporting and BI infrastructure along with the business units. Last year Gray moved back into the architecture group to get back to his technical roots and is working on exciting ways to utilize the new offerings SQL server provides us.

Turning SQL Server into a Successful Development Platform by Scott Currie

By many measures, SQL Server is hugely successful as a platform for data development. But SQL Server, and database platforms in general, have been under consistent attack from multiple angles, often with very compelling arguments. Scott Currie will take a closer look and identify critical areas where SQL fails to offer development capabilities that are standard in most other technical platforms. Even better, he’ll show us how to fill these holes without needing to reinvent the wheel – right now – for free.

About Scott

Scott founded Varigence in 2008 because he saw a huge opportunity to improve the way the world makes decisions. The problem isn’t a lack of data. Rather, the available data is locked up and impossible for most of us to transform into insight. Varigence aims to help solve that problem. Before founding Varigence, Scott worked on large scale Business Intelligence and Data Warehousing projects at Microsoft Customer Service and Support (CSS). Before that, he worked for several years on Microsoft developer technologies including Visual Studio and the .NET Framework.