2024-02-26
156 reads
2024-02-26
156 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
3,314 reads
2023-10-13
367 reads
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
2,703 reads
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
645 reads
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
328 reads
2019-08-12
264 reads
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
246 reads
Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.
2023-07-26 (first published: 2019-05-03)
371 reads
2018-04-13
764 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers