Past Meetings

Special Event: Orange County SQL Server Professionals User Group

Topic: SQL Server Integration Services Control Flows and Data Flows

Presenter: Bret Stateham

Bret Stateham

Presenter Bio:

Bret has over 20 years of experience in the IT field, over a decade of experience as a trainer. He has been working with Microsoft platforms since the early '90s.

Bret's focus is on SQL Server solutions and is an expert in .Net development as well as SharePoint implementation, configuration and administration.

Bret is a published author, and a frequent speaker at regional Code Camps and user group meetings.

Session Summary:

In this session we will cover the specifics of SQL Server Integration Services Control Flows and Data Flows.

Control flow is where SSIS developers manage the sequencing of tasks within an SSIS package. Control Flow concepts covered in this session include tasks, precedence constraints, containers, variables and more. Understanding the core concepts of control flow is the foundation of creating effective SSIS Packages.

In this session we will also focus on a specific SSIS task: The "Data Flow" task. The data flow is the most commonly used tool to move data in an SSIS package. It is in the data flow that you specify the data sources, transformations, and destinations for your data movement process. Data Flow concepts covered in this session include Connection Managers, Data Sources, Data Destinations, Transformations, Error Output, and more.

Please visit http://sqloc.com/ for further details.

Windows Server 2008 and SQL Server 2008 Failover Clustering

Presented by: Allan Hirt

(Please stay tuned for additional posts by the speaker.)

Forget a good portion of everything you know about deploying failover clustering ? Windows Server 2008 changes the game. Come to see how the changes and improvements affect clustered SQL Server deployments. Things also change a great deal with SQL Server 2008, especially around the setup, upgrade, and patching processes (among other things). This session will talk about what you need to know to have successful deployments of SQL Server failover clustering on Windows Server 2008. Live demos will be shown where possible.

Bio:

Allan Hirt has been using SQL Server in various guises since 1992 since interning at Sybase in college. Except for the OS/2 version of Microsoft SQL Server, Allan has worked with all versions on Windows since 4.21a. He has also worked with other RDBMS systems over the years including Oracle, Sybase, and Informix, and can relate to non-SQL Server DBAs. He is currently based in the Boston, MA, area and for the past ten years, has traveled all over the world to work with clients as well as deliver training Before forming his own consulting company Megahirtz in 2007, he most recently worked for both Microsoft and Avanade. Over the years, he has authored or contributed to publications about SQL Server for Microsoft, SQL Server Magazine, and others including whitepapers, webcasts, training courses, and books. He is a frequent speaker at conferences like TechEd and SQL PASS and a Clustering MVP. His most recent book, Pro SQL Server 2008 Failover Clustering, was published by Apress in July, 2009, and Allan?s most recent whitepaper on consolidation was published by Microsoft in October, 2009. His blog and contact information can be found at: http://www.sqlha.com