Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The administrator does not need to know how to develop an integration service (SSIS) package or create a calculated measure in analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.
BI Consultant and Trainer
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, LA. Today, he designs Dimensional Models in the financial industry while using Integration (SSIS) and Analysis Services (SSAS) for development along with Reporting Services (SSRS) and Power BI for reporting. Starting as a developer in COBOL while at LSU, he has been a developer, tester, project manager, and team lead, as well as a software trainer for writing documentation. His involvement in the SQL Server community includes speaking at SQLPASS.org Summits, SQLSaturday events since 2011, IT/Dev Connections and Live! 360. He is the past Chair of the PASS Data Architecture and Excel Business Intelligence Virtual Chapters and worked on the nomination committee for the PASS Board of Directors in 2016 and 2017.
WHAT TO KNOW BEFORE THE CLASS
Basic DBA skills that can be obtained by watching our DBA Fundamentals course.