Stairway to SQL Server Virtualization Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine (2022-11-23)

SQLServerCentral Newsletter for November 23, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Stairway to SQL Server Virtualization Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine]( - [Introducing the MySQL UPDATE statement]( - [Using SQL Backup in Development Work]( - [From the SQL Server Central Blogs - Testing the code (T-SQL Tuesday #156)]( - [From the SQL Server Central Blogs - What is production grade code? : T-SQL Tuesday #156]( Question of the Day - [Searching Strings]( The Voice of the DBA  Daily Coping Tip Build new ideas by thinking “Yes, and what if…” 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. AI Medical Record Scanning Artificial Intelligence (AI) systems continue to pervade many industries, usually where there is a lot of data and human developers struggle to build solutions that handle the complexities of the problem. Often the experts in these subject areas can't fully articulate the reasoning behind how and why they use data to arrive at some conclusion. We developers often struggle to get clear specifications from clients in simple cases, so I certainly understand why AI might be attractive in complex problem spaces. I think AI is a promising way to try to tackle some of these issues, some of which are important to humans. These systems can achieve a focus and analysis of complex data in a way that very few people, if any, can. The sheer volume of data and myriad of relationships among the various different metrics captured eludes the ability of most people to properly analyze. I found [an article that looks a neat non-intrusive way of analyzing medical records]( from patients to detect blood issues. In this case, an AI looks at the records of treatment and test results, looking behind the doctors and nurses to catch patterns that can indicate blood poisoning. The signs are subtle, and in today's world where the humans are often overloaded, hand-offs between people can be incomplete. This means that doctors and nurses sometimes miss things. The AI doesn't order treatment or prescribe anything, but raises a flag to alert humans. The medical staff can then review things, examine the patient, and decide on the treatment. Early results seem promising, and more importantly, this is the type of lever that computing can bring to leverage human expertise and help humans. Not only can they better treat patients, but potentially this can help enhance the understanding of what signs a doctor or nurse should look for in future patients. When a flag is raised and an issue detected, the staff can go over notes or discuss how they might have caught this themselves. A little continuous learning applied between humans and machines, just what we'd want in a DevOps software pipeline in technology. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Stairway to SQL Server Virtulization]( [Stairway to SQL Server Virtualization Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine]( David Klee from SQLServerCentral.com In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware. [External Article]( [Introducing the MySQL UPDATE statement]( Additional Articles from SimpleTalk In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML) statements in MySQL. In this article, I focus on the UPDATE statement, another valuable DML statement in MySQL. [External Article]( [Using SQL Backup in Development Work]( Additional Articles from Redgate For a development team, SQL Backup provides a simple way to restore development or test databases, if required, while minimizing the tedium of the task of taking, managing, and restoring the backups. We can generate the required backup commands in the GUI and then use them to construct a SQL script that backs up all the required databases. We can even use the backup commands in a beforeMigrate SQL callback, in Flyway, to make sure the current version is safely backed up before we run migration. [Blog Post]( From the SQL Server Central Blogs - [Testing the code (T-SQL Tuesday #156)]( Zikato from StraightforwardSQL Foreword Even though I picked the question, I struggled to answer it. Following my train of thought - production code should be of the highest quality. To enforce quality, we use... [Blog Post]( From the SQL Server Central Blogs - [What is production grade code? : T-SQL Tuesday #156]( Kenneth.Fisher from SQLStudies It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading   Question of the Day Today's question (by Steve Jones - SSC Editor):  Searching Strings I have a table of address values that looks like this: If I run this code, what happens to the addresses in the result set? SELECT SUBSTRING(at.AddressValue, PATINDEX('%[^9]%', at.AddressValue), LEN(at.AddressValue)) FROM dbo.AddressTable AS at 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) Checking Time What does this code return? SELECT DATEADD(MILLISECOND, -sample_ms, GETDATE()) FROM sys.dm_io_virtual_file_stats ( 1,1) Answer: The date and time when the instance was restarted Explanation: This DMV/DMF cannot be cleared, so the sample_ms represents the ms since the instance was last restarted. The DATEADD calculates the date and time when this was restarted . Ref: sys.dm_io_virtual_file_stats - [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 - Development [Remove certain unknown amounts of character from a string]( - All,  I have a field, SourceID, that looks like the folloing V0008048 V0011675 V0000145  In each instance I need to remove the V and all of the zeros, so I should return the following: 8048 11675 145  Ive tried a replace, trims and nothing will work. Is this possible?  Thank you! [Split string]( - I have a table where values into field is like this way There are multiple rows now we need to find distinct value from all this row and create a lookup table Here are 3 rows from this tables 1    ["Acct Vert - Chemical","Acct Vert - Energy","Acct Vert - Seaport","Prod Vert - Access […] SQL Server 2016 - Administration [Non Clustered Index]( - Quick question If I create Non Clustered index on a table will that help if there is no Clustered Index on a table? If yes how, I was in the impression to work Non clustered Index table should have clustered index or it will show Heap on the table SQL Server 2016 - Development and T-SQL [How to get ID from XML file?]( - Hi all, So I have some XML files which contains person's name and addresses in their respective nodes. Sample of XML file code is below: P965 John KyleTokyoJapan  Now what I am trying to do is I am fetching all the data from Individual […] SQL Server 2019 - Administration [SQL Change null values for integer column]( - Hi All, In MSSQL How can I handle null values for integer column. Do I need to update null to zero maybe? I am doing BCP out from MSSQL to MYSQL. The text file is having null-empty values and MYSQL load is errors out with Incorrect integer value. SQL Server 2019 - Development [SSMS csv export file is missing leading zeroes for Numeric data types]( - Hi, I am working to move data from SQL Server to BigQuery. I tried exporting the .csv data out via SSMS (Tasks + Export Data), but noticed that all the columns that have numeric data types have leading zeroes missing (.0000053653 instead of 0.0000053653). This is causing issues when I try to import into BigQuery. […] [How can i get the more accurate and optimzed grouped data ?]( - Hi , I need to get the correction and a way to group it in a better and efficient way. What I want is that I need to group the data on the bases of RenterUserId or MainDriverUserId in following cases /scenarios 1). Take the count of ba.Id (BookingAgreements) When RentalAgreementId is not equal to null or […] [SQL Syntax for BETWEEN any dates and specific time]( - hi all i want to ask how to select from any dates and spesific time id     date 1      2022-01-01 00:00:00 2      2022-01-02 05:00:00 3      2022-01-03 09:00:00 i want to select from 00:00:00 - 06:00:00 how to […] [Refinement of my query in a best way with optimum results (for large data)]( - How can I refine my query in a best way with optimum results (for large database tables) ? I tried to optimize the query with same results. please see my query. I used two inner join by using the same derived tables which is fine. Our client is now experiencing the slow performance issues by […] T-SQL (SS2K8) [Analyzing a huge ( more than 10600 lines )stoc proc using cte]( - Hello commuty, Need your help, your support and proposition! I'm analysis a huge stoc proc in sql server including a list of cte , but it's very complicated to understand the differents dependencies, Are there any tools or code that help to display a list of tables used in each cte ! Or to show […] SQL Azure - Development [Azure AD Integrated Security on a Mac Connecting to Azure SQL database]( - Hopefully the great minds here can help, to give some back ground to the situation we have Azure SQL databases created which we are trying to ensure that all access to the DB is via Azure Active Directory authenticated users, we don't want SQL Auth users as you probably know people will share the user […] [New to Azure - which IDE tools?]( - I've been working as a developer within SQL Server for over 15 years now (DWH and transactional) and think it's time I added SQL Azure to my toolbelt. I've created an account, server and database etc in Azure. Which tools are commonly used in organisations for doing the actual development? I've got Azure Data Studio […] Azure Data Factory [How to copy ADF pipeline from one subscription to another and change the config]( - Hello, I have a pipeline which is a chain of several sprocs, activities etc... My ADF uses user assigned managed identity of the relevant subscription, let's call it ArchiveUser that accesses several Azure sql servers and azure blob storages. Pipeline in Dev Dev subscription ArchiveUser set up in dev subscription Azure sql servers in dev […] Powershell [SOAP request]( - I'm trying to test a SOAP request from powershell, but getting an error. I goggled error but solutions don't seem to be working... any suggestions to fix? Error: Reading and converting file to XmlDocument: c:\miscjunk\soap-W.txt Sending SOAP Request To Server: Initiating Send. Send Complete, Waiting For Response. Exception calling "GetResponse" with "0" argument(s): "The […] Strategies and Ideas [Questions about Fact Table structure]( - Hi Everyone, I created a data warehouse allowing to analyze data from the commodity trading business. I have multiple fact tables which are refreshed every night and for some customers up to 3 times per day. In all the fact tables, I have some measures and dimension keys and always a specific column called "ValuationDatecode" […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -