Preserving Data
Today Steve has a few comments on backups and your ability to get to a restore in the event of an issue with your provider.
2026-08-31
296 reads
Today Steve has a few comments on backups and your ability to get to a restore in the event of an issue with your provider.
2026-08-31
296 reads
Downtime causes a lot of problems, not all of which are financial for an organization.
2025-09-22
194 reads
A few recent disasters inspire Steve to remind you to prepare now, before a disaster occurs.
2024-08-02
144 reads
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy.
2024-07-29
2024-04-03
761 reads
2024-03-21
535 reads
We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.
2023-12-01
An Azure datacenter had a failure after an incident, partially because they didn't have enough people. Steve notes that staffing is a challenge in many ways.
2023-09-29
213 reads
A disaster in LA affected many companies, some of which were innocent bystanders to the event. Steve talks about the need to have some plans in place.
2023-06-05
156 reads
Grant takes a few lessons for database DR from a nuclear accident in the US.
2022-08-06
141 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah 52663
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers