Social Engineering: How to prevent unauthorized access to SQL Server using SQL Logins
People are always concerned about Security when it comes to their data. I don’t blame them, I love keeping my...
2013-10-02
736 reads
People are always concerned about Security when it comes to their data. I don’t blame them, I love keeping my...
2013-10-02
736 reads
I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the...
2013-10-02
906 reads
Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the...
2013-10-02
2,831 reads
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,498 reads
I’ve been struggling for months to bring this blog back to life. I’d love to produce content dedicated to the...
2013-10-02
439 reads
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,337 reads
On Thursday of this week I will be presenting a webinar for Pragmatic Works Free Training on the T’s. I...
2013-10-02
952 reads
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk...
2013-10-02
2,057 reads
Today my colleague come to me and ask me why her database restore query was hang. She was going to...
2013-10-01
1,288 reads
I have been honored to be chosen a Microsoft SQL Server Most Valuable Professional (MVP). Here is a video on my...
2013-10-01
2,361 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