2020-10-22
9,577 reads
2020-10-22
9,577 reads
It's not the first task when I start a new job, but often as a DBA or developer, I usually ask about Disaster Recovery (DR) plans sometime within the first six months. If I'm a DBA, of course I need a plan. If I'm a developer, however, I still need to understand how this might […]
2020-10-01
131 reads
Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.
2020-09-28
110 reads
Being prepared for things to go wrong is important, more so these days than in much of our past.
2020-09-04
104 reads
In this tip we look at how to restore a missing or corrupt SQL Server model database.
2019-12-23
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
2019-12-05
247 reads
Today Steve asks about HA and DR. What compromises and choices do you make in your environment and how do you ensure your clients can get to their data.
2019-11-22
247 reads
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”.
2019-10-31
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
745 reads
Severe weather events cause disruptions that could lead to security vulnerabilities.
2019-05-15
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers