Things I learned in 2015
Happy 2016!
I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what...
2016-01-25
666 reads
Happy 2016!
I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what...
2016-01-25
666 reads
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-01-25
431 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-25
532 reads
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
654 reads
I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...
2016-01-22
658 reads
Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...
2016-01-22
637 reads
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
779 reads
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,683 reads
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
395 reads
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
503 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
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