Power BI Custom Visuals Class (Module 21 – Advanced Time Slicer)
In this module, you will learn how to use the Advanced Time Slicer Power BI Custom Visual. The Advanced Time...
2016-11-01 (first published: 2016-10-17)
1,599 reads
In this module, you will learn how to use the Advanced Time Slicer Power BI Custom Visual. The Advanced Time...
2016-11-01 (first published: 2016-10-17)
1,599 reads
Troubleshooting
I ran into an error: The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)
I...
2016-10-17
1,375 reads
Can’t make it to the #SQLSummit? I know EXACTLY how you feel. Maybe not at the depths or level of...
2016-10-17
393 reads
I am proud to present that Deji Akomolafe from VMware Corporation, Cody Chapman from our team at Heraflux, and I will be presenting at...
2016-10-17
363 reads
On Thursday night, Oct 27, 2016, Andy Warren and I are hosting a game night event at the Washington State...
2016-10-25 (first published: 2016-10-17)
1,090 reads
I read all the time how SELECT * hurts performance. I even see where people have said that you just have...
2016-10-25 (first published: 2016-10-17)
4,431 reads
A couple of years ago I blogged about Installing the SQL Server 2014 Language Reference Help from disk.
With SQL Server 2016...
2016-10-27 (first published: 2016-10-17)
1,652 reads
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece...
2016-10-17
481 reads
I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...
2016-10-26 (first published: 2016-10-17)
2,829 reads
Most of you would know how to get the query plan from the cache via "sys.dm_exec_cached_plans" or "sys.dm_exec_query_stats" DMV or...
2016-10-17
974 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