Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
136 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)
263 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)
625 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
202 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,675 reads
Blogs
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental...
Daily Coping 1 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Power BI – Hungry Median – Aggregations
Introduction In my last blog post, I have addressed an issue with DAX Median...
Forums
SQL server service account lost permission on directories
I last week installed a SQl 2019 instance on a new server, applied the...
poor performance function
Hello friends. This is my table "Cuentas" [IdCuenta] [int] IDENTITY(1,1) NOT NULL, [IdJerarquia] [int]...
Random Timeout Error
Hi, following a code release we have seen random timeout errors. I'm not sure...
Ask SSC