SSIS 2012 Deployment Fail
(Update: Part 2 focuses on clearing out the SSISDB by creating new stored proc based on the one used by the maintenance job. If your Maintenance Job is taking...
2013-05-22
21 reads
(Update: Part 2 focuses on clearing out the SSISDB by creating new stored proc based on the one used by the maintenance job. If your Maintenance Job is taking...
2013-05-22
21 reads
Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.
They can handle unexpected database growth...
2013-05-21
464 reads
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...
2013-05-21
5,961 reads
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
831 reads
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s. A video...
2013-05-21
727 reads
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...
2013-05-21
795 reads
One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company...
2013-05-21
2,008 reads
A little more than a year ago while working at Idera, I was consulted on reports from a few clients...
2013-05-21
1,230 reads
This past Saturday I was fortunate enough to present a session at the largest SQL Saturday EVER in Alpharetta GA....
2013-05-21
511 reads
Development and demo environments can be hard to come by. Over the course of this series you will learn how...
2013-05-21
2,297 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