Part -1 : Managing SQL Server with DBA Tools Introduction to DBATools DBATools is an open-source, free, community-driven PowerShell module that effectively helps the DBAs manage and automate different SQL Server tasks. The dbatools module is designed to simplify the management of SQL Server instanc...
Install SQL Server using Powershell Desired State Configuration (DSC) Introduction As per Microsoft, Desired State Configuration (DSC) is a management platform in PowerShell that enables you to manage your IT and development infrastructure with configuration as code. DSC allows administrators to de...
Scheduling a PowerShell Script Using SQL Server Agent Automation with SQL server Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating sys...
Scheduling SQL Scripts Using Jenkins Introduction There are scenarios where you need to schedule the SQL Server scripts without using SQL Server Agent, like when you use SQL Server Express edition. Mostly, the DBAs in this case is will choose to use the Windows task scheduler. However, Jenkins tool...
Scheduling PowerShell Using Jenkins Start automation using Jenkins Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, O...