Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
673 reads
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
673 reads
It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection...
2017-04-05
682 reads
You can see me in May at VS Live in Austin, where I and many others will be talking DevOps....
2017-04-04
537 reads
I’m speaking as part of a small panel for IT GRC Forum on keeping up your data security program in the...
2017-04-04
318 reads
On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and...
2017-04-04
360 reads
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
649 reads
Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...
2017-04-04
411 reads
For most of the time I’ve been working for Redgate, we’ve had some sort of R&D group that tries out...
2017-04-04
508 reads
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
593 reads
One of my clients came up with a requirement to use log shipping along with an AlwaysOn Availability Group. They cannot extend an AlwaysOn replica to the disaster recovery...
2017-04-04
24 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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