Back with a new focus
First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career have been focused on transitioning...
2019-05-19
35 reads
First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career have been focused on transitioning...
2019-05-19
35 reads
If you have not already seen in the What’s New in Integration Services list there is a new property for...
2016-07-21
1,764 reads
Why create your databases manually if you don’t have to? If there is one thing that I hate to do...
2016-07-20
866 reads
Wanted to just post my latest versions of my Date and Time Dimension scripts. It has been a couple years...
2016-05-09
405 reads
The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...
2016-04-05
589 reads
Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...
2016-04-01
851 reads
If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...
2016-01-22 (first published: 2016-01-13)
2,267 reads
One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...
2016-01-20
1,325 reads
As we embark on a new year I decided to take a look back at my career within I.T. trying...
2016-01-12 (first published: 2016-01-06)
2,255 reads
While I never really enjoy a cross country flight back home my feet are very happy that I am finally...
2016-01-11
338 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