MuleSoft Integration with Azure Key Vault (2023-06-02)

SQLServerCentral Newsletter for June 2, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [MuleSoft Integration with Azure Key Vault]( - [SQL WHERE LIKE to Construct More Efficient Queries]( - [Flyway and SSDT: Merging Work from a Branch]( - [From the SQL Server Central Blogs - Running SQL Server in a container with sqlcmd]( - [From the SQL Server Central Blogs - Restore One Backup From Many in a Device–#SQLNewBlogger]( - [Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance]( Question of the Day - [Contained AG Databases]( The Voice of the DBA  Better Communication Through Less Messaging I have learned to really appreciate and enjoy Slack as a messaging tool. It's something I use daily, and a place where many inside my company communicate about all sorts of issues. There certainly can be an overload of channels, but for me, I add and prune channels regularly and it's a good way to segregate conversations. I didn't feel that way when I started. At first, I resisted using it. Now I couldn't imagine not having it, but not everyone feels the same way. There's an article about a SaaS provider [moving their company off Slack]( and instead using the Basecamp project management platform and keeping communications inside there. Why? They say they have less meetings, less interruptions, less direct messaging, and more productivity. Interesting conclusions. I certainly can see that some people might find Slack to be chatty, and there are definitely lots of channels devoted to non-work items. There can be a lot of unread channels from me, but I don't know that I think we would have less meetings without Slack. We have various work tracking and productivity tools Personally, I don't have a lot of DMs, and I like that I can see unread channels , ignoring them when I'm busy and looking at them when I have time. I can also just mark as read when I want to declare thread bankruptcy. I usually don't find Slack to be too intrusive to my day. I work fairly independently and asynchronously, as I'd expect many developers to work. I also don't know that it causes more meetings, at least not for me. There is a fairly high bar to opening a meeting and I find many people don't bother. Instead, we can have a discussion, in real time or across days, that deals with a topic. What do you think? If you use Slack (or Teams/etc.) is this a drain on productivity or an enhancer? I think the latter. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [MuleSoft Integration with Azure Key Vault]( Sukanya Konatam from SQLServerCentral Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As part of the data integration, the MuleSoft Anypoint Environment needs source system and target system login credentials stored in the platform, making it a vulnerability. The storage is vulnerable to attacks from cyber-criminals. This vulnerability can arise […] [External Article]( [SQL WHERE LIKE to Construct More Efficient Queries]( Additional Articles from MSSQLTips.com In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries. [External Article]( [Flyway and SSDT: Merging Work from a Branch]( Additional Articles from Redgate In an SSDT-Flyway hybrid development, the required database changes may be delivered as a DACPAC, but we get far more control over merge operations and deployments if they are done using Flyway migrations. This article demonstrates how to automate as much as possible of the work required to extract a Flyway-compatible migration script from a DACPAC. [Blog Post]( From the SQL Server Central Blogs - [Running SQL Server in a container with sqlcmd]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold One of the options that I completely missed with the new go-sqlcmd CLI tool is the ability to spin up a container running SQL Server. Let’s have a look... [Blog Post]( From the SQL Server Central Blogs - [Restore One Backup From Many in a Device–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA I wrote recently about finding multiple backups in a file. This post looks at how to restore one of those. The one you choose. Another post for me that... [Practical Database Auditing for Microsoft SQL Server and Azure SQL]( [Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance]( Site Owners from SQLServerCentral Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss   Question of the Day Today's question (by Steve Jones - SSC Editor):  Contained AG Databases Which system databases are included in a SQL Server 2022 Contained Availability Group? 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) Full Managed Instance Backups As of April 2023, if I have an Azure SQL Managed Instance, how often are the automated full backups run on my databases? Answer: once a week Explanation: Managed Instance performs one full backup a week for each database. Ref: Automated backups in Azure SQL Managed Instance - [ [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 2017 - Administration [Best migration approach]( - Hi Colleagues, I am considering the across-the-wire migration method to SQL Server 2017. However, my source is an SQL Server 2014 Availability group with three nodes, one asynchronous. Is launching a new VM on the remote site and the same cluster to migrate this first node a good idea? Later, demote the old node, then […] SQL Server 2017 - Development [Need help with a Query logic]( - I have a table which tracks of activity when users from one specific app login and logout. But I have seen some cases where let's say a user logins at 11:40 on March 24th and then logins again at 11:55 on the same day without logging out. The application doesn't allow that but I am […] SQL Server 2016 - Development and T-SQL [MS SQL Query - JOIN mutiple tables but it duplicates results]( - MS SQL Query - JOIN multiple tables but it duplicate results; Good day! it duplicate results when i run this query below;  - if i comment out "LEFT JOIN BBI$Barcodes AS BAR", the query results are correct. Thank you! Administration - SQL Server 2014 [Database backups going to device]( - Hi Friends, How can I know the exact device where my backups are going on? I only see {67BAB2D0-A1DC-44F8-BF73-EBAFD5AE3220}16 as one device. However, I do not find out where are my backup files located. Some databases are going to a particular drive, but others are using that expression, Thank you, Best Regards, SQL Server 2019 - Administration [Does Query Store persist data across an upgrade from SQL 2016 to SQL 2019]( - This may be somewhere in the docs, but my Google-fu wasn't able to find it... We're testing an upgrade from SQL 2012 to SQL 2019, but tests indicate performance in SQL 2019 with compatibility level 110 is worse than native SQL 2012 for some critical queries and switching to compatibility level 150 (native 2019) is […] [adaptive memory grants]( - Hi we have a sql server we use as a data warehouse. It has 1TB of RAM but still suffers from memory pressure. Looking at the plans there are excessive memory grants. I changed the compatibility level to 150 to take advantage of the Adaptive Memory Grants. It's been in place for around a month […] [Upgrade to SQL2019 from 2012 and everything is slow - what to look for?]( - We have recently started a process of planning the upgrade of our four-node SQL2012 availability group to SQL2019. The main database is pretty large (a few TB) and we've spent years tuning the SQL to get the performance to where it needs to be such that huge complex procedures absolutely fly on SQL2012. We've had […] SQL Server 2019 - Development [T-SQL Query Help]( - Hello, I am working on one of the SQL Logic, i need help to build core logic to do the rest, below is ddl, create table #x1 ( task varchar(100), subtask varchar(100), status varchar(100) ) insert into #x1 values ('a','x','completed') insert into #x1 values ('b','l','overdue') insert into #x1 values ('b','m','completed') insert into #x1 values ('b','n','not […] [SSIS package configuration connecting to design-time instance]( - I have an SSIS package which uses SQL Server Configurations. This uses an expression-based, project connection manager but is connecting to the instance at development time as opposed to the instance at run time. However the remainder of the package is using the run time version of the connection manager. The expression-based values come from […] [MSSQL STRING_AGG() Conversion failed when converting the varchar value to int.]( - Short story, I needed to convert a table insert/update trigger to a Service Broker task. That's not the issue but it might help explain the structures being used. The INSERTED table is used but is passed from the Trigger as XML variable to the SP and executed asynchronously under the Broker Service. Again this is […] [Query to Insert Data Based on CustomerID from one table to another]( - Hello All, Below is the my existing table structure from which I need to insert records to a new table I need a query to insert records into a new table for each customer for same date.  For example considering above data structure query should insert records into a new table as below based on […] SQL Azure - Administration [Scheduled Jobs in Azure SQL Databases Failing for Auto-Paused DB]( - Hello! I have somewhat similar kind of PowerShell script which executes the stored procedure on a schedule. Since the database is set to auto-pause, job is failing at times with the error message below: "Exception calling "Open" with "0" argument(s): on server is not currently available. Please retry the connection later. " How can I […] Integration Services [Visual Studio 2019 Pro won't load my projects]( - HI all, For some reason I've been having issues with VS pro opening up my projects that are in my SIS Solution. I'm NOT having the same problem with my SSRS solution. That opens fine. I have both Solutions/projects under Azure Devops/Git. I had this issue about 2 weeks ago and I was able to […] SQL Server 2022 - Administration [Allow only encrypted connections.]( - Hi In SQL22, Is there a way to allow only / force encrypted connections? I have 'force encryption' on and have cert installed:  But when I connect via SSMS I can unselect ' Encrypt Connection' and it connects. My understanding is that means that it is allowing non-encrypted connections: How do I make my […] SQL Server 2022 - Development [VNN and unique ports]( - Background TLDR: We are creating non-prod WFC clusters. Each node in the cluster will have a handful of sql instances and each instance will have many Always on groups separating logic database sets.  The Issue: I did some testing and while the warning about 1433 on VNN creation with unique IP's per VNN is […]   [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -