Meet Claude, the new AI (2024-02-26)

SQLServerCentral Newsletter for February 26, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Meet Claude, the new AI]( - [Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster - Part 3]( - [From the SQL Server Central Blogs - There Is Insufficient Free Space on Disk Volume To Create the Database]( - [From the SQL Server Central Blogs - Knowing String Defaults in T-SQL–#SQLNewBlogger]( - [Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers]( Question of the Day - [Updatable Views II]( The Voice of the DBA  The Dangers of Not Upgrading About ten years ago my sister-in-law broke the screen on her mobile phone. She'd had an older iPhone and when she went to upgrade, none of the processes worked because her OS was so far behind that they couldn't transfer her information smoothly. She kept avoiding OS updates because they interrupted her life, but that became a problem at some point because the world marched so far beyond that point that there weren't tools, or at least, no one was interested in trying to perform an upgrade across multiple OS versions (I think it was 4 or 5). I ran into this recently with someone else I knew, but not for a mobile phone. For TFS 2015. This customer had been working along with this older system and is finally ready to upgrade to Azure DevOps in the cloud. They wanted to know if they could somehow upgrade the database they used for 2015 and move all that data easily into the cloud. I said this wasn't likely easy as this isn't an upgrade, but an export and import of a lot of data. Microsoft offered a path, but it was multiple upgrades before an export/import, which was deemed too expensive. I know that many people keep old versions of SQL Server out there. [Brent's population report]( still shows some 2014 and older databases, and I'm sure there are plenty of 2008-era (or older) ones out there. Many of you continue to run older software because it works. That might especially be true on desktops, where we often install specific software for a task that might not change for years. I think there is plenty of value in older software that works well, though there might be security concerns. However, for platforms or software where there is a regular upgrade path that you will need at some point, it pays to keep up, at least a bit. Maybe you don't upgrade with every version, but you likely shouldn't fall more than two versions behind. Vendors don't want to maintain compatibility for too long, and certainly don't want to keep providing updates for new features. Even security updates get expensive to produce for old versions with complex test matrices needed to ensure the patches actually work. Software is a bit of a crazy business. In the analog world, if we own a product and it breaks or has an issue, often there are third parties who can repair it, or even create the necessary parts for the DIY market. Software is different, and the pace of change can be a bit overwhelming, expensive, and annoying. We can't fix old software, heck, we're not even allowed to fix old software. We can get into legal trouble if we try. I don't know if there is any good solution, but I certainly do know that if you manage software, you ought to be careful to keep abreast of how often the software upgrades and when support for previous versions is waning. Even if you don't care about customer support calls, you likely care about upgrading to a newer version at some point, so make sure you know when they might drop support for upgrading from your version. Stepped upgrades work, but they can be expensive and time-consuming, and if there are issues, often vendors aren't interested in why the upgrade didn't work from your extremely-old version to a slightly-less-old version. I still expect a database version to run for 10 years, but I know that support is tricky, and I also know that I better be ready to upgrade at that time. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Meet Claude, the new AI]( Daniel Calbimonte from SQLServerCentral Learn how a new AI service, Claude, can help with database code. [External Article]( [Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster - Part 3]( Additional Articles from MSSQLTips.com I used the guide in a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 to install a SQL Server 2008 on a Windows Server 2008 failover cluster (WSFC). Now, I would like to upgrade and migrate my SQL Server 2008 failover clusters to SQL Server 2022 running on Windows Server 2022. What is the process for installation and configuration? [Blog Post]( From the SQL Server Central Blogs - [There Is Insufficient Free Space on Disk Volume To Create the Database]( Tim Radney from Tim Radney - Database Professional I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have... [Blog Post]( From the SQL Server Central Blogs - [Knowing String Defaults in T-SQL–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple... [Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers]( Site Owners from SQLServerCentral Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Updatable Views II I have this view: CREATE OR ALTER VIEW dbo.City AS SELECT TOP 10 cn.CityNameID, cn.CityName FROM dbo.CityName AS cn WITH CHECK OPTION GO How can I modify the view to make it is updatable with this code? INSERT City (CityName) VALUES ('Dillon') 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) Filestream on Linux I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this? Answer: FILESTREAM is not supported on Linux. Explanation: FILESTREAM is not supported on Linux. Ref: Unsupported features and services (Linux) - [ [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 2019 - Administration [Transactional replication breaks during WSFC failover to new primary]( - Hi expert, Is there a best way to fix or be proactive during patching of primary node of WSFC? Whenever I failover to passive node (which will become new primary) the replication will break, since the replication has small database so I re configure again (with GUI/scriptout) what if there there is a big database […] SQL Server 2019 - Development [ssas memory issues even after switching over to table level refreshes]( - Hi, we just moved to 2019 std from 2016 std.  We comingle the engine, ssas and ssrs on one server.  I just realized that i allowed my post at to go off on a tangent so i'm going to carefully move the memory part of that discussion here and just leave the tsml sequence […] [is process add available in standard ssas]( - Hi, i cant tell from these 2 articles if incremental processing is available in standard edition...‚   and   . Does anybody know? [Refactoring an EAV schema for Notes]( - We have a fixed number of entities (each with their own table) such as Person, Service, Organisation, Contract, Invoice, etc. We also have a table for Notes - this has quite a few columns in order to support existing functionality. Each instance of an entity (e.g. a Person or a Service etc.) can have any […] [Alter table query to change identity column from int to bigint in sql2019 server]( - Alter table query to change identity column from int to bigint in sql2019 server [is there a way to process a tabular model's tables in sequence?]( - Hi, i'm reading the posts at and and thinking "maybe not".  My hope was to script some tmsl in one step in my sql agent job that would process one table at a time probably dims first.  There is only one fact table. The reason i want these things single threaded (sequenced) is […] [Downgrade a DB from 2022 to 2019]( - Dear DB Gurus I have an application that was running in 2019 database. We tested that application using 2022 and it was all working fine. But after putting that in production we found an issue that was not tested before. The situation is that vendor of the application is no longer reachable and able to […] Working with Oracle [Help needed in ORACLE Group by]( - Hello, working in Oracle Database 19c Enterprise Edition. Below is my sample data with Sample( ID, QTY,STATUS,LAST_UPDATED_DATE) as ( select 1, 2400, null, null from dual union all select 1, 2400, null, null from dual union all select 1, 2400, null, null from dual union all select 1, 2400, 'Received', sysdate from dual ) I […] General [Exporting? data to Existing Preformatted Excel work book]( - Hello all, Is it possible to either:  export data to an existing preformatted worksheet on demand OR  connect the existing workbook to SQL Server and query on demand, with the dataset going to a specified worksheet with specific formatting requirements? I have a user who uses Excel regularly to manage the setup of a production […] Integration Services [Extracting data from Dynamics into data warehouse problem with expired details]( - So Dynamics/D365 requires setting up of an app in Azure Portal along with a certificate / secret. and by using the KingswaySoft tool for SSIS, I can successfully extract and import data into the data warehouse. Now the certificate / secret has expired, and have been told a new one will be required with a […] [Corrupt SSIS Package & Unsupported Error]( - I am using the Community Edition of SSIS/Visual Studio. I find that my SSIS package can get corrupt, i dont know why. Is the Community Edition too sensitive? I am also finding myself with this error: Unsupported This version of Visual Studio is unable to open the following projects. The project types may not be […] SQL Server 2022 - Administration [what are the best sites to get sqlserver automation of scripts and alerts config]( - HI ALL, what are the best sites to get sqlserver automation of scripts and alerts configurations My requirement is to set alerts in sqlserver to get notifications and also 1.get daily health report 2. backups report 3. disk reports 4.log (ldf) increase alert 5. database growth report 6. backup failures alert 7. db long running […] SQL Server 2022 - Development [Using R and Python with SQL Server 2022 not possible]( - I want to use R and Python with SQL Server 2022, but I get an error if I try to exec the Python syntax. I did everything that Microsoft recommends: I also checked some older Stack articles but nothing was usable. But still I get an error if I try exec and Python OR R […] [Who else is Actual competitor of SQL Server when it comes handling Complexity?]( - When it comes to programming and how robust / flexible the programming can be with SQL Server - have experienced a lot what all can be accomplished with how we convert any logic to a working functionality . I am here to understand what are other database technologies which are available who can be the […] [How to detect a column rename?]( - Hi, products like SQL Compare detects if a column has been renamed. To detect new columns, dropped columns or a type or length column is easy, my question is how to detect if a certain column has been renamed. Thanks for any ideas.  Mauricio   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -