Alexander Safronov

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

2020-05-22 (first published: )

68 reads

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

2020-05-22 (first published: )

513 reads

Blogs

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Daily Coping 10 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Creating a Dimension with no Primary Key

By daithiboy

Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and...

Code signing a dll with certificate for use in SQL Server 2016

By fafful

I have a dll that will perform some webservice calls function. in order to...

Find whether a clustered index is actually unique

By DamianC

Hi   I have a table that has a clustered index on it The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers