1 / 13

PowerShell & PowerBi Reducing DBAs Context Switching

PowerShell & PowerBi Reducing DBAs Context Switching. Rob Sewell @ sqldbawithbeard http://sqldbawithAbeard.com # psconfasia Slides and Demos available at https://github.com/SQLDBAWithABeard/Presentations/ PowerShell & PowerBi Reducing DBAs Context Switching. Speaker Questionnaire.

muriele
Download Presentation

PowerShell & PowerBi Reducing DBAs Context Switching

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PowerShell & PowerBiReducing DBAs Context Switching Rob Sewell @sqldbawithbeard http://sqldbawithAbeard.com #psconfasia Slides and Demos available at https://github.com/SQLDBAWithABeard/Presentations/ PowerShell & PowerBi Reducing DBAs Context Switching

  2. Speaker Questionnaire Name : Rob Occupation : DBA, Automator, Do-er Interests : PowerShell, Automation And SQL (PaaS geddit?) Website : sqldbawithAbeard.com Twitter : @sqldbawithbeard Interesting Fact : Has a Beard. (Still) Plays Cricket Speaker : SQL Saturdays, SQL Relay, PowerShell Conference EU Community : SQL South West , SQL Saturday Exeter , PowerShell Virtual Chapter, Organiser for PowerShell Conference EU 2017, Officer, Lead for dbareports, contributor to dbatools https://dbareports.io @psdbareports

  3. What Problem are we Solving? Rob Sewell @sqldbawithbeard

  4. Questions • Managers • PMs • Developers • Compliance • Auditors • DBAs • Change Managers • How Many? • Where Are? • What Is? • Which? • When? Rob Sewell @sqldbawithbeard

  5. Replace The Old Ways Rob Sewell @sqldbawithbeard

  6. Instant ViewsFor TheDBA Team Rob Sewell @sqldbawithbeard

  7. Help Yourself Rob Sewell @sqldbawithbeard

  8. REQUIREMENTS SOLUTION Local Knowledge Rob Sewell @sqldbawithbeard

  9. The Manual Part This used to be a bit of a pain to set up. And then we wrote And now all it is this PS Git:\dbareports> Install-DbaReports -SqlServerDBASQLServer PS Git:\dbareports> Add-DbrServerToInventory -SqlInstance 'ROB-SURFACEBOOK' -Port 1433 -Environment Prod -Location Singapore

  10. MUST BE TIME FOR A DEMO

  11. Questions?

More Related