MySQL and Backups As A Service
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
611 reads
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
611 reads
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
258 reads
I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw...
2017-05-10
775 reads
It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was...
2017-05-10
1,025 reads
Last week I was having an issue with a SQL install within a container and to fix I needed to...
2017-05-10
2,140 reads
Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the...
2017-05-10
571 reads
One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on...
2017-05-10
35 reads
One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is...
2017-05-10
2,673 reads
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...
2017-05-10
3,788 reads
My fantastic friend Andre Kamman b | t and I presented at PSConfEu last week
and whilst we were there we were...
2017-05-26 (first published: 2017-05-09)
1,011 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