I think in the first example (of loading relatively small fact table and switching tables from schema to schema) one step is missing: Step 6 - DROP swap.table.  Otherwise, you...

Thank you for the article! I do have a question though. In the last section of the article, it looks like "user::filename" variable is used twice. First...

This is great! I've been procrastinating on switching from SQL Trace to Extended Events. Now I have no excuse! (well, maybe until this stairway series is finished :Whistling:...

Thank you for the article!

Do I understand correctly that the entire table marked with REMOTE_DATA_ARCHIVE = ON will be migrated into the cloud (storage-wise)? If so, it...

One of a very few times I found myself smiling while reading technical article. Good information. Thank you!

Thank you for the article! For those of us powershell-challenged, can you explain this part in the RESTORE stetment: $($tlog.name) ? I understand the...

Thank you for the article!

Has anybody trying using this on SQL Server 2014? I did and it returns no records.

Great work, thank you! One suggestion: it doesn't seem to play well in cases when there are complex multi-line expressions used for various properties. Maybe convert CR/LF into...

Neat trick! I can see myself using it very soon. Thank you for sharing!

Great article! Thank you for sharing.

Awesome explanation! Thank you again!

This is a great article! Thank you very much! I just recently started leveraging powershell in my work and find it very powerful and useful. There is...

I was facing the same challenge. I am pasting abbreviated version of the code I use. It does seem to avoid generating full snapshot.

--1. Declare some variables

DECLARE @found_out...

Great article! Thank you.

Thank you for sharing your approach! Am I correct in saying that this would not work if multiple users happen to run this simultaneously? (because of the global...