Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
694 reads
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
694 reads
One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the...
2017-08-11
1,288 reads
Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on...
2017-08-29 (first published: 2017-08-11)
1,884 reads
Original help was identified from this article Why is VirtualBox only showing 32 bit guest versions on my 64 bit...
2017-08-10
145 reads
Well, that’s something to be proud of. This is my 500th post on this blog. Not including a handful of...
2017-08-10
423 reads
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up...
2017-08-10
506 reads
Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing...
2017-08-10
425 reads
And like the wind another SQL Saturday Louisville has come and gone. This past weekend seemed to be a huge...
2017-08-09
490 reads
I always have a special place in my heart for the SQL Server user groups of the mid-west. I ran...
2017-08-09
148 reads
I always have a special place in my heart for the SQL Server user groups of the mid-west. I ran...
2017-08-09
329 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