This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques to build applications using SQL Server tools. The first article of the series covers the rudimentary DevOps concepts and discusses on a high level, the overview of SQL Server tools that can be piped for DevOps operations.
In this article, I will explore various SQL tools. I will be discussing in detail about each of the following tools in the upcoming articles:
- Sqlcmd
- Bcp
- SqlPackage
- MSSQL-Scripter
- SQL Operations Studio
For the first installment of this new series, I will give you an overview of DevOps and highlight how SQL Server tools help.
The recent trends under the umbrella of DevOps (Development and Operations) led to the birth of various new techniques to fulfill the complexities of today’s needs through Continuous Integration (CI) and Continuous Deployment (CD) over a wide range of diverse enterprise applications. DevOps is a combination of two teams — development as well as operations — and it’s a whole new value stream for delivery. There is a direct correlation between automation of software delivery processes and success with customers.
We’ll introduce ourselves to these tools in this article, and dive deeper into each of them in upcoming articles.
Further reading
Please share your thoughts in the comments section. I would love to hear and learn from you as well.
Happy Learning!!
