2024-09-09
379 reads
2024-09-09
379 reads
2024-08-26
365 reads
2024-08-12
512 reads
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
4,515 reads
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
6,425 reads
2023-09-25
462 reads
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
300 reads
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)
1,101 reads
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)
2,347 reads
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
299 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers