Steve... I was very surprised as well. Here's where I found it.

https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx

Look at the restrictions section. Maybe I'm misinterpreting what that's saying.

Thanks

I read somewhere that I'll need to disable Backups and database maintenance during the encryption process. Is this true?

This is very concerning, since my testing took ~4 days to complete...

Thanks Eddie! This is great feedback! I especially appreciate the info about VLFs. That's the first time that I've seen that mentioned during my research.

My apologies... The only thing that is slowly changing is the data itself. There are only a few UPDATEs and a couple thousand INSERTs to the source data on a...

And here's the answer...!!!

http://blog.hoegaerden.be/2011/03/23/where-the-sheets-have-a-name-ssrs-excel-export/

Thanks Me!

I was able to use the single DataSet by setting up Row Groups and Page Breaks. Unfortunately...I can't seem to rename each of the excel tabs with the customer name....

I still can't figure this one out. Anyone else wanna take a stab at it?

I ran into another issue. Here's an example of a session that started in the previous month and continues all the way through to the end of the month without...

Thanks Jeff...! I think this might work.

Turns out...all I had to do was add "Username" to the included columns on the date index. Using the variables works now...but it's still slow. It takes ~2.2 mins to...

Although I can't take credit for writing the cursors. I am happy to part of this historic teaching moment. 😛

Thanks Chris! This is exactly the kind of answer I...

Here's what I came up with. It was actually much easier than I thought it would be.

DECLARE @query NVARCHAR(2000)

DECLARE @table NVARCHAR(20)

SET @table = (SELECT 'Stats'+''+[dbo].[fnFormatDate](GETDATE(), 'YYYYMM'))

SET @query = '

DECLARE @start...

Thanks Jason!

I tried doing that earlier. Unfortunately...the problem isn't simply creating a variable for the table name and using it in the cursor. The issue is with cursors in general....

Yes...it will always have that format.

Thanks Jeff... I also use FOR XML PATH for some of my smaller reports. 🙂 I was was hoping there was some way to turn the HTML bloat...