Power BI Custom Visuals Class (Module 42 – Stars)
In this module you will learn how to use the Stars Power BI Custom Visual. The Stars visual is a...
2017-03-14
854 reads
In this module you will learn how to use the Stars Power BI Custom Visual. The Stars visual is a...
2017-03-14
854 reads
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...
2017-03-27 (first published: 2017-03-14)
2,794 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,898 reads
Problem
Most DBAs are aware that (prior to SQL 2016) one of the most common, post installation changes that needs to...
2017-03-28 (first published: 2017-03-14)
6,024 reads
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this since it’s a big news! So, what exactly is...
2017-03-14
24 reads
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this...
2017-03-14
800 reads
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
388 reads
[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...
2017-03-13
24 reads
[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...
2017-03-13
1,551 reads
I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since...
2017-03-13
1,154 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