Automating installation of Docker & SQL command line tools on Linux
I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been...
2017-08-03
471 reads
I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been...
2017-08-03
471 reads
In my previous blog we learnt to connect to Azure subscription by importing azure license setting file. In this blog...
2017-08-03
538 reads
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...
2017-08-02
19 reads
Imagine we have the following table
Users
FieldTypeIdINTUsernameNVARCHARDeletedBITThen imagine we want Username to be unique for non deleted users. Normally we would...
2017-08-02
72 reads
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what...
2017-08-02
147 reads
I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to...
2017-08-25 (first published: 2017-08-02)
1,631 reads
Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow...
2017-08-02
697 reads
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...
2017-08-02
162 reads
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
429 reads
One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...
2017-08-22 (first published: 2017-08-02)
3,292 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