SQL Server & Containers – Part One
Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News...
2016-11-16
662 reads
Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News...
2016-11-16
662 reads
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
3,393 reads
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-15
1,106 reads
Since Power BI is all the rage right now, I was in need of some material to spice up my...
2016-11-21 (first published: 2016-11-15)
2,143 reads
After lots of crisis in last month, We are back again.
Sorry for inconvenience caused !
Reference : Rohit Garg (http://mssqlfun.com/)
You can find...
2016-11-15
527 reads
Spaghetti Sauce Origins
During the 1970s consumers had a limited number of spaghetti sauces that they could purchase at their local supermarket. Each store-bought sauce tasted the same, developed in test...
2016-11-15
26 reads
In this module you will learn how to use the Scroller Power BI Custom Visual. The Scroller has the appearance...
2016-11-22 (first published: 2016-11-14)
1,844 reads
Background
We have recently been working on large data migration project for one of our clients and thought I would share...
2016-11-18 (first published: 2016-11-14)
1,477 reads
After the MVP Summit, I was excited to check out more code and features in all aspects of SQL Server,...
2016-11-18 (first published: 2016-11-14)
1,881 reads
I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday,...
2016-11-14
439 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