Alexander Safronov

Sr. DBA @ Adams12 Five Star School District. Thornton, CO.
20 years of experience with SQL Server (from 6.0).

Technical Article

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: )

467 reads

Technical Article

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: )

1,254 reads

Blogs

Daily Coping 27 May 2022

By

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

Daily Coping 26 May 2022

By

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

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Read the latest Blogs

Forums

OLE DB provider \"SQLNCLI11\" for linked server

By EasyBoy

We have a DTS package running on one of the production server. This is...

Need to provide access to database without giving access to production

By gray6

Hoping I could find some best practice answers here: We have analysts who need...

Fill missing rows in dataset

By Ombir

I have data in table like this. I want to fill/insert the rows with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers