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
7,255 reads
Vishnu Gupthan
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
2,489 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)
9,782 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.
2020-06-24
1,706 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
2,405 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
3,041 reads
Fixing ‘A required Privilege is not held by client’ Error
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
13,894 reads
Scheduling a PowerShell Script Using SQL Server Agent
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
20,369 reads
Install Visual Studio 2015 in Server without Internet Connection
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
7,075 reads
Blogs
2020 Advent of Code – Day 5
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
What’s new with Power BI?
By James-Serra
At the Microsoft Business Applications Summit 2021, a ton of new features for Power...
Forums
Availability Group with Replication
I have configured availability group for automatic failover with synchronous mode. So that way...
Geocoding in SQL Server - do I need C# for it?
I've been digging around playing with spatial maps in SQL Server. I've read a...
Ask SSC