Set up a Windows Server Fail-over Clusters (2024-06-28)

SQLServerCentral Newsletter for June 28, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)]( - [Build Chatbot with Large Language Model (LLM) and Azure SQL Database]( - [From the SQL Server Central Blogs - Using the Pure Storage PowerShellSDK2 - Part 5 - Checking Replication Status]( - [From the SQL Server Central Blogs - What I actually do at Microsoft]( - [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( Question of the Day - [Updating Sensitivity Classifications]( The Voice of the DBA  What Metrics Do You Collect? One of the hot terms in software these days is observability. There are a few definitions ([Splunk]( [RadixWeb]( but essentially this is the insight into how your software runs and performs using metrics, logs, traces, etc. In DevOps, we do this with an eye toward improving performance and identifying the root cause of issues. The focus is slightly different from monitoring, where we often focus more on resources and health. We need both, but often in trying to improve software and the behavior for users, developers need observability. Infrastructure people responding to acute issues and looking to ensure we have the capacity, availability, and other x-bilities, that need monitoring. Today I'm wondering if you collect a variety of types of metrics for your software that might tell you how your system is running. What things are important to you in order to better serve your clients? If you're a DBA/sysadmin, what is important to you? If you are a developer, are there different types of data you want? Certainly, you might collect various resource measures (CPU, IO, reads, etc.), but there are many more things. There are logs, which could include the SQL Server error log, but I'd hope that you had a more in-depth way of measuring the activity on your system. Do you have custom xEvent traces running? Can you collect application logs easily when you're looking at issues? Do you spend time trying to solve chronic issues? Do you look for potential future problems? Most software applications should include some sort of basic logging of major functions, but I would hope that there are various levels available. If problems are reported or noticed, can you increase the detail of logging? Can you correlate this with logs from different systems, such as the database? Can I get execution data that matches calls and trace down the potential issues that users are experiencing? I know that we have problems in applications. Some (many?) of these are data-related, which might be easy or hard to trace down. That often depends if the data changes too quickly or is static enough for someone to investigate a report. Some errors are logical code errors, which might indicate a lack of testing early in the software process, but we ought to be able to determine this quickly from logs. If there are performance issues, and we have a lot of these, how easily can we verify a problem? Let us know what types of metrics help you solve issues. I certainly think that you should have some sort of monitoring and observability system in place that helps you dive deep into the database, especially concerning execution plans at the time of the issue. The situation can change quickly inside a database, so capturing data regularly is important. If there is something you wish you had, let us know as well. Maybe someone else will have a neat solution for you. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)]( Stewart "Arturius" Campbell from SQLServerCentral Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating [External Article]( [Build Chatbot with Large Language Model (LLM) and Azure SQL Database]( Additional Articles from MSSQLTips.com In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database. [Blog Post]( From the SQL Server Central Blogs - [Using the Pure Storage PowerShellSDK2 - Part 5 - Checking Replication Status]( aen from Anthony Nocentino Blog Introduction Welcome back to the fifth installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, we’re diving into a hands-on demonstration of using... [Blog Post]( From the SQL Server Central Blogs - [What I actually do at Microsoft]( Randolph West from Born SQL with Randolph West I started working at Microsoft in January 2022. I enjoy it. I even wrote a stream-of-consciousness post about it last year. A significant part of our job in the... [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]( Site Owners 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):  Updating Sensitivity Classifications I ran this code on a column in my SQL Server 2022 database: ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Contact', RANK = CRITICAL ); GO I then realize I've made a mistake and run this: ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Contact', RANK = HIGH ); GO What happens? 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 Same Operator Precedence Which groups of logical operators have the same precedence? Answer: +, -, ^, & Explanation: The answer is: +, -, ^, & The positive (+), negative (-), bitwise and (&), and bitwise exclusive OR (^) all have the same precedence. They are evaluated left to right. Ref: Logical Operator Precedence - [ [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 [Script]( - We have about 30 databases in server A.  All of them need to migrate to server B. Decided to use the backup & restore method. The dat file & log file paths are will be different on source server & destination server. I am looking for the script to backup all the databases on the […] SQL Server 2016 - Administration [SHOWPLAN documentation]( - The most recent documentation I can find is this v=sql.105) which is showing as retired. Does anyone know if there is a newer version which applies to 2016? Apologies for asking for assistance with searching. I have searched extensively and not been able to find it. I'm guessing the content is still accurate for 2016 […] SQL Server 2019 - Administration [Using TDE Best Practice]( - I am trying to understand when best to enable TDE. Our Asst. Director has been pushing to encrypt everything when we can due to more and more cyber crime. We have implemented all SQL instances are backing up using encryption as well as all our SQL connections are encrypted. As far as TDE, Should we […] [Program Code giving duplicate errors where no duplicates exist]( - On our Java Hibernate program it is giving a duplicate value on an insert on a table where there are no values remotely close to the vales being inserted. The developers have stepped through their code, connecting from other source code, though the program has not changed in 2 years. Running the insert directly in […] [Add alarms to database when a query, stored procedure, SSIS package hangs]( - Hello SSC, I am a SQL Server developer that has some DBA skills. I need to add alarms to an instance or database when a query, stored procedure, or SSIS package hangs for longer than a few hours. I did not see anything in the security or maintenance drop down in SSMS. Any assistance would […] [MSOLEDBSQL/MSOLEDBSQL19 - Linked Servers and encryption]( - Yes I know Linked Servers can be evil... but they can be fine and fair enough for small data sets. If trying to setup a linked server and using either the MSOLEDBSQL that ships with SQL2019 or the newer one MSOLEDBSQL19 (that by default wants to be encrypted and trust a valid certificate)... Given using […] SQL Server 2019 - Development [Looking for recommendations for reporting technologies replacements]( - Here at work I've been maintaining an old ASP.NET WebForms app. I was assigned it when I came to this job. I never met the original developers, as they'd all left before I was hired. Anyway, this old app has several problems, include multiple .NET Frameworks have been used for the 9 projects that comprise […] [How to get calculated values from a derived(?) table?]( - Here is my filtered dataset: I would like to calculate the time difference between each 0 and 1 that occur sequentially. In this case, the time difference between each time stamp, since the 0's and 1's alternate. So, from item 10 to 11 - that's just over 25 minutes, from 11 to 12 - almost […] Anything that is NOT about SQL! [I got tired of always having my feet to the fire, so after 42 years I fixed it!]( - SQL Server 2022 - Administration [sp_server_diagnostics in ErrorLog]( - I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics encountered a long delay that was 2.5 times more than the repeat interval between two consecutive diagnostics result generations. The repeat interval: 300000000, the elapsed time of this diagnostics result generation: *****, the elapsed time between the latest two diagnostics result […] [should i make as many datafiles for temdb as many cpus i have]( - hi, q1 As people said if u ghave GAM conention then u can go for adding as many datafiles of equal size in temdb as many cpus u have is it correct in sqlserver 2019 vesion also. q2) right click on sqlserver instance then select reprots->perfomance dashboard report then click io statistics . i have […] [dbcc clonedatabase issue]( - I have used the 'dbcc clonedatabase'  schema-only backup procedure many times in the past to have control over what I want to backup . Now I have a freshly installed SQL2022 Standard Edition instance that throws the duplicate record error message , like: Cannot insert duplicate key row in object 'sys.syssingleobjrefs' with unique index 'clst'. […] [Cannot Force Encryption - SQL Will Not Take Cert]( - Hi there, I have a sql server on government AWS and we're trying to satisfy a requirement to force encryption on the server. I have tried creating self signed certs and we have obtained official certs from DoD, but the SQL configuration manager will not accept the certificates. I have been able to get it […] SQL Server 2022 - Development [Login failed for user sa sql server 2022 - windows server 2022]( - i got the login failed error for user sa, but not always so I went to server properties - security - server authentication change to windows authentication mode and change again to sql server and windows authentication mode, and restart sql server. this happened when i upgraded to sql 2022, I have Service Pack 13 […] [Login failed for user sa sql server 2022 - windows server 2022]( - i got the login failed error for user sa, but not always so I went to server properties - security - server authentication change to windows authentication mode and change again to sql server and windows authentication mode, and restart sql server. this happened when i upgraded to sql 2022, I have Service Pack 13 installed, […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -