1 Before you begin
1.1 Why data professionals can’t afford to ignore PowerShell
Data is now one of the most valuable assets in the world, so data professionals need a broad set of skills and are expected to be able to accomplish a wide number of tasks, including the following and many more:
-
Build SQL Server instances
-
Develop extract, transform, and load (ETL) solutions
-
Ensure SQL Server instances are correctly configured
-
Monitor and respond to alerts
-
Troubleshoot performance and access issues
-
Perform OS and SQL upgrades
-
Deploy changes to schemas
-
Evaluate index usage and settings
In the process of performing our role, we interact with a ton of technologies: SQL Server, virtualization (Hyper-V or VMware), operating systems (Windows ...
Get Learn dbatools in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
