Sometimes database professionals need to perform specific tasks at the operating system level. These tasks can be like copying, moving, deleting files and folders. A use case of these tasks might be removing the old backup files or copying backup files to a specific directory after a particular time. In SQL Server, we can use xp_cmdshell extended stored procedure to execute commands directly in the Windows command prompt(CMD). You need a sysadmin role or proxy account configured to use this extended procedure. We can also use the SSIS package for the file transfer, but it also requires you to build a package with the relevant tasks.
Read more »Rajendra Gupta
As an MCSA certified and Microsoft Certified Trainer in Gurgaon, India, with 13 years of experience, Rajendra works for a variety of large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation. He is the author of hundreds of authoritative articles on SQL Server, Azure, MySQL, Linux, Power BI, Performance tuning, AWS/Amazon RDS, Git, and related technologies that have been viewed by over 10m readers to date.
He is the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups. Based on his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
He is the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups. Based on his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Direct Query Mode in Power BI for Azure Analysis Services - April 19, 2021
- Azure Analysis Services and Power BI Live connections - April 14, 2021
- An overview of Power BI data models - April 12, 2021
An overview of distributed SQL Server Always On Availability Groups
August 21, 2020This is the 12th article in the series of SQL Server Always On Availability Groups.
Read more »
Configure a SQL Server Always On Availability Group on the domain-independent Failover Cluster
August 13, 2020This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.
Read more »
Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups
August 12, 2020This is the 10th article in the series for SQL Server Always On Availability Groups.
Read more »
Automatic Page Repair in SQL Server Always On Availability Groups
August 5, 2020This is the 9th article in the series of SQL Server Always On Availability Groups.
Read more »
Database-level health detection in SQL Server Always On Availability Groups
July 30, 2020This is the 8th article in the series for SQL Server Always On Availability Groups.
Read more »
Add or remove a node from SQL Server Always On Availability Groups using T-SQL scripts
July 29, 2020This is the 7th article in the series of SQL Server Always on Availability Groups.
Read more »
Configure Managed Service Accounts for SQL Server Always On Availability Groups
July 24, 2020This article is a 6th article in the series for SQL Server Always On Availability Groups. It covers the configuration of the group managed service account (gMSA) for SQL Services.
Read more »
Add a new node into existing SQL Server Always On Availability Groups
July 23, 2020This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups.
Read more »
Visual Studio Code (VS Code) integration with Git Source Control
July 22, 2020This article explores Visual Studio Code integration with Git Source Control.
Read more »
Visual Studio Code (VS Code) for SQL Server development
July 16, 2020In the previous article, Getting started with Visual Studio Code (VS Code), we took a detailed overview of the popular code editor. It supports various programming languages t-SQL, Python, PHP, AWS CLI, PowerShell, etc. We need to use extensions in the VS code to work with these languages. For example, if we open the T-SQL script, it recommends you for the below extension.
Read more »
Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups
July 15, 2020In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations.
Read more »
Launch a static website using AWS S3 buckets
July 15, 2020This article explores the AWS S3 bucket to configure a static website.
Read more »
Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups
July 14, 2020This article explores the configuration of Windows failover clusters, storage controllers, and quorum configurations for SQL Server Always On Availability Groups.
Read more »
Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups
July 13, 2020In this series for SQL Server Always On Availability Groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In the article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016, we configured three virtual machines with their networking configurations.
Read more »
A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016
July 13, 2020In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration.
Read more »
Working with Git components in Azure Data Studio
July 9, 2020This article gives an insight into the terms in the Git repository of Azure Data Studio. In the previous articles, we learned the following things:
Read more »
Getting started with Visual Studio Code (VS Code)
July 8, 2020Visual Studio Code is a popular text editor or code editor to write queries and codes for developers. It is popularly known as VS code. It can highlight and format the code for quick development and understanding purposes.
Read more »
Integrating Azure Data Studio with Git and GitHub
July 3, 2020In the last article, Source Control using Git in Azure Data Studio (ADS), we explored the following topics:
- The requirement of Source control for SQL scripts
- Git installation on Windows
- Integrate Git in Azure Data Studio
- Create Git repository, add SQL scripts, modify files, commit into source control
- View different versions using the Git timelines
In this article, we will take a step forward and integrate Git installed locally on the GitHub.
Read more »
Explore the SQL query Hint OPTION (FAST N)
July 2, 2020In this article, we will introduce SQL queries hint and will analyze the OPTION(Fast ‘N’) hint in detail.
Read more »
Explore SQL Server Index Properties in SSMS
July 2, 2020This article gives you an insight into SQL Server Index properties in SSMS.
Read more »
Source Control using Git in Azure Data Studio (ADS)
July 2, 2020Azure Data Studio is a tool for both developers and database administrators with exciting features. You can install ADS on both Windows and Linux platforms. You can go through various Azure Data Studio articles on SQLShack to be comfortable with the tool and its features.
Read more »
The SQL Server Assessment Extension for Azure Data Studio
June 30, 2020Azure Data Studio extensions enable adding new functionality for development and administrative tasks. It is an open-source functionality and allows Microsoft as well as third party extensions using Marketplace. We explored a few useful extensions in the Azure Data Studio category of articles.
Read more »
Different ways to search for objects in SQL databases
June 29, 2020This article explores various ways to search for database objects in SQL database such as tables, stored procedures, functions, and views.
Read more »
AWS Launch Wizard for quick SQL Server Always On deployments
June 29, 2020SQL Server Always On is a high-availability and disaster recovery solution. We can use multiple secondary replicas for configuring database backups, redirect read requests to offload primary instance load.
Read more »