SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• There and back again: From a partition number to a filegroup and vice versa

    I've been trying to navigate the DMVs concerning partitions and filegroups and find my way b…

  g.britton

  11 replies

  5 years ago

  By: g.britton

• extended events bulk copy process

  Trying to setup an extended event to capture bulk copy process. Was able to successfully capture so…

  Dhruva_51

  8 replies

  5 years ago

  By: Grant Fritchey

• SQL Agent Jobs

  There is a requirement to use application AD account to execute backend SQL Agent Jobs(SSIS Package…

  Admingod

  3 replies

  5 years ago

  By: Ant-Green

• SQL 2014 and above the Agent job text logs - how to redirect?

  For each of our backup jobs in SQL, they are management jobs as SSIS, when they run they create tex…

  Warren Peace

  1 replies

  5 years ago

  By: Ant-Green

• SQL Server Availability Groups on Kubernetes

  Hello, I wanted to ask if anyone knows if Microsoft is moving forward with supporting Availability …

  martinghale

  1 replies

  5 years ago

  By: martinghale

• stop responding to queries of specific database

  Hello I found a problem on my SQL Server instant, after 5-6 days the servers stop responding to que…

  neginsadeghi892@gmail.com

  5 replies

  5 years ago

  By: Ant-Green

• Unable to uninstall Sql Server 2019 in my Laptop

  Hello, I have installed Sql Server 2019 more than 6 months before and forgot the credentials. So I …

  vijayarajanse

  5 replies

  5 years ago

  By: wayne Freeman-369096

• Changing Data Drive Allocation Unit Size on Existing Installation

  I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup is fairly ty…

  garyb1

  2 replies

  5 years ago

  By: Mr. Brian Gale

• SQL server 2019 reporting need help

  Hello sql server reporting 2019, i created temp for 180 days and not sure what to do next, I need t…

  juliava

  4 replies

  5 years ago

  By: Ant-Green

• Grant Execute on ALL procs in a Database

  I see a lot of old, 10+ year old posts for SQL 2000, 2005 etc on this.    For our SQL 2019 environm…

  Express12

  2 replies

  5 years ago

  By: Grant Fritchey

• Where To Set Up SQL Server

  Background: We have MS Access database split with backend tables that we want to convert to SQL Ser…

  JP789

  9 replies

  5 years ago

  By: JP789

• upgrade path to SQL 2019

  I read the upgrade path for standard edition to SQL server 2019, the oldest version is SQL server 2…

  sqlfriend

  2 replies

  5 years ago

  By: Grant Fritchey

• Polybase and External table

  Hi - we have 2 SQL Server 2019 instances, both with Polybase installed. I created an external table…

  Robinson

  4 replies

  5 years ago

  By: Robinson

• HKCKP files \ sys.dm_db_xtp_checkpoint_files

  Hi all, does anybody know how can I get rid of the old files in the folder: \$HKv2 under my data fo…

  ran.ovadia

  2 replies

  5 years ago

  By: Evgeny Garaev

• Permissions

  Granting Connect,View any database and view any definition in UAT and PROD to Developers. Do you se…

  sqlguru

  6 replies

  5 years ago

  By: Mr. Brian Gale