#DBATools

#DBATools

#DBATOOLS What it is and why you should use it Who uses PowerShell? Cmdlets About 100 PoSH cmdlets for SQL from Microsoft

About 350 PoSH cmdlets for SQL from dba tools Open Source code reviewed by many people Pester

Code tested is available Health check is available

What can you use powershell for? Build and configure a VM Configure Install Windows including clustering

and configure SQL CI/CD All of these are Repeatable universal PoSH

is even available on Linux #Help Available on Slack What is the coolest thing you can do with DBATools? 1

line of PoSH to move an entire instance to another (think upgrade) Some SID) former pains are now easy i.e. Copy-DbaLogin (keeps the

Copy-DbaLogin mylogin Source server1 Destination server2 Login History Started After

with desire to migrate a server quickly that they split the cmdlets out so if you dont need to migrate an entire instance, you can just move what you need. Demo Additional links DBATools Slack:

https://dbatools.io https://dbatools.io/slack/ YouTube: https://www.youtube.com/results?search_query=dbatools+powers hell

Interview http://www.runasradio.com/Shows/Show/572

Recently Viewed Presentations

  • 2018 Clinical Practice Guidelines Hyperglycemic Emergencies ...

    2018 Clinical Practice Guidelines Hyperglycemic Emergencies ...

    2018 Clinical Practice GuidelinesHyperglycemic Emergencies in Adults. Chapter 15. Jeannette Goguen MD MEd FRCPC. Jeremy Gilbert MD FRCPC
  • Advanced Appearance and Shape Models

    Advanced Appearance and Shape Models

    boundary. term. In continuous framework computational methods computing global optimum of the energy require that . U(S) is linear with respect to characteristic function of S. Combinatorial methods for global optimization require that U(S) is unary term
  • Safety Council Brief Notes - United States Navy

    Safety Council Brief Notes - United States Navy

    Safety Council Objectives. 1. Reviews statistics compiled by the safety officer. from mishap, hazard and inspection reports, safety or health ... Confirmation brief to chain of command/ORM analysis. Review of current publications. Assess qualifications/training. All hands are Safety Officers.
  • The Structure and Function of Blood

    The Structure and Function of Blood

    Hemoglobin Determination Hemoglobin Hemoglobin Found in the RBC. Responsible for carrying oxygen to all cells in the body. Also binds to carbon dioxide and carries it to the lungs from the cells to be released.
  • Informal Resources and Constraints Freewrite What formal resources

    Informal Resources and Constraints Freewrite What formal resources

    Informal resources & constraints Skills: Persuasion Hidden hand leadership Personality Ambition Changes in the dominant political rhetoric Richard Neustadt The constitutional presidency is a clerkship Presidential power is the power to persuade The power to persuade is the power to...
  • The cardiovascular system

    The cardiovascular system

    Cardiac Output (CO) amount of blood pumped out by each ventricle in 1 min. Stroke Volume (SV) = vol of blood pumped out by 1 ventricle with each beat. correleates with force of ventricular contraction. CO = HR x SV...
  • Rhetoric: Ethos, Logos and Pathos - Mrs. Bottesi's Class

    Rhetoric: Ethos, Logos and Pathos - Mrs. Bottesi's Class

    Rhetoric: Ethos, Logos and Pathos * * * * * * * * * * * * * * Rhetoric Rhetoric (n) - 1. the art of speaking or writing effectively 2. using speech or writing to persuade Aristotle Aristotle,...
  • Treaty of Versailles

    Treaty of Versailles

    What did Lloyd George hate about the Treaty? He thought it was too harsh and would start another war in 25 years' time. List the four other treaties of 1919-20. Saint Germain (with Austria) Neuilly (with Bulgaria) Trianon (with Hungary)...