VMware Updates In-Guest Clocks When You Say Not To
VMware’s VMTools package has some options for synchronizing the in-guest clock with the time of the ESXi host. By default,...
2017-03-16 (first published: 2017-03-06)
831 reads
VMware’s VMTools package has some options for synchronizing the in-guest clock with the time of the ESXi host. By default,...
2017-03-16 (first published: 2017-03-06)
831 reads
Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean...
2017-03-15 (first published: 2017-03-06)
1,507 reads
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,765 reads
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...
2017-03-06
2,455 reads
It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...
2017-03-06
33 reads
Roles and Permissions
Some of my recent articles have been focused on permissions and security. There is good reason for that – security...
2017-03-15 (first published: 2017-03-06)
3,117 reads
I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon...
2017-03-06
410 reads
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,553 reads
One of the most visited posts on my blog is nearly two and half years old now – Add User to...
2017-03-16 (first published: 2017-03-06)
1,740 reads
Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has...
2017-03-06
351 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