My Build and Deploy Process (as Requested by Bill Fellows)
Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...
2015-11-10 (first published: 2015-11-05)
2,690 reads
Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...
2015-11-10 (first published: 2015-11-05)
2,690 reads
I started using a product called SQL Diagnostic Manager from Idera about 10 years ago at a Home Health company....
2015-11-05
520 reads
Ed Leighton-Dick has renewed his New Blogger Challenge this month. Here are all (I think) the posts for this week after Ed posted his announcement. If I’ve missed any, please let...
2015-11-05
19 reads
PASS Summit 2015 is over and of course, no PASS Summit is complete without also attending SQLSaturday Oregon. Below are...
2015-11-04
633 reads
I’m still catching up after my 13th PASS Summit and as usual the longer I wait the shorter the notes...
2015-11-04
553 reads
The day finally came and I was fortunate, no I was blessed to be a part of the PASS Summit...
2015-11-04
554 reads
It’s Wednesday and time to revive the Monday summary of last week’s blog activity and links shared on twitter. Hopefully I’ll be...
2015-11-04
438 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
One...
2015-11-11 (first published: 2015-11-04)
1,569 reads
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by...
2015-11-04
526 reads
I have added my first actual deployment contributor to my deployment contributor project:
https://github.com/DacFxDeploymentContributors/Contributors
The idea is basically for people to share...
2015-11-04
586 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