Power BI Custom Visuals Class (Module 58 – Drilldown Choropleth)
In this module you will learn how to use the Drilldown Choropleth Custom Visual. The Drilldown Choropleth is a map...
2017-07-06
1,040 reads
In this module you will learn how to use the Drilldown Choropleth Custom Visual. The Drilldown Choropleth is a map...
2017-07-06
1,040 reads
“Climb the mountain to see the world, not be seen by the world.” – from Tim Ford.
This past July 1 was...
2017-07-06
466 reads
I want to take a moment to thank a few people for being amazing.
First up, Thomas LaRock is wrapping up...
2017-07-06
337 reads
I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I...
2017-07-06
470 reads
SQL Server 2012 introduced IIF and CHOOSE functions and I completely missed they even existed until recently. They make some...
2017-07-06
68 reads
If you are actively managing VMware environments with workloads that have high performance needs (such as all of the virtualized...
2017-07-05
506 reads
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-05
601 reads
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
196 reads
I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling...
2017-07-17 (first published: 2017-07-05)
2,793 reads
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts...
2017-07-05
798 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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