Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
178 reads
SQL Server Upgrade
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)
364 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,128 reads
Waking Up to No Support
Support for SQL Server 2008 and 2008 R2 ended yesterday. Steve has a few thoughts on what you should be thinking about today.
2019-07-10
204 reads
5 Questions to Ask When You Upgrade SQL Server
Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you’re probably doing upgrade projects. This is a good time to ask yourself 5 questions...
2019-06-07
2018-01-26 (first published: 2015-10-15)
6,711 reads
Blogs
Daily Coping 17 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Ethics in Modern Data at Music City Tech 2021
By Will Assaf
On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...
Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available
Last week, Kerry and I delivered a webinar with tips on how to set...
Forums
SSRS Migration Question
So I have a SQL 2017 server that has the two Report Server Databases,...
What is the specific job of the SQL Developer position?
I knew about the position of SQL Developer through an introductory newspaper. I found...
update final code where not contain x then null if not contain x and another cod
i work on SQL server 2012 I face issue i can't update table replacement...
Ask SSC