Test if a File Exists with Powershell
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
Awhile...
2015-11-25
1,414 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
Awhile...
2015-11-25
1,414 reads
If you are a member of PASS, you probably got an email from our President, Thomas LaRock. I interpreted his...
2015-11-25
623 reads
I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as...
2015-11-25
541 reads
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
636 reads
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some...
2015-12-01 (first published: 2015-11-24)
2,736 reads
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person...
2015-11-24
16 reads
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
54 reads
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
61 reads
How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other...
2015-12-02 (first published: 2015-11-24)
1,906 reads
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...
2015-11-24
498 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