Bree's first blog post... Amazing training deals
Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT....
2016-11-28
386 reads
Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT....
2016-11-28
386 reads
After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a...
2016-12-01 (first published: 2016-11-28)
1,912 reads
Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...
2016-11-27
612 reads
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
936 reads
Dear All,
I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...
2016-11-26
424 reads
One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are...
2016-11-26
220 reads
This post is in support of Tim Ford’s (blog|twitter) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it,...
2016-11-26
18 reads
Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...
2016-11-25
669 reads
I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but...
2016-12-02 (first published: 2016-11-25)
1,544 reads
Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual
Tony Davies discusses containerisation...
2016-11-25
491 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