Bing vs Bard (Chatbot wars) (2023-08-14)

SQLServerCentral Newsletter for August 14, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Bing vs Bard (Chatbot wars)]( - [Managing the challenge of migrating to the cloud]( - [Dive into RDS Custom for SQL Server - Leverage your existing licenses and high availability]( - [From the SQL Server Central Blogs - Which Schema is Queried First?–#SQLNewBlogger]( - [From the SQL Server Central Blogs - Running SQL Server in Docker Swarm]( - [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( Question of the Day - [A Bundle of Changes]( The Voice of the DBA  Using Clear Language to Avoid Confusion A long time ago a software engineer advised me to try and ensure that I made my interfaces clear to users, especially those that are busy focusing on some other task the software enables. The phrase he used was to make a "Fisher-Price" interface, referring to the toy company that makes [big and brightly colored buttons]( for their toys. The idea being that we didn't want to cram too many things on the screen or possibly confuse a user. As a kid, I watched [Mr. Roger's Neighborhood]( on television and enjoyed the show. Lots of kids had a similar view, but they might not have known that the main actor took care in choosing his words to convey concepts and ideas to children. In fact, the former producer said that the writers joked that his manner of speaking was its own language, called "Freddish." I saw [an article]( that talks about the care Fred Rogers took in explaining things, with examples of how he made choices in how to communicate with his audience. The piece got me thinking about not only Fisher-Price interfaces, but also the language that we use to communicate with developers when we ask them to build something. Often I find in software development that we use a model or a shortcut to represent what we want. We partially describe something, or we assume that the words we choose mean the same thing to us and the other party. This goes both ways, with developers needing to be clear with their clients (and each other) and clients needing to be clear with developers. I don't think I'd advocate for adopting Freddish, but I do think that we ought to pay attention to the words we choose, especially when we find the end result isn't quite what is expected. Examining where the design went wrong and if we could communicate differently, or more often, earlier in the process to avoid problems. Communication is a difficult skill. I find constant examples at work, in my hobbies, even within my family where someone says one thing, but means another. To me. To themselves, they feel perfectly clear. Context, innuendo, implication, we depend on these a lot in communications, but those can cause issues when we aren't very familiar with others. As we move to remote work, as we find less bonds with our co-workers because we don't see the same body language, as we don't eat meals together, as we don't often share a context of work, we need to be more careful about the words we use and find ways to ensure we all are saying the same thing that the other person hears. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Bing vs Bard (Chatbot wars)]( Daniel Calbimonte from SQLServerCentral Introduction about Bing vs Bard You heard it well Chatbot wars, the war between Bing vs Bard. Ladies and gentlemen, in the Google corner we have the challenger, Bard! And in the Microsoft corner, we have a powerful AI-based in ChatGPT 4, the stupendous, the magnificent…Bing! (applause). These great chatbots will demonstrate their power in […] [External Article]( [Managing the challenge of migrating to the cloud]( Additional Articles from Redgate Migrating to the cloud has many advantages… until you’re the one tasked with making it happen. There are a lot of considerations, and the key is to break it down into four steps, not one. Find out how you can manage the challenge of migrating to the cloud. [External Article]( [Dive into RDS Custom for SQL Server - Leverage your existing licenses and high availability]( Additional Articles from MSSQLTips.com RDS Custom for SQL Server recently released exciting new features related to Bring Your Own Media (BYOM) and High Availability. By using BYOM, customers may leverage their existing SQL Server licenses with Amazon RDS Custom for SQL Server, when used in accordance to Microsoft terms. This allows customers who have already purchased SQL Server licenses to save on TCO/license costs, while offloading the undifferentiated heavy lifting of database management to Amazon RDS Custom. By using Multi-AZ deployment, customers can now set up high availability for their databases. [Blog Post]( From the SQL Server Central Blogs - [Which Schema is Queried First?–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote... [Blog Post]( From the SQL Server Central Blogs - [Running SQL Server in Docker Swarm]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can... [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( Steve Jones - SSC Editor from SQLServerCentral Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.   Question of the Day Today's question (by Steve Jones - SSC Editor):  A Bundle of Changes I have this code I'm running on SQL Server 2019. BEGIN TRAN ALTER TABLE dbo.Product ADD productdescription VARCHAR(max) CREATE FULLTEXT INDEX ON dbo.Product(productdescription) KEY INDEX ProductPK WITH STOPLIST = SYSTEM; GO COMMIT The objects listed exist, except for productdescription, which is being added. No other transactions are open and a full-text catalog exists. What happens when I run this code? 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) Setting Windows System Variables In Windows, how do I set the system variable, myvar, to the value "SQLSaturdayBoston"? Answer: setx myvar SQLSaturdayBoston /m Explanation: SETIX is used to set system variables, similar to the SETENV in Unix. Use the /m parameter to set the system environment. Ref: SETX - [( [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 [How to identify changed values from a history table?]( - We have several tables with system_versioning set to on. There is a requirement now to produce a solution (function / stored procedure) to return a list of changed columns of a given table within a range of days. Below is an example of one of the tables - customer_sites and a bit of data: /**** […] [Run Stored Procedure on the first Monday if each month of Tues if Mon Holiday]( - Hello, I need to setup a Stored Procedure to run on the first Monday of each month that is not a holiday. If the first Monday of the month is a holiday, than I need the PROC to run on Tuesday. Via Scheduled Jobs, how is this possible? Can someone help with a query on […] SQL Server 2019 - Administration [repeated login failures.]( - Do repeated login failures into SQL affect performance. Surely some resources are used with each attempted ack & nack? Certainly log writes. I have careless app owners who repeatedly fall foul of my attempts to stop this happening as their apps try access every 10 seconds or so. They failures fill my logs & I […] [SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format]( - Hi Team, SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format we can see the audit logs using view logs rather than is there any way we can set the audit to run in frequency for every one hour and schedule it in a job where we can get […] [Deadlock - implicit transaction]( - Hi, We are experiencing deadlocks. The process not being the victim is doing an update by stored procedure which has begin tran, commit tran. However the transactionname in the deadlock graph is implicit_transactions. Could this be potentially causing the deadlock issue and from the application implicit_transaction is on?  [File does not close: VerifyShareWriteAccess.txt]( - Hi Folks. We have two SQL Server 2019 Enterprise in an High Availability Group (always on). The OS is Windows server 2019. For the witness of the failover cluster we use a file share. The cluster itself runs perfect. But we have some troubles with the file VerifyShareWriteAccess.txt. The cluster service opens the file (read, […] [Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.]( - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. see error below: I'm trying to login into a sql server on another domain (DEV). I run a command to launch SSMS and then login to a DEV server as follows: %windir%\system32\RUNAS.exe /smartcard /user:ABC@dev.com /netonly "C:\Program Files (x86)\Microsoft […] [Why would user account authentication issues arise in Azure?]( - Through a series of events too long to go into here, last year I was involved in helping to move a test SQL Server 2019 database from on-premises, to a VM in Azure. However, after it was migrated, they no longer needed me and that was the last I heard of or knew about it, […] SQL Server 2019 - Development [Using Dynamic SQL to execute Select from Openrowset with JSON]( - I have some code which will load in and process a JSON file using Select..from Openrowset as follows: Declare @JSON varchar(max) SELECT @JSON = BulkColumn FROM OPENROWSET (BULK 'C:\Users\User1\DR\staging\returns\RET02022203.JSON', SINGLE_CLOB) as j select @JSON i tried to turn this into Dynamic SQL so that I can pass in the path to the JSON file as […] [xp_cmdshell problem]( - Hi, i'm trying to run this command from within the SQL but i get this error 'C:\Program' is not recognized as an internal or external command, operable program or batch file. here is my code DECLARE @CONVERT_HTML_TO_PDF VARCHAR(4000) SET @CONVERT_HTML_TO_PDF = '"C:\Program Files\Microsoft SQL Server\MSSQL15.PRI\MSSQL\monitor_binaries\wkhtmltopdf.exe" "c:\new folder\1.html" "c:\new folder\1.pdf"' EXEC xp_cmdshell @CONVERT_HTML_TO_PDF what is wrong […] [Best way to handle incremental duplicate data in SQL Server?]( - I am processing .csv files daily which has persons data. Every person has a unique ID. My table has FileID and PersonUniqueID columns; it is working fine and saved to parsed table, i.e. with duplicate rows. Now would like to copy the unique data to new tables which is used by other applications. I can […] CosmosDB [To change the maximum throughput of an Azure Cosmos DB for NoSQL container]( - Hello,  I have a question, and please advise. When I wish to change the maximum throughput of an Azure Cosmos DB for NoSQL container from 4000 RU/s to 5000 RU/s, would that be sufficient if I use command: az cosmosdb sql container throughput update command --max-throughput ‘5000’ ???  Tanks in advanced  Reporting Services [Custom Authentication SSRS 2019]( - When trying to setup custom authentication on ssrs 2019 getting "ERR_CONNECTION_REFUSED " and this in the logs  ERROR: Error loading configuration file: The configuration file contains an element that is not valid. The #text element is not a configuration file element. library!DefaultDomain!13d0!08/02/2023-09:54:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration […] [SSRS Integration with Power BI]( - I am trying to integrate SSRS 2022 with Power BI. One of the steps is to go into Report Server Configuration Manager and go to the Power BI integration tab; however, I am not seeing a Power BI integration tab. Is there something special I need to do or install to see that tab?  […] Analysis Services [Date Difference of current record and its relative record using MDX]( - Dear All, I have a some rows where it points to another row in same table based on RelativeId column value. I need to find the difference of these two records date values using MDX. for ex. sample table structure with some values ID - HasRelative - Date - RelativeId 1 - False - 2023-01-01 […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -