Hi,

Have a look at https://www.brentozar.com/archive/2021/11/video-office-hours-black-friday-edition-ask-me-anything-about-sql-server. It mentions a case of a slow running sp_BlitzFirst

I guess unless you pay Brent for it ( or use his consultant kit) , you'll have...

According to https://docs.microsoft.com/en-us/sql/sql-server/compute-capacity-limits-by-edition-of-sql-server?view=sql-server-ver15

Express

Limited to lesser of 1 socket or 4 cores

It should use 4 cores if you present them as 1 socket, 4 cores.

If you would present is as 2...

Higher core counts also mean higher licensing costs.

Is the SSRS 2019 site in their single-signon internetzone? Browsers don't allow single signon by default

For IE it would be Security -  Local Intranet ( Verification of user: only automatic...

You could use

https://docs.dbatools.io/Copy-DbaDbTableData

with a query as a source.

Or export/import the data as csv from a restored backup

https://learnsql.com/blog/how-to-export-csv-from-sql-query/

4th wave is in full effect. Luckily most are vaccinated and have lower hopitalization needs.

Back to telework for a month

Where is the DDL of ExtractReports.dbo.TAllData and [ExtractReports].[dbo].[TradeCodesInsert] ? I only see [Parts].[TradeCodes]

Is there any sample data to work on?

Thanks Jeff Moden for the extensive reasoning. Bookmarked this post.

Most of our non-guid indexes are fillfactor 100. If I understand correctly I'll better stop the index maintenance for now and...

Why don't you script out the command instead of doing it through the GUI.

Do it once in the GUI but before applying choose "Script".

I agree. TDE = encryption at rest. If SQL Server is not running, you can't make sense of the data looking at the file

Always encrypted: encryption is specific to the...

I'm interested also if this is possible. I believe not because SSRS is rendering it as Excel.

I think in

rsreportserver.config

SSLCertificateConfiguration

• This reply was modified 4 years, 5 months ago by Jo Pattyn. Reason: misread, is about ssrs certificate
• This reply was modified 4 years, 5 months ago by Jo Pattyn.

Can't help you with it. Are you using the latest SSMS?

What do you mean by "there is a small difference in DNS between VM and SQL hostname"

What software do you use for the connection?

Do you connect using the fully qualified...

Haven't read it, but I wouldn't buy a book regarding SQL 2012 today.

The current version is 2019 and there was a major change with version 2016, you would miss out...