Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-09
1,143 reads
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-09
1,143 reads
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
166 reads
I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San...
2017-08-09
192 reads
I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San...
2017-08-09
339 reads
In this module you will learn how to use the Quadrant Chart Custom Visual. The Quadrant Chart is used to...
2017-08-09
646 reads
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are...
2017-08-09
310 reads
We know that we need to keep our credentials secure. We know that we should not re-use our passwords across...
2017-08-09
1,603 reads
I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason...
2017-08-09
259 reads
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
983 reads
I’ve recently started contributing to the dbatools project and it’s all done through GitHub. Prior to this, I’d never used git and GitHub for anything more than an offsite...
2017-08-09
17 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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