Brian P ODwyer

Brian is a Senior BI Analyst at Cook Children's Health Care System where he has been for the last 12 years working in both Infrastructure and Enterprise Application support before moving into a BI role. Brian has worked with SQL server since version 2000 over the years and has much experience integrating SQL Server with Third Party and Microsoft Applications. Brian has worked with SQL in depth since version 2005 and holds numerous SQL Server Certifications MCTS, MCITP, MCDBA and MCSE and certifications in Exchange, SharePoint and Windows Server. Brian started out as an Actuarial Analyst and moved into Computers in the DOS days. Brian specializes in integrating the various parts of the Enterprise into solutions to solve problems that have no simple answer or easy framework.
2014 Awards
2014 Awards

Availability Groups
- Finding Primary Replicas for SQL Server 2012 AlwaysOn Availability Groups with PowerShell (last update: 4/14/2014)
Integration Services Upgrade
- Finding Execute DTS 2000 Package Tasks Prior to Upgrading to SSIS Packages (last update: 3/31/2014)
Microsoft Excel Integration
- Using PowerShell to scan and find SQL Server database connection information inside MS Excel files (last update: 5/28/2014)
Security
- Creating a Kerberos Delegation Table for SQL Server Access (last update: 3/5/2014)
- Get SQL Server SPN information for all servers using PowerShell (last update: 2/18/2014)
Virtualization
- Gather information from VMware vCenter VCDB about SQL Server (last update: 4/23/2014)
- Gathering ESXi Host Information from VMware vCenter VCDB for Virtual SQL Servers (last update: 12/11/2014)