SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• DEA

  What is the use of DEA tool in sql ?  how can we  install on sql ?

  ramyours2003

  1 replies

  5 years ago

  By: Sue_H

• restore from azure blob

  Good morning all , I must restore my backup from AZURE URL except that I have this error RESTORE D…

  abdalah.mehdoini

  5 replies

  5 years ago

  By: Johan Bijnens

• Explanation of duration in MS

  I have a query that is long running. It takes about 30 seconds to run. My question is why does this…

  stevec883

  2 replies

  5 years ago

  By: stevec883

• SQL Server 2016 mdf encrypted by ramsomware

  Hi, I'm a accidental DBA and had an ramsomware attack today. I stopped the attack but it encrypted …

  helder-filipe

  3 replies

  5 years ago

  By: Summer90

• Log Shipping into an Availability Group

  I have a database I need to migrate to a new environment that is being built. The current environme…

  fodderoh

  2 replies

  5 years ago

  By: Cebisa

• how to migrate certain filegroups with partitions to another server

  Hi guys, I have 3 partition tables on multiple file groups on monthly basis., each month it generat…

  i1888

  5 replies

  5 years ago

  By: i1888

• Backup space

  I am trying to get the backup space estimate based on the dev server since I need to know how much …

  Admingod

  2 replies

  5 years ago

  By: Jeffrey Williams

• Replication

  I would like to know if any one in this group has worked with Qlik attunity Replicate it is a Data …

  Admingod

  1 replies

  5 years ago

  By: Admingod

• SQL Script Help

  I am looking for a script  that can return the following values for each of the databases in my ins…

  EMtwo

  15 replies

  5 years ago

  By: Phil Parkin

• How does sql server agent access the azure storage blob

  Good morning all , I must configure an automated backup to an azure blob storage in the backup scri…

  abdalah.mehdoini

  1 replies

  5 years ago

  By: Grant Fritchey

• Basic Availability Groups and AG Listener

  Hi Can anybody tell me, when setting up Basic Availability Groups in a 2 node cluster, do you requi…

  PearlJammer1

  2 replies

  5 years ago

  By: as_1234

• Changing nvarchar to varchar

  I have a table with millions of rows in it. The character fields are nvarchar. Currently its only g…

  terry999

  27 replies

  5 years ago

  By: Jeff Moden

• Script to monitor total size of transaction log backups between 2 dates / times

  Hi Looking for a script which will show me the total amount of transaction logs taken in mb or gigs…

  caz100

  4 replies

  5 years ago

  By: Mr. Brian Gale

• backup to blob azure with sa account

  Good morning all I must make backup to Azure BLOB URL Can I do this type of backup with the SA acco…

  abdalah.mehdoini

  1 replies

  5 years, 1 month ago

  By: Steve Jones - SSC Editor

• Trying to Make combinations within a bracket in SSMS column

  This is what the data looks like, I need to break the Column TID prefix as the first letter outside…

  riddhi10

  6 replies

  5 years, 1 month ago

  By: Steve Jones - SSC Editor