Translate Text Data using Azure Cognitive Services (2023-01-11)

SQLServerCentral Newsletter for January 11, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Translate Text Data using Azure Cognitive Services]( - [Subqueries in MySQL]( - [Useful Commands for Snowflake Transactions]( - [From the SQL Server Central Blogs - Power Automate: Sending Emails As A Different User]( - [From the SQL Server Central Blogs - Running SQL Server on Apple Silicon]( Question of the Day - [Replacing text]( The Voice of the DBA  Daily Coping Tip Do a kind act for someone else today to brighten their 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. Do Hybrid Conferences Work? The pandemic forced many events online, which has worked fairly well inside many companies and certainly spurred some technological advances in how we meet and share information. With the pandemic ending or at least entering an [endemic]( phase, there are many live events now, as well as some attempting to embrace a hybrid philosophy. I went to two conferences in 2022 that embraced the hybrid concept: [SQL Bits]( and the [PASS Data Community Summit](. I was just a speaker at the former, and mostly a speaker at the latter, though I saw quite a bit of the behind-the-scenes action from the organizers' perspective at the Data Community Summit. During SQL Bits, I watched a hybrid session with a remote speaker. I also presented two sessions with a moderator that was engaged with the virtual attendees. The experience watching a remote presenter wasn't great, and the audio at times was hard to hear. I spoke with a few virtual presenters who also noted they struggled to hear people in the room. All in all, it felt somewhat live, but I felt disengaged from the speaker, and missed a feeling of interaction from the picture-in-picture of the individual inside their screen. At both events, the sessions I presented with a moderator went well, and I felt the moderator could be a good proxy for people online. I also know that I have little visibility into what people online see and hear. I've gone out of camera range at times, and I rarely know if the virtual audience can see my entire screen, me, or some combination of both, much less hear what I'm saying. After the Summit,I read [a post about hybrid events from Andy Galbraith](, which made a lot of sense to me. I enjoyed seeing and speaking with Andy in Seattle, and I know that our interactions would have been fewer, less satisfying, and less connected if we were virtual using [Spatial.IO](. Spatial has been the best online platform I've seen for groups, but it's still not great. Like Andy, I don't want to pick a fight, but I have a few perspectives on why I don't think hybrid works for the most part. First, it's resource expensive. The equipment, people, and time spent putting the show together make it less attractive for most events, even paid. The people managing AV find it more than twice as hard and don't like the added stress. Second, the interaction is still very limited, and when we do try to interact, it's full of pauses and stutters in conversation that make this much worse than in person. Even a proxy adds delays and a very un-natural feeling to the engagement. Lastly, we don't really create the same engagement as the view from a virtual event is very limited, and one can't really engage with other attendees in the same way we can in person. Not only in sessions but before/after and in other spaces. I appreciate the accessibility aspect of virtual attendance. I think we ought to have more virtual events. I was glad we had a few virtual SQL Saturdays in 2022 and I'd like to see more in 2023. If you want to put one on, especially with a niche technology, please [reach out](mailto:admin@sqlsaturday.com). I'd love to see more of these events. I just don't think hybrid works. Not at large conferences, not at SQL Saturday, and not at user groups. My view is you should choose one or the other. Make it in-person or virtual. That being said, I do like the broadcast efforts from large conferences. I thought PASSTV was great. I have enjoyed the shows between sessions at Ignite and Build, and I hope we can do some of that for the 2023 PASS Data Community Summit. One thing I think has worked well across decades is broadcasting. The effort is lower and the experience for the remote audience can be better. They aren't included, but they can see a "show" that is better than a clumsy attempt at bringing thousands of people into a "room" of some sort. I don't think hybrid conferences work, but I know I'm biased in that I help run and organize live events. I want to see more live events in the future, and I want to see more virtual events. Just not together. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Translate Text Data using Azure Cognitive Services]( Ajay Kumar from SQLServerCentral Learn the basics of the Text Translation services in Azure Cognitive Services. [External Article]( [Subqueries in MySQL]( Additional Articles from SimpleTalk A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article. [External Article]( [Useful Commands for Snowflake Transactions]( Additional Articles from MSSQLTips.com In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions. From the SQL Server Central Blogs - [Power Automate: Sending Emails As A Different User]( Devin Knight from Devin Knight A common frustration when sending emails from Power Automate is how to force Power Automate to send your emails from a specific user. While there [Blog Post]( From the SQL Server Central Blogs - [Running SQL Server on Apple Silicon]( aen from Anthony Nocentino Blog Last week I purchased a shiny new MacBook Air with an M2 processor. After I got all the standard stuff up and running, I set out to learn how...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Replacing text What datatype should I use to replace the text datatype in a database upgraded from SQL Server 2008 on SQL Server 2022? 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) The Time Conversion On SQL Server 2022, I have this code. DECLARE @t VARCHAR(20)= '24:33:12'; SELECT TRY_CAST( @t AS TIME) What does this return? Answer: NULL Explanation: This returns NULL as the maximum time for the TIME datatype is 24 hours. Ref: Time - [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 [Where clause filter view before dense rank]( - I have a view that has a dense rank function on a cte, sorta like this: drop view if exists drview; go create view drview AS with cte as ( select * from (values ('1', '1', 'N'), ('1', '1', 'S'), ('1', '2', 'N' )) v(field1, field2, field3) ) select * , dense_rank() over ( partition […] SQL Server 2019 - Administration [Database in "restoring" mode in secondary server]( - Hi, We have a primary and secondary server where 'Always on' is set. We remove one DB from Availability group and the same DB in secondary automatically goes to "Not Synchronizing" and then it changes to "Restoring" mode. How can i use the DB now in secondary server? What all options we have to use […] [Static port in sql server]( - I'm on sql 2019 and I want to use static port 50010. I already set up an incoming firewall rule for port 50010 and deleted the default port 1433 firewall rule, however I can still connect to sql server using ssms without specifying the port number 50010 using "home\instance2019" instead of "home\instance2019,50010". What did I […] [bcp out from sql table rows are breaking divided into rows two or three rows]( - Hi All, I am doing BCP out to text file notepad, looks like some rows are getting divided into two or multiple rows. Is there anything I need to add in the code to format it. I have comma some special characters inside the field. Ex. This test is for, dba team @, got success […] SQL Server 2019 - Development [Cannot alter database on Azure]( - Hi there We have created a database (empty) on Azure called 'Logger_Groups_CI' We then created a user called test2 as follows: -- add login CREATE LOGIN [test2] WITH PASSWORD='XXXX'; -- add user CREATE USER [test2] FROM LOGIN [test2] WITH DEFAULT_SCHEMA=dbo; then i added the user to the roles [dbmanager] and [loginmanager] as follows: -- add […] [Passing Multiple Choices to a Stored Procedure]( - In my stored procedure, I have something like WHERE W.Warehouse=@WH1 It works well when it is simple as EXEC dbo.MyProcedure @WH1='S0' I need to select multiple warehouses.  For example. EXEC dbo.MyProcedure @WH1='S0' OR W.Warehouse='T0' OR W.Warehouse='T0' OR W.Warehouse='Z0' I would expect that the prefix of first warehouse would be handled in the procedure so after […] SQL Azure - Administration [Create table Partition on an existing table in synapse]( - I have a table in Synapse with huge volume of data and planning to create a partition by year wise with out dropping the table or data. I have seen many examples of creating a new table with partition but never came across of Alter table statements with add partition .So my question is ..is […] Amazon AWS and other cloud vendors [How to scan the number and utilization of all EBS, from multiple accounts ?]( - Folks. Management is complaining about the expenditure on EBS. We have approximately 2000 EC2 multiples ASG, multiple Apps... I am looking for ideas on how to collect data about the number of EBS and the current utilization. Any suggestion ? General Cloud Computing Questions [Industry Advice for a Cloud Engineer]( - Hi and happy new years! I was hoping for some guidance.... Ive been working in cloud for 4 years (same company). My current tittle is a cloud operations engineer / finops engineer. I do alot of CI/CD, infra as code, cloud governance, cloud optimization and python for automation work. I am being paid 75k a […] Azure Data Factory [ADF Conditional Trigger]( - Need your help, I have a requirement to start my core ADF Pipeline only when all required csv files arrives in ADLS folder. required list of csv files are stored in SQL Table. what are the best possibilities to achieve this, Thanks In Advance. Analysis Services [Visual studio, SSAS and stored procedure]( - I am trying to get data from a stored procedure into my SSAS Tabular model project. This stored procedure accepts few parameters. Is there away to supply the parameters at run time without hard coding it? Job Postings [Looking for SQL Architect]( - My company is looking for a SQL Architect Here's a summarized version of the job posting, but you can get more details on the link below. It's a really nice company and I can totally vouch for it. About the role Major Responsibilities Be an exceptional corporate citizen. Actively contribute as a member of the […] SQL Server 2022 - Development [What is the syntax for comparing a null value to another value in SQL?]( - To compare if a value is null in an IF condition in SQL, you can use the IS NULL operator. For example: IF myTable.custId IS NULL THEN ... END IF; This will evaluate to true if the custId column in myTable has no value. If there is a value in the custId column and you […] [Number rows from a value in one column]( - Hi! I want to number rows from a value in one column (apar_id). Table Apar_id  Amount 10     200 10     100 11     100 12     300 12     200 12     500 Want this result from my query Number Apar_id […] [Joining two columns of foreign key with one column of another table]( - Hi,  I have two columns in table1 i.e. hotel1 and hotel1 . Both of them have foreign key of second table2 hotels. i.e. Table 1 (Book) hotel1   hotel2 1        3 Table 2 Hotels 1   HotelName1 2   HotelName2 3   HotelName3  I want […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -