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
6,247 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,349 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,233 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
12,296 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
18,258 reads
Install Visual Studio 2015 in Server without Internet Connection
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
6,815 reads
Blogs
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Daily Coping 3 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Forums
How to update table partwithcompany column name company id by companyid for max
How to update table partwithcompany column name company id by companyid for max partid...
Appttime add with duration how to get endtime please
Hoe to get appt_time+duration = end_time can you please help on this
SQL Sever becoming Non Responsive
SQL server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....
Ask SSC