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
1,617 reads
Vishnu Gupthan
Install SSMS using Powershell DSC
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
2024-01-31
1,951 reads
Advanced SQL Server installation using Powershell DSC
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
2,541 reads
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
4,860 reads
Configure Extensible Key Management Using Azure Key Vault - Level 3 of the Stairway to TDE
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)
6,401 reads
Scheduling SQL Scripts Using Jenkins
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
2020-12-22
25,899 reads
Scheduling PowerShell 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, 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,974 reads
Configuring SQL Server Always on Azure Servers(Iaas)
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,508 reads
Restore a Backup of a TDE Database to Another Server: Level 2 of the Stairway to TDE
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
35,373 reads
Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE
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
8,210 reads
Blogs
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Forums
process records in loop
I'm only processing 50,000 records not everything from the Table where there are 250,00...
The Marked Transaction
Comments posted to this topic are about the item The Marked Transaction
What happens when we drop a column on a SQL Server table? Where's my space?
Comments posted to this topic are about the item What happens when we drop...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers