Attaching Database Using SMO & Powershell
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...
2016-11-18
1,102 reads
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...
2016-11-18
1,102 reads
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
SQL Server 2016 SP1 has been released....
2016-11-18
434 reads
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,400 reads
Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made. Here is a summary of the...
2016-11-17
632 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-11-17
737 reads
Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are...
2016-11-17
896 reads
SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...
2016-11-17
732 reads
They finally did it! Finally SQL Server for Linux was announced. I’ve been waiting for this for quite a while, so...
2016-11-16
1,340 reads
SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better,...
2016-11-16
1,192 reads
In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward. Aside from significant relational engine...
2016-11-16
457 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