Windows Azure pay per minute – Time is money !
One of the most exciting news which got announced yesterday was related to Windows Azure. When Scott Guthrie mentioned that billing...
2013-06-04
701 reads
One of the most exciting news which got announced yesterday was related to Windows Azure. When Scott Guthrie mentioned that billing...
2013-06-04
701 reads
Let’s be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on...
2013-06-07 (first published: 2013-06-04)
1,775 reads
Just when you thought you got a handle on SQL Server 2012, here comes the next version! SQL Server 2014 was announced...
2013-06-07 (first published: 2013-06-04)
6,989 reads
There's enough from this morning's 2013 Techno Security and Forensics Investigation Conference to split into multiple blog posts. I'll focus this...
2013-06-04
1,164 reads
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...
2013-06-03
1,384 reads
Oh my god, there are so many events happening this month it is crazy. I’m going to break with tradition...
2013-06-03
702 reads
A while back I wrote a blog post at the House of Brick technical blog that details talking points and...
2013-06-03
720 reads
As the world is going green, Microsoft announced today that it is going “Blue”. Confused? I’ll explain all in a...
2013-06-03
1,273 reads
I was searching all over the place to try to find out how to move files into Azure Storage. Most...
2013-06-03
2,393 reads
I was asked today to take a table with a social security column and put all 0s if the column...
2013-06-03
925 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