All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker…or two. These events provide for great learning opportunities as well as networking with other local SQL Server professionals.
Northern Colorado SQL Server User Group Meeting
Date: Monday, June 17th
Main Presentation:
How NOT to Migrate to SQL Server 2012
Do you want to avoid a potential train wreck when migrating to SQL Server 2012? Todd has just finished up a successful side-by-side migration going from SQL2005 to SQL2012. The project began last summer and launched on 6/8/2013. The system in question is a mission-critical OLTP hosting multi-terabyte databases and is used by the company's website and many internal applications. The system is a FCI+AG running on three cluster nodes, each 384GB, 2P8C. We will look at several challenges to the project and how they could have been better managed or avoided. Shortcomings to discuss (lack of): data leadership, communication, budget, physical servers, virtual machines, disk space, technical expertise, application testing, and disaster recovery. Why you don't upgrade other database systems on the same day that have dual-dependencies. We will also look at tools and documentation which assisted in the migration.
Presenter: Todd Kleinhans, Senior SQL Server DBA
Todd Kleinhans has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. He is currently a Senior SQL Server DBA consultant at Datavail. Todd is also the current VP of Marketing for the Denver SQL Server User Group. He has presented at user groups, SQL Saturdays, and the Rocky Mountain Trifecta.
Meeting Location
UNC Loveland Center at Centerra
2915 Rocky Mountain Ave.
Loveland, CO 80538
Silverton Conference Room 2nd Floor
Colorado Springs SQL
Date: Wednesday, June 19th
Main Presentation:
What every DBA should know about NoSQL
NoSQL is one of the buzzwords you hear going around in the developer world. As DBAs inevitably someone will come to us for help or advice on (or possibly choosing) a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization.
This presentation will cover: What exactly NoSQL is (and is not), introductions to some of the common NoSQL flavors, dispel some common misconceptions about NoSQL, and we will look at when you might (or might not) want to leverage it for a solution.
Presenter: Kelly Martinez, Developer / DBA
Kelly Martinez is a Developer/DBA currently working in municipal government. With over 15 years of I.T. experience he has also worked as a Web Developer in the Open Source space and as a System Administrator on both Linux and Windows.
Meeting Location
Hyatt Place - Colorado Springs
503 Garden of the Gods Rd W,
Colorado Springs, CO
BoulderSQL
Date: Tuesday, June 18th
Main Presentation:
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performances
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.
Presenter: Glenn Berry, SQL Server MVP
is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.Sql Server. He has worked in all aspects of Sql Server including Administration, Database Development, BI and Reporting Services. He has worked in the Finance and Car Dealership industry. His experience has included International deployments. Tom is the co-leader of the PASS Virtualization chapter and the past President of the Denver Sql Server User Group.
Meeting Location
Confio Software in Boulder
4772 Walnut Street
Suite 100
Boulder, CO 80301
DenverSQL
The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft's SQL Server, together to learn and network with others. There is no charge to attend, and you are encouraged to bring guests. Food and refreshments are provided by event sponsors.
Date: Thursday, June 20th
Time: 5:30 - 8:30 pm
Main Presentation: Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
Presenter: Glenn Berry, SQL Server MVP
Glenn Berry is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.Sql Server. He has worked in all aspects of Sql Server including Administration, Database Development, BI and Reporting Services. He has worked in the Finance and Car Dealership industry. His experience has included International deployments. Tom is the co-leader of the PASS Virtualization chapter and the past President of the Denver Sql Server User Group.
Meeting Location
Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237
