SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server 2019 container kubernetes

  Hi everyone, can anyone tell me, if the sql server 2019 is ready for container and is there an offi…

  andreas.kreuzberg

  1 replies

  5 years ago

  By: Steve Jones - SSC Editor

• Retrieve Encrypted data from SQL in MS Excel

  Hi I have a customer who has an SQL database and would like to encrypt columns i.e bank details. bu…

  Raxso1

  1 replies

  5 years ago

  By: Steve Jones - SSC Editor

• Export encryption keys to SQL 2019 from MySQL

  Hi My customer is migrating from MySQL to SQL 2019 using SSMA, thier current MySQL uses PHP and enc…

  Raxso1

  1 replies

  5 years ago

  By: Steve Jones - SSC Editor

• Cannot attach databases in folder after power outage

  We had a power outage on one of our hosts, and it unfortunately caused some problems on two of our …

  cphite

  3 replies

  5 years ago

  By: prettsons

• SSRS - connecting to multiple SQL Instances

  Hi, We have 4 SQL instances (2014, 2016, 2017, 2019) all using AOAG. What's the score with SSRS con…

  lanky_doodle

  9 replies

  5 years ago

  By: Jeffrey Williams

• Data Analization

  Dear Forum, I would like to ask the following question: We have 50 excel tables. Each table has abo…

  Rose

  2 replies

  5 years ago

  By: pietlinden

• Licensing question

  Thinking of getting a perpetual standard licensing with certain number of cores. Was wondering what…

  noobdba

  2 replies

  5 years ago

  By: noobdba

• SQL Server database "fail safe"

  Hi, I have SQL Server 2019 Enterprise Edition and would like to know what would be the best way to …

  PiMané

  10 replies

  5 years ago

  By: Steve Jones - SSC Editor

• SSIS package succeeds but fails

  Here's an odd one for you. SSIS 2012 package put into SSIS 2019 (SQL Server, not Catalog or file sy…

  Brandie Tarvin

  14 replies

  5 years ago

  By: frederico_fonseca

• Headline: spreadsheet data analysis system for beginners

  Dear community, I want to ask you the following question: I have a larger set of data. It consists …

  Rose

  4 replies

  5 years ago

  By: Grant Fritchey

• load zipcode with extension

  Hi, I am trying to load data from files to tables. One of the columns is a zip code column which in…

  Ram

  1 replies

  5 years ago

  By: Mr. Brian Gale

• SQL Server upgrade from 2017 to 2019

  We are currently in the process of migrating from Teradata to MSSQL and using SQL Server 2017.  Doe…

  TD_SQLDBA

  2 replies

  5 years ago

  By: Grant Fritchey

• Set Up SQL Server on SANs, NAS or computer

  We are a small manufacturing company with about 8 – 12 users of our application that work mostly re…

  JP789

  5 replies

  5 years ago

  By: Steve Jones - SSC Editor

• 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