Free SQL Server Training!
Join us for the April 2015 meeting of MagicPASS, South Orlando's SQL Server User Group. Food and beverages will be served, plus we've got swag to give away!
This month we welcome SQL Server MVP Bradley Ball to present BI DBA Performance Tuning.
After the meeting we'll head to the Celebration Town Tavern for more socializing. (You are responsible for your own drinks)
Make a difference in someone's career: Invite them to attend the meeting with you! (Heck, invite them to attend even if you can't make it)
BI DBA Performance Tuning
Speaker: Bradley Ball
Summary: Data Warehouses and OLTP systems are different! But there are some core concepts that we need to understand for managing and maintaining both. Do you want to know how you can load data faster, just by setting up your database correctly? Are your queries running slow? Want to understand how you can reduce locking and blocking in reporting queries? Do you have a system with views, that reference views, which reference more views? Let's discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!
About Bradley: Bradley Ball is a Microsoft SQL Server MVP with over 15 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army, The Executive Office Of the President of the United States, and Publix Supermarkets. Currently he is the Data Platform Management Lead for Pragmatic Works and a Microsoft VTSP assisting Microsoft in delivering technical solutions, troubleshooting problems, and Evangelize SQL Server for Microsoft. He has presented at many SQL Saturdays, for PASS SSUG’s across the US, SQL Rally, DevConnections, SQLBits 2015, SQL Live 360, & the PASS Summit 2011-2014. Published Author, including the recent SQL Server 2014 Pro Administrators Guide. He can be found blogging on http://www.sqlballs.com about SQL Server or anything else that interests him.
70-461 (Querying Microsoft SQL Server 2012) Study Session
Summary: We'll continue studying for exam 70-461 (Querying Microsoft SQL Server 2012) with a goal of taking the test by the end of May. This month we'll watch Pluralsight videos on working with XML data and answer some sample exam questions as a group to help get ready to take the exam.