Dir2Dac and github2dacpac - create dacpacs from script folders or the internet
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
24 reads
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
24 reads
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
57 reads
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
57 reads
I like writing go (golang not the batch separator) and one of the things that I like is that if you want to use something from github you literally...
2015-10-16
12 reads
Microsoft are releasing regular CTP updates for SQL Server 2016. In the very recent release (CTP 2.4), there is a...
2015-10-20 (first published: 2015-10-16)
3,576 reads
In a previous blog I talked about copying on-prem data to Azure Blob Storage (Getting data into Azure Blob Storage). ...
2015-10-15
858 reads
Its just a bit over a week until PASS Summit 2015 will start. If you are a Microsoft Data Platform...
2015-10-15
410 reads
In this article, I am going to address some better practices for Reading Event_file targets attached to an XEvent Session.
Related Posts:
How to: File Target use in Extended Events December...
2015-10-15
13 reads
I have demonstrated over the past couple of articles the basics involved with reading the
event_file target along with a more...
2015-10-15
647 reads
If you’ve worked with SSMS for any length of time this will look awfully familiar:
SSMS 2008R2
SSMS 2012 +
This little green...
2015-10-15
528 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