Install SQL Server using Powershell Desired State Configuration (DSC)
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
2,769 reads
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
2,769 reads
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
2022-05-18 (first published: 2020-06-24)
5,505 reads
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
2020-12-22
23,746 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
3,648 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,000 reads
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
2020-05-20
27,691 reads
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
2020-04-29
7,234 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
30,253 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
36,444 reads
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
8,387 reads
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
In this series of blog posts, we’re diving into how to use the Pure...
Hello Gurus for one use case we converted the code to use temp tables...
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
I am considering implementing an Azure Postgres DB for use in a part of...