Omaha SQL/BI User Group Meeting - August 13th, 2014 @ 6PM
Topic: Implementing Centralized Backups For All Of Your DatabasesRunning backups instance by instance can be painful and hard to keep in sync at times. Backup scripts can become out of date, it can become difficult to turn off backups globally (e.g. for maintenance), and backup location changes can be difficult to make.If you desire to have a single-point of execution for backups so that you can control your environment by going to a central place, this session is for you. We will go through the required database structures, the SSIS packages that perform the work, and the metadata that is responsible for controlling the backup process. You will walk away with an understanding of how you can implement your own solution to fit the needs of your organization. Speaker: Phil Brammer Phil is a Microsoft Certified Solutions Expert in the data platform and an eight-year and running Microsoft MVP awardee. His focus is on SQL Server Integration Services and the database engine. He currently manages over 150 database instances with over 2,300 databases.Phil has over 14 years of data warehousing experience in various technologies from reporting through ETL. Including Ralph Kimball’s Red Brick data warehousing software, SQL Server, Oracle, SAP, Teradata, MySQL, etc… he is well versed in Crystal Reports, Business Objects, and other prominent reporting technologies.Sponsor: TegileTegile Systems is a leading provider of intelligent flash storage arrays. Our mission is to accelerate the transformation of enterprise IT by changing the performance and economics of enterprise storage. Our flash storage arrays, with patented IntelliFlash architecture, deliver high I/O and low latency for business applications such as databases, server virtualization and virtual desktops. Our customers achieve business acceleration and unmatched storage capacity reduction.