Happy holidays and Merry Christmas! Have a healthy and fun 2022

Doing fine. Bracing for omikron impact. There is also some budget tightening, luckily most sql databases are now sql 2019 or azure

I disagree with Chandler on avoiding an ICT position but heartily agree with "No position is worth dying over". Live your life instead of being lived.

Remote work is way more...

How's everybody? Wishing a good 2022

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.