How to Integrate Azure DevOps with Azure Synapse Studio (2022-01-26)

SQLServerCentral Newsletter for January 26, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to Integrate Azure DevOps with Azure Synapse Studio]( - [Testing a Flyway Database Migration]( - [Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing?]( - [From the SQL Server Central Blogs - Can I create a CI/CD pipeline to deploy Python Function to Azure Function App using Windows self-hosted Azure DevOps agent?]( - [From the SQL Server Central Blogs - Running Powershell code in Vim]( Question of the Day - [Fully Indexing Views]( The Voice of the DBA  Daily Coping Tip Focus on what’s good on a tough day I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Defining DevOps DevOps has become somewhat mainstream in that many companies, perhaps most, are talking about it or trying to implement some of the principles behind this software development approach. However, even as I talk with people that practice DevOps, I find the idea of what DevOps actually includes can vary widely among developers, even inside the same company. There are lots of definitions, and [this one]( caught my eye recently. It says, among other things, that there should be "increased collaboration among not only developers and operations staff but users." I like that there is some emphasis on working together, which is often the hardest part of changing how we build software. I find that many customers struggle because they end up adopting the technology tools, but fail to change how they communicate with others. Culture change is hard, and DevOps requires a culture change. The article is high level, but it does highlight some of the complexities of DevOps, mainly that lots of stuff is happening at once. Good reporting, tracking, and management are important, and unfortunately, lots of managers don't want to change their approaches to managing teams, which further complicates the process of building better software faster. Certainly, the need to have developers work with ops people, including supporting production systems, is important, but it never happens without management requiring and supporting this collaboration. The drawbacks to DevOps are many. Plenty of teams slap together code, getting the "faster" part but forget the "better" part, which means increasing and higher quality code over time. They embrace new tools, but they sometimes forget to run small experiments and change their approaches across time when they find better ways of building and operating code. Or they refuse to stick with current techniques or software because they crave change. Developers also find that some groups, like security and compliance departments, aren't ready for the pace of change, which can be frustrating. Ultimately, DevOps is better collaboration, getting all teams on board working together. Like many people rowing a boat, every group needs to align their work with others to ensure a smooth and successful journey. Actually creating that alignment requires strong leadership and culture, two of the hardest, and rarest, things to build inside many organizations. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to Integrate Azure DevOps with Azure Synapse Studio]( diponkar.paul from SQLServerCentral Learn how to connect your Synapse workspace to a Git repository. [External Article]( [Testing a Flyway Database Migration]( Additional Articles from Redgate Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers. [External Article]( [Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing?]( Additional Articles from SimpleTalk Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software. [Blog Post]( From the SQL Server Central Blogs - [Can I create a CI/CD pipeline to deploy Python Function to Azure Function App using Windows self-hosted Azure DevOps agent?]( Rayis Imayev from Data Adventures (2022-Jan-10) My short answer to this question is Yes and No. Yes, you can use Windows self-hosted Azure DevOps agent to deploy Python function to the Linux based Azure Function... [Blog Post]( From the SQL Server Central Blogs - [Running Powershell code in Vim]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold I’ve been mucking about with Vim a bit recently and recently found myself (for reasons unknown tbh) writing powershell scripts in it. Once I’d written a script, I would...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Fully Indexing Views I have an indexed view created in my SQL Server 2019 database. Can I create a full-text index on this view? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) A Key-value Cloud Database Which Amazon product provides a key-value NoSQL database? Answer: Amazon DynamoDB Explanation: DynamoDB is the NoSQL key-value store. Ref: Amazon DynamoDB - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2016 - Development and T-SQL [INSERT INTO Getting error on second record values]( - I am trying to create a table to use for testing. I have codded the script correctly based on many posts I have seen. It is giving me a error "Msg 102, Level 15, State 1, Line 21 Incorrect syntax near ','." I dont know what I did wrong.  /****** Object: Table [dbo].[Temp_UnMatching_Mail2] Script […] [Will insert process be blocked?]( - I am investigating a Query Timeout failure in our overnight batch. This is a simplified version of what has happening: The process that failed was trying to insert a row into a table (table_a): Insert table_a (col1,col2) VALUES ('Bah','Humbug') However, at the same time there was another process running which updated a different (table_b) but […] [Setting a variable from a multi-table Select]( - Hi all, I have a variable to declare, and this works: Declare @CopyFromUser Varchar(10) = (Select Top 1 Op_Ref From [MyServername].[TemperTest_BATON].[dbo].Op Where Op_Forename+' '+Op_Surname = @CopyFromUserFull) However, the Op_Ref could be in any combination of 5 databases with thankfully identical schema, so I need to select against them, the following is as far as I've […] Administration - SQL Server 2014 [how to find network issues for sql prod server?]( - Hi Experts, Is there a dirty trick or easy way to check network issues or slow network for the database server without using any 3rd party monitoring tool? Can we use continous ping from some quite non-prod server to prod sql server ? can we do that or is there a better way to do […] SQL Server 2012 - T-SQL [SQL Server Cursor,change qty of a column when the time is starting from midnight]( - We need to update the qty when the timestart is from midnight only,anything before should change to midnight time and accordingly the qty value should change.  SQL Server 2019 - Administration [Master Data Services (MDS) - list of users permissions]( - Hi all, I'm trying to get a list of all the user/entities permissions for my Master Data Services, for example UserA-------------Model A ----------Entity 123------------------Read permissions. UserA-------------Model A ----------Entity 456------------------Write permissions. I found a couple of scripts which mention mdm.udpSecurityPrivilegesSummaryGet but it doesn't reallye do the job. So I wondered if anyone had any query or […] SQL Server 2019 - Development [JSON building from configuration table]( - The attached file shows  the json schema - defined levels and the bottom section shows the JSON needed to be built I want to write a TSQL query which can read the JSON schema and built the JSON shown Please advise Thanks  [build groups by finding specific "first and last records"]( - Hello, After receiving great help here, I am coming back for a little follow-up. I need to refine the previous question by adding an additional step which goes down to this: find the first "startSignal" in an ordered table and match it with the first "stopSignal" to form a group there can be multiple round-trips […] [SSRS Changing Output Location to a different location]( - We are in the process of migrating a customer to our environment. This customer has a lot of SSRS Subscriptions that are writing out to a file share on a particular server. Is there a way to do a mass change so that the location can be changed to our Server's file share without having […] SQL Server Newbies [Will my Query affect any rows in the DB??]( - Dear All, Hope you are doing well. I am really new to SQL and was wondering whether anyone could just quickly confirm somethinng for me. I want write an SQL Query that would create an output which I want to export as a csv. I have already created the query which uses SELECT, CASE, FROM […] [Will my Query affect any rows in the DB??]( - Dear All, Hope you are doing well. I am really new to SQL and was wondering whether anyone could just quickly confirm something for me. I want write an SQL Query that would create an output which I want to export as a csv. I have already created the query which uses SELECT, CASE, FROM […] SQL Azure - Administration [Azure VM backups, database snapshot backups]( - I have inherited two Azure VMs each hosting a marketplace SQL 2012 instance. Both VMs receive daily application-consistent VM backups. So far so straightforward. What I don't understand is that on one VM all of the databases show (on the logs and in msdb) as having snapshot backups at the same time as the VM […] Amazon AWS and other cloud vendors [Drive Allocation with FSx]( - We're in the process of planning the migration of our whole platform into AWS. The current thinking is that we will host our instances on EC2 and use FSx as the file system. However, I can't find anything about whether a separate FSx instance is recommended for each drive needed by SQL Server. It's good practice to […] General [How to practice OOP in C++ effectively?]( - I am currently writing a desktop application with Qt and C++. While I have learned some things about OOP from working on this project, I do not feel I am really using the full potential of OOP. I am not creating a lot of my own classes. I generally don't have an idea of what […] Replication [Updating Transnational Replication with Publisher Schema updates]( - Hi, We have just incorporated 2017 Transactional Replication into our product for Archiving purposes. Schema updates are enabled. On each product update we run a set of Db Schema migrations (via application-hosted Fluent Migrator SDK) on the Publisher database. However, Transnational Replication does not support all schema changes. For example, adding Identity columns to a […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -