Azure SQL Database Error
I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...
2016-02-18
458 reads
I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...
2016-02-18
458 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-02-17
8,263 reads
Life we be so much easier if we could just trust everyone, but since we can’t we need solid security...
2016-02-17
995 reads
This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...
2016-02-17
458 reads
When is the last time you audited who has SQL Server access? No really? When did you last do this?...
2016-02-22 (first published: 2016-02-17)
1,699 reads
When developing in SQL Server you are eventually going to have to modify a column or two (at least). And...
2016-02-23 (first published: 2016-02-17)
3,986 reads
In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016. Let’s...
2016-02-22 (first published: 2016-02-17)
6,876 reads
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it...
2016-02-17
32 reads
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it...
2016-02-17
52 reads
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world....
2016-02-17
2,008 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