Basic Always On Availability Groups in SQL Server Standard (2024-06-05)

SQLServerCentral Newsletter for June 5, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [PowerBI premium capacity administration: dataset monitoring and tuning]( - [Basic Always On Availability Groups in SQL Server Standard]( - [WITspiration - Year 2]( - [From the SQL Server Central Blogs - Are ABORT_AFTER_WAIT's victims logged?]( - [From the SQL Server Central Blogs - Part 2: The Modern Azure Data Warehouse – ADF and ADLS]( - [Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers]( Question of the Day - [Logon Trigger Messages]( The Voice of the DBA  Using AI for the First Draft At the Redgate Summit in London, I ran a panel talking about Platform Engineering and how we can make developers more productive. One of the questions from our audience revolved around AI (Artificial Intelligence) technologies and how they might assist. As a note, AI tech includes a lot of different things, like machine learning (ML) among other things, but a lot of people seeing the media and hype around LLMs (large language models) think those are AI. They see AI as what is implemented in ChatGPT and Copilot, which is correct, but incomplete. One of the panelists, Jeff Smith of Redgate, said that he views the output from AI as a first draft, something that bootstraps further work by a human. This can save time and can help someone be more productive, but it's a starting point and a boost, not a final product. I had not thought of AI this way, even though I expect to have to test, refine, and edit the results I've gotten from various assistants. While it might be possible for me to keep refining my prompt and perhaps generate better results (code and/or text), I don't know that it's often worth the time to do much of this. I might do a little, but it's much easier to take the result of AI as a first draft and then make it fit my requirements. In much the same way I use Stack Overflow or SQL Server Central for code snippets. They often give me a starting point and something I can then adapt to my needs without all of the time and effort spent on reading an API or SDK, experimenting with the syntax, and then actually using this in some code I'm writing. Similarly, I can get a head start on writing a summary or a pitch, though I'll admit I've found it less useful there. In fact, for many of my editorials, I've tried to use it to summarize an article or web link, and it does a very poor job (IMHO). Some of you might be concerned or worried about this, and some might not. To me, the average-to-poor code produced isn't any different than the legions of Stack Overflow developers or SQL Server Central DBAs who take code from an online forum and fail to test it. Anyone using any code (or prose) should test (proof) it and verify it works appropriately in their situation. We have a lot of people who don't do that now and AI might exacerbate that with more code, but I don't know if we are in a worse situation. We certainly seem to be able to produce lots of average tech professionals now who turn out plenty of average code. Ultimately AI is a tool that does exist in the world and will continue to exist. We have to learn to work with it and use it to our advantage. Good developers and DBAs will do that. I'd like to think that many organizations will look to hire and use those people as their staff and use fewer of the people who don't bother to test and improve the results from their tools. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [PowerBI premium capacity administration: dataset monitoring and tuning]( Additional Articles from SimpleTalk Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator. [SQLServerCentral Article]( [Basic Always On Availability Groups in SQL Server Standard]( Stewart "Arturius" Campbell from SQLServerCentral Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition. This facilitates High Availability in SQL Server Standard, with three levels of availability and failover: Asynchronous commit with manual or forced failover, Synchronous commit with manual or forced failover, Synchronous commit with automatic failover. [Technical Article]( [WITspiration - Year 2]( Additional Articles from SQLServerCentral A new cohort of WITspiration is strating, the women in technology mentoring circle. [Blog Post]( From the SQL Server Central Blogs - [Are ABORT_AFTER_WAIT's victims logged?]( Zikato from StraightforwardSQL In SQL Server, using the KILL command to terminate a session results in an entry being logged in the error log. This raises the question: Does the ALTER INDEX REBUILD... [Blog Post]( From the SQL Server Central Blogs - [Part 2: The Modern Azure Data Warehouse – ADF and ADLS]( hellosqlkitty from SQLKitty In today’s data-driven world, having the right tools to manage and process large datasets is crucial. That’s where Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) come... [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):  Logon Trigger Messages I created this trigger in SQL Server 2022: CREATE TRIGGER checksteve ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve' PRINT 'Steve logged in' END; GO Where can I view "Steve logged in"? 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 SQL Assessment API What is the SQL Assessment API? Answer: An API to evaluate the configuration of your SQL Server Explanation: This is a real thing, and it's in all SQL Server 2012+ instances as well as the Linux and Managed Instance versions of SQL Server. This is an API that is used to evaluate your SQL Server instance configuration for best practices based on [a ruleset from Microsoft](. Ref: SQL Assessment API - [ [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 [DB stuck in restoring state]( - A developer tried restoring a test DB 3 times and each time it was getting stuck at restoring. And when I tried restoring the DB "Restore database DBName from disk '' with recovery I ran into the same issue and I saw DB, stuck in restoring state. Sys_dm_requests doesn't show any records because I could […] [The backup to one location fails but is successful on another]( - Dear Friends, Would be glad if any of you can help in a backup related issue I am stuck in. I am trying to take a database backup to two network locations , and mapped drives. The difference between the two targets is the domain. The source SSMS session from \\a.b.c.d\backup to target \\a.b.c.e\\backup works […] [How to set execution timeout in SSMS for SQL Server]( - I tried to set the execution timeout in SSMS using multiple methods. Initially, I tried changing the query execution time through the tools option, as described on the website Subsequently, I tried a second method from the link. In the tools design settings, we can configure values for the execution timeout in seconds. […] SQL Server 2012 - T-SQL [Adapt the query to 2012]( - Hello I have a query that works as a loop but it is slow. How can I do this with a standard query? -- LINES tablosunu oluşturma IF EXISTS (SELECT 1 FROM SYS.tables WHERE name = 'LINES') BEGIN DROP TABLE LINES END GO CREATE TABLE LINES ( ID INT IDENTITY(1,1), CODE NVARCHAR(100), DATE_ DATETIME, TIP […] SQL Server 2019 - Administration [sysmail_event_log last_mod_user has a disabled login]( - Hello experts, We routinely disable sa after a SQL install. However, while troubleshooting a database mail issue (test mail not received), I saw that the sysmail_event_log entries have last_mod_user of sa for some rows. How can that be if the login is disabled? How can I change it so that sa is not used here? […] [LinkedServer error]( - I getting the bellow error when runing query on linkedserver from another server after adding linkedserver. OLE DB provider "MSOLEDBSQL" for linked server "xxx.xxx.x.xxx" returned message "Protocol error in TDS stream". OLE DB provider "MSOLEDBSQL" for linked server "xxx.xxx.x.xxx" returned message "Communication link failure". Msg -1, Level 16, State 1, Line 11 Session Provider: Connection […] [SQLCMD and the permissions needed]( - Hey all, Hopefully this is a simple question. I am trying to figure out what permissions are needed for an account to use SQLCMD. I understand sysadmin allows use of it, but we are trying to not grant this non-user account sysadmin. I have been googling and either I'm not using the right keywords or […] SQL Server 2019 - Development [Filtered index prerequisites to be used]( - Hello, After few videos and showing how filtered indexes works, what are the prerequisites to be used and so on still I am not able to make my query using it. Now, I have table CDPOS which is over 100 milion rows. There is a statement which will run automatically, we are still in deciding […] [Monitoring if something is deleted in DB]( - Hello, I have long-term task, which came one year ago, and just now I have a little free time to start working on it. I will explain a little bit of the task, and then what I have done so far. Some time ago, even before I worked here, colleagues of mine using the web-application […] Powershell [Invoke-SQLCMD]( - If my server has dashes seems like that is throwing an error -serverinstance at-ts-cblsql  is server name Anyway to get around that? THanks Continuous Integration, Deployment, and Delivery [Red Gate SQL Change Automation]( - Hi, What's happened to this product has it now become Flyway? [Red Gate SQL Change Automation]( - Hi, What's happened to this product? has this now become Flyway?  Suggestions [How to change password]( - How can I change login password of this website? I don't see option under my profile, and google give no result. Is it even possible to change password? SQL Server 2022 - Development [singleton is interferring with getting multiple nodes in xml]( - Hi we have an xml doc shaped essentially as shown in image 2 below.  Unfortunately we are so used to using the singleton structure to avoid problems that we dont know how to get multiple nodes like those inside featuresandoptions . At the moment we are only getting one occurrence of each for each line […] [Calculating moving moving averages for different ranges in one query]( - I have this query, which is gives result I want (may be not, i have not checked extensively yet), i feel like it could be written in more effective way. I have to calculate moving average, for 7 , 90, 365 days, and for 3 and 12 month, for every one of them I have […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -