We help IT Professionals succeed at work.

training on Azure CI/CD

28 Views
Last Modified: 2020-05-17
hi,

any way to learn Azure CI/CD, what is that? how and why we can use it ? what is the difference between SQL Azure and on on-pre SQL server in this area ?

it seems more on development size!
Comment
Watch Question

Udara PeirisSystem Engineer
CERTIFIED EXPERT

Commented:
Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
SQL Azure is a topic inside Azure contains some serverless sql database technology:
  • Logical SQL Server
  • Azure SQL Database (single or elastic pool)
  • Azure Synapse Analytics (Data Warehouse)
  • Azure SQL Managed Instance

And you can use a simple Virtual Server resource install a Windows Server and SQL Server on it. This is an on-prem SQL Server however the host virtual machine is in Azure.
marrowyungSenior Technical architecture (Data)

Author

Commented:
Máté Farkas,

I am focusing on Azure CI/CD at this moment, please share.


marrowyungSenior Technical architecture (Data)

Author

Commented:
Udara Peiris,

I am still not sure what and why and when we need CI/ CD, any idea?
e.g. : why we need CI/CD pipeline ?

Udara PeirisSystem Engineer
CERTIFIED EXPERT

Commented:
Hi marrowyung,
You will be able to learn them by referring above as I think.
Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
In fact, in terms of CI/CD Azure SQL does not differ from an on-premise system.
So if you have an existing CI system you can still use it for Azure SQL.
Because for example an Azure SQL databases is a simple SQL Database and you can connect to it with all usual tools (ADO.NET, Native SQL Client, SSMS, sqlcmd.exe, bcp.exe).
You can continue to use SSMS, Visual Studio, Git, Red Gate Source Control, ApexSQL, Atlassian BitBucket and Bamboo or any other CI/CD control software.

marrowyungSenior Technical architecture (Data)

Author

Commented:
So if you have an existing CI system you can still use it for Azure SQL.

as I am not a developer I do not have much concern on devops and what CI system on-premise commonly use ?

You can continue to use SSMS, Visual Studio, Git, Red Gate Source Control, ApexSQL, Atlassian BitBucket and Bamboo or any other CI/CD control software.

so CI/CD is ALSO source control program? what I am learning is , CI/CD is just to open Auzre on Devops feature ! it helps to move data/packge from one platform to other platform (dev - > UAT to pro) automatically !

nothing else ?


Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
No, CI = Continuous Integration; CD = Continuous Delivery (of solutions).
This is not just a set of tools but a development principle.

Let's see what is the full cycle in terms of database development:
1. Users report any issue or development request >>> Atlassian JIRA
2. Developers work on the issue >>> New branch in Git > Red Gate Source Control > Commit/Merge changes
3. Devops create a release and deploy it to a Test Environment >>> Atlassian Bamboo
4. Users test new changes on a Test Environment and sign it off >>> Atlassian JIRA
5. Devops deploy the same release to a Production Environment >>> Atlassian Bamboo
6. Developers create or fix documentation of the product >>> Atlassian Confluence

But you can use other toolset (from Apex, Devart, Redgate, Microsoft etc.).
marrowyungSenior Technical architecture (Data)

Author

Commented:
one thing, I applied for the 1 year free Azure service, any way for me to try work on the Azure data factory and CI/CD?

This is not just a set of tools but a development principle.

yeah Devops !

Let's see what is the full cycle in terms of database development:
1. Users report any issue or development request >>> Atlassian JIRA
2. Developers work on the issue >>> New branch in Git > Red Gate Source Control > Commit/Merge changes
3. Devops create a release and deploy it to a Test Environment >>> Atlassian Bamboo
4. Users test new changes on a Test Environment and sign it off >>> Atlassian JIRA
5. Devops deploy the same release to a Production Environment >>> Atlassian Bamboo
6. Developers create or fix documentation of the product >>> Atlassian Confluence

Excellent,  this is good for me to learn quickly !

But, what is Atlassian JIRA ? a product? https://www.atlassian.com/software/jira?&aceid=&adposition=&adgroup=95003642849&campaign=9124878690&creative=415542751621&device=c&keyword=%2Batlassian%20%2Bjira&matchtype=b&network=g&placement=&ds_kids=p51394879813&ds_e=GOOGLE&ds_eid=700000001558501&ds_e1=GOOGLE&gclid=EAIaIQobChMIwPmDje-66QIVVamWCh3TqwUAEAAYASAAEgLTy_D_BwE&gclsrc=aw.ds  ?

It seems you use Atlassian to do devops a lot ?

3. Devops create a release and deploy it to a Test Environment >>> Atlassian Bamboo
4. Users test new changes on a Test Environment and sign it off >>> Atlassian JIRA

devops will notisfy user to test it and assuming they know how to test it ?

 Devops deploy the same release to a Production Environment >>> Atlassian Bamboo
6. Developers create or fix documentation of the product >>> Atlassian Confluence 

Devops automatically tell developer the test is done and the process has automatically deploy to production too and notisfy the developer to document it?





Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
What I describe you is a fully controlled and a complete cycle of CI/CD.
But you can simplify and you should not use so many Atlassian products. I have experience with those tools but you can choose other ones.
You can skip ticket management (Jira), automated deployement and release management (Bamboo) and documentation (Confluence).
For the simplest environment you need a database source control tool (Red Gate Source Control, ApexSQL Source Control, DevArt SQL Database Source Control or Microsoft TFS) and a repository manager (SVN or GitHub).
marrowyungSenior Technical architecture (Data)

Author

Commented:
What I describe you is a fully controlled and a complete cycle of CI/CD.
understood
You can skip ticket management (Jira)

      Users report any issue or development request >>> Atlassian JIRA 

automated deployement and release management (Bamboo)

 but this is the heart of Devops, right ?

a repository manager (SVN or GitHub).

is the tools/service to auto deploy and test release to other platform than dev ?

You can skip ticket management (Jira)
basically  what ticketing system can intergrate with Azure data factory with CI/CD ?


Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
You have to know that Azure Data Factory is a different story because you don't have full control of the source.
But to answer currently ADF can use only GitHub for repository.

If you don't want or cannot have DevOps then Developers can be in a DevOps role.
In this case a developer user can deploy changes/release to database with the source control tools.
marrowyungSenior Technical architecture (Data)

Author

Commented:
If you don't want or cannot have DevOps then Developers can be in a DevOps role.

yes, but it is just a process, not a software. it is all about developement stuffs, right ?
In this case a developer user can deploy changes/release to database with the source control tools.
in this case they are the owner, right?

You have to know that Azure Data Factory is a different story because you don't have full control of the source.
what do you mean, please clarify more on this. like which part of Devops Azure Data factory is presenting and which one is not, tks.

Get access with a 7-day free trial.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.