August Monthly Meeting New Location!
New Location Change!
Meeting Denver SQL User Group
Thursday, August 17, 2017 5:30pm – 8:30pm
Aurora Mental Health Center
791 Chambers Road,
Aurora CO 80011
Auditorium in the Basement. Please enter by the Front Door.
5:30 – 6:00 Food / Socializing
6:00 – 6:15 User Group Business
6:15 – 6:30 Open panel/Questions & Answers
6:30 – 7:00 Warmup presentation
7:00 – 8:30 Main presentation
Introduction to RoundhousE
If you’re a database professional whose task is to do deployments, and you’re still doing the releases by manually executing scripts, then it’s time to have a look at open source free tool which will help you and your organization and ease the task at hand.
RoundhousE is an automated database deployment (change management) tool that helps database professionals with deployment of database scripts. It also aids versioning the database based on the source control system. This short presentation will cover the features of RoundhousE and show you how this tool can help you with your database deployment. Using RoundhousE, you can automate your deployments and version your database and easily track the changes.
Bulent Gucuk (MCTS, MCP) has been working in IT since 1999. He started his career in helpdesk then moved to system administration and earned a MCSE certification. In 2004 by pure accident he started learning and working with SQL Server and hold couple of positions as part time DBA part time systems administrator roles and then become a full time DBA in 2006. In the last 11 years, he worked as production DBA, Development DBA focusing mostly on deployment, administration, maintenance and troubleshooting of SQL Server. You can visit his blog at http://milehighdba.blogspot.com/ or follow him on Twitter at @bulentgucuk.
Title : Why Is My DBA So Grumpy? Real Reasons Why Some Coding Practices Cause Problems
One of the interesting things about the SQL Server community is how often best practice advice is flatly ignored. Have most of us heard that using NOLOCK is bad? Yes, almost certainly. Does NOLOCK still get used heavily in production code? Yep, you betcha. Presumably the issue is not that we don’t care whether or not code is written correctly – we’re all professionals and take pride in our work. It seems more likely that those responsible for the care and feeding of database servers haven’t found the right way to explain _why_ some of these practices matter. Come hear Rick’s attempts to expain why some code patterns are problematic. Topics covered will include NOLOCK, heaps, and cursors among others.
Rick Lowe is a Microsoft Certified Master for SQL Server with more than 15 years of experience working with SQL Server, both as a developer and as a performance DBA. He specializes in performance tuning and mentoring developers on better practices. Most weekends Rick can be found presenting at SQL Saturday events all over the country.