Notes from the March 2017 MagicPASS Meeting
I was a last minute volunteer to speak at the March meeting and used it as a chance to talk...
2017-03-31
637 reads
I was a last minute volunteer to speak at the March meeting and used it as a chance to talk...
2017-03-31
637 reads
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
429 reads
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
577 reads
Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along...
2017-03-30
1,049 reads
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
720 reads
Watch your memory configuration! You can’t just throw RAM in a physical server and expect it to work right. Depending on...
2017-03-30
724 reads
In this module you will learn how to use the Attribute Slicer Power BI Custom Visual. Using the Attribute Slicer...
2017-03-29
1,164 reads
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
725 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-29
1,011 reads
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
333 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