Speaking at SQL Saturday Spartanburg (#681)
I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg...
2017-08-30
505 reads
I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg...
2017-08-30
505 reads
On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip...
2017-08-30
3,166 reads
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
541 reads
I’ve been meaning to get to grips with Kubernetes for a while now but I have to admit, I was...
2017-08-30
891 reads
Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40010.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-2.aspx Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Virtual...
2017-08-30
796 reads
This year we’ve handed off Game Night to the PASS organization and it’s an official event. Volunteers from the community...
2017-08-29
651 reads
Watch this week's video on YouTube
Looking for a script to find possible SQL injection vulnerabilities on your server? Scroll to the bottom of this post.
OWASP names SQL injection as...
2017-08-29
37 reads
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,420 reads
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
1,435 reads
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
656 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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...
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