Denver SQL Server User Group – June 20, 2019
June 20, 2019
5:30 – 8:30
7595 Technology Way Suite 400
Denver, CO 80237
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
Demonstrating Database CI/CD using RedGate SQL Change Automation, Git, Jenkins, and Octopus Deploy
By Peter Daniels
Database Change Management and DevOps can help us move from “It worked in dev” to “it works”. Why do we care about database change management? How do we evolve from change chaos to change sanity? What is devops and CI/CD and how do they relate to DB change management? Come to this session to see an introduction to the concepts around database change management and devops, how it evolves, and the tools and technologies used to implement devops for the database. After a brief presentation, we will demonstrate a solution using RedGate SQL Change Automation, git, Jenkins (CI), and Octopus Deploy (CD).
Peter is an accomplished Database Expert and Software Developer with demonstrated results in architecting, designing, developing and administrating databases, data architectures, and software in various industries. Strong mentor who lifts more junior members to higher confidence. Team player who is comfortable navigating complex cultures and personalities. Enthusiastic problem solver and quick learner. Intuitively recognizes how to improve processes and systems.
Lessons Learned from a Successful Enterprise Power BI Deployment
By Steve Wake
Power BI is an amazing tool for end-user analytics and reporting, but if you don’t architect for it correctly it may not work right as an enterprise reporting solution. Come to this session to get actual implementation details from a real deployment that was completed for a mid-sized company (1,500+ employees) and is being used daily by more than half of the employees after only a few months of being live in production. Using demos and actual documentation you will see what you need to think of for a project like this. We will be covering architecture, implementation, governance, change control, and support to get a Power BI enterprise deployment working successfully from someone that has done it! Azure Analysis Services, Power BI Pro, and Power BI Premium will be discussed and how each is being used in this solution as well.
Steve is currently the Principal BI Developer at Brown and Caldwell and has experience in advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full Microsoft BI stack. Steve is also very involved in the SQL community, speaking at events around the world, blogging at wakebi.com, and is currently Chapter Leader of the Mile Hi Power BI User Group.