SQL Server on Linux, first observations.
Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going...
2016-11-22
596 reads
Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going...
2016-11-22
596 reads
A short break in speaking, as I haven’t been on stage since Oct 11.
Now it’s two weeks to Live! 360...
2016-11-24 (first published: 2016-11-21)
849 reads
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article, I’m going to try to figure out how.
Update: Since...
2016-11-21
22 reads
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article,...
2016-11-29 (first published: 2016-11-21)
2,933 reads
The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics...
2016-11-28 (first published: 2016-11-21)
1,287 reads
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....
2016-11-28 (first published: 2016-11-21)
2,921 reads
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if...
2016-11-25 (first published: 2016-11-21)
2,588 reads
No No, not my new hat, although it is rather splendid. I have received the weekly email from Learning Tree listing...
2016-11-21
459 reads
Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made...
2016-11-21
360 reads
I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try...
2016-11-21
580 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