I’m speaking at SQL PASS 2016 (Speaker Idol)
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...
2016-09-29
786 reads
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...
2016-09-29
786 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-09-28
1,255 reads
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,792 reads
PASS is our community.
It may sound a little cliche in this time of election propaganda in the US, but it’s...
2016-09-28
731 reads
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect...
2016-09-28
1,174 reads
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,144 reads
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...
2016-10-12 (first published: 2016-09-28)
3,888 reads
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
552 reads
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to come with a single language to manage a heterogenous...
2016-09-28
21 reads
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to...
2016-09-28
3,489 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