SQL Server Patching Using PowerShell DSC
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
2024-04-05
2,605 reads
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
2024-04-05
2,605 reads
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
2024-01-31
2,383 reads
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
2023-11-22
3,397 reads
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
5,772 reads
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
2020-12-22
26,922 reads
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, OSX, and Windows) and the processes related to the applications that run on those operating systems. For system administrators (DBAs\Wintel Admins), creating PowerShell scripts is a […]
2020-12-10
4,103 reads
Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.
2020-09-04 (first published: 2018-12-06)
13,780 reads
This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.
2018-07-16
36,591 reads
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
2018-05-22
39,225 reads
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
8,631 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers