Accessing SQL Server Databases from PowerShell Год выпуска: 4/10/2017 Производитель: Pluralsight Сайт производителя: pluralsight.com/courses/sql-server-databases-powershell Автор: Vlad Catrinescu Продолжительность: 55m Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: PowerShell is an awesome tool, and as an IT pro or a Developer you probably want to use its powerful automation potential to automate your own tasks. SQL Server is the database software of choice for organizations running in the Microsoft ecosystem. Instead of storing information from your PowerShell scripts in CSV or text files, you can store this information into a SQL Database and then use SQL Server's powerful reporting tools to create beautiful looking reports and historical data. In this course, Accessing SQL Server Databases from PowerShell, you'll learn how to use PowerShell to read and write data from/to a SQL Server database. First, you'll discover how to get the required PowerShell Module and how to connect to both a local and a remote SQL Server. Next, you'll explore how to use PowerShell to read data from a SQL Table. Finally, you'll learn how to use PowerShell to write information to an existing, or a brand-new SQL database. When you're finished with this course, you'll have the skills and knowledge of PowerShell needed to access SQL Server databases from PowerShell. PowerShell - отличный инструмент, и как ИТ-разработчик, так и разработчик, вы, вероятно, захотите использовать свой мощный потенциал автоматизации для автоматизации своих собственных задач. SQL Server - это программное обеспечение базы данных для организаций, работающих в экосистеме Microsoft. Вместо хранения информации из ваших сценариев PowerShell в CSV или текстовых файлах вы можете хранить эту информацию в базе данных SQL, а затем использовать мощные средства отчетности SQL Server для создания красивых отчетов и исторических данных.
Содержание
Course Overview Course Introduction Connecting to SQL Server Reading Data from a SQL Database Writing Information into a SQL Database Course Conclusion
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
