Why Log Shipping is Better than Database Mirroring for Migrations
This topic has come up several times recently, so I feel the need to blog on it. As the person...
2017-05-05
1,162 reads
This topic has come up several times recently, so I feel the need to blog on it. As the person...
2017-05-05
1,162 reads
It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap...
2017-05-05
1,388 reads
Into May and a big couple of events this week in SQL Nexus and the Powershell Conference EU 2017, looking...
2017-05-05
480 reads
I’m going to walk through an example that we can build up and improve with a number of the new...
2017-05-05
67 reads
7th Interview of #DataChannel is out 🙂 Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge on "Managing SharePoint Databases" on #DataChannel. Steve, demystifies...
2017-05-05
21 reads
7th Interview of #DataChannel is out 🙂 Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge on "Managing SharePoint Databases" on #DataChannel. Steve, demystifies...
2017-05-05
20 reads
7th Interview of #DataChannel is out 🙂
Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge...
2017-05-04
425 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-04
798 reads
It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL PowerShell world! It’s all my fault I’ve been spending...
2017-05-04
10 reads
It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL PowerShell world! It’s all my fault I’ve been spending...
2017-05-04
23 reads
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...
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