Compare Patch levels across all installed sql instances
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
745 reads
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: 2020-05-13)
619 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: 2020-05-12)
1,362 reads
Blogs
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Daily Coping 27 Sep 2022
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Running SQL Server in Windows Subsystem for Linux (WSL)
I previously wrote a post on how to convert a SQL Server Docker image...
Forums
The Migration Tool to Use III
Comments posted to this topic are about the item The Migration Tool to Use...
SSIS File System Deployments
I created a package that utilizes environment variables in the configuration manager to toggle...
Create a DACPAC to only update not replace a SQL Server Database
Hi there We have been creating a DACPAC from a SQL server database project...
Ask SSC