Server level database permissions
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...
2017-02-14
743 reads
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...
2017-02-14
743 reads
In this module you will learn how to use the Mekko Chart Power BI Custom Visual. The Mekko Chart visual...
2017-02-14
886 reads
Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option.
What is...
2017-02-14
4,186 reads
The latest course offer is in from Learning Tree!! And It's Valentine's Day!
Learning Tree are showing you the love with...
2017-02-14
346 reads
I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired...
2017-02-13
1,190 reads
By Steve Bolton
…………To get the point across that fuzzy sets require membership grades of some sort, throughout this series I’ve...
2017-02-13
946 reads
I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad to present to the joint Dutch...
2017-02-13
437 reads
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....
2017-02-13
876 reads
Man, if there was an award for procrastinating I’d definitely be in with a shout for today (I write these...
2017-02-13
313 reads
There’s a group at Redgate that investigates new ideas and products. They’re called the Foundry, and they do some cool...
2017-02-13
486 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