June 2014

Featured Presentation

5 T-SQL Commands I've Been Missing

Speaker: Jason Carter

Summary: Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me. In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing. We will evaluate the usefulness of CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.

About Jason: Jason's past has included being a developer, a development manager, and accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator.

Pre-Meeting Presentation

Building an Effective Data Warehouse Architecture (Video Replay)

Speaker: James Serra

Summary: You're a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What's the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What's the difference between the Kimball and Inmon methodologies? Does the new Tabular Model in SQL Server 2012 change things? What's the difference between a data warehouse and a data mart? Is there any hardware I can purchase that is optimized for a data warehouse? What if I have a ton of data?

Join this session for the answers to all these questions. You'll leave with information that will amaze your boss and lead to a big raise . . . or at least lead you down the correct path to adding business value to your organization!

Back to Top