Recent SQL PowerShell Articles I Have Written
It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL PowerShell world! It’s all my fault I’ve been spending...
2017-05-04
27 reads
It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL PowerShell world! It’s all my fault I’ve been spending...
2017-05-04
27 reads
It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL...
2017-05-04
476 reads
Slack is a popular tool for team interaction. To describe it quickly, it's a feature-rich persistent chat room, with threads,...
2025-09-25 (first published: 2017-05-04)
632 reads
Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of...
2017-05-04
747 reads
A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...
2017-05-04
325 reads
The Pivot and Unpivot features in SQL Server are I find quite underused. For a long time I got by...
2017-05-04
64 reads
Announced today are some really cool new Power BI features:
Power BI Premium
Previously available were two tiers, Power BI Free and...
2017-05-03
2,096 reads
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
544 reads
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
108 reads
Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as...
2017-05-03
581 reads
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...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
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