Topic: SQL Server 2012 AlwaysOn Readable Secondaries

Description: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications & databases, are currently using Database Mirroring, or if you’re just curious about AlwaysOn, then you won’t want to miss this session.

Speaker: Adam Belebczuk

Bio: Adam Belebczuk is a Developer turned Accidental DBA for Banyan Technology of Elyria, OH. Adam has about 8 years of experience in IT ranging from customer service to server/network administration to software and database development. Adam is an MCITP DBA 2005/2008, and specializes in SQL Server development and performance tuning.

Sponsor:

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Event Registration for June Meeting -

Topic: Using BIML as an SSIS Design Patterns Engine

Description: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.

Speaker: Andy Leonard

Bio: Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.

Sponsor:

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Event Registration for June Meeting -

Topic: BI: Fact Table Modeling – Real World Case Study in ‘Threshing’ Out the Grain of a Fact

Description: This data warehousing case study in fact modeling will demonstrate how to properly discover the grain of a fact table. Together we will prototype the ETL to turn detailed transactional data into a structured and powerful fact table.

Speaker: Chris Umbaugh

Bio: Located near Toledo, Ohio, Chris is a business intelligence/data warehousing contractor specializing in the Microsoft stack with 15 years of experience. He has successfully delivered complete one-man BI solutions and more recently has had the privilege of serving on a larger BI team in Hilliard, Ohio responsible for the design and delivery an enterprise-wide data warehouse. Chris is a new speaker on the subject of SQL Server and recently presented at the August meeting of the Columbus PASS chapter. He will sometimes write in third person but promises never to talk that way.

Sponsor: WiT Inc

Topic: Manage SQL Server 2012 on Windows Server Core with PowerShell

Description: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.

Speaker: Allen White

Bio: Allen is a Practice Manager for UpSearch Technology Services in Northeast Ohio. He’s spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT.  Allen has been awarded Microsoft’s MVP Award for the last five years. He’s President of the Ohio North SQL Server User’s Group and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.

Sponsor: Cleveland Tech Consulting – http://cletechconsulting.com

We specialize in IT automation, software development and architecture, and general technology decisions. Cleveland Tech Consulting is also the proud owner of Cleveland Tech Events (http://clevelandtechevents.com), promoting over 60+ technical user groups in the Cleveland area.  Whether it’s a product, a language, or a methodology, there are probably user groups out there for your interests.  And if not, form a user group!  For more details, contact Sarah Dutkiewicz at admin@clevelandtechevents.com.

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Add to Calendar

Pre-Session: TBA

Topic: Report Services: Set up to Deployment

Description: In the SQL Server tool box there is a great tool called SQL Server Report Services. With five different interfaces, Report Services can be a bit challenging to  setup and configure.

Our focus will mainly include setup, configuration, and deployment;  in addition, there will be some time spent on  report building. When you walk away from this session, you will understand terms like BIDS, SSRS, Report Builder, and Crescent.

If you are looking for information to start developing your repertoire of SQL Server Report Services, this is definitely a session to attend!

Speaker: Cory Stevenson

Bio: Cory Stevenson is a Database Engineer for Hyland Software in Westlake, Ohio. With over 8 years of experience in IT, his interests include Reporting Services, Virtualization, PowerShell, coffee, and keeping up with the latest BI features in SQL Server 2012.

Sponsor: Oxford Global Resources

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Topic: From Geek to BizDude

Description: Have technical skills? Great, but not good enough. Today’s IT professional (especially if he or she is going the to consulting world) has to be able to work on the business side as well. This includes the traditional “soft skills” as well as an understanding of standard business “stuff.”

Speaker: Bob Coppedge

Bio: Allen made me do this<g>. President/CEO of Simplex-IT, former CIO, dba, develper, consultant, vagabond and man-about-town.

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Topic: Using SQL Azure in a SSMS Addin

Description: The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. This talk will be a step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio AddIn. You’ll find that Azure is so easy to work with, you’ll get two for the price of one in this talk: you’ll learn Azure and learn how to create a Management Studio AddIn!

Speaker: Jeff Mlakar

Bio: Jeff Mlakar is an experienced Enterprise Data and ETL designer. He has 2 degrees from the University of Michigan, Mechanical Engineering and Computer Science. He just completed a 2 year contract as a Database Architect at Ernst & Young, after which he was hired by E&Y as a SQL Lead Designer.

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Description: Key takeaways: Learn how to performance tune SSIS and common pitfalls.

Level: 400

Length: 50-75 minutes

In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server’s resourcing. Lastly, discover SQL Server 2008 and Denali features that will make SSIS more efficient.

Session Level: Advance

Speaker: Brian Knight

Bio: SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at SQLShare.com. He is the author of a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Event Registration for June Meeting -

Topic: Who dropped my table? – DDL auditing in SQL Server

Description: Who altered this view and how? When was this index created? What happened to my stored procedure? From SQL Trace to SQL Audit, this session offers comparative analysis of various methods to audit DDL changes in your SQL Server database.  

Session Level: Beginner

Speaker: Colleen Morrow

Bio: Colleen Morrow is a Database Administrator at Jones Day in Cleveland, OH. She has worked in the IT industry for 14+ years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms.

Sponsor: Upsearch

Social Gathering: Mavis Winkles – 5005 Rockside Rd., Independence, OH 44131

Topic: Conquering ETL Projects

Description: Few projects in Information Technology are as fraught with danger as data migration / ETL projects. With the life’s blood of the organization on the line ( the data ), these projects require strategies for success that are beyond just the code. After conquering successful data migration and merger projects, and surviving failed projects as well, I will present the life cycle of an ETL project, with strategies for handling the specifics of each phase. I will also share a battle hardened methodology for transforming and merging data with multiple key conflicts, and resolving overloaded fields.

Session Level: Beginner

Speaker: Austin Zellner

Bio: Austin has been in IT for over 14 years, working as a developer, programmer analyst, and system designer. He has worked in the call center, insurance, printing, and retail domains.

Sponsor: Oxford Global Resources

Social Gathering: Winking Lizard – 6111 Quarry Ln, Independence, OH 44131