SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• What the best ways to create an AG and do failovers with 8TB databases?

  Hello. I've been working with AGs for a few years now.  However, in my latest position, I am now wo…

  WebTechie

  3 replies

  6 days, 19 hours ago

  By: Mr. Brian Gale

• One of two secondary replias is stuck in restoring

  Good afternoon, I had a 7.8 TB database that needed some work.  I removed the database from the AG,…

  WebTechie

  3 replies

  6 days, 22 hours ago

  By: Mr. Brian Gale

• Recommended Extended Event that will send an email

  I'm looking for an extended event recommendation that will send an email when a transaction runs lo…

  ericwenger1

  2 replies

  1 week ago

  By: Lowell

• Trouble Sending Email from Scheduled Job

  I'm a little rusty with SQL, been away a while. I have SQL Mail set up, and I can get a test email …

  homebrew01

  4 replies

  1 week, 5 days ago

  By: homebrew01

• AGs: Linked Servers and Kerberos

  Hey, When connecting SSMS using the AG name, it never works. Creating the linked server returns 'AN…

  lanky_doodle

  4 replies

  2 weeks, 4 days ago

  By: frederico_fonseca

• Each database having its own disk?

  Good morning, Once again, I find myself Sr. DBA for a company.  As I review this latest environment…

  WebTechie

  6 replies

  3 weeks, 1 day ago

  By: Perry Whittle

• Creating Maintenance plan to run annually

  What is the best way to set the schedule of a maintenance plan or a SQL Agent job to run annually. …

  Andre 425568

  2 replies

  1 month ago

  By: amandawilli

• Batchmode execution in SQL 2019

  Is there a way to force a query to use Batchmode execution, my database is in 2019 compatibility mo…

  SqlAdmin001

  4 replies

  1 month ago

  By: abdalah.mehdoini

• Migrating Temporal/systemversioned Tables

  Hello, for my client i have to do regular refreshes of production to dev. We have been automating t…

  bernaerts_joris

  1 replies

  1 month, 2 weeks ago

  By: Site Owners

• disable remote access

  If I configure remote access to 0 on my servers, am I right in saying that the only things that wou…

  goodtimecharlie

  3 replies

  1 month, 2 weeks ago

  By: Joie Andrew

• Transitioning AlwaysOn Availability Group to Synchronous Commit Mode

  Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas operating in…

  abdalah.mehdoini

  2 replies

  1 month, 3 weeks ago

  By: Abhinav

• Question about updating statistics

  We have very large tables in our database, some even more 1 B records, so updating statistics will …

  SQL Guy 1

  3 replies

  1 month, 3 weeks ago

  By: Abhinav

• Best/easiest way to import an SSIS package...

  Folks, Looking for advice on the best way to import a package. I hope I'm in the right location! Ap…

  jellybean

  2 replies

  1 month, 4 weeks ago

  By: WirkKarl

• balancing numa nodes

  Can anybody advise on how i go about balancing threads to each node. As you can see from the below …

  PearlJammer1

  3 replies

  2 months ago

  By: PearlJammer1

• Urgent, Please Help. Named Instance Question

  Hello all, I just installed a new named instance on SQL Server 2019 RTM-CU32.  The installation was…

  brettwalker42

  2 replies

  2 months ago

  By: Emperor100