SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Creating a DB

  Hi there, when creating a DB with Auto close= False Auto shrink= True Database read only= True with…

  Nusc

  7 replies

  5 years ago

  By: Jeff Moden

• How do I reattach my databases?

  Yesterday I went through the process of replacing an old, failing hard drive, out of my Windows 10 …

  Doctor Who 2

  2 replies

  5 years ago

  By: Doctor Who 2

• moving one 500 GB DB from lower version to SQL Server 2019

  Hello Gurus, Task is to move a  500 GB  DB from lower version ( source ) to a brand new server ( de…

  sqlguy80

  4 replies

  5 years ago

  By: Mr. Brian Gale

• Using MS SQL Server Security mechanisms in a three-tier architecture

  I am trying to understand how I can use the db server authentication - authorization mechanisms and…

  badok12an

  1 replies

  5 years ago

  By: Grant Fritchey

• Queries run by a particular login or Database user in SQL Server 2016

  Hello, Is there a way in SQL Server to find out which queries were run by particular login in SQL S…

  MillionQueries

  3 replies

  5 years ago

  By: MillionQueries

• Trouble installing latest version of SSMS

  Last night I went to the control panel and removed any programs that had 'SQL' in its name.  That w…

  michael.leach2015

  5 replies

  5 years ago

  By: michael.leach2015

• SQL native client oledb method

  Hi Expert,   I have encrypted the connection from the application side and wants to encrypted …

  Shree23

  2 replies

  5 years ago

  By: Shree23

• connecting to named instances from sql server to sql server, firewalls

  I am setting up a Win2019/Sql2019 server.  Setting up the firewalls for the default services are fa…

  Steve T

  6 replies

  5 years ago

  By: Steve Jones - SSC Editor

• Table, Stored Proc, DB Last Used Date?

  Has it become any easier in recent releases to see when a table, stored procedure, database was las…

  homebrew01

  3 replies

  5 years, 1 month ago

  By: homebrew01

• Looking for the cmd to Recompile ALL procs across ALL DBs on a single SQL Server

  This command will update ALL stats on ALL DBs on a single SQL Server: exec sp_MSForEachDB 'use ?; i…

  Express12

  7 replies

  5 years, 1 month ago

  By: Jeff Moden

• Cannot create cloud witness for Windows cluster on Azure

  All Windows firewalls are actually turned off. The Windows Cluster is the 1st step for my SQL AG se…

  dbdude

  2 replies

  5 years, 1 month ago

  By: jcarranza 23978

• SQL2019 AG setup on Azure with working Listener but not being shown

  I setup a Windows 2019 cluster and SQL2019 AG on Azure for some proof of concept that I need for wo…

  dbdude

  2 replies

  5 years, 1 month ago

  By: jcarranza 23978

• Linked server authentication error

  I have a db and app server. I created a LS on the DB server and this works. It uses an AD account a…

  Darryl Wilson

  3 replies

  5 years, 1 month ago

  By: Sue_H

• Creating a User Account on a database

  Hi Im a bit rusty with SQL and Im moving over into administration a little more now. Ive created a …

  Debbie Edwards

  5 replies

  5 years, 1 month ago

  By: Steve Jones - SSC Editor

• SQL 2019 features

  Does anyone knows that SQL 2019 came up with tables to contain additional character lengths vs SQL …

  Admingod

  3 replies

  5 years, 1 month ago

  By: frederico_fonseca