Thanks Steve for this easy to understand article for beginners for docker.

One question: the docker in this example is for windows desktop ,just curious , if using a Linux laptop,...

Is there a way to copy a folder on ssrs production server to a test server?

This includes all the reports under that folder plus subscription's for those reports.

Thanks, checked the date of the createdate and modified date in the catalog table, they were created about half a year ago, which was before I created those subscriptions.

Nobody deleted the subscription manually, I have checked with developers.

We do have a build process using Octopus to deploy reports, but we tested earlier by deploying they don't...

i am not ignoring the problem. Just want to separate the hdhoc, or self -service based query aside from other main functionality of this server.

Yes, make tempdb in multiple files that could make use of the cores and reduce the contention.
We have already done so. 8 tempdb files. Our situation is some that...

yes, I did mean tablespace in Oracle. For in oracle you can assign different users to different tablespace.
In case one user use extensivly tablespace, we can assign it a...

Could you send me the script to anncao[at]outlook.com, thanks!

Thanks for the great article!  Very through and easy understand!

Can someone change my rate to 5 stars instead of one, not sure how to use the rate...

Thanks much.  The dataware house db is mainly for SSRS reports purpose. But for others users that use PowerBI or Tableau that they can build large ad hoc queries in...

Thanks, does this code mean: not to use the named instance, but just use the computer name which is the default instance.
Since it only server name in it like this:...

Could you send me the scripts? thanks.

I figured out.
There is a third party tool Veeam that is doing the backup of snapshot.
We did not setup the Veeam to do the database backup, but not...

I got it. Thanks

Thanks.
Then what does DECRYPTION  word mean in the create certificate statement?  THanks

- Restoring the certificate,with the private key:

CREATE CERTIFICATE TDECert FROM FILE = 'C:\SQLBackups\TDECert.cer' WITH...