Ensuring a Single Row Table (2023-11-27)

SQLServerCentral Newsletter for November 27, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Ensuring a Single Row Table]( - [SQL Server 2022 Build List]( - [Time Series Data Mining Example with T-SQL when Adding New Data]( - [From the SQL Server Central Blogs - Part 1: The Modern Azure Data Warehouse – Choosing The Tech]( - [From the SQL Server Central Blogs - Force parameterization is powerful-feature]( - [SQL Server 2022 Administration Inside Out]( Question of the Day - [Skipping Checks when Detaching]( The Voice of the DBA  Data Security and AI I ran across [an article on the best AI meeting assistants]( which can help you with note-taking and summarization tasks. Most of these cost money, but there was something that struck me about these tools. They aren't allowed for a lot of my meetings. At Redgate, I'm not sure if these are allowed. Our policy is to seek permission before using a tool, so I've sent a query off for more information. In many of my customer meetings or in Microsoft meetings, I've been told these tools aren't allowed as there isn't sufficient data security to allow their usage. I think a lot of people are concerned about their data when these AI LLMs (large language models) are involved and if their data is being used to train future models. If it is, then that could be a security problem. Already [many people and organizations are upset]( about their data sets being used for training without their knowledge. [Not everyone agrees](. I don't quite know how I feel about this issue, but I do think there ought to be guidelines and discussions about how data is used, and where data is stored (or where it transits a network). Certainly, organizations might need to set this in place to ensure their employees aren't exposing confidential or internal data in ways that could increase their risk of a breach. After all, without any guidelines or rules, you may have no recourse if employees just use tools and data escapes your network. At Redgate, we've begun experimenting with [SQL Prompt and AI](. As of now, we've had quite a few queries about how customer data is being used. Our EAP EULA notes that schema information will leave your network, but not data in rows. That might be a problem or might not, but it's important to disclose that, which we've done. I'd like to think that as hardware power increases and models become more mature, we'll stop having to send data for many AI-related tasks away from a device that might perform a task. At some point, I hope your mobile phone or laptop can process the AI model without a network connection, which would be helpful for data security. AI is here to stay, and we have to learn how to work with it, and where it works well. It feels a little like we haven't really answered many of these questions as an industry or inside our organizations. [That's something that needs to change]( and quickly as the number of places AI is being used continues to rapidly increase. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Ensuring a Single Row Table]( preitano 86677 from SQLServerCentral Learn how you can design a table that will only have one row. Always. [SQLServerCentral Article]( [SQL Server 2022 Build List]( Steve Jones - SSC Editor from SQLServerCentral This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […] [Technical Article]( [Time Series Data Mining Example with T-SQL when Adding New Data]( Additional Articles from SQLServerCentral Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining. [Blog Post]( From the SQL Server Central Blogs - [Part 1: The Modern Azure Data Warehouse – Choosing The Tech]( hellosqlkitty from SQLKitty With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and... [Blog Post]( From the SQL Server Central Blogs - [Force parameterization is powerful-feature]( Hemantgiri S. Goswami from SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP Force parameterization in Microsoft SQL Server is a feature designed to optimize query performance by converting literal values in Transact-SQL statements into parameters. This process helps in plan reuse,... [SQL Server 2022 Administration Inside Out]( Site Owners from SQLServerCentral Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Skipping Checks when Detaching If I set the @skipchecks variable to false when running sp_detach_db, what does this do? 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) Which Thursday is the Holiday? Yesterday was Thanksgiving in the US, which is a major holiday. This holiday is always a Thursday in November. If you were writing code to determine which day is Thanksgiving, which number Thursday in November would you code for? Answer: the fourth Explanation: Thanksgiving is always the fourth Thursday in November. Happy Thanksgiving or Happy November! Ref: Thanksgiving Date in the US - [( [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 [UPDATE query is running slow and is causing blocking]( - Hi All, We have an UPDATE query which is causing a lot of blocking in QA env. Its taking more than 4 hours and keep running and we see a waittype as "(151ms)PAGEIOLATCH_SH:QA4_ORS:3(*)". Worst part is, the app team has scheduled this stmt at multiple times of the day. Even before the 1st UPDATE completes, […] SQL Server 2016 - Administration [SQLPS (and SQL Agent PowerShell steps) don't work after Windows upgrade to 2019]( - We were running SQL2016 on Windows 2012R2 without issues. We've just had an OS upgrade to Windows 2019 and now we can't run SQLPS.exe or any SQL Agent PowerShell steps. SQLPS.exe returns: import-module : File E:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\SQLPS\Sqlps.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see […] [How to solve "The operating system returned error 21"]( - Starting point was a power break with open files etc. in windows. I really do not know where to start.  TITLE: Microsoft SQL Server Management Studio ------------------------------ Backup failed for Server 'DESKTOP-MB6NMGV\EDVARD'. (Microsoft.SqlServer.SmoExtended) For help, click: ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The operating […] SQL Server 2016 - Development and T-SQL [The DATETIME data type question]( - I know that the DATETIME data type is no longer an ANSI/ISO Standard and I have heard the Microsoft plans to eventually stop supporting it but I cannot find any mention of this out on the internet, besides the few comments I came across which I cannot find now. So does anyone know if Microsoft […] SQL Server 2012 - T-SQL [AttachDbFileName in Connection String in Vb.Net code gives errors.]( - While using AttachDbFileName in the connection string to attach database to localdb,The following error occurs Error: The logical database file 'Common WM_log' cannot be found. Specify the full path for the file. Could not open new database 'C:\USERS\SOURCE\REPOS\WINDOWSAPP20\WINDOWSAPP20\BIN\DEBUG\COMMON.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file C:\Users\source\repos\WindowsApp20\WindowsApp20\bin\Debug\common.mdf failed. A database […] SQL Server 2019 - Administration [Concerns about database access after migrating to new server - CNAME record]( - Hi all, I'm planning to migrate a database from SQL Server 2008 (Windows Server 2008 R2) to SQL Server 2019 (Windows Server 2019), I've ran the Data Migration Assistant to assess the move and it came back without any issues, I'm also planning on using this tool for the actual migration. There are currently multiple […] [Recovery Point Objective (RPO)]( - Does the following backup strategy satisfy the RPO of 24 hours. these are SIMPLE recovery. no transaction FULL every sunday at 12 am. DIFF daily at 2am  [SPID 0 is blocking some SPID.]( - This is the 1st time I have seen some sessions blocked by SPID 0. Does anyone know what this zero session is? SQL Server 2019 - Development [How to copy from one to another almost identical db]( - I have inherited a demo db called demo_1 and a live db with +300 tables. They are almost identical, but there has been done some work on the live db, which has not been done on the demo. Its missing primary fields, some keys, a few identity fields.  Its pretty easy to copy the […] [Split json column]( - I have a column which has the following data in it for example {"changedAttributes":[{"logicalName":"line1","oldValue":"street1","newValue":"street2"},{"logicalName":"city","oldValue":"City1","newValue":"City2"},{"logicalName":"phone","oldValue":"123","newValue":"345"}]} There maybe 100 logicaname values not just the three here How do I write in sql a query to extract the logicalname, old value and new value for each logical name that exists in the column Lets presume the table is […] Integration Services [How to add a variable to Data Flow task?]( - We have a Data Flow task to load a table from one server to another. But the destination has one extra column which I have to pass from a package variable. How I can add it? In a Mapping tab it has an drop-down option against this column, but how I can insert my […] SQLServerCentral.com Website Issues [HTML on the published article is broken]( - Hey team, I need help with fixing the HTML on my published article. SQL Window Functions Series: RANK() and DENSE_RANK() It is all broken and is providing no value to the reader. Please fix it ASAP SQL Server 2022 - Administration [Table with high unused space]( - I have a table where over 50% has unused space  How can I reclaim this space back? Index maintenance? SQL Server 2022 - Development [Cannot able to login to mysql as localhost]( - I have a query in mysql I have created a account with test@localhost and i want to access the particular database where I have given access to the db like all necessary permissions and all these my sql accounts are hosted in a server and now when i try to login in local mysql workbench […] [Update CSV string with lookup table]( - I need to replace word(s) in CSV string in table tblA, in the [original] column, by [word] from lookup table tblB. The new CSV string will be stored in tblA table, in the column [modified]. If the [tblB].[synonyms] column doesn't contain the word from CSV in tblA, then the original word will be kept. For […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -