PowerShell Archives - {coding}Sight https://codingsight.com/category/languages-coding/powershell/ Blog for SQL Server DBAs and Developers Fri, 14 Jul 2023 15:48:09 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png PowerShell Archives - {coding}Sight https://codingsight.com/category/languages-coding/powershell/ 32 32 How to Check Status Of SQL Agent Jobs using PowerShell Tool https://codingsight.com/powershell-tool-to-get-the-status-of-sql-agent-jobs/ Fri, 21 May 2021 07:48:36 +0000 http://codingsight.com/?p=14013 From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential thing in my personal toolset. That’s why I’m here at CodingSight to share my very first PowerShell tool, of many, I truly hope, that any SQL Server DBA can use …

The post How to Check Status Of SQL Agent Jobs using PowerShell Tool appeared first on {coding}Sight.

]]> How to Automate the Process of SQL Server Database Schema Synchronization https://codingsight.com/how-to-automate-the-process-of-sql-server-database-schema-synchronization/ Sun, 19 May 2019 23:04:33 +0000 https://codingsight.com/?p=6700 The goal Keeping two databases in sync is a task we often encounter when working on SQL database development and maintenance. One particular case is this – the versions of a database present on testing and development environments need to be consistently synchronized to make sure that tests are running on the most recent version. …

The post How to Automate the Process of SQL Server Database Schema Synchronization appeared first on {coding}Sight.

]]> Automatic gathering of SQL Server configuration by using PowerShell https://codingsight.com/automatic-gathering-of-sql-server-configuration-by-using-powershell/ Fri, 26 Apr 2019 09:34:56 +0000 https://codingsight.com/?p=6672 At present, the gathering of SQL Server configuration information is no longer a problem— the opportunities to add value through an update and to build a stable database environment exist permanently. Most of the third party tools provide the appropriate functionality in order to capture the software market. Through this guide, you’ll figure out the …

The post Automatic gathering of SQL Server configuration by using PowerShell appeared first on {coding}Sight.

]]> Execute Powershell in SSIS Using C# https://codingsight.com/execute-powershell-in-ssis-using-c/ Wed, 12 Jul 2017 09:42:00 +0000 http://codingsight.com/?p=1781 Introduction PowerShell is a Shell included in Windows to automate tasks in the operative system and other applications like SQL Server, SharePoint and Internet Information Services. You can create reports, start services, check the hard drive space, verify the RAM and more. PowerShell can now be installed in Linux, Docker, and Mac. You can use …

The post Execute Powershell in SSIS Using C# appeared first on {coding}Sight.

]]>