Description
Course info
Rating
(124)
Level
Intermediate
Updated
Jun 26, 2012
Duration
2h 48m
Description

This course is designed to teach you the fundamentals of using PowerShell to manage your SQL Servers, as well as develop on them. In Module 1, we cover basic DBA tasks using just PowerShell. With Module 2, we provide an introduction to the two main tools for working with SQL Server, the SMO, or SQL Management Objects, and the SQL Server Provider. Module 3 will cover basic DBA tasks using both SMO and the SQL Provider. With Module 4 we switch to Developer mode and cover development using the SQL Provider. Module 5 continues the developer theme, this time using the SQL Management Objects. We finally wrap things up with Module 6, in which we go over a real world example of using PowerShell and SQL Server. We also cover the SQL PS mode of PowerShell, as well as how to make effective use of PowerShell from a SQL Server job.

About the author
About the author

Robert C. Cain (arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books.

More from the author
Kusto Query Language (KQL) from Scratch
Beginner
4h 33m
Jun 20, 2018
Azure PowerShell Playbook: Azure SQL
Intermediate
1h 4m
Jan 18, 2018
More courses by Robert Cain
Section Introduction Transcripts
Section Introduction Transcripts

Developer Tasks Using the SQL Provider
Hi, I'm Robert Cain. Welcome to the PowerShell and SQL Server course. This is Module 4: Developer Tasks Using the SQL Provider. This course is designed to teach you the fundamentals of using PowerShell to manage your SQL Servers as well as develop upon them. This module is one out of a series. In Module 1 we covered the basic DBA tasks using just PowerShell. With Module 2 we provided an introduction to the two main tools for working with SQL Server, the SMO or SQL Management Objects, and the SQL Provider. In Module 3 we covered the basic DBA tasks using both SMO and the SQL Provider. With Module 4 we'll switch to developer mode and cover development use in the SQL Provider. Module 5 continues the developer theme, this time using the SQL Management Objects. We'll finally wrap things up with Module 6, in which we go over a real world example of using PowerShell and SQL Server. We'll also cover the SQLPS mode of PowerShell as well as how to make effective use of PowerShell from a SQL Server job. Please treat this course as a set of building blocks. There are such a wide variety of needs and environments, it would be difficult, if not impossible, to provide a course that covered every minute aspect of PowerShell on SQL Server. Instead this course will provide a basis for you to grow and expand from. It will expose you to all of the basic techniques for interacting with your SQL Server. From that base you will be able to develop your own unique solutions crafted for your individual needs. In this module we'll expand on the knowledge from previous modules, but in the light of the needs of a database developer. We'll see how to do common tasks such as creating databases and tables. We'll insert data, then read it back out. Finally, we'll see how to remove those now unwanted databases from our system.

Developer Tasks Using the SMO
Hi, I'm Robert Cain. Welcome to the PowerShell and SQL Server course. This is module five, developer tasks using the SMO. This course is designed to teach you the fundamentals of using PowerShell to manage your SQL Servers as well as develop upon them. This module is one out of a series. In module one we covered the basic DBA tasks using just PowerShell. With module two, we provided an introduction to the two main tools for working with SQL Server, the SMO or SQL Management Objects and the SQL Server Provider. Module three covered the basic DBA tasks using both SMO and SQL Provider. In module four we switched to developer mode and covered development using just the SQL Provider. Module five continues the developer theme, this time using SQL Management Objects. We'll finally wrap things up with module six, in which we go over a real-world example of using PowerShell and SQL Server. We'll also cover the SQLPS mode of PowerShell as well as how to make effective use of PowerShell from a SQL Server job. Please treat this course as a set of building blocks. There is such a wide variety of needs and environments, it would be difficult, if not impossible, to provide a course that covered every minute aspect of PowerShell and SQL Server. Instead, this course shall provide a basis for you to grow and expand from. It will expose you to all of the basic techniques for interacting with your SQL Server. From that base, you will be able to develop your own unique solutions, crafted for your individual needs. In the last module, we saw how to use SQL Provider to create databases and tables, as well as how to work with data. In this module, we'll do the same types of things but now we'll use the SQL Management Objects to perform these tasks.

Real World Examples, SQL PS, PowerShell Jobs
Hi, I'm Robert Cain. Welcome to the PowerShell Sequel Server course. This is module six, Real World Examples of PowerShell and Sequel Server and the Sequel PS and PowerShell Jobs. This course is designed to teach you the fundamentals of using PowerShell to manage your Sequel Servers. This will also develop upon them. This module is one out of a series. In module one, we covered the basic DBA Tasks using just PowerShell. With module two, we provided an introduction to the two main tools for working with Sequel Server the SMO or Sequel Management Objects and the Sequel Provider. In module three, we covered the basic DBA Tasks using both SMO and the Sequel Provider. With module four, we switched to developer mode and covered development using the Sequel Provider. Module five continued the developer theme using the Sequel Management Objects. We finally wrapped things up with module six in which we go over a real world example of using PowerShell and Sequel Server. We also covered the Sequel PS mode of PowerShell as well as how to make effective use of PowerShell from a Sequel Server job. Please treat this course as a set of building blocks. There is such a wide variety of needs and environments it would be difficult, if not impossible, to provide a course that covered every minute aspect of PowerShell and Sequel Server. Instead, this course will provide a basis for you to grow and expand from. It will expose you to all of the basic techniques for interacting with your Sequel Servers. From that base, you'll be able to develop your own unique solutions, crafted for your individual needs. As our course wraps up, well start with a real world example of how to use both a Sequel Provider and a SMO to accomplish a task. We'll then look at something you may have heard about elsewhere, Sequel PS. Finally, we'll look at the right way to call PowerShell from a Sequel Server job.