I380 Corridor PASS Chapter

  Eastern Iowa's SQL Server User Group
  Cedar Rapids • Iowa City


Meeting Details




Building a Data Warehouse for the DBA

  • In-Person @ 415 12th Ave SE, Cedar Rapids, Iowa (map)
  • Tue, May 10 2016
    17:30 - 19:30 Central Daylight Time
  • Language: English

Featured Presentation:

Building a Data Warehouse for the DBA

Pat Phelan and Denise Horner Involta

<p>Users want Data Warehouses built, but no one ever builds one for the DBA. Let's fix that!</p> <p>Get information from Active Directory, your Windows Servers, SQL Servers and other sources that mean something and will help you to keep the databases running smoothly. Be able to see which disks/machines are low on disk, what databases are on which SQL Servers, when backups happened and if any jobs failed.</p> <p>This is targeted at the DBA who is responsible for multiple SQL Servers, in multiple places, and doesn't have time to "point and click" their way to a comfortable understanding of the moving pieces on all of the systems that they need to monitor!</p>

About Pat Phelan and:
<p>Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.</p> <p>Denise Horner started her IT career when she was 17 as a data entry operator in May of 1982 at AC Nielsen in Clinton, IA. That August an internal job posted for the position of a Computer Operator on a large IBM mainframe system. Denise put in and got that job – even though in the first interview, Denise’s first question was - What is a mainframe? Denise stayed with AC Nielsen until she relocated to Bandag in Muscatine in January of 1990. Denise stayed at Bandag working her way up in the mainframe platform. Because of the dreaded O word (outsourcing), she transitioned to being an Involta employee in Sept of 2006, in the same job, same location, just a different employer. Denise continued in mainframe until she was asked in 2011 if she wanted to “try” doing “something” with databases. “I guess”, was her response and shall we say, “the rest is history”. Currently holding the title of database administrator, mentoring under Pat Phelan, Denise has a core client she supports on site along with supporting other Involta clients and Involta databases. Denise has been active in her local SQL PASS Chapter, volunteers on the committee for the local SQL Saturday event and attended her first Pass Summit last year.</p>

Back to Top