SQL Server 2012 AlwaysOn Groups and FCIs Part 1 (2023-03-29)

SQLServerCentral Newsletter for March 29, 2023 Problems displaying this newsletter? [View online](. - [SQL Server Central]( Featured Contents [SQL Server 2012 AlwaysOn Groups and FCIs Part 1]( - [Using TOP clause in a SELECT statement]( - [Piping, Filtering and Using Flyway Output in PowerShell]( - [From the SQL Server Central Blogs - WIT/DEI Mental Health and Wellness Day Challenge to Present]( - [From the SQL Server Central Blogs - My personal experience using kubecost in Kubernetes environment]( - [SQL Server Execution Plans, Third Edition, by Grant Fritchey]( Question of the Day - [Contained Availability Groups]( The Voice of the DBA  Being Responsible for Data For much of my career, I've run SQL Server Central. A large part of the popularity of the site is from the forums, where people can pose questions about their struggles with SQL Server and get answers from the community. There are also some [off-topic forums](, where people discuss various things outside of databases. In here, we have discussions a about life, sports, and more. While we do expect people to maintain an air of professionalism and respect others, we don't try to moderate content. That's how much of the Internet has worked, with various sites allowing users to post content, but not having any responsibility for what has been posted. The liability for that lies with the person doing the posting, which creates a thorny issue when users post anonymously. Setting that aside, I've been a proponent of this, not believing that Facebook or LinkedIn, or SQL Server Central ought to be liable for what users write and post. I do thinks users bear that responsibility. However, in the US, there is [a Supreme Court case that may change our view](, and that of many others. This case deals not with the data itself, but rather the algorithms that might display or recommend some of that data to others. That's an interesting approach to the case law that has shielded many tech companies from their users' poor behavior. Essentially the plaintiffs argue that Google and Twitter bear responsibility for their algorithms, which in this case aided terrorist recruitment. Meaning that the code they wrote to analyze data, essentially the queries that promoted content to users, were harmful. There are four possibilities listed in the article for what could happen, and I find them fascinating from a data analysis standpoint. Essentially a ruling against tech companies could shape how many of these companies process data in the future. While we might like to ensure these companies do not promote harmful content, think about this from the data analysis view? Do you want these companies to moderating how they provide results? Would this mean that we need to more carefully craft our search terms? In the context of tremendous floods of information, we often depend on Google, Bing, or some search algorithm to distinguish among the various meanings of words to bring back results relevant to us. At the same time, we might wish that everyone got the same results from the same search terms. Separate from the results, what about related results, or suggested items that might be related. I find the quality of these can vary for me, but often there is something "sponsored" or "I might like" that is helpful to me. Or just interesting. The infinite scrolling that many people live, getting similar recommendations is a double edged sword. It can increase learning, pleasure, etc. It can also send someone down a rabbit hole of anger and reinforcement of negative emotions. I think this also is one way that the content of the Internet creates division and disagreement among many. While I think users are responsible for their words, I also think that the way that these companies recommend and showcase content likely bears some responsibility. At the time time, I can't imagine how you regulate this, and I do not want to see a constant battle of lawsuits over how we interpret rules. The sex, drugs, and rock and roll issues of the past, where we tried to legislate morality, didn't work well. I don't want to see that again. There isn't a good answer here for me, and of the four possibilities, I fall somewhere between two and three. Some changes to section 230 (the legal writing) but not heavy changes or an abandonment of the way this has been interpreted. What do you think? Should we start to hold companies responsible for how they present content? I don't know I worry for SQL Server Central, but it might change other sites. For us, we just show things from the last 24 hours. It's not much of an algorithm, but it is one that likely isn't going to get us sued. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Technical Article]( [SQL Server 2012 AlwaysOn Groups and FCIs Part 1]( Perry Whittle from SQLServerCentral.com Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an AlwaysOn availability group. [External Article]( [Using TOP clause in a SELECT statement]( Additional Articles from Redgate There might be a time when you might want to return just a few rows of a result set, instead of the complete set. This might be useful if you want to just validate a selection criteria or a few rows of data. For whatever the reason the TOP clause can be used to return a specific number or a percentage of rows from a result set. This article will cover using the TOP clause in a SELECT statement and how it can be used to return a partial set of records. [External Article]( [Piping, Filtering and Using Flyway Output in PowerShell]( Additional Articles from Redgate Flyway's output is often overwhelmed with verbose messages, most of which we can ignore but some of which provide vital warnings about failed compilations, or useful details about what a migration or callback did. I'll show how to use some pipeline-aware PowerShell functions to filter out and save the bits we want and pass the results along in a form that is useful to the next process in the pipeline. [Blog Post]( From the SQL Server Central Blogs - [WIT/DEI Mental Health and Wellness Day Challenge to Present]( Tracy Boggiano from Database Superhero’s Blog Back in December 2019, I started presenting my session on mental health with lots of fear as to how the community was going to take The post WIT/DEI Mental Health... [Blog Post]( From the SQL Server Central Blogs - [My personal experience using kubecost in Kubernetes environment]( Adetokunbo Ige from Adetokunbo Ige What is Kubernetes? Kubernetes which is also referred to as k8. k8 is an open-source container orchestration platform that automates deployment, scaling, and management of the containerized application. k8... [SQL Server Execution Plans eBook, Third Edition, by Grant Fritchey]( [SQL Server Execution Plans, Third Edition, by Grant Fritchey]( Grant Fritchey from SQLServerCentral Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Contained Availability Groups In SQL Server 2022, a contained availability group adds which features to an AG? 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) Managed Instance Link and SQL Server 2022 What does the Managed Instance Link allow me to do with SQL Server 2022? Answer: Either replicate data to Managed Instance or failover/failback from SQL Server 2022 Explanation: The Managed Instance Link allows both replication and failover/failback from SQL Server 2022. Ref: Overview of the Managed Instance Link Feature - [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 [Calculate log space required on principle for maintenance activity]( - Hi all, We have a database configured for asynchronous mirroring. We have some planned maintenance activity on mirror server. Expecting for 6-8hrs. How to calculate the log space requirements on Principle server after you run the command on principle alter database set partner suspend [Need an alert for a sudden increase in data]( - Hi All, Today, all of a sudden the size of the data file (.mdf) is increased by 30 GB and drive got filled up. Is there a way, to get an alert on such sudden increase of data and can we capture the query(s) and spids which caused the data grow that huge? Regards, Sam SQL Server 2017 - Development [Tsql query to show currently running sql agent jobs]( - Hi All, Using Tsql query I want to know currently running sql agent jobs and how long they have been running in [dd hh:mi:ss]? Expected output: job name , start time, duration [dd hh:mi:ss] I can see it in Job activity monitor for currently running jobs but it is not telling me when it started […] [SQL Agent Job schedule]( - Hi All, Want to know what are the SQL Agent Jobs scheduled for today at what time they are going to run ? Env : SQL Server 2017 CU23 Regards, Sam [how to identify table(s) changing quite often]( - Hi All, Is there any query using which we can tell what is the table which is changing the most or more frequently? The idea, is to identify those tables and run update statistics with full scan on daily basis instead of weekly basis. Regards, Sam SQL Server 2016 - Development and T-SQL [SQL blocking caused by running ALTER VIEW script]( - Hello experts, One of our developers tried to alter a view and reported to me that it was taking a long time. When I checked, it turns out that, for some reason, running the ALTER script is consistently causing database blocking. I ran a trace to capture the blocked process report. Below is an excerpt […] SQL Server 2019 - Administration [SQL Agent jobs - script to get what jobs failed]( - I have been trying to find SQL that shows what SQL Agent jobs failed as our manager wants a report generated showing what jobs fail. The below SQL I have found but it shows which steps fail but that is not what I want. Reason being is that we have an AG environment and the […] [Need help desperately]( - I accidentally ran this on a dev server which has locked my acct and I am unable to drop the trigger. Can someone help please? --Create the dbo.ServerLogonHistory Table CREATE TABLE dbo.ServerLogonHistory ( EventType VARCHAR(512), PostTime DATETIME, SPID INT, ServerName VARCHAR(512), LoginName VARCHAR(512), LoginType VARCHAR(512), SID VARCHAR(512), ClientHost VARCHAR(512), IsPooled BIT ) GO --Grant insert […] SQL Server 2019 - Development [Seperator after value]( - Hi, I need to insert a separator after each value but I don't want to mess the db with irrelevant characters. The best separator would be a semicolon. I got 5 columns in my db and export them via SQL Server Agent further to my FTP Server. The easiest way would be through the Server […] [Get a Date Time Stamp of table when another columns value changes.]( - I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime] NULL, [Tagvalue] [int] NULL ) ON [PRIMARY] GO Inserted Values Like insert into MYDBtemp values ('2023-02-03 03:00:00.000', '1') insert into MYDBtemp values ('2023-02-03 04:00:00.000', '1') insert into MYDBtemp values ('2023-02-03 05:00:00.000', '2') insert into MYDBtemp values ('2023-02-03 06:00:00.000', '2') insert into […] [SSIS C# Script Question]( - Hi everyone I am working on a SSIS package where I am automating data collection and table updates. My script is not performing as expected. I am not sure how I can revise it in a way that doesn't make the script too complicated. I am hoping there is an efficient way to fix it. […] [Slow performance when processing a JSON file in Azure]( - We have a stored procedure that can load up a JSON file and process this in 12 seconds However on Azure ...this is taking up to 90 seconds. this is running on an Azure pay as you go database. Now the code isnt too complex as is doing the following. Code is shown... Json File […] SQL Server 2008 - General [how to write a query by using some filter patterns in SQL Server?]( - what I want is to apply some filter patterns to search the data. For example. There is a large physical table in the database regarding medicines, I want to allow search even if user write lasix, lasixx, lasixxx, lasax, lasi, lisax. Data should be retrieved for the medicine lasix. How can I write these filter […] SQL Server 2022 - Administration [script to find the frequent used login information in the sql]( - Hi, Kindly some one share the script or query to get the login information used for the sql database in the instance. InstanceName,DatabaseName,HostName,LoginName,Program,date used etc Thanks, Jo [SQL Server Agent is not expanding and Jobs are not visible]( - Hi, We are not able to expand the SQL SERVER Agent. It is taking very long time. It is throwing below error. Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: ADDITIONAL INFORMATION: Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) For help, click: -- If the Agent opens No […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -