وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Automating SQL Server with dbatools

سرفصل های دوره

If you want to learn more about automating SQL Server, you’ve come to the right place. Did you know you can use the open-source PowerShell module dbatools to manage your SQL Server estate? In this course, instructor Jess Pomfret covers the skills you need to know to automate SQL Server with dbatools, helping you optimize your workflow, database performance, and overall server management experience.

Learn about the history of dbatools and why it should become one your trusted go-to tools, as Jess shows you how dbatools can accomplish most of the tasks available in SQL Server Management Studio. Find out how to handle multiple instances, databases, and logins at the same time, as well as gather and set information, change configurations, and migrate instances. Upon completing this course, you’ll be prepared to keep building on your new skills so you can become a more effective and efficient database administrator.


01 - Introduction
  • 01 - Why dbatools
  • 02 - What you should know
  • 03 - Setting up your environment

  • 02 - 1. What Is dbatools
  • 01 - Introducing dbatools
  • 02 - Installing and updating the module
  • 03 - Find the command you need
  • 04 - Running your first command

  • 03 - 2. Get Information
  • 01 - Get a list of SQL Servers in your environment
  • 02 - Get database status across your estate
  • 03 - Check database last backup times
  • 04 - Get SQL Server patch levels
  • 05 - Review SQL Server Configuration Settings
  • 06 - Find failed SQL Agent jobs

  • 04 - 3. Set Information
  • 01 - Set databases online or offline
  • 02 - Discover and apply recommended data compression levels
  • 03 - Update database compatibility levels
  • 04 - Insert data into SQL Server tables

  • 05 - 4. Migrations Made Easy with dbatools
  • 01 - Migrate whole instances with one line of code
  • 02 - Simple database migrations
  • 03 - More advanced database migrations
  • 04 - Migrating logins
  • 05 - Exporting documentation

  • 06 - Conclusion
  • 01 - Continue your learning
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 2747
    حجم: 207 مگابایت
    مدت زمان: 61 دقیقه
    تاریخ انتشار: 28 دی 1401
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید