I am a Microsoft Data platform MVP
I am so excited and happy to be chosen to receive the Microsoft Data Platform MVP award. This is my...
2016-07-04
496 reads
I am so excited and happy to be chosen to receive the Microsoft Data Platform MVP award. This is my...
2016-07-04
496 reads
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...
2016-07-14 (first published: 2016-07-03)
3,515 reads
A really great feature that was silently added into June update of the Power BI Desktop is a feature called...
2016-07-03
1,101 reads
Scenario
This is a short article where I want to share something I discovered recently. I worked on an SSIS package...
2016-07-14 (first published: 2016-07-02)
1,977 reads
The PASS Security virtual chapter hosted a great webinar on Thursday. Amit Banerjee from Microsoft’s SQL Server Tiger Team (b|t)...
2016-07-02
896 reads
On one of my SQL Server instances, I see a lot of these infinite recompile messages in the SQL log....
2016-07-01
2,307 reads
I got a Pebble Classic watch for Christmas a few years ago, in Dec 2014 to be clear. That’s (as...
2016-07-01
552 reads
Last night at approximately 9:28 PM EST the June 2016 release of Power BI Desktop dropped, which you can download...
2016-07-01
701 reads
Giveaway details at the bottom for those interested
Dealing with development & sql servers, I like to know what type of network...
2016-07-01
1,479 reads
In the June update of the Power BI Desktop there were some really cool features that were added. I’d encourage...
2016-07-01
1,229 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