PowerShell for SQL Server Administrators (MS-55069)

• Experience working on Windows desktops or servers
• Experience working in a Windows domain environment
• Experience Administering SQL Server Servers

2. What is the Difficulty level of the PowerShell for SQL Server Administrators (MS-55069) certification training?

Intermediate Level.

3. How will this training benefit me in my current job role?

• Our brief yet highly intensive IT Ops Training program is designed to help students gain professional knowledge of PowerShell. This course is taught by professional instructors from the industry to help you gain the knowledge and skills required to become efficient SQL Server Administrators for PowerShell.
• With the knowledge and exercises taught in the course, you will be able to efficiently manage a number of maintenance tasks on SQL Server 2012, 2014, and 2016. The purpose of this course is to allow students to gain adequate learning of the administration, Integration Services, and Analysis Services of the platform.
• This IT Ops training program is designed for students who want to or are willing to work as SQL Server Administrators in Windows.
• Provides value added skills and expertise to excel seamlessly and robustly in your job role along with the confidence of being product specialist.
• provides a real-world, hands-on practical approach for you to apply the knowledge and skills learned in the course.
• provides on-the-job reference material to boost knowledge and skills retention.

4. What is the PowerShell for SQL Server Administrators (MS-55069) course objective?

• Install and Configure SQL Server and all its components using PowerShell
• Manage day-to-day SQL Server Administration with PowerShell
• Maintain the SQL Server environment using PowerShell scripting and programming options

5. What is Windows PowerShell?

Windows PowerShell is an object-oriented scripting language that includes an extensive library of common commands, known as cmdlets. You can also write your own cmdlets.

6. How we can use PowerShell help?

A good place to start when learning PowerShell is the Get-Help cmdlet. This cmdlet displays a page that explains how to get more information, including downloading or updating help files.

Download Help for First Time Use Before using PowerShell help, you must specifically download it. When you access help, you might be prompted to download updated help for the first time or to update help files from the Internet when updates are available. Note: you must be running the PowerShell console as Administrator to download the files.

Get-Help Cmdlet

When you understand how to use PowerShell help, learning PowerShell becomes a lot easier. Get-Help, displays a summary of the help available in PowerShell.

7. What is PowerShell ISE?

The PowerShell ISE is designed to develop PowerShell scripts. It has two sections: a scripting pane where you write the script that will be saved, and the console where you can write cmdlets and display results. The console window behaves just like the stand-alone console; you can use it to test PowerShell scripts, get help about cmdlets, and make sure everything works as expected.

8. How to manage Users and Roles using PowerShell?

• To maintain users and roles, use the SQL provider to access SMO objects
• List database users with the Database.Users property:
• Within a database
• Across database instances
• Add a database role with Smo.DatabaseRole object and the create method
• Create permissions with the Smo.ObjectPermissionSet
• Add a user with the Smo.User object and the Create method

9. How to manage Users and Roles using PowerShell?

SQL Server 2012 included updates to the sqlps PowerShell module with which you could use PowerShell to back up and restore databases.

Backup-SqlDatabase The Backup-SqlDatabase is the cmdlet used to back up databases. It is a flexible cmdlet with seven parameter sets, meaning you can choose from a number of different ways of specifying the backup. These include the database to be backed up, the backup location, log truncation, encryption, and much more. Type Get-Help Backup-SqlDatabase for the full syntax As the database is being backed up, PowerShell shows a progress bar to indicate the backup is running.

Restore-SqlDatabase Unsurprisingly, there is an equivalent cmdlet to restore databases, namely Restore-SQLDatabase.

10. How we can amend SQL Server Database settings?

• You can amend a database setting by using PowerShell and SMO
• Use the Alter method to make the change
• PowerShell works with objects
• Get-Member enables you to find information about objects