SQLBits 2015

BI DBA Performance Tuning

Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
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!