2024-09-09
379 reads
upgrading
2024-08-26
365 reads
2024-08-12
512 reads
2024-07-10 (first published: 2024-07-08)
159 reads
2024-02-26
286 reads
Why Don't You Upgrade in Place?
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,513 reads
2023-10-13
385 reads
Restore With Standby; A Review and A Lesson Learned
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
6,421 reads
Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
976 reads
The Slow Upgrade of SQL Server Versions
It seems that instances are being upgraded about every ten years, according to Steve's interpretation of some reports. Do you agree? Let us know how often you upgrade.
2021-08-16
333 reads
Blogs
Creating a GitHub Actions Self-Hosted Runner
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore
This is more complicated than using the Azure Migration method, but because it’s maxed...
PowerShell (and T-SQL) and Elastic Jobs
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Forums
Contracting DBA - Permissions for initial analysis
Accidental DBA here. After looking at all the work that needs to be done,...
How to convert run_date and run_time columns to datetime from SQL Agent systable
Hello SSC, Hope you are all having a great Monday! I am trying to...
SQL Server Reporting Services 2022 Permissions Issue
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Question of the Day
AG Rules for Databases
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers