SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Migrate 10 Gb database from MSSQL to MYSQL

  Hi All, Does anyone have experience in moving /migrating database from mssql to mysql. I have tired…

  Saran

  17 replies

  3 years ago

  By: frederico_fonseca

• Sqlagent data transfer issue

  I am not an sql person but have been asked to investigate strange behaviour when transferring large…

  Blokeandbird

  7 replies

  3 years ago

  By: Blokeandbird

• Fix for SSPI context error uses RC4 - any alternatives?

  Hello experts, I've been trying to resolve an issue that seems to happen when SQL Server 2019 runs …

  webrunner

  1 replies

  3 years ago

  By: frederico_fonseca

• SQL 2019 SQLBrower.exe

  Hi, Has anyone encountered an issue like this before - I have a 3 node active, active passive clust…

  TJ_SQLDBA

  5 replies

  3 years ago

  By: durai nagarajan

• Pitfalls of setting up MySQL as a linked server in SQLEXPRESS

  I have a database in MySQL 5.7 that I need to link to a DB in SQLEXPRESS so that I can selectively …

  agerber85

  3 replies

  3 years ago

  By: agerber85

• Linked Server With SQL Authenticated Users

  I'm facing an issue that has me stumped. Server A is linked to Server B via "be made using this sec…

  RonMexico

  10 replies

  3 years ago

  By: Andy sql

• SP_whoisactive duration vs Profiler Duration for SP_prepexec statements

  Hi I have an application that executes statements using sp_prepexec and an sp_unprepare after each …

  Alexp012

  3 replies

  3 years ago

  By: Grant Fritchey

• Alwayson availblity group on dev edition vs enterprise edition

  We would like to set up two test instances for test alwaysOn availability group for disaster recove…

  sqlfriend

  3 replies

  3 years ago

  By: sqlfriend

• DENY DELETE to does not seem work for me

  I grant database roles to our developers in the Azure sql databases.  I need to DENY DELETE on all …

  Coriolan

  2 replies

  3 years ago

  By: Coriolan

• Hiding SSRS Jobs does not work

  Ahoy, i have a weird/annoying problem which i cant get my head around. We have implented the follow…

  ktflash

  1 replies

  3 years ago

  By: ktflash

• SQL Server Transaction Log Backup Fails Intermittently backing up to Azure

  Just recently we have been receiving: BackupIORequest:ReportIOError: write failure on the backup de…

  ericwenger1

  1 replies

  3 years ago

  By: ericwenger1

• SPN / SSPI Context error even though SPN exists

  Hello experts, I've been dealing with a maddening issue. I am getting the familiar error "The targe…

  webrunner

  2 replies

  3 years ago

  By: EdVassie

• Need Help with SQL

  Hello, its the first time I am here, I am a new programmer who is currently learning Java + MySql, …

  Di

  3 replies

  3 years ago

  By: Jeff Fant

• Can SQL 2019 appear as SQL 2008 R2?

  There's a manager where I work, who has a nasty habit of springing something upon you, with the exp…

  Rod at work

  5 replies

  3 years ago

  By: Jeff Fant

• SQL server 2008 upgrade to 2016 or 2019 enterprise

  I have 2008 enterprise I would like to upgrade,questions I have sql server 2016 standard replicatin…

  juliava

  3 replies

  3 years ago

  By: frederico_fonseca