SQL Server 2016: The Coolest New Feature – Live Query Stats
This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should...
2017-02-23
1,507 reads
This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should...
2017-02-23
1,507 reads
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PMSQL Server has had ways to encrypt data in the past - for...
2017-02-23
22 reads
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM
SQL Server has had ways to...
2017-02-23
670 reads
[read this post on Mr. Fox SQL blog] [UPDATED 7 JUN 2020 – ADDED NEW TEXT ANALYTICS v3.0 FEATURES!] Just last week we had the fantastic opportunity to present at Microsoft...
2017-02-22
23 reads
[read this post on Mr. Fox SQL blog]
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in...
2017-02-27 (first published: 2017-02-22)
2,885 reads
Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!
Wait a minute! Almost forgot.
More great news coming...
2017-02-22
814 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-02-22
1,146 reads
In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by...
2017-02-22
432 reads
I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic...
2017-02-22
356 reads
Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...
2017-02-22
957 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