Behind the Scenes of an Online Presentation
Last week I presented my session "DBAs vs Developers: JSON in SQL Server 2016" at the online GroupBy Conference.
As I prepared for the event, I thought about all of...
2017-06-13
19 reads
Last week I presented my session "DBAs vs Developers: JSON in SQL Server 2016" at the online GroupBy Conference.
As I prepared for the event, I thought about all of...
2017-06-13
19 reads
DevOps isn't running SQL Server in a container and pushing code to it from Jenkins
When we talk about DevOps we...
2017-06-13
367 reads
DevOps isn’t running SQL Server in a container and pushing code to it from Jenkins
When we talk about DevOps we...
2017-06-13
26 reads
DevOps isn’t running SQL Server in a container and pushing code to it from Jenkins
When we talk about DevOps we...
2017-06-13
73 reads
DevOps isn’t running SQL Server in a container and pushing code to it from Jenkins
When we talk about DevOps we...
2017-06-13
46 reads
DevOps isn't running SQL Server in a container and pushing code to it from Jenkins
When we talk about DevOps we envision that we have the ability to check-in code,...
2017-06-13
16 reads
This month the T-SQL Tuesday invitation is from Grant Fritchey, my colleague at Redgate Software. Surprise, surprise, the topic is...
2017-06-13
452 reads
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-06-13
104 reads
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-06-19 (first published: 2017-06-13)
992 reads
The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps...
2017-06-13
1,147 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