Have you backed up your SQL Logins today?
Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...
2017-06-22
434 reads
Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...
2017-06-22
434 reads
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
554 reads
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
2,611 reads
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
146 reads
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
841 reads
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their...
2017-06-21
484 reads
I have been working at Microsoft now for 3 years and 4 months (side note: it’s by far the best...
2017-06-21
857 reads
My last post talked about 9002 errors and how they *might* be corruption.
Recently I moved up to the next consecutive...
2017-06-21
2,040 reads
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
665 reads
Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my SQL Server 2017 (Linux and Beyond) and Stretch...
2017-06-21
30 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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