Steps for Installing AlwaysOn Availability Groups - SQL 2019 (2020-12-07)

 SQLServerCentral Newsletter for December 7, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Steps for Installing AlwaysOn Availability Groups - SQL 2019]( - [Export SQL Server Data to Multiple Excel Worksheets with C#]( - [How to Execute SSIS Packages from SQL Server Agent]( - [From the SQL Server Central Blogs - Virtual Log Files]( - [From the SQL Server Central Blogs - Top 10 Must-Ask Questions Before Going to the Cloud]( Question of the Day - [The default ORDER BY]( The Voice of the DBA  Daily Coping Tip Discover your artistic side and design your own Christmas cards I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Seeking Growth The word of the day is na·ive·té: lack of experience, wisdom, or judgment. I used this word in a post, and wound up checking the spelling, since I constantly want to include an "i" instead of an "e" in middle of the word. As I saw the definition, I started to think about what this really means. We all experience this at times, after all, how can we gain experience except by working in a field where we lack it. The wisdom and judgment, hopefully come with experience, time, and (not too large) mistakes. The thing I've found often for myself is that I try to avoid situations where I am naive. I lean towards those places where I have some confidence, some wisdom, and experience. I work on my strengths most of the time. Certainly I've seen lots of people embrace that. We polish those things we enjoy, we have success with, and from which we get good feelings. When I coach, I see this often. Arguably, this is not the best use of most of your time. You ought to work on those things you don't do well, those weak points, the places where you are naive. Improve the lower end, and the entire finished product is better. Or is it? I think you need a balance here. It pays to continue to refine you top skills, but it's also good to grow and embrace things where you have little skill. Step into areas with the acceptance that you may make mistakes. Grow and learn, and embrace new ways or working, or even refinements to your skills. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Steps for Installing AlwaysOn Availability Groups - SQL 2019]( Ginger Keys Daniel from SQLServerCentral With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […] [Export SQL Server Data to Multiple Excel Worksheets with C#]( Additional Articles from MSSQLTips.com In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file. [How to Execute SSIS Packages from SQL Server Agent]( Steve Jones - SSC Editor from SQLServerCentral Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow. From the SQL Server Central Blogs - [Virtual Log Files]( Kevin3NF from Dallas DBAs Today’s post is a guest article from a friend of Dallas DBAs, writer, and fantastic DBA Jules Behrens (B|L) One common performance issue that is not well known that... From the SQL Server Central Blogs - [Top 10 Must-Ask Questions Before Going to the Cloud]( kleegeek from Technobabble by Klee from @kleegeek After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top ten must ask questions before migrating to the cloud so that you can save time, money,...   Question of the Day Today's question (by Steve Jones - SSC Editor):  The default ORDER BY If I have an ORDER BY in a SELECT, what is the default ordering? 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) Autocorrect for Git What command will enable autocorrect in the git command line for all repos, with a 2 second delay? Answer: git config --global help.autocorrect 20 Explanation: You can set help.autocorrect as a global option. The delay for this is in tenths of a second, so 2 sec is 20. Ref: - Auto-Correct Git Commands - - Customizing Git - - Tip: Enable Autocorrect for Git - [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 [alias SQL multisubnet failover = true]( - Good morning all , I have an always on instance to configure with a listener in mutlisubnet mode on the application side I am unable to add multisubnetfailover = true is it possible to create an sql alias with this parameter DESKTOP-95KKMMH\DISS; multisubnet failover = true thanks [HA Availability Group Listener]( - I was looking for a specific definition for the Active Directory / DNS team as to what I need set up for an HA Group Listener; does it just need to be a DNS name, IP address, and Directory Object in AD? If so, what is the object called, a cluster object? I have the […] SQL Server 2017 - Development [Operand type clash: text is incompatible with datetime2]( - Dear Group: I am not sure what is causing this, and having a terrible time debugging and hoping someone might notice what I am missing. If I take the actual SELECT * FROM OPENQUERY(......) and run it, I have no problem and the data is returned, so there isn't anything wrong with the SELECT statement, […] SQL Server 2016 - Administration [is_merge_published]( - I'm running the following query to get a list of my Merge Publications but I'm getting results of publications I have deleted a long time ago. Thanks in advance, David. SELECT name as merge_published_db FROM sys.databases WHERE is_merge_published = 1 ORDER BY merge_published_db [Performance and usage of system stored procedure sp_columns_100]( - Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query. I know there are many ways to this, but I just noticed this result and want to know if anyone knows what might make this particular code come up at the top of this particular report. It seems like this system […] Administration - SQL Server 2014 [Can I clone a database across servers?]( - Hi all, I have a database that resides on server A and I need to create its clone on server B. I am using DBCC clonedatabase command. I have a linked server from B to A. And I can create an opposite linked server too, from A to B. Is it possible, and if yes, […] [sp_refreshview on indexed views]( - Hi I have to increase the size of a field in a table. I've listed all the views that use this table so I can run sp_refreshview on these. I'm left with a couple of schema bound views that use the underlying table, but not the changed field otherwise it wouldn't have allowed me to […] SQL Server 2019 - Administration [Virtual SQL - Standard vs Enterprise, per-core]( - Hi, I understand that licensing all the Cores in a physical host with Standard Edition and SA give almost the same benefits as Enterprise Edition with SA, but what does the one that isn't included in Standard - Unlimited Virtualization - actually mean? I'm working on a 2-site design that involves SQL versions 2012 through […] [SQL server service account lost permission on directories]( - I last week installed a SQl 2019 instance on a new server, applied the service pack. Everything looks fine. Then this week when I login to that server again I noticed all the services in the configuration manager are down, this include database engine, SSIS, and SQL server agent. I tried to restart the services, […] SQL Server 2019 - Development [Can I download Shapefiles for all countries from somewhere?]( - I'm trying to get my head around the Geography/Geometry methods in SQL Server... are the shapefiles for all the countries downloadable from somewhere? So far I haven't found them. [Random Timeout Error]( - Hi, following a code release we have seen random timeout errors. I'm not sure whats causing the system to slow down to the point that a timeout happens so set a SQL profiler running and found that on 2 traces before the timeout occurs there is a deadlock thing recorded... SET DEADLOCK_PRIORITY -10 Does this […] SQL Azure - Development [What is the best way to create events from table inserts in SQL Server]( - I have a SQL 20XX database in an on-premise data center that has a table, call it acct.trans_history, with about 1 million rows in it generated per day (and truncated at the end of the day). It is a table written by an old accounting application. This is a table that looks like an accounting […] General [poor performance function]( - Hello friends. This is my table "Cuentas" [IdCuenta] [int] IDENTITY(1,1) NOT NULL, [IdJerarquia] [int] NOT NULL, [Cuenta] [varchar](20) NOT NULL and I use this function CREATE FUNCTION [dbo].[fIdCuentaPadre] (@IdCuenta as integer) RETURNS integer AS BEGIN DECLARE @IdJerarquia INT DECLARE @Cuenta VARCHAR(20) SELECT @IdJerarquia = idjerarquia, @Cuenta=Cuenta FROM cuentas WHERE idCuenta = @idCuenta RETURN (SELECT TOP(1) […] [Costing per database]( - Hi, I am just checking to see if anyone has ever did a costing per database (based on it size). I am trying to figure out what the cost is for a database throughout its lifecycle. I am looking for mow much disk space will each DB use, how much memory does it require, how […] Integration Services [SSIS Startup directory not found]( - This seems to be a common issue throughout my packages. Anywhere I try to access anything in the startup directory. The startup directory is a server URL mapped to Z:\. In this example package. The task that is failing is a script task that verifies the components required are in the startup directory. This is […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -