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,140 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,475 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,736 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,766 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,167 reads
Install Visual Studio 2015 in Server without Internet Connection
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
7,051 reads
Blogs
Basic XML Queries–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)
By kleegeek
This past week I had a great Client ask an even greater question, and...
Query Compile Time
A question that came up recently was how to track the query compile time....
Forums
SELECT column based on parameter
Is there a way in the same SELECT statement to show different columns without...
Restore WITH RECOVERY freezing on source DB after tail of log backup
Hello everyone, I've encountered this scenario twice so far and I still don't understand...
SQL SMO property to determine if server is named or default instance
I'm using my registered server list to generate a collection of servers in powershell. The...
Ask SSC